April 6, 2016 at 6:27 pm
I am using SSMS 2008 and can connect to my DB, but can't see it in the object explorer pane. I can see two folders "System Databases" and "Database Snapshots", but get an error when I try to expand them. I know I'm connected because I can execute queries from a query window. My database is also shown in the 'Available Databases' window.
Thanks for any help or suggestions.
April 6, 2016 at 9:04 pm
Is the SQL server instance 2008 as well ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 7, 2016 at 1:31 am
Screen shot please.
April 7, 2016 at 6:28 pm
SQL 2008. Have no problems using 2014 on another system. Screen shots attached. Thanks for your help.
April 7, 2016 at 7:31 pm
See if this helps.
https://support.microsoft.com/en-us/kb/956179%5B/url%5D
Please note the issue occurs only if the user trying to connect is not a sysadmin.In your case if you are a sysadmin and are trying to connect and still getting the error then I guess only option would be to reinstall SSMS.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply