December 17, 2008 at 9:44 pm
Dear all
I have changed the default port (1433) of sql server default instance to different port no. Service started successfully and able to connect using hostname and using local (.) but I am not able to connect to sql server using IP addresses of the server. I have configured Alias Name in client network with new port no, after that I am able to connect using IP. But my application is not able to connect to database now. Connection string contains only IP address of the server and nowhere port is mentioned.
Browser service is running in the server.
It will be greate if I get the clarification (what exactly each option means) for the configuration page (Protocol Tab, IP Address Tab) in TCP/IP protocol properties.
Regards
Kokila K
December 17, 2008 at 10:28 pm
Try it like this in your connection string "111.222.333.444:1433"
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 18, 2008 at 7:23 am
Just so you understand the data following the colon in Barry's post is the port number.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 18, 2008 at 8:32 am
I have never used a colon except for JDBC, otherwise I use a comma to specify port after the IP.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 18, 2008 at 9:30 am
I have never tried the comma, always seen and used the colon seperator.
December 18, 2008 at 9:46 am
like Barry said, mention the ip address like this:
127.0.0.1:[the new port number].
since you changed the port number, the sql server will then listen to new port number.
December 18, 2008 at 10:03 am
Well now that you mention it, I realize I'm inconsistent and use both. I don't see it consistently on the web either, though the comma seems more prevalent. The colon is used in URLs, so I might recommend that more.
December 18, 2008 at 12:42 pm
Well if the colon (":") doesn't work, then I would try it with a comma (",") instead. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply