Error Connecting to SQL Database
I have SBS 2008 and am getting an error when conneting to the SharePoint SQL databases the SQL Studio Management Express:
TITLE: Connect to Server
--------------------------
Cannot connect to SERVER\MICROSOFT##SSEE.
--------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
TITLE: Connect to Server
--------------------------
Cannot connect to SERVER\MICROSOFT##SSEE.
--------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
hi
1. make sure that the SERVER\INSTANCE are correct
2. make sure the instance is up.
3. make sure that the user your using to logon is a privileged login in sql server.
1. make sure that the SERVER\INSTANCE are correct
2. make sure the instance is up.
3. make sure that the user your using to logon is a privileged login in sql server.
ASKER
Ashilo,
The instance is correct.
The instance is running, I have the small green arrow under the 'database engine' on the instance.
How do I make sure the user is a privileged logon?
thanks
The instance is correct.
The instance is running, I have the small green arrow under the 'database engine' on the instance.
How do I make sure the user is a privileged logon?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.experts-exchange.com/A_1881.html