Cannot Access database

Category: sql server dbdesign

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

To change security authentication mode to mixed mode
  1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
  2. On the Security page, under Server authentication, select SQL Server and Windows Authentication mode, and then click OK.
  3. 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.