Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Imran
Starting Member
3 Posts |
 Posted - 2007-07-11 : 08:43:42
|
| Hi, I have written a database application using .mdf in visual studio 2005 using vb.net (Windows XP sp2)The app runs fine on the local machine. But I want to access the database from another computer (remote connection)My Questions:1. How to host the database file (mydb.mdf) on server machine?2. How does connection string change on the client side?Any other idea? THanks!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-11 : 12:38:14
|
| 1. create the don on remote sql server.2. replace localhost with remote sql instance name.Ensure that sql server allows remote connection. |
 |
|
|
Imran
Starting Member
3 Posts |
Posted - 2007-07-11 : 15:12:04
|
Hi, rmiao and thanks for reply.I have VS2005 which has bundled SQLEXP2005.Infact, I do not know how to create sql server, when I execute my project under VS2005 it becomes temporary server how to make it permanent?What's a don? Is it Database on Network? :)Would you please explain step.1 (I'm kind a novice)  |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-11 : 22:20:04
|
| Oh, should be db. You just need connect to sql server, not create server. |
|
|
|
|
|
|
configure/access SQL Express 2005 db remote conn..