I created new website using Classifieds Starter Kit and created new database using scripts provided in App_Data folder and modified connection string in web.config. But it doesnt work. It gives error saying "
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
Everything seems ok to me, I tried to connect to same db by creating new page and it worked but it doesnt work using this kit. Please let me know if i am doing something wrong.
Thanks
classified starter kitdatabaseclassified configurationclassifides site errorweb.configclassifidesclassifide starter kit
softwareluv
Member
8 Points
8 Posts
Problem connecting database
Jun 30, 2010 11:10 AM|LINK
Hi,
I created new website using Classifieds Starter Kit and created new database using scripts provided in App_Data folder and modified connection string in web.config. But it doesnt work. It gives error saying "
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
Everything seems ok to me, I tried to connect to same db by creating new page and it worked but it doesnt work using this kit. Please let me know if i am doing something wrong.
Thanks
classified starter kit database classified configuration classifides site error web.config classifides classifide starter kit
divided
Participant
977 Points
236 Posts
Re: Problem connecting database
Jun 30, 2010 01:54 PM|LINK
This thread deals with your specific problem:
http://forums.asp.net/p/1456846/3353472.aspx
softwareluv
Member
8 Points
8 Posts
Re: Problem connecting database
Jun 30, 2010 03:55 PM|LINK
Hi,
I am sorry but it doesn't solve the problem completely. I tried to attach the database file but still it gives same error.
Can you provide me with the script to generate database? And connection string i should use with it. I am using sql server 2008.
I will be very thankful for that.
Thanks
divided
Participant
977 Points
236 Posts
Re: Problem connecting database
Jun 30, 2010 05:45 PM|LINK
Create database script:
http://msdn.microsoft.com/en-us/library/ms176061.aspx
Connection string:
http://www.connectionstrings.com/sql-server-2008