When I try to make the connection, the following message appears
"Cannot open database requested in login 'DBName'. Login fails."
Err Code = -2147467259
We are using SQL Server 2000 on NT Server 4.0 SP 6.
The client machine has MDAC 2.6 SP1.
All ideas are welcome.
ThanksSounds like the connection to the server has been made but the login cannot open the database. Could be because the database does not exist or because the login does not map to a valid user in the database.
Try just connecting to master.
No comments:
Post a Comment