Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 4th, 2007, 10:49 AM
Authorized User
Join Date: Mar 2007
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...

Old April 6th, 2007, 07:17 PM
Registered User
Join Date: Apr 2007
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

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

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.