SQL Database access through C# application

Question

0.00/5 (No votes)

See more:

, +

Hello everyone! This is my first question ever so I hope I do everything correctly. Please feel free to provide feedback on how to use the community website since I'm eager to learn.

I am about to complete an application that runs different databases, 2 locals within the client computer, and a 3rd one MS SQL Database that I have hosted with Hostgator.

Right now, in order to work with SQL Management Studio or so, I need to whitelist the IP that I am currently using so that I get access. My question is that if this must be done for all the computers that will need to access the MS SQL application in order for them to be able to connect when the application is actually deployed.

I was told that I shouldn't need to, but I want to be 100% sure. That would be pretty stupid IMO.

Thanks in advance

PS. I have a functioning Connection String with successful connections, which then I use in DataSets in order to work with those within the Windows Forms Application.

Connection String:
Provider=SQLNCLI11;Data Source= Valid IP;Password= paspas;User ID=useradmin;Initial Catalog=Database1

Posted 24-Jun-13 7:21am

Julio Zuart

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)

Ron Beyer · Accepted Answer · 2013-06-24T07:30:00

Solution 1

If you are accessing the system from a Windows Forms application, then I would say yes (with the caveat of asking HostGator directly) you have to white-list them.

Most providers only allow the database to be accessed from its domains. This is because they are meant to be the data back-end to websites. Using it from a Windows application is a different usage scenario.

The alternative (and probably better course) is to develop a Web Service application that interacts with your database. This way you can more tightly control what data goes into and out of your database, rather than put the power in the hands of anybody who gets your application. (Connection strings like the above, with unlimited access is a great way to hack, and not in a good way).

Posted 24-Jun-13 7:30am

Ron Beyer

v2

Comments

Zoltán Zörgő 24-Jun-13 13:53pm

Good points! My 5!

Ron Beyer 24-Jun-13 14:00pm

Thanks!

Julio Zuart 25-Jun-13 9:55am

I entirely agree :)

Julio Zuart 25-Jun-13 9:45am

Thank you very much for your prompt reply!

I am going to go crazy over this. I am very tight on schedule and I don't have any kind of experience with webservices. Do you happen to have a quick guide for dummies?
Also, stating that the interaction with the Web Database is as follows:
1. When the program starts, it tries to connect and "pour" all the information into the database
2. The server returns an access database which is an export of the server one (I have never worked with MS SQL Server scripts, with any scripts yet :( )
Based on this, how complex would you judge the service to be?

I know that my questions aren't yet specific, and thank you very much for your replies since they have provided the peace of mind I was looking for.