Change of connection string to make application online accessable

Question

0.00/5 (No votes)

See more:

Hi,
I have a winforms application that uses SQL Server Databases. The connection string in data source is something like

Data Source=Office1\SQLEXPRESS;Initial Catalog=dbRepHost;Integrated Security=True

Now I have hosted the DBs on a web server to access the online DBs. I have attached the DBs.

The new required connection string is

Data Source=dbRepHost.mssql.somee.com;Initial Catalog=dbRepHost;Persist Security Info=True;User ID=nouman;Password=abc123

My question is if it is enough to change the connection string in app.config file or I need to edit all data sets to and change the connection string?

Thanks

Posted 10-Feb-13 6:08am

Furqan Sehgal

Updated 10-Feb-13 6:09am

Thomas Daniels

v2

Add a Solution

2 solutions

Solution 2

From the look of your new connection string, it looks like you're hosting it somewhere on the internet.

Microsoft SQL Server requires certain ports to be opened to communicate over a firewall. The default SQL Server port is 1433, and client ports are assigned a random value between 1024 and 5000.

Now if this server is on the internet: *don't open those ports*, unless you know what you are doing.

Please read Encrypting Connections to SQL Server[^] - or even better: Expose you datalayer as a web-service, and use SSL to communicate with that web service.

Best regards
Espen Harlinn

Posted 10-Feb-13 10:39am

Espen Harlinn

Comments

Abhinav S 11-Feb-13 0:31am

Sounds good. 5.

Espen Harlinn 11-Feb-13 4:27am

Thank you, Abhinav :-D

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)

Abhinav S · Accepted Answer · 2013-02-10T06:13:00

Solution 1

Ideally, if you have done your coding right, you should only need to change App.Config and nothing else.
That is exactly the benefit of storing connection string in App.Config.

If not, you should look at changing your code so that you pick up the connection string from this file.

Posted 10-Feb-13 6:13am

Abhinav S

Comments

Sandeep Mewara 10-Feb-13 14:21pm

Exactly. My 5.

Abhinav S 11-Feb-13 0:32am

Thank you.