• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

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
------------------------------
0
ie0
Asked:
ie0
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you might want to go through this article to start understanding concepts and troubleshooting:
http://www.experts-exchange.com/A_1881.html
0
 
Aaron ShiloChief Database ArchitectCommented:
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.
0
 
ie0Author Commented:
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
0
 
evgeny_f31Commented:
try this:
When connecting to the database, use this as the “Server Name”: \\.\pipe\mssql$microsoft##ssee\sql\query
0
 
Aaron ShiloChief Database ArchitectCommented:
hi

under logins in sql server managemnt studio find the login your using and under his privileges

or you can run this
 EXEC sp_helprotect NULL, 'Judy'
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now