attaching to a remote database

[kristinac]

I was wondering if it is possible to attach a local version of sql server to a remote database file. I have someone working on my program from the next desk over, and he needs access to the actual database we're using to add tables and stored procs. Is this even possible?

 

[JayKusch]

If he is on the same network as your machine it should be nothing more than installing the client tools on his system. This will allow him to connect to your database and make the needed changes.

Thanks

J. Kusch

 

[kristinac]

Okay cool, thank you. I am looking through the books online and such trying to find out how. The client tools are installed, however I have not figured out how to set up the remote attachment. I'm sure I'm missing something simple!

 

[kristinac]

Ah I got it. Yes okay remote servers, then add a server, then there you have it. Thank you so much for sending me in the right direction!!