Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP 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 June 11th, 2004, 08:33 AM
Registered User
 
Join Date: Apr 2004
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error:SQL Server does not exist or access denied.

My ASP page thows an error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

But I tested - SQL Server Connection string is valid
and SQL Server box is visible for the web server box.

 
Old June 11th, 2004, 09:06 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Do you have proper permissions to access the SQL database?

Om Prakash
 
Old June 11th, 2004, 10:26 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Can you post your connection string here? May be you can replace the UID and PASSWORD values with some junk before posting here for safety.

Cheers!

_________________________
-Vijay G
Strive for Perfection





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server does not exist or access denied jennypretty Classic ASP Databases 3 May 18th, 2007 11:43 AM
SQL Server does not exist or access denied danielboland BOOK: ASP.NET Website Programming Problem-Design-Solution 13 January 5th, 2006 05:00 AM
SQL Server Does Not Exist or Access Denied hugh@kmcnetwork.com SQL Server 2000 3 September 30th, 2004 09:37 AM
SQL Server does not exist or access denied haidee_mccaffrey Classic ASP Databases 19 June 28th, 2004 09:38 PM





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