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