Windows Authentication in SQL Server 2005

Few days earlier, I came to learn some very basic login stuffs while working on Windows Authentication Mode of SQL Server. My task was to disable the Windows Authentication Mode. This is really very simple but it may irritate you if you are not informed of following facts.

First of all, you can’t disable or drop [BUILTIN/Administrators] or [ComputerName/UserName] Windows Credentials if you are logged in to SQL Server using this account.

So, you have to enable SQL Server Authentication Mode if it has not been enabled yet. Moreover, assign SERVER ROLE to “sysadmin” for this SQL Server Account.

Finally, login to SQL Server using SQL Server Authentication Mode and you can disable or even drop [BUILTIN/Administrators] or [ComputerName/UserName] Windows Credentials to disable Windows authentication in SQL Server.

However, you can create Windows Credential using the following query. Just assign SERVER ROLE to “sysadmin” after creating the LOGIN.



CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]

-- To Drop LOGIN
DROP LOGIN [BUILTIN\Administrators]

Thanks
A Rahim Khan

Advertisements
  1. thank u…………

  2. Do you have a spam issue on this website; I also am
    a blogger, and I was curious about your situation; many
    of us have created some nice practices and we are looking to exchange strategies with other folks,
    why not shoot me an email if interested.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: