Hello.
I am making an application that is reading and editing database.
I make a copy of the database while developing and woked on it. It was easy to connect and work with it.
But I now need to connect to teh real database that is on another computer on our network. Connect wizard , as far as I can se only helps me to connct to lacal database file, not on the network.
Could anyone help me here
Connect to database on another computer
lgratkowski
Hello.
Sorry, My bad.
I am using Viasual C# to code the application and using SQL express on as the server.
My client is WInXP pro and Win2003 on server.
So it is not possible for me to connect to that database using sql express are you 100% sure.
We are planing to use MS SQL server 2005 eventualy but not righ now.
It is an webshop that I made backoffice for, and it is supposed to connect to database on when run inside the network.
But I guess then that I will just have to run my app from server....BAD..
Stijnp
What do you mean by can not be used in web project
We have developed an webapplication and we run it just fine. It is about to go live tonight. We run this web app from the same server where SQL Express is installed. There should not be any trouble with that
nigliazzo
ASaleem
Can you please write some environment details. What DBMS you use, on client and on server. We can only gues what are you using.
I can gues that you are using SQL Express and if so, you can't connect trough network on mdf file using sqlexpress.
mscherotter
I've had the exact same problem a few weeks back. with a similar setup as you... WinXP for development and Win2k3 for Server with SQL 2005
I was certain my connection string is OK, so I did some research.
turns out my Win2k3 machine wasn't setup properly after installing SQL2005
you have to manually add an Exception to your Windows Firewall on Win2k3
Add the following ports:
1433 TCP
1434 UDP
then everything worked. I hope this helps.