Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

53


Chapter 3: Installing SQL Server


3


Figure 3-12 shows the Database Engine Confi guration options.

FIGURE 3-11
Service Accounts.

Always defi ne at least one Windows or Active Directory domain user as part of the SQL Server Administrators if
selecting the Windows Authentication Mode option. Failure to do so results in the inability to log in with administra-
tive rights to the SQL Server instance. Uninstalling and reinstalling the SQL Server instance is the only option to fi x
this issue. To ensure you have access to the SQL Server instance, add at least one user using the Add Current User or
Add button.

c03.indd 53c03.indd 53 7/30/2012 4:10:05 PM7/30/2012 4:10:05 PM


http://www.it-ebooks.info
Free download pdf