Help! I cannot connect to database master on my SQL server! -

SharePoint Events

	5/13/2013 - Conference: SharePoint Summit 2013
	5/21/2013 - Webcast: SharePoint 2013 and ECM: Content Migration and Storage
	5/22/2013 - Webcast: Managing CAD in SharePoint
	5/23/2013 - Webcast: SharePoint Document Automation and E-Forms for Financial Services
	5/24/2013 - Webcast: What's New in Search for SharePoint 2013

SharePoint Videos

	Why SharePoint 2013
	SharePoint 2013 Launch
	SharePoint 2013 Migration and Governance
	SharePoint 2013 and Enterprise Content Management
	Top Benefits of SharePoint 2013
	What's New in Business Intelligence in Office and SharePoint 2013
	SharePoint and Office 2013 Integration
	SharePoint 2013 Infrastructure Preview
	SharePoint, Lync, and, Exchange in the Cloud with Office 365
	Advanced Reporting in SharePoint with Microsoft Power View

Archives

Title

Opening SharePoint Links in a new window

Mail Enabled Lists vs. The Missing Windows 2008 POP3/IMAP Server

7 Tools for SharePoint Developers

Public Facing Masterpage Techniques

How to Quickly Deploy and Activate a Timer Service to Your Site Collection

Custom SharePoint Master Page Feature with WSP Builder

Date Math with InfoPath

Enterprise Search Tricks and Tips Part 1

Populating Word Documents With SharePoint Data. Try The DIP!

Programmatic Deep Dive into Blank SharePoint Lookup Columns

1 - 10

7/25/2011

Help! I cannot connect to database master on my SQL server!

By: Kathryn Bartlett

Ever come across the following error?

The_SharePoint_Blog_Help_I_cannot_connect_to_database_master_on_my_SQL_server

You’ve tried googling this error message, but all of the suggested fixes do not work?

To fix this, you have to make the account that runs the SQL Server 2008 services a Domain Admin and re-install your instance of SQL Server 2008 while logged into this account. This error can result from not having the SPN record added correctly upon installation of SQL Server. Only an account that has AD administrator rights can correctly add this SPN record.

To determine which account is running the SQL Services, click Start -> Administrative Tools -> Services.

The_SharePoint_Blog_Help_I_cannot_connect_to_database_master_on_my_SQL_server

From here, we can find the SQL Server services and which accounts are running them:

The_SharePoint_Blog_Help_I_cannot_connect_to_database_master_on_my_SQL_server

This is the account we need to give AD administrator rights before re-installing SQL Server 2008.

By: Kathryn Bartlett

Posted at 1:03 PM by WDC812\richardm | Permalink | Email this Post | Comments (0)

Comments

There are no comments yet for this post.

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.