SQL Server Installation - Mixed/Windows Question 1

[rebelknight]

If I install SQL server 2005 with Windows selected...

Will I be able to sign on as an SQL Server Login?
( i.e. on starting up you get a sign on box with 'Authentication'. Is 'SQL Server Authentication'
offered and accepted? )

 

[mrdenny]

If you select Windows Authentication as the authentication method no you will not be able to sign on with a SQL login. You will have to use a windows login. You can change the allowed authentication method within the Server properties in the GUI.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[rebelknight]

Thanks.