|
 |
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
|
|
 |