how to connect sql2005 while i have sql2000 too on my computer RRS feed

  • Question

  • i have sql2000 and sql2005 both installed

    how do i connect to 2005 beacuse with the current conection setting it conect to 2000 :

    <add name="localCon" connectionString="Data Source=localhost;Integrated Security=True"

    providerName="System.Data.SqlClient" />



    thnaks in advance


    Saturday, July 7, 2007 9:38 PM

All replies

  • Running both versions is accomplished by using "named instances"..you just need to specify the instance name of the Sql Server 2005 instance in your connection string..


    Here is an example:

    connectionString="Data Source=localhost\InstanceNameFor2005;Integrated Security=True"


    If you are unsure of the instance name for your instance of 2005, you can find it in dropdown of the SQL Server Service Manager  (which should be in your start menu with Sql Server).

    Sunday, July 8, 2007 1:07 AM