Solved

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

Posted on 2007-12-02
5
188 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 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

717 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