• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

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

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
Artform04
Asked:
Artform04
  • 2
1 Solution
 
samtran0331Commented:
>>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
 
Artform04Author Commented:
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
 
samtran0331Commented:
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
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now