Installation Problem - SQL connection failed

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
cellardoor
Posts: 12
Joined: Thu Nov 19, 2009 9:14 pm

Installation Problem - SQL connection failed

Post by cellardoor » Mon Dec 14, 2009 9:28 pm

Hi all,

I m trying to install vault on a brand new windows 2003 64 bit server. Configured the box as I did before. But I got this error msg for the " Connect to SQL server" installation part.

The error says " SQL connection failed. unable to connect to sql. The type initializer for "system.data.sqlclient.sqlconnection" threw an exception."

I believe the SQL server 2005 express is configured probaly since i can connect to it from a remote location, I also used 'servername'\SQLEXPRESS as the SQL server name.

I also tried to install ODBC, reinstall IIS, .net, but none of them works.

Can anyone help me with this issue?

Thanks a lot.

Dave

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Installation Problem - SQL connection failed

Post by lbauer » Tue Dec 15, 2009 2:29 pm

What version of Vault are you installing? Are you using the Vault 32- or 64-bit installer?

Did you choose SQL Server authentication or Windows Authentication for your SQL Server setup durign the installation?
Is SQL Server on the same machine or a different machine than the Vault Server?
Linda Bauer
SourceGear
Technical Support Manager

cellardoor
Posts: 12
Joined: Thu Nov 19, 2009 9:14 pm

Re: Installation Problem - SQL connection failed

Post by cellardoor » Tue Dec 15, 2009 3:25 pm

I tried both 32 bit and 64 bit installer, same result. I choose mix authentication for the SQL server, from remote and local location, I can connect to SQL server express 2005 with both SQL and windows login. SQl server is in the same server as the vault server.

"The type initializer for "system.data.sqlclient.sqlconnection" threw an exception."" looks like a .net error to me, I re installed .net framework few times, but still doesnt help.

Thanks.

Regards.

Dave

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Installation Problem - SQL connection failed

Post by lbauer » Wed Dec 16, 2009 1:55 pm

What version of Vault are you installing? If you are installing Vault 4.1.4 it takes extra configuration.
Linda Bauer
SourceGear
Technical Support Manager

cellardoor
Posts: 12
Joined: Thu Nov 19, 2009 9:14 pm

Re: Installation Problem - SQL connection failed

Post by cellardoor » Wed Dec 16, 2009 2:29 pm

vault v 5.0.2.18753

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Installation Problem - SQL connection failed

Post by lbauer » Wed Dec 16, 2009 4:17 pm

Is the SQL Server machine on the same machine as the Vault Server or a different machine?

Send me a copy of the Vault Server installation log. It's called Vault_install.log and is in your user's temp directory on the server machine.

Send the log zipped up to support at sourcegear.com, Attn: Linda. Please include a link to this forum post.
Linda Bauer
SourceGear
Technical Support Manager

cellardoor
Posts: 12
Joined: Thu Nov 19, 2009 9:14 pm

Re: Installation Problem - SQL connection failed

Post by cellardoor » Wed Dec 16, 2009 6:37 pm

I cant find any files named Vault_install.log, are you sure about the file name?

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Installation Problem - SQL connection failed

Post by lbauer » Thu Dec 17, 2009 10:34 am

Yes, that's the right name. It's generally in the temp directory of the user who installed Vault. Type %temp% in an address bar and it will take you there. Sometimes the log isn't created.

Do you have a Vault Server log? It's called sgvault.log and is in %windir%\temp\sgvault on the server machine.
Linda Bauer
SourceGear
Technical Support Manager

Post Reply