473,320 Members | 1,694 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem in Hosting a website on SQL Express Database

Dear friends,

I have hosted the website on the sqlexpress database, but on database operation getting following error.

"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)"

My connectionstring is as belows.

string path = HttpContext.Current.Server.MapPath("App_Data");
path = path + "\\";


string ConnectionString = @"Server=<server name>;Data Source=.\SQLEXPRESS;AttachDbFilename=" + path + "Database.mdf;Integrated Security=True;User Instance=True";


Thanks and Regards
Jaydeep.
Nov 25 '09 #1
1 1497
@Jaydeep Ramavat
Hi

The <server name> is the SQL Server name or your machine name?

Check the SQL Server name and if its not the one you have given then replace it.

Hope this helps you.
Nov 27 '09 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Anthony J. Narcise | last post by:
PowerLynx hosting has a new look and more features. Check us out at www.PowerLynxHosting.net PowerLynx Hosting is a Web Hosting Company geared towards Developers. We support the latest versions...
2
by: TTT | last post by:
Hi, I have developed a website from the model "Starter kits Classified". Well, the application works good, no problem in my development environment. It uses a SqlServer 2005 express database...
1
by: OGG | last post by:
Hi guys, I hope this is the correct place to post this question. 1) My website makes use of the Membership and Roles of asp.net 2. 2) I have uploaded my website to a shared hosting server, which...
9
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...
5
by: Glen Buell | last post by:
Hi all, I have a major problem with my ASP.NET website and it's SQL Server 2005 Express database, and I'm wondering if anyone could help me out with it. This site is on a webhost...
2
by: itfetish | last post by:
I've just upgraded our WIndows 2003 (with SBS server) web server to .Net framework 2.0 (it had 1.1 before) As I have been working on a web parts page on my laptop, hosting it there, working...
5
by: =?Utf-8?B?bXVzb3NkZXY=?= | last post by:
Hi, I wonder if someone could shed some light on this one for me. I have developed a web app in VS2005 with the built in server. It uses an sql database, everytihng works. I need to test it...
6
by: =?Utf-8?B?ZGF2ZWJ5dGhlc2Vh?= | last post by:
Dear List, I have been writing Web Services and running them from either a local IIS Server on XP Pro or within the built in web server in VS2003 and more recently VS2005. I was considering...
14
by: Jeff | last post by:
Hello I'm teaching myself web programming in ASP.NET using freely available online resource and videos. It's going really well and I've built myself some personal web pages based on the Visual...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.