I have SQL 2000 on my PC at home, which is running WinXP Home.

I want to allow another programmer who is at a remote site to connect to the DB
from his remote site.

It would be preferable if he could administer the DB remotely, but as long as he
can access the DB to run queries, I can handle the admin part.





>Hi Kevin,
>
>I'm confused. Do you want to manage your SQL Server from another PC or access it? Anyway, I'm not familiar with WinXP Home and how it could affect your task.
>
>>
>>If I set up a WinXP Guest Account on my PC, can another programmer then access
>>the SQL database on my PC from a remote site?
>>
>>Thanks
>>
>>
>>
>>
>>
>>>What is involved in setting up remote access to SQL? SQL will be on my PC which is
>>>running WinXP Home, and the remote user is also using XP Home.
>>>
>>>
>>>
>>>>>Is it possible to make changes to a SQL database remotely? What is involved in this?
>>>>
>>>>If you can access SQL Server remotely, you can manage it using EM or SSMS.