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

Is the username/password in your OLEDB connection string the same as what

you are using to connect via EM?



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Berkhoudt, Rene" <RBerkhoudt@s...>

Subject: [asp_database_setup] OLE DB Access Denied





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

:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~