November 17, 2005 at 9:06 am
A database has just been restored an usually you will look at synchronizing users when there are issues...
There are no orphaned users .The agent is running and surprisingly
when trying to connect the error
Microsoft Sql Server Driver Sql Server
cannot open database " test" requested by Login. The Login failed
On the Server the database is opened with no problem even with osql on the command line there connection works just fine or sometimes could not locate entry in sysdatabases for Test
Your input will be appreciated
Mike
November 17, 2005 at 9:43 am
Mike,
Did you check the pasword for the person on a new server?
The user on another server may exist but his/her/its password is different from the one you have in the script or job that is trying to connect.
Regards,Yelena Varsha
November 17, 2005 at 10:01 am
when default database is master login works just fine when a user database is chosen then "Cannot open user default database Login failed" comes up
As usual your input is greatly appreciated
Mike
November 17, 2005 at 10:17 am
For some reason the user had rights revoked from the database in question.
Once the rights were given all seems to work fine
Let your the remainder of your day be good and peaceful
Mike
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply