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.
| 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 |
|
|
bigmix38
Starting Member
6 Posts |
Posted - 2014-12-11 : 15:06:12
|
| Simliar to the error in this link......Thankshttp://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 |
 |
|
|
bigmix38
Starting Member
6 Posts |
Posted - 2014-12-11 : 15:07:40
|
| All in the link is done..... |
|
|
|
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.aspxTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
SSMS