With this path can I be connected with two computers?

Israel

Hi!

I have a very small question but important.

Right now I am developing a simple and small system that will manage stock. But it to work on a local network (three computers: server and two clients).

Now what is my question:

can I use this path to use the sqlserver database with those two clients from the principal computer as server?:

string connstr = "database=master;server=.\\localhost\\sqlexpress;user=;password=";

I re-ask my question in other manner:

those two computers with the same system installed can be connected to the server where the sqlserver database is localised?

Many thanx,

Israel.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
I'm not 100% sure but I think you'll have to install SQL Server Management Studio first and then follow the previous instructions to configure remote connections.

I found this link which should help with the SSMS part:

http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx?Redirected=true
Israel12y ago
Thanx for your answer. But to help me more I would like to inform that I am using the sqlserver express integrated in VS 2010. As you know it's limited. Means that I doesnt give all the full tools as sqlserver express 2008 separeted. There is any way to do it with the one integrated in VS 2010?
Vulpes12y ago
localhost means 'this computer'.

To access SQL Server Express from the client computers, you'll therefore need to replace localhost with the name or IP address of the server.

However, before you can do that you'll need to configure SQL Server Express to accept remote connections if you haven't done so already.

Check this article for full instructions:

http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/