Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 4th, 2007, 10:49 AM
Authorized User
Join Date: Mar 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server remote connection error

Hi all,

I've got an error in my application when I have published it up to a remote server:

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'm using membership and the ASPNETDB sql server express database which is created as default. I'm using Windows Authentication.

On my own PC it works perfectly, but when I publish to the hosted website, I get the error message above.

I don't have access to SQL Server on the remote machine and I cannot run any commands. I've been working on this for 4 days, and this is the last thing I need to sort out for the website to go live.

If anyone has any idea of what I have done wrong, please help!

Appreciate a response...

Reply With Quote
  #2 (permalink)  
Old April 6th, 2007, 07:17 PM
Registered User
Join Date: Apr 2007
Location: New Delhi, Delhi, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to prashant_victory@hotmail. Send a message via Yahoo to prashant_victory@hotmail.

actually in ASP.NET wht i know is you can work with embeded database in asp.net on your local machine only and till the time ur not going to publish ur website or host ur website , when u want to host ur website u have to seaprate ur sql database and run it on sql server not from the aspnetdb.

the above article will help u...
Read the "Deploying a SQL Server Express Edition Database" section of above article.

Prashant Pandey
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remote connection error with SQL Server Express DudeBori82 SQL Server 2005 4 April 12th, 2009 01:51 AM
Remote Connection to SQL Server asharkashif Visual Studio 2005 1 November 24th, 2007 12:11 PM
SQL Server Remote Access error sterreyl BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 April 18th, 2007 01:24 PM
Bugbase SQL 2005 remote connection error dtcalif BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 January 12th, 2007 06:46 PM
SQL server connection error Mayuri25 Pro VB Databases 4 September 12th, 2005 05:42 AM

All times are GMT -4. The time now is 02:53 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.