March 15, 2013 at 12:46 pm
To access a named instance from SSMS it is SERVER\INSTANCE_NAME or SERVER$INSTANCE_NAME? I have tried both, for SERVER\INSTANCE_NAME I get an immediate "Login Failed" message so I tend to think that is it and I just don't have access? But I need a way to confirm. I can not open the SQL SERVER Configuration Manager, I get a "Cannot connect tp WMI provider, you don't have permission or the service is unreachable".
I am trying to access a Reporting server database that had a named instance of sql server installed for it but whoever did this didn't add permissions for our sqlAdmins group.... hmmm.. Any advice on this? Thank you.
March 16, 2013 at 8:04 am
use either
computername\instancename
computername, portnumber
IPaddress\instancename
IPaddress, portnumber
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 2 posts - 1 through 1 (of 1 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