Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server installation question!! Expand / Collapse
Author
Message
Posted Monday, November 3, 2008 9:21 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
While installing sql server 2005, is it okay for selecting mixed mode of authentication? Thanks!
Post #596285
Posted Monday, November 3, 2008 9:27 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 2:42 PM
Points: 89, Visits: 748
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
Posted Wednesday, November 5, 2008 9:38 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:14 PM
Points: 2,999, Visits: 568
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 »

Add to briefcase

Permissions Expand / Collapse