Set connection string to a remote sql server

Question

0.00/5 (No votes)

See more:

, +

Hey guys,
i'm new to the asp.net world (so far i developed in winforms desktop applications).
i just baught a domain and a windows 2008 R2 standard+PLESK hosting.
through the plesk panel, i created an sql server database.
in my local pc, i have a vb.net winform application and i'm trying to connect to the database. so far, no good.
my connectionString is like this:

"Data Source= my_ip ;Network Library = DBMSSOCN;initial Catalog=my_db_name;User ID = my_user_name;Password=xxxx"

maybe i need to mantion the port? (whats my port, i have no idea...)
again, this subject is brand new to me. any advice on how to get thing started will be very kind. and another thing: the panel is very (very!) slow and has the most basic options. is there anyway to manage the database through other platform?
thanks a lot,
oron.

Posted 27-Sep-15 1:19am

oronsultan

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-09-27T01:34:00

Solution 1

Basically the same connection string should work especially since you're using SQL server authentication.

Id suggest checking that the instance isn't a named instance and if it is, provide the name for the instance in the data source. For complete examples, have a look at https://www.connectionstrings.com/sql-server/[^]

If the hosted database is clustered then you most likely need to define the port.

Posted 27-Sep-15 1:34am

Wendelius

Comments

oronsultan 27-Sep-15 7:44am

is the user id in the connection string is the user name?

Wendelius 27-Sep-15 8:12am

Yes, the user id is the name of the user (or actually login) as recognized by Sql Server

oronsultan 27-Sep-15 8:15am

i'm still not solving this issue. is there any configuration i need to do on my side? maybe my firewall? if i have sql server on my local pc, can i connect it to my remote database?

Wendelius 27-Sep-15 8:18am

What is the exact error message you get?

oronsultan 27-Sep-15 8:23am

There was an error related to the network or instance-specific error when establishing a connection to SQL Server. The server was not found or is not available. Verify that the show right Os- SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Wendelius 27-Sep-15 8:33am

Ok, so if the SQL Server is located on a hosted server, you cannot use named pipes as the communication protocol, you need to use TCP/IP. Depending on the technology you use to establish the connection the way to configure the client may differ. One reason behind this could be the firewall blocking TCP/IP connections.

Please go through the steps described in Steps to troubleshoot SQL connectivity issues[^]