Installation problem - SQL Connection failed

[paulhectors]

I am unable to install SourceGear Vault server because during the install the connection to the database fails.

I am not experienced with SQL Server but I have downloaded and installed SQL Server 2005 Express edition. I have checked in the service controller and the SQL Server service has started.

I have tried connecting with Windows Authentication and SQL Server authentication but I get the following error:
"SQL Connection Failed. Unable to connect to SQL.

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)"

The Vault Server and SQL Server are on the same machine.

Operating system is Win XP SP2 and I am running in a virtual machine using Virtual PC 2007. I am trying to evaluate Vault Server to replace CVS and Sourcesafe at the company I work for.

Best regards,

Paul

[Beth]

Do you have the SQL Server Management Studio Express installed? That's a very helpful tool.

In the path to the SQL server, you will need to enter something like .\sqlexpress or machinename\sqlexpress. Try that and let me know your results. If you have SQL Server Management Studio Express installed, then you can just copy the path used to connect with that tool and use that same path for SQL during the install.

[paulhectors]

Thank you for your post.

I installed the Studio Express and connected to the database server.

The solution to my problem was that the text in the installer should be "<computer name>\SQLEXPRESS".

Best regards,

Paul

[Beth]

Thanks for the update.