Cannot open database requested in login

[heidiwags]

I currently am trying to connect to a SQL Server 2000 database from an ASP page and a Java connection. I can connect to the database fine using ODBC locally, but when I try to create my connection string in ASP with the same username and password, I get an error

Also, on the same server, I currently am connecting to a different database in ASP and that works fine

Here is my connection string and error
mstrConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=userid;Password=password;Initial Catalog=catalog;Data Source=servername.com

Microsoft OLE DB Provider for SQL Server (0x80004005
Cannot open database requested in login 'catalog'. Login fails.

[Ray at]

If you open Query Analyzer, select servername.com, select SQL
authentication, COPY AND PASTE the userid from your connection string, COPY
AND PASTE the password from your connection string, connect, and then
execute USE CATALOG, do you successfully get in?

Ray at home


"heidiwags" <heidiwags99@yahoo.com> wrote in message
news:605CFA45-2AF3-4E73-8FA0-F9D0B3ADC875@microsoft.com...

> I currently am trying to connect to a SQL Server 2000 database from an ASP

page and a Java connection. I can connect to the database fine using ODBC
locally, but when I try to create my connection string in ASP with the same
username and password, I get an error.

>
> Also, on the same server, I currently am connecting to a different

database in ASP and that works fine.

>
> Here is my connection string and error:
> mstrConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User

ID=userid;Password=password;Initial Catalog=catalog;Data
Source=servername.com"

>
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> Cannot open database requested in login 'catalog'. Login fails.