I'm using the following to deploy a script to my SQL servers to check version information.
sServer = "127.0.0.1"
' Set the connection string, open the connection and get rows.
oCn.ConnectionString = "PROVIDER=SQLOLEDB.1;Integrated Security=SSPI;Server=" & sServer
I'm having an issue with servers that have an instance defined. For example, my Altiris SQL Server. It's NTALTSQL\Altiris. Simply using 127.0.0.1 will not work. However, if i use 127.0.0.1\Altiris it works fine. Yes, I’m running it locally on the server. J
What I'm looking for is some type of wildcard to specify that it connects to whatever instance is there, if any.