Can not open database requested. Login fails

Hallo:
Trying to connect to database using OLE DB. Gave the
following code:
con.ConnectionString="Provider=sqloledb;"&_
"Data Source=ServerName;Initial Catalog=DatabaseName;"&_
"Integrated Security=sspi;Trusted_Connection=yes;"
con.Open
Getting error message:
Microsoft OLEDB Povider for SQL Server(0x80004005).Can not
open database requested in login 'user'.Login fails.
Any solution please.
Thanks.
tinkuTinku,
May be the database has been deleted.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"tinku" <ritadi2002@.yahoo.com> wrote in message
news:1d3ab01c42351$efa2bf00$a301280a@.phx
.gbl...
> Hallo:
> Trying to connect to database using OLE DB. Gave the
> following code:
> con.ConnectionString="Provider=sqloledb;"&_
> "Data Source=ServerName;Initial Catalog=DatabaseName;"&_
> "Integrated Security=sspi;Trusted_Connection=yes;"
> con.Open
> Getting error message:
> Microsoft OLEDB Povider for SQL Server(0x80004005).Can not
> open database requested in login 'user'.Login fails.
> Any solution please.
> Thanks.
> tinku
>|||Dinesh,
It is an existing database and after adding user to the database the
problem got solved. Thank you for your e-mail.
Tinku
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!