April 25, 2015 at 2:37 am
Hi
I have Db1 On my server Which has a user : User1
When I login with this user to ssms , And Click to Database , This error message raised :
"The Database Db1 is not accessible. (Object explorer)"
These are my tries and All info :
1- From This login, Is created a user to another databases , And all of them work properly.
2- Another User From Another Login, with full access to this db (db_owner) , Cause such error : "The database ..."
3- If a User (such as User1) be sysadmin , It Works Properly. But I dont want get this level access to this user.
4- If I changed The database owner from sa to User1 , It works Properly . (EXEC sp_changedbowner 'User1') !!!!! , But I dont Want to do this.
5- I backed Up , And Restore , The problem still remains. (More over I restored It on Another server : The problem Remains!!!!)
>>>>>> Then : I think Problem is in this database , and not related to login , server , ....
--------------------------------------------------------------------------------------
I read from internet and did some things that they say : Offline and Online , ....
But any of them didnt work.
Please help me.
April 26, 2015 at 10:56 am
Quick thought, create the user login and grant the appropriate permissions
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply