Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Re: OLE DB Access Denied


Message #1 by "Raj Kotecha" <radicalx2000@y...> on Tue, 2 Apr 2002 19:14:06
If you have a firewall try disabling it and try again. I wrestled with 
this problem for an hour before disabling my Norton firewall at which 
point everything worked fine.

> I recently set up an OLE DB connection to SQL Server.  Everything worked
> great for two weeks.  Then suddenly I started to pick up the error :
> 
> Technical Information (for support personnel)
> *	Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or 
access
> denied.
> /Mining/ADO/lifeform.asp, line 22
> Line 22 of my asp form points to my connectstring.
> 
> 
> The thing is this script worked fine before.  I believe that someone (an 
SA)
> has inadvertently changed some permissions on the Server that hosts the
> Sequel database.  What should the proper settings be?  I can still 
connect
> using Enterprise manager or using a system DSN to the SQL Server.  Only 
my
> access via OLE DB on ASP is now denied.
> 
> 
> Thanks

  Return to Index