Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SSMS

Author  Topic 

bigmix38
Starting Member

6 Posts

Posted - 2014-12-11 : 13:04:46
I am having issues where I am sysadmin on the sql server, but I can not log in to SSMS on the server. I am running 2008r2. What kind of permissions am I missing?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-11 : 13:59:59
Show us the error.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

bigmix38
Starting Member

6 Posts

Posted - 2014-12-11 : 15:06:12
Simliar to the error in this link......Thanks


http://social.technet.microsoft.com/wiki/contents/articles/1411.ssms-error-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server.aspx
Go to Top of Page

bigmix38
Starting Member

6 Posts

Posted - 2014-12-11 : 15:07:40
All in the link is done.....
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-11 : 15:10:37
That isn't a permissions issue. That is a connectivity issue. It can't make a connection, hasn't even tried to use your credentials yet.

Typically this is a SQL Browser/port issue or a firewall issue. But first things first, make sure the SQL Server service is in a started state. Then try connecting with ServerName,PortNumber. If you don't know the PortNumber, you can find it in the active Errorlog file (LOG directory in the file system). If you can connect that way, then you can add an alias so that you don't have to remember the port. If the port number doesn't work, then a firewall issue is suspected. You would need to do a telnet test. Let's take it one step at a time though.

And this blog article I wrote a while back addresses this issue: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

bigmix38
Starting Member

6 Posts

Posted - 2014-12-12 : 15:45:32
Still getting the same error msg..

Even when I do an sqlcmd from the command prompt, it gives me the same msg.

Thanks
Go to Top of Page

bigmix38
Starting Member

6 Posts

Posted - 2014-12-12 : 16:26:36
Question and I think I may have solved the issue...

If I am clustered and can see the server thru the cluster controller via SSMS, does this mean I am good.

Ex. DB1(IP001) and DB2(IP002) are my DBs. DBSQL(IP003) is my cluster controller. I can log on to DB1 and DB2, but can't get to SSMS. But I can log on to DBSQL and get to DB1 as well as get to SSMS.

I was on the DB1 via Remote Desktop and did a remote to DBSQL and it logged me out of DB01 when I got connected via Remote desktop.

Am I correct in assuming I am ok because of the clustering....

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-15 : 12:04:20
I am not following your last post. If you are having issues connecting remotely, then you need to go through that link I posted. Sqlcmd is no different than SSMS when it comes to the connection. Specify port number in both to see if it works. If it does, then resolve it with an alias.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -