hi everybody
I have a ASP project that I have done before and it was working fine with SQL Serve Express 2005. After formatting my PC, I installed first VS 2008 Pro and then SQL Server Developer 2008 and I'm testing on my laptop but I can't connect to database. After reading a couple of articles I knew that I can't use mdf file because I'm using SQL Developer so it needs another procedure to follow such as changing the parameters in Web.Config
Web.Config
By the way, I tried a lot of soultion like start SQL browser Service to be on but still didn't work, also I tried to change the instance name in VS in options but also didn't work with me. I hope I can find solution with you. Thank you for your help
I have a ASP project that I have done before and it was working fine with SQL Serve Express 2005. After formatting my PC, I installed first VS 2008 Pro and then SQL Server Developer 2008 and I'm testing on my laptop but I can't connect to database. After reading a couple of articles I knew that I can't use mdf file because I'm using SQL Developer so it needs another procedure to follow such as changing the parameters in Web.Config
Web.Config
Code:
<connectionStrings> <add name="Connection" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Store.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings>
By the way, I tried a lot of soultion like start SQL browser Service to be on but still didn't work, also I tried to change the instance name in VS in options but also didn't work with me. I hope I can find solution with you. Thank you for your help
Comment