i created a database on my local computer and then i moved to a computer in my local network. I changed the app.config file to point to the computer where the DB is on (server computer) and i made a user account as a DBowner to this DB on the server computer (incase ur wonderin, I deactivated the firewall on the server computer). When i tried to connect to the DB using SQL server Management studio express using the username and password given at the server computer, i logged perfectly. but using my developed program i always connect to the local DB not the one on the server WHYyyy ???
 Plz help

Ummm i am not sure what you are saying. Are you saying that in one instance you are connecting through the server and then in the other instance you are trying to connect directly to the database file?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

i just want to connect to a database on another computer .... can u help me ??

Unless its a Database file (Access or Excel) you must connect through a SERVER to your database. For example, if i take an .MDF file for one of my Sql Server databases and try to connect directly to it, I can't do it as my SQL server defines my users and permissions.

There may be a work around to this, but I do not know of one.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

i am using sql server 2005 express(on the server computer), and i am connecting thruogh it. I gave the sql server a constant IP and i enabled the TCP/IP protocol, and i connected to it easily using my "sql Server management studio express", but how can i make my developed program stop connecting to the local database and connect to the server ???
by the way i also changed my app.config file

any help ??