Question
LisaKruger on Wed, 20 Nov 2019 14:28:53
Please need help. I cannot access any databases. The only one i can access, i cannot access the system objects like tables,views....
When i click on the database that i cannot access, i am getting the following error
TITLE: Microsoft SQL Server Management Studio
------------------------------
The database IR is not accessible. (ObjectExplorer)
The server level security is like the screen shot. How can i log in as "sa" if i have the password and what access needs to be granted to the user to alleviate the above issues. Please advice.
Thanks
Replies
Uri Dimant on Wed, 20 Nov 2019 14:43:06
>>>The database IR is not accessible. (ObjectExplorer)
Yep, you do not permission to access that db
>>How can i log in as "sa" if i have the password and what access needs to be granted to the user to alleviate the >>>above issues
Your server should be configured with Mixed authentication mode
- In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
- On the Security page, under Server authentication, select SQL Server and Windows Authentication mode, and then click OK.
- https://help.blacknight.com/hc/en-us/articles/212511129-Set-MS-SQL-to-mixed-mode-Authentication-on-Windows-Cloud-VM
Regarding sa
https://serverfault.com/questions/35505/cant-connect-to-sql-server-using-sa-account-what-im-missing
LisaKruger on Wed, 20 Nov 2019 15:11:02
Thanks Uri Dimant. That fixed it.