How to check which SQL server I'm using

[ramzibalaa]

Hello,

How can I check which SQL server I'm current;y attached to ? I setup Vault a while ago and cannot remember which server I'm on.

[lbauer]

Check the web.config file in the Vault Service directory on the Vault Server machine.

The ConnectString value will have the authentication type and the SQL Server name -- here it's (local).

Code: Select all

<appSettings>
		<add key="ConfigPath" value="C:\inetpub\wwwroot\VaultService\Vault.config"/>
		<add key="BugTrackingPath" value="BTPBTPBTP"/>
		<!-- SQLSERVERMODE-add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=(local); Database=sgvault; User ID=UUUUUUUU; pwd=PPPPPPPP" />SQLSERVERMODE- -->
		<add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=(local); Database=sgvault; Integrated Security='true'" />
	</appSettings>