Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1570
  • Last Modified:

Unable to Connect to Database Engine

I recently installed SQL Server 2005 Developers edition on Windows Vista Home Premium to run through some tutorials but am continuously getting the below error when trying to connect to database engine using Windows authentication (however I am able to connect to Analysis Services.

TITLE: Connect to Server
------------------------------

Cannot connect to %computername%.

------------------------------
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 5)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=5&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
0
reedsdomain
Asked:
reedsdomain
  • 2
1 Solution
 
dqmqCommented:
Start the Surface Area Configuration tool (found in the Start Menu).  You can enable remote connections there.  Then restart the server.
0
 
David ToddSenior DBACommented:
Hi,

When you installed SQL, did you add your user account to the SQL Administrator?

HTH
  David
0
 
reedsdomainAuthor Commented:
When  SQL Server first installed it failed during the script that was supposed to handle the addition of the windows admin account to SQL server.  It appears as though one of the services failed while the script was running.  I thought I had worked around this by creating a new Windows admin account which was then trusted, however I followed the steps from dqmq and enabled remote connections and now the error I get when trying to connect to the Database Engine is "Login Failed" .  Is there anyway to workaround this short of a full uninstall/reinstall?
0
 
dqmqCommented:
You are making progress.  "Login Failed" has numerous potential causes--it's time to starting looking for a more descriptive message.  Start by logging on using SQL authentication and the SA or anothe administrtor account.  Assuming that works, it's just a tweak to Windows Authentication working.  Make sure the windows account is defined in the SQL Server Logins.   Make sure that login has a valid default database and permission to connect.  Make sure the windows account is defined as a user in the default database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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