Connection strings and SQL Express 2005

Hello,

I am working on porting a Windows Forms VB.net VS 2003 app with a SQL 2000 backend - to using VS 2005 with SQL Express 2005.

I cannot seem to figure out how to set my connection string to work in the new environment. I have already recreated my database in SQL Express 2005 and ported the VS project to VS 2005.

The old string was (in my app.config file):

<add key="ConnectionString" value="workstation id=MAIN1;packet size=4096;user id=sa;data source=MAIN1;persist security info=True;initial catalog=Dbname;password=####" />

Any ideas?

Thanks,

Sam

Which error do you get ? SQL Server Express is disabled for remote connection by default, you might check the Screencast on my site to see how to enable that.

HTH; jens Suessmeyer.

http://www.sqlserver2005.de