Tuesday, June 26, 2007

Changing SQL Server 2005 authentication mode

I had to hunt around today to figure out how to change SQL Server 2005 authentication mode , so I figured I would document it here in case it slips my mind again.

1. Launch SQL Server Management Studio Express ( Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio)

2. Right-click the Server name, select Properties > Security (see picture below)



3. Under Server Authentication, select SQL Server and Windows Authentication Mode



4. Stopped and re-started the SQL Server

2 comments:

Anonymous said...

Thanks dave, your post came in very handy today as it saved me a whole day of re installment of sql server

Anonymous said...

TITLE: Connect to Server
------------------------------

Cannot connect to "My Machine name".

------------------------------
ADDITIONAL INFORMATION:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

This was the error that i got when i tried to connect for the first time after installing Sql server 2005 standard edition. Is there a solution for this? Please reply...