CODEWITHSUNDEEP
c#sqldatabasenetwork-programming
Milan
Milan

Reputation: 185

SQL server and c# applications over network

I created a C# application that uses .mdf database and it works perfectly on my PC. Now i wanted to install that application on network PCs that can connect to a single database and use that data. I tried changing the connection string in application with only changing file path, but it doesn't work. How can i use one PC as server and use program as client application that can connect over network. How do i set up SQL server on that PC, and should i do that? How is this done? I couldn't find any tutorial so far...

Could someone help me a bit.

Upvotes: 0

Views: 1746

Answers (2)

Derek
Derek

Reputation: 8628

I don't think you should be doing this, this is something that I once looked into myself. I once used a standard base unit for this same purpose and although it worked fine your not really supposed to do it.

You have to ask yourself how important the application is to the business. If its critical then this would be a real bad move for a couple of reasons :-

1) What happens if base unit hosting SQL Server dies? or is switched off. Your unstuck.

2) You will only be able to schedule backups of the SQL Server Database on the local hard disk . If the Disk dies then you will lose everything.

When all is said and done, for the scenario that you are presenting, a MS Access database is probably a cleaner way to go. Access databases, albeit dated, can be hosted on a shared network space and can be accessed by multiple users. ADO.NET is nt too bad and you can still use LINQ with Data Tables etc.

What your looking into doing in your description wont really be fruitful unless your hosting the SQL Server on an Actual Server, as its designed for.

Some people suggest using using SQL Compact, but that itself is designed only to run from a local machine.

Hope this Helps.

Upvotes: 1

Priyank Thakkar
Priyank Thakkar

Reputation: 4852

@Milan: Go to the SQL Server configuration manager and enable TCP/IP service for SQL Server. As sql server uses TCP/IP for communication.

This link will help you.

http://kristofmattei.be/2010/06/21/enabling-sql-server-2008-r2-access-over-network/

Upvotes: 0

Related Questions