Changing the SQL Server port

[bmacadam]

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

[lbauer]

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>