Enabling local testing over the LAN

[Borix]

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

[PlausiblyDamp]

Is this a windows or a web application? If a web application are you hosting it under IIS or using the built in web server?

[Borix]

Sorry, forgot to mention. That's a Windows App I'm developing... (in VS 2005/SQL Server 2000)...

[PlausiblyDamp]

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.

[Borix]

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.