Connect to Instance
Posted: Tue 22 May 2007 18:13
I am having a problem connecting to a instance of MS-SQL which is not the default instance.
This test does not work:
osql -S SQL-SERVER -U uname -p password
while this does works:
osql -S SQL-SERVER\inst1 -U uname -p password
And as expected setting this does not work:
TMSConnection.ConnectString:='User ID=uname;Password=password;Server=SQL-SERVER';
But again, this does not work either::
TMSConnection.ConnectString:='User ID=uname;Password=password;Server=SQL-SERVER\inst1';
What is the proper syntax for the ConnectString to connect to a different instance?
ed
This test does not work:
osql -S SQL-SERVER -U uname -p password
while this does works:
osql -S SQL-SERVER\inst1 -U uname -p password
And as expected setting this does not work:
TMSConnection.ConnectString:='User ID=uname;Password=password;Server=SQL-SERVER';
But again, this does not work either::
TMSConnection.ConnectString:='User ID=uname;Password=password;Server=SQL-SERVER\inst1';
What is the proper syntax for the ConnectString to connect to a different instance?
ed