RE: pass through authentication

Hi Bad,

Thank you for using Newsgroup.

Do you use the SQL SERVER 2000 or SQL SERVER 2005?

Actually SQL SERVER 2000 has two types of authentication: Windows
authentication and mixed authentication. If you do not use the domain
account to login in the Windows, you cannot use the Windows authentication
type to pass through the SQL SERVER, however you can use the SQL SERVER
authentication to access the SQL SERVER from the Windows XP machine. To do
so, you need to do the following things:

1. Enable the SQL SERVER to use the mixed mode. (in the SQL SERVER
Enterprise Manager, right click your server->click properties->Security,
select SQL Server and Windows under the Authentication)
2. Set up a SQL SERVER login account. (extend your server in the Enterprise
Manager, Security->Logins, set up your sa account, and you can use this sa
account to access the SQL SERVER)

If anything is unclear, please feel free to let me know. Thank you!

Sincerely,
Warner Wang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient
    ... > account also must be a member of the sysadmin role in the target SQL ... and the Windows firewall is disabled on both client & server. ... to the remote SQL Server 2005. ... But I'm still getting the "T-SQL execution ended without debugging. ...
    (microsoft.public.vsnet.debugging)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: connecting to sql server with windows authentication
    ... least the ones I was involved in), would be to use SQL authentication. ... not recommend running SQL Server in mixed mode, ... > using windows authentication. ... Use delegation to leverage the current user's account. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
Loading