How do you tell Visual Studio 2010 to Connect to a SQL 2008 server running on port 11433

Posted on 2011-03-21
Last Modified: 2012-08-14
I am trying to connect to a SQL 2008 server that is running TCP on port 11433.  Visual Studio wants to connect to the server of 1433.  The two are just not seeing eye to eye.  How do I make VS 2010 connect on port 11433?
Question by:kwh3856
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 19

Expert Comment

by:Rikin Shah
ID: 35186611
I'm not sure with your problem, but if you can check the settings and 4th point (Enable Remote Connection) in below link.

see if this helps,

Author Comment

ID: 35186738
Great artical but still no luck.  I have multiple NICs in the SQL 2008 server and I tried changing the Port for the NIC in Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER - TCP/IP -> Properties --> IP Addresses TCP Port on the IP Address of the NIC that I am trying to access.  I changed it from 11433 to 1433.  Rebooted the server and still no luck.  I checked the registry and saw the changed had been updated.  I made specific rule in the firewall for the port....NO Luck:)  

Any Ideas?
LVL 19

Expert Comment

by:Rikin Shah
ID: 35186824
can you check with the 3rd point in "Server-related causes"

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

LVL 52

Expert Comment

by:Carl Tawn
ID: 35187182
How are you trying to connect from Visual Studio? Are you talking about your code, the Server Explorer, or something else?
LVL 19

Expert Comment

by:Rikin Shah
ID: 35187974
yes to server explorer.
- open your VS.NET project
- go to server explorer
- right-click on 'Data Connections'
- select 'Add Connection'
- Advanced...
- Data Source = "SERVER=servername;DATABASE=YourDataBaseName;Network=DBMSSOCN;Address=IP_Address,1433;UID=YourUID;PWD=YourPassword;"

try this if it works!

BTW, are you able to connect sql server through Management Studio?

Expert Comment

ID: 35188479
You should add an alias on the client machine which is (where the VS is) connecting to the SQL Server in SQL Server Configuration Manager -> Aliases.


Author Comment

ID: 35188826
I am trying to connect through Server Explorer Data Connections
LVL 19

Expert Comment

by:Rikin Shah
ID: 35188845
Is this what you were looking for?

Author Comment

ID: 35188855
I tried that and it responded with invalid connection string.
LVL 19

Accepted Solution

Rikin Shah earned 500 total points
ID: 35188869
can you try this connection string!

Data Source=,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Author Closing Comment

ID: 35189477
That was it.  My mistake initially was that I put Data Source x.x.x.x:11433 and I should have put x.x.x.x,11433.  Works like a champ now.


Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question