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 |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2012-01-25 : 12:09:06
|
| Hi there,I try to connect a sql server in my sql management studio but got error msg: "error: 26 Error locating server / instance specified". I can access that sql server through RDP connection and doing some admin jobs there. I am sure the instance name is right ... What should I configure to make it accessible to me? Thanks in advance. |
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2012-01-25 : 12:33:19
|
| Here is a great article on connection issues. There are some simpler steps in there to confirm access is enabled. Let me know if you have any questions about the steps.http://forums.asp.net/t/1499314.aspx/1Steve |
 |
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-01-25 : 15:15:19
|
| thanks steve, I tried all the possible settings but the problem is still there. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2012-01-25 : 15:39:10
|
| Or even IP:PortnumberSteve |
|
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2012-01-25 : 15:43:27
|
| Another simple thing could be your firewall. RDP already has exceptions to allow remote connections however default SQL might not be allowed. Disable the firewall temporarily and confirm whether access is or isn't there.Steve |
|
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-01-26 : 12:45:35
|
| Hi guys thanks for the replies. I tried everything possible no luck. I noticed that there are 2 sets of ip used in that sql server so I think it could be the DNS or firewall (not firewall setting in the server) issues. |
|
|
|
|
|
|
problem to connect other sql server