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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy