April 27, 2012 at 5:31 pm
Alan Kwan (4/27/2012)
4) How do I do this?5) How do I do this?
Use portqry (link in my last post). Let me know if you have trouble figuring the cmd line. It's a bit cryptic.
To find the port # look in the SQL Server Error Log: remote to server, open Management Studio, then do this to view the error logs.
By the way, when I connect the through ODBC, the server drop down list is blank. Not sure if this is relevant.
That is an indication that you cannot broadcast to, or receive from, UDP port 1434 from your machine. It may be a network security configuration at your site preventing that. Once you know the SQL Server port # (from Error Log steps above) you can change your connection host name in the DSN connection from:
SERVER\INSTANCE
to:
SERVER,PORT
like this:
MYSERVER,1713
which will bypass port-resolution, i.e. does not use SQL Browser so does not need to communicate on UDP port 1434.
I am done for a while, good luck!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 9:39 am
I have located the general direction of the problem.
I was able to connect when I turn off my firewall. So it MUST BE a firewall issue.
What should I do now?
April 30, 2012 at 10:09 am
"my firewall" meaning the firewall on your machine?
What port is your SQL Server running on? Did you use portqry? Is your firewall preventing access on the SQL Server TCP port or the Browser UDP port?
If you have the ability to do so you can add an outbound rule to your firewall to allow the traffic to pass through as needed, while still keeping the firewall in place, preferred.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 10:13 am
Sorry, it's the firewall of the server machine. The issue is solved now, after I identified it's firewall problem, I did a little bit of research myself, and followed the steps in this article.
http://msdn.microsoft.com/en-us/library/ms175043.aspx
And everything is working like a charm now.
Thank you very much for all your help, I really appreciate it! Kudos!
April 30, 2012 at 10:18 am
Excellent work! Happy you got it working 🙂 Thanks for posting back too, hopefully it may help someone else down the line.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply