RE: NT Authentication Issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ashish Ruparel [MSFT] (v-ashrup_at_online.microsoft.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 02:09:16 GMT

Hi Jill,

You will have to add the Windows Login to the SQL Server for authentication.
Give them access to the required database(s)
Also give them access to the required Objects in the database(s).

A way to achieve this is

1. Create a Role in the Required Database(s)
2. Give permission to the role
3. from the Security -> Login

Click on the Action -> New Login Menu Option

A Dialog Box will popup.
Enter "Domand\UserName" for Name
Select windows Authentication
Select Grant Access
In the Database Access
Select the Required Database(s)
Select the appropriate Role(s)

This will create a login for the Windows user in SQL and give the user
access to the required objects.

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

Relevant Pages

  • Re: SQL Server Authentication, NOT Windows NT
    ... Windows wizard for creating ODBC link on user pc. ... The problem is that even though I set up the ODBC links to use SQL Server ... Authentication because SQL Server won't accept our Windows logins (reads them ... SQL Server Login window opens, unclick Trusted Connection, input SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Kerberos / Authentication to SQL2K
    ... use Windows integrated security for database access. ... That SQL Server be running on the same computer as IIS. ... > authentication until I switched on impersonation either. ... > When set up on my web server however, I get the "Login failed for user ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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)
  • 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)