sql server installation question!!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » sql server installation question!!

sql server installation question!!

Rate Topic

Display Mode

Topic Options

Author

Message

Mh-397891

Posted Monday, November 03, 2008 9:21 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:55 AM
Points: 262, Visits: 1,499

While installing sql server 2005, is it okay for selecting mixed mode of authentication? Thanks!

Post #596285

sayfrend

Posted Monday, November 03, 2008 9:27 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 1:58 PM
Points: 89, Visits: 715

Yes you can, unless you want it. You can complete installation with only WIndows Authentication as well, if you decide to use windows and SQL Server Authentication then choose Both.

SQL Server Authentication is only for backward compatibility.

When you choose Mixed authentication, give a strong password for SA A/c, by default SQL Server Installation keeps a blank password for SA ( System administrator, the highest priviledge A/c in SQL Server).

Post #596287

Tom Schuettke

Posted Wednesday, November 05, 2008 9:38 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 4:40 PM
Points: 2,999, Visits: 511

By default, SQL 2005 makes you create an SA password. You have to specify if you want it blank.

Post #597473

« Prev Topic | Next Topic »

Permissions