Is it possible to connect to a SQL Server 2005 database usine asp.net v1.1

Hi,

I am having difficulties connecting to a SQL Server 2005 database from an ASP.NET windows application.

Is there any difference in the way the connection string is written when connecting to SQL Server 2005

I have the following connections in my App.config file :

<addkey="Sql2000ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2000DB; User ID=UID;Password=Pwd;"/>

<addkey="Sql2005ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2005DB;User ID=UID; Password=Pwd;"/>

Every time I run my application it crashes when I try to connect to SQLServer2005 - The connection to the Sql2000 database works without any errors.

Do I need to write the connection differently??

Thanks

Hi kellem,

You would have to post your error message.

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

|||Make sure the remote connections are enabled on the SQL2005 instance, which can be checked in Sql Server Surface Area Configuration.