Install MS SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Install MS SQL

Author

Topic

missMac
Posting Yak Master

124 Posts

Posted - 2009-06-01 : 17:26:42

Hello,
am installing ms sql and prompted whether to use windows authentication or mixed mode.

1. I chose windows authentication. Is this ok ?

2. how can i change it to both, once installtion is complete

thanks

MM

SQLRatankalwa
Starting Member

42 Posts

Posted - 2009-06-02 : 00:19:18

Hi

The best authentication is going for Windows Authentication. If you have any legacy systems, then I would advice you to go with the SQL Server Authentication.

In the management studio -> object Explorer -> Right Click on the Registered SQL Server -> Properties -> Security -> Server Authentication -> You can choose between Windows Authentication Mode and SQL Server and Windows Authentication Mode.

I hope this will help.

Ratan Kalwa
SQL Server Professionals User Group

http://www.revalsys.com

missMac
Posting Yak Master

124 Posts

Posted - 2009-06-02 : 04:25:06

ok thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources