nasemabdullaa
asked on
Management Studio cannot find my SQL but I can connect to the SQL server by IP address or by name
Hi
I'm Install new SQL server 2008 enterprise addition on windows server 2008 enterprise addition. I can connect to SQL server from outside company using Public IP address and I can connect using private IP address from inside also I can connect to SQL server by name from inside . But the problem is the SQL management studio cannot find SQL when I try to search it in instance
I do not know the problem I check the browser in SQL service and its work
Please any Idea
Regards
I'm Install new SQL server 2008 enterprise addition on windows server 2008 enterprise addition. I can connect to SQL server from outside company using Public IP address and I can connect using private IP address from inside also I can connect to SQL server by name from inside . But the problem is the SQL management studio cannot find SQL when I try to search it in instance
I do not know the problem I check the browser in SQL service and its work
Please any Idea
Regards
Yes, the system admin would need to associate an external name to that IP in DNS.
If the issue is that you do not see the SQL Server when you click the "Browse for more" option in the server name drop-down when connecting in SSMS, then it may be that the instance has been configured to be hidden (not enumerated by the Browser service). See http://msdn.microsoft.com/en-us/library/ms179327.aspx, which details how to hide an instance. You would change the Hide Instance option to No if this is the case with your instance.
If possible, you may also want to see if browsing for the instance works from a host on the same subnet/VLAN as the instance host, but not from hosts (such as your workstation, perhaps) which are on different subnets/VLANs from the instance. If you only have an issue from hosts not on the same subnet as the SQL Server host, then UDP port 1434 traffic may not be forwarded off the SQL Server host's subnet. See http://msdn.microsoft.com/en-us/library/ms188200.aspx and http://msdn.microsoft.com/en-us/library/ms181087.aspx for information on the "Browse for server" dialog box and the Browser service.
If possible, you may also want to see if browsing for the instance works from a host on the same subnet/VLAN as the instance host, but not from hosts (such as your workstation, perhaps) which are on different subnets/VLANs from the instance. If you only have an issue from hosts not on the same subnet as the SQL Server host, then UDP port 1434 traffic may not be forwarded off the SQL Server host's subnet. See http://msdn.microsoft.com/en-us/library/ms188200.aspx and http://msdn.microsoft.com/en-us/library/ms181087.aspx for information on the "Browse for server" dialog box and the Browser service.
ASKER
Hi
Thank you for all reply
Please I use internal DNS I mean my DNS is not registered and I use my ISP DNS as second DNS. Also I do not want to connect from outside using name I will use IP address and its work now. But I need to find the SQL server when I click"" Browse for more"". Please now I can connect to the server from outside using public IP address and that is OK and I can connect from inside using private IP address or name server but the problem that management studio cannot find the instance when I click "" Browse for more"" I need the management studio to find the SQL because I have program need to find the server in management studio to connect to it
Regards
>>>>If the issue is that you do not see the SQL Server when you click the "Browse for more"
yes this is the issue. Please I check and the instance has been configured to be visible (not hidden)
Thank you for all reply
Please I use internal DNS I mean my DNS is not registered and I use my ISP DNS as second DNS. Also I do not want to connect from outside using name I will use IP address and its work now. But I need to find the SQL server when I click"" Browse for more"". Please now I can connect to the server from outside using public IP address and that is OK and I can connect from inside using private IP address or name server but the problem that management studio cannot find the instance when I click "" Browse for more"" I need the management studio to find the SQL because I have program need to find the server in management studio to connect to it
Regards
>>>>If the issue is that you do not see the SQL Server when you click the "Browse for more"
yes this is the issue. Please I check and the instance has been configured to be visible (not hidden)
It is still not clear whether your want to find MSSQL using the private or public IP. The latter is impossible.
ASKER
Hi
Thank you for your reply
Please I want to see the SQL server in instance (Management studio)(brows for more) from inside I mean private IP address
Regards
Thank you for your reply
Please I want to see the SQL server in instance (Management studio)(brows for more) from inside I mean private IP address
Regards
If you don't see any MSSQL Server when browsing, check your firewall settings if they allow for incoming udp/1434. Best to switch it off for a test.
ASKER
Hi
Thank you for your reply
Please I can see the other SQL server I have three SQL server but I can not see this server
Regards
Thank you for your reply
Please I can see the other SQL server I have three SQL server but I can not see this server
Regards
HI,
As you said the you are able to connet to SQL server using IP address.
So it is not firewall problem.
Now i understand your ponit, That you want to see the SQL Server instance name in the SSMS.
Is the system where you are using SSMS to connect is in the same domain or diffreent domain or it in workgroup?
If it is in workgroup.I would say you have to try connectserver using IP address.
As you said the you are able to connet to SQL server using IP address.
So it is not firewall problem.
Now i understand your ponit, That you want to see the SQL Server instance name in the SSMS.
Is the system where you are using SSMS to connect is in the same domain or diffreent domain or it in workgroup?
If it is in workgroup.I would say you have to try connectserver using IP address.
ASKER
Hi
Thank you for your reply
Please the computers in other domain and I use mixed mode when I install SQL server therfore I connect using IP address but I need to find SQL server in Mangment studio. Plesae can I find it or I need to enter all computer using this SQL server to the same domain
Regards
Thank you for your reply
Please the computers in other domain and I use mixed mode when I install SQL server therfore I connect using IP address but I need to find SQL server in Mangment studio. Plesae can I find it or I need to enter all computer using this SQL server to the same domain
Regards
HI,
Would you please tell me the requirement of your program. What it wants to interact with the SSMS.
Would you please tell me the requirement of your program. What it wants to interact with the SSMS.
HI
Hope the below link will help you.
http://stevenharman.net/blog/archive/2006/10/25/SQL_Server_2005_Management_Studio__Clear_Recent_Servers_List.aspx
Hope the below link will help you.
http://stevenharman.net/blog/archive/2006/10/25/SQL_Server_2005_Management_Studio__Clear_Recent_Servers_List.aspx
ASKER
Hi
Please I have Archive program and this program design by VB.net. This program allowed me to connect to SQL server by below way
1- From outside using IP address (if I'm outside company use public IP address and if I'm in out in any branch of our company connect use privet IP address all branch connect together by VPN)
2- From inside I have search bottom to find the SQL server and if I cannot see it I cannot connect ti the server
3- Because the SQL management studio cannot find the instance the program cannot find it) the search bottom in the program work as same the management studio when click "brows for more)
Regards
Please I have Archive program and this program design by VB.net. This program allowed me to connect to SQL server by below way
1- From outside using IP address (if I'm outside company use public IP address and if I'm in out in any branch of our company connect use privet IP address all branch connect together by VPN)
2- From inside I have search bottom to find the SQL server and if I cannot see it I cannot connect ti the server
3- Because the SQL management studio cannot find the instance the program cannot find it) the search bottom in the program work as same the management studio when click "brows for more)
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
HI
Hope the below link will help you.
http://stevenharman.net/blog/archive/2006/10/25/SQL_Server_2005_Management_Studio__Clear_Recent_Servers_List.aspx
Hope the below link will help you.
http://stevenharman.net/blog/archive/2006/10/25/SQL_Server_2005_Management_Studio__Clear_Recent_Servers_List.aspx
ASKER
Hi
Thank you for all reply I raed and try all above but its stll not working
and help
Regards
Thank you for all reply I raed and try all above but its stll not working
and help
Regards
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please check with you windows sys admin.
Whether the SQL Server name hasbeen in sync with DNS.
If you created the server newly. It would take some time for the DNS to get sync.