reedsdomain
asked on
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
--------------------------
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
--------------------------
dqmq
Start the Surface Area Configuration tool (found in the Start Menu). You can enable remote connections there. Then restart the server.
Hi,
When you installed SQL, did you add your user account to the SQL Administrator?
HTH
David
When you installed SQL, did you add your user account to the SQL Administrator?
HTH
David
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.