?
Solved

Why doesn't my mdf database work once I have uploaded the website to the server?

Posted on 2007-12-02
5
Medium Priority
?
190 Views
Last Modified: 2013-11-26
Hi,

I have created an ASP.net website in Visual Studio 2005, it all runs fine. BUT, i have just tried uploading it to the server where it is going to stored and all of a sudden the database won't connect.  The error i get when i access a page that uses the database is as follows:

"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 thought that if you developed the database inside VS2005 that you could just upload the whole site and everythinig would work.. nieve i know!!

If anyone knows how I can get the database working, please could you let me know.  I'd appreciate all help,anything you know of.

Phil
0
Comment
Question by:Artform04
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 37

Expert Comment

by:samtran0331
ID: 20391544
>>I thought that if you developed the database inside VS2005 that you could just upload the whole site and everythinig would work

The server needs to have sqlserver 2005 express running
0
 
LVL 1

Author Comment

by:Artform04
ID: 20391622
it has sql server 2005 (non express) running. Should that not take care of it?? So if i can get them to install the express edition, it should start working, is that correct?
0
 
LVL 37

Accepted Solution

by:
samtran0331 earned 2000 total points
ID: 20391754
SQL Server 2005 is not the same as SQL Server 2005 Express.

An mdf file sitting in an App_Data folder is going o look for an instance of Express running..it doesn't care that "full" SQL 2005 is running.

You might run into permissions issues, but yes, start by making sure Express is installed and running.
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20592707
Forced accept.

Computer101
EE Admin
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question