Changing the SQL Server port

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

Moderator: SourceGear

Locked
bmacadam
Posts: 20
Joined: Tue Sep 27, 2005 12:39 pm

Changing the SQL Server port

Post by bmacadam » Tue Jul 11, 2006 4:06 pm

I have both Dragnet and Vault installed on a Windows 2003 Server that also has SQL Server 2005 on it. When I change the port that SQL Server listens to from 1433 to another number, both applications cease to function. Both applications connect to their database using Windows Authentication.

What do I need to change in Dragnet and Vault to allow them to properly connect to their respective databases?

Thanks,

Bill
Bill MacAdam
GigglePop.com

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

Post by lbauer » Wed Jul 12, 2006 2:38 pm

You'll need to change the connection string in each app's web.config file.

Put a comma after the server name, then the new port number:

<add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=Servername,1234; Database=sgvault; Integrated Security='true'" />
</appSettings>
Linda Bauer
SourceGear
Technical Support Manager

Locked