March 19, 2008 at 5:53 am
The users within a particular domain group are having trouble accessing all the appropriate databases via their SQL Server Management Studio client. They receive the error message, “The database is not accessible. (Object Explorer).
Am I lacking some permissions. All the related databases are in a Multi_User mode, Normal Status.
I'm using SQL Server 2005 Mgmt Studio.
Thanks in advance for all the fwd solutions.
Mathur
March 19, 2008 at 6:54 am
There should be some error code, severity state.. Please check them. Check SQL Server log files and application log.
Piotr
...and your only reply is slàinte mhath
March 19, 2008 at 7:21 am
Hi,
The problem says----->
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.GetChildren()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView summaryView)
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView summaryView, List`1 columnDescriptors)
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
March 19, 2008 at 7:33 am
Are there any errors in the sQL error log from around the same time?
does that domain group have access to the DB in question?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2008 at 8:18 am
Do they have any SSMS plugins installed? They also tend to screw things sometimes.
Piotr
...and your only reply is slàinte mhath
March 19, 2008 at 8:53 am
The domain has all the relevent access to the related Dbs.
March 19, 2008 at 10:39 am
I had this once where you could not view the tables when someone was running a hugh update statement and then i could not view the tables. Is any process running that is active.
March 19, 2008 at 11:13 am
Hello,
I think that your problem is as follow, someone as revoke the view existing databases to your user or from public.
use master
go
revoke view any database from public
go
You could try one of the following command to try to revert the situation.
grant view any database to {username}
go
or
grant view any database to public.
go
Hope this can help you.
Regards 😉
JMSM
December 1, 2010 at 10:57 am
I just had this occur with all user databases on one of our SQL 2005 servers. It turned out to be the database owner. The DBA's domain account was the owner of two of the databases and there was no owner for several others. I changed the owner on these databases to 'sa' and access was once again granted for our developers.
I figure the original post has been long corrected, but this may help someone else in the future.
April 19, 2012 at 4:39 am
Recently had this issue.
Turned out that the drive holding the .ldf was full.
Shrank another ldf on that drive to free a bit of space, bounced SQL - db came online.
Shrank the problem database log.
Job done.
June 14, 2012 at 1:18 pm
Here's something else to try, if you've come here looking for suggestions:
1. Log into SSMS as the user for whom the DB in question isn't accessible.
2. Right-click on the inaccessible DB
3. Click 'Properties'
If you see an error message indicating that a 'Server Principal' does not have access to the DB, re-login as 'sa' and give that 'Server Principal' access to the DB in question ( Logins->{username}->Properties->User Mapping ).
This should open up the DB in question for the user who is getting the 'inaccessible' message.
I hope this info is helpful.
May 19, 2013 at 11:19 pm
Hi,
Login with the problem db as default db is not able to connect to server.
Thanks,
Pavan
June 24, 2013 at 2:21 pm
I get the error the Database is not accessible for a user.
What is wrong?
I can't find an answer.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2013 at 2:27 pm
Please post new questions in a new thread and give as much information example as possible, including exact error messages, anything unusual in the error log, etc.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 2:28 pm
Welsh Corgi (6/24/2013)
I get the error the Database is not accessible for a user.What is wrong?
I can't find an answer.
What have you tried? Did you read through this thread (which by the way is from 2008)? You really should start your own threads instead of hijacking another one.
We can't help you find an answer because we don't have any idea what you have tried or any details about what is going on.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply