SQL Connection Failed. Unable to connect to SQL

n3n9 · Post by **n3n9** » Sun Feb 11, 2007 9:00 pm

hi,

This is a total nooby question but thanks for helping.

I've just installed SQL2005 Express on my winxp sp2 with all default settings except authentication mode (i set it to mixed). Then i enabled TCP/IP and Named Pipes.

Then i tried to install Vault Server and i get this error.

Sql Connection Failed. Unable to connect to SQL.
An error has occured while establising a connection to server. When connecting to SQL Server 2005, this failure may be caused be the fact that undert he default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL Server).

Note that i've already enabled TCP/IP and Named Pipes client protocol.

thanks
n

lbauer · Post by **lbauer** » Mon Feb 12, 2007 10:01 am

It's possible it's not finding the database if you used the default value (local) in the SQL Server setup portion of the installation.

When installing Vault Server with SQL Server 2005 Express, use .\sqlexpress (local machine) or machinename\sqlexpress instead of (local), as SQL Express is installed as an instance.

n3n9 · Post by **n3n9** » Wed Feb 14, 2007 8:55 am

Thank you. It works now.