Windows Authorization

This is a discussion on Windows Authorization within the sqlserver-faq forums in Microsoft SQL Server category; Hello! If I for some reason want to disable the feature to use Windows Authorization to be able to log in to SQL Server 2005 how is this done. I must admitt that I have no reason at all for doing this now but I just want to have the knowledge to do this. //Tony...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-faq

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-27-2008, 06:24 AM
Default Windows Authorization

Hello!

If I for some reason want to disable the feature to use Windows
Authorization to be able to log in to SQL Server 2005 how is this done.
I must admitt that I have no reason at all for doing this now but I just
want
to have the knowledge to do this.

//Tony


Reply With Quote
  #2  
Old 08-27-2008, 10:15 AM
Default Re: Windows Authorization

You can't disable Windows authentication.

As I recall, you could in 6.5 and earlier (security mode was a tri-state setting where now it is a
two-state setting), but I admit that my memory is hazy, it has been some 10 years ago...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Tony Johansson" wrote in message
news:u$lvEUCCJHA.4576-at-TK2MSFTNGP05.phx.gbl...
> Hello!
>
> If I for some reason want to disable the feature to use Windows
> Authorization to be able to log in to SQL Server 2005 how is this done.
> I must admitt that I have no reason at all for doing this now but I just
> want
> to have the knowledge to do this.
>
> //Tony
>
>


Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 02:54 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.