|
I have multiple versions of Microsoft SQL Server installed and running on the same machine. Microsoft SQL Server 2000 is the default instance on the machine, while Microsoft SQL Server 2005 is installed on the same machine as an alternate instance. Can I configure the software to use the alternate instance of SQL Server rather than the default instance?
|
|
|
Yes, when you want to have the application use an installed instance of Microsoft SQL Server other than the default instance, you simply need to include the instance name in the server name as part of your connection string. For example, if your alternate instance of SQL Server 2005 is installed with the instance name of SQL2005, then you would modify your database connection string so it looks like the following:
gsConnect = "DRIVER=SQL Server;SERVER=sql.example.com\SQL2005;UID=SQLlogin;PWD=SQLpassword;DATABASE=SQLdbName"
Of course, the instance name will vary depending on what you named the instance during the installation of SQL Server.
|
