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 > BOOK: Beginning ASP.NET 2.0 and Databases
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 2.0 and Databases
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 and Databases by John Kauffman, Bradley Millington; ISBN: 9780471781349
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 and Databases 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 March 30th, 2009, 05:05 AM
Authorized User
 
Join Date: Mar 2009
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy connection to the sql database

I have designed a website ASP.NET and in the website I have made a contact and username and password form. I have created the database file Sql. Now i am getting below mentioned error in remote server, locally it works fine.

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "

Please explain me how to solve this error.

Thanking you,
Apurva
  #2 (permalink)  
Old March 30th, 2009, 03:42 PM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

That error literally means your application is unable to locate the Server you specified. This can be caused by a myraid of reasons most noteably: you have specificed an incorrect server name, the web server that you are getting the error from cant "see" the sql server, and so on.

Are you actually using SQL Server or are you attaching an MDF to some instance of SQL Server on the web server?

-Doug
__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================
  #3 (permalink)  
Old March 31st, 2009, 12:22 AM
Authorized User
 
Join Date: Mar 2009
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Question Connection to the sql database

Thank you Mr. Doug for your immediate response.

I am not using Sql server. We have taken web server space to host our website. I am just attaching the MDF file.

I have with me Sql server IP address, port no., UserID and Password with me.

Pl. let me know how to proceed further.

Thanking you,

Apurva


  #4 (permalink)  
Old March 31st, 2009, 02:12 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Apurva:
Where does the .mdf file reside? It is not clear from your question.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
  #5 (permalink)  
Old March 31st, 2009, 02:57 AM
Authorized User
 
Join Date: Mar 2009
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Question connection to the sql database

The .mdf file is resided in App_Data folder.
  #6 (permalink)  
Old April 1st, 2009, 02:38 AM
Authorized User
 
Join Date: Mar 2009
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy connection to sql database

Dear p2p forum,

I am eagerly awaiting for the answer about my query on above said subject. I have intimated you that the .mdf file is resided in the App_Data folder.

I hope the all the details like sql server IP address, port, UserId, and password should be written in web.config file. But I am not clear.

Pl. help me out and indicate the way the path to be written.

Thanking you,

Apurva
  #7 (permalink)  
Old April 1st, 2009, 05:52 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Apurva:

Scroll to the list of "Similar Threads", located at the bottom of your thread. Click the thread by fs22. Open the thread, then scroll to the bottom again for the list of "Similar Threads"'. Open the thread entitled "connection strings issues, web.config issues. Planoie suggests two web sites to visit. In your case, the following url is very helpful: http://www.connections.com/ . Check it out.


Hope this helps.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
 


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
SQL Server Connection and Database Problem workib C# 1 November 13th, 2008 03:26 PM
Database connection with SQL Server yubaraj JSP Basics 3 May 29th, 2007 04:39 AM
SQL Connection/Database Issues fs22 ASP.NET 2.0 Basics 0 August 1st, 2006 03:17 PM
MS SQL Database Connection Adam H-W SQL Server 2000 0 July 20th, 2005 12:01 PM



All times are GMT -4. The time now is 05:07 PM.


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