WIndow form accessing a SQL Server on network

Currently we have a C# .net windows application that uses a local desktop instance of SQL Server.  We wanted to know the challenges of changing this model to using a single instance of a SQL Server on a network.

First, I am assuming it is not a problem for a desktop windows form application to access a SQL server on a internal network given the connection parameters are provided.  Please correct me if I am wrong.  What other things do we need to consider if we decide to make this change?
HojoformoAsked:
Who is Participating?
 
rawinnlnx9Commented:
This is a larger topic than you are aware of. Mainly you need to configure your connection strings to use an SQL server by name or IP on the network.

This is from my config file, yours should be in app.config. You need to use a connection string that has been configured to use that server.

<add name="SiteSqlServer" connectionString="Data Source=WEBDEV\SQL2005;Initial Catalog=LAB;User ID=sa;Password=1234pass" providerName="System.Data.SqlClient"/>

Open in new window


Then from your code you'd set your connection string to:

ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString;

Open in new window


0
 
Carl TawnSystems and Integration DeveloperCommented:
There shouldn't be anything major. Just make sure that the firewalls on the server and the clients will allow traffic through on port 1433, and that incoming connections are enabled on the SQL Server (they should be by default if it is a full-blown sql rather than express, but it is something to bare in mind).

Obviously you need to make sure that the server has enough processor, RAM and disk resources available, but i assume you have already done that.
0
 
anarki_jimbelCommented:
Some challenge may be finding DB server on a network but it shouldn't be a big problem

Connection string - it's obvious. And may be it's better to use Windows authentication on an internal network... Anyway, shouldn't be a big problem...
0
 
Sudhakar PulivarthiProject Lead - EngineeringCommented:
0
 
KentMarshCommented:
Classic "Client Server".
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.