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

> :

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>