Enabling local testing over the LAN

B

Borix

Newcomer
Joined
May 14, 2008
Messages
9
Hi all,

I recently completed certain milestones of a project I am developing in VB.Net/SQL2000, locally in my computer at my workplace. I am using a local database and my computer is part of a domain. Now, I got some users over the domain (I am not an admin). Is there any way I can make it possible for the users (of the same domain) to test my project using the local database in my computer? That is, could my computer be used as a "server", just for the purpose of testing the program?

Thanks
 
Sorry, forgot to mention. That's a Windows App I'm developing... (in VS 2005/SQL Server 2000)...
 
The users would need a copy of your application (plus framework) and they would need the database connection string to point to the database on your computer (ideally this should be in a config file).

You would also need to give the relevant users permission to the sql server (create a login) and then to the database (create a user for their login). Once that is done the users would need permissions assigned to allow them to access the stored procs, views, tables etc.
 
Thanks for your tips PDamp, and this is what I basically did.

First, I installed a local copy on the users' computers.

Then, I modified my Firewall settings in Control Panel, by adding the "Server Network Utility" on the Exception list in the Exceptions tab. I also edited the scope of the utility to limit it to certain IP addresses and ports. Thereafter, the users tested it (with the sa login credentials) and it worked.
 
Back
Top