jobowoo
06-20-2006, 03:07 PM
Hey guys,
I'm just starting to familiarize myself with .Net and seem to have run into a problem before I could even start coding. I've installed VS 2005 and have SQL Server 2005 on a desktop and SQL Express 2005 on my laptop.
I downloaded the starter kits off of:
http://asp.net/downloads/starterkits/default.aspx?tabid=62
The one I'm trying to get working is the Personal Website one. As per the readme file it says I can just run it right after I install it using ctrl+f5. I do that and I get a SQL error. Error 26 to be exact. Here's what it says:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
I looked up error 26 on google and it came up with:
http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx
I tried the first solution and that didn't work and I don't really understand their second solution. Have any of you guys ever run into this kind of problem before? Any help would be much appreciated. Thank you! :)
PS: Here is the connection string.
<connectionStrings>
<add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" />
</connectionStrings>
I'm just starting to familiarize myself with .Net and seem to have run into a problem before I could even start coding. I've installed VS 2005 and have SQL Server 2005 on a desktop and SQL Express 2005 on my laptop.
I downloaded the starter kits off of:
http://asp.net/downloads/starterkits/default.aspx?tabid=62
The one I'm trying to get working is the Personal Website one. As per the readme file it says I can just run it right after I install it using ctrl+f5. I do that and I get a SQL error. Error 26 to be exact. Here's what it says:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
I looked up error 26 on google and it came up with:
http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx
I tried the first solution and that didn't work and I don't really understand their second solution. Have any of you guys ever run into this kind of problem before? Any help would be much appreciated. Thank you! :)
PS: Here is the connection string.
<connectionStrings>
<add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" />
</connectionStrings>