i want to select mssql2005 or mssql2008 where 2005, 2008 was instlled.

buffering83

my computer have ms-sql 2005, 2008. i select web.config like this <add key="dsn" value="data source=localhost;initial catalog=PERSON_database;uid=sa;pwd=1111;persist security info=False;packet size=4096"/> but i only connect mssql2005. how can i connect mssql 2008?

hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~

m dhu

I think the connection string you mentioned is for database in 2005. Similarly add another connection string pointing to database in sql 2008. :)

Lost User

It means a SQL 2005 server instance has been installed as the default instance, which enables you to specify localhost as the data source. SQL 2008 server must have been installed as a named instance (since there can be only one default instance). Find out the name of the named instance and use it in your connection string like this.

data source=localhost\mySql2k8instance

You can find the name of your SQL 2008 instance by looking at the list of serivces in services.msc.