[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

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

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?
0
kwh3856
Asked:
kwh3856
1 Solution
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
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,
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
0
 
kwh3856Author Commented:
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?
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
can you check with the 3rd point in "Server-related causes"

http://support.microsoft.com/kb/328306

and

http://support.microsoft.com/kb/328383
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Carl TawnSystems and Integration DeveloperCommented:
How are you trying to connect from Visual Studio? Are you talking about your code, the Server Explorer, or something else?
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
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?
0
 
chandra_darbhaCommented:
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.

Thanks,
Chandra
0
 
kwh3856Author Commented:
I am trying to connect through Server Explorer Data Connections
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Is this what you were looking for?
0
 
kwh3856Author Commented:
rikin,
I tried that and it responded with invalid connection string.
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
can you try this connection string!

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
0
 
kwh3856Author Commented:
Rikin,
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.

Thanks
Kenny
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now