OK, so I’m a little behind schedule – but I’m finally getting a chance to really dive in to SBS 2008, and I should hopefully have some decent posts moving forward . . . yeah, yeah I hear you – *any* post decent or not would be an improvement over the last year . . . I’m workin’ on it, k?
So most of us running WSUS 3.0 or WSS 3.0 are familiar working with the Windows Internal Database, and know that we can connect to that instance via Named Pipes so we can actually use the nice GUI interface provided by SQL Management Studio (Express). Well, if you’ve tried using the Named Pipes method to connect to your Windows Internal Database on your SBS 2008, you’ve probably noticed that it doesn’t work . . .
Here’s the deal: When the Windows Internal Database is installed, the built-in administrator account is granted system administrator privileges to the SSEE instance. As you’re aware – with SBS 2008 the built-in administrator account is disabled by default and we use a custom administrator account created during setup to administer the box. The problem is that this custom administrator account is not granted SQL system administrator privileges to the SSEE instance by default.
The work around to get this to work was simple enough – all i did was enable the built-in administrator account on my SBS 2008, then log in using that account. Once I was logged in, I was able to successfully connect to the Windows Internal Database via named pipes. At that point, I was able to add my custom administrator account as a SQL system administrator for the SSEE instance;
Expand Security | Logins. Right-click on Logins and select “New Login”
Click the Search button to find your custom administrator account in the directory
Accept the defaults on the General page
On the Server Roles page, check the sysadm role
Click OK to add the user
Now you can log back in to your SBS using your custom administrator account and access the Windows Internal Database instance via named pipes. Just don’t forget to disable the built-in administrator account when you’re done!