Question Locked

Upgaded to SBS 2003 R2, tried to implement Remote Access

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

and the firewall changed. Then the local computers couldn't access the server. So I disabled Remote Access and everything works again. So, here's what I'm trying to do .

I have a BCM database setup on the server (SBS 2003 R2, 1 NIC, server inside the firewall/router. )I can access it from the inside. Yippee! Now I want users, including myself to access it remotely. Can this be done with RWW or VPN? How do I set this up? The wizard (I tried it for VPN) makes it so nothing works.

Thanks,

Bryan

8 replies

by cg it

1 NIC

when you run the remote access wizard from the Things to do list, it makes the single NIC as the external listening NIC. Therefore clients are viewed as external clients.

install a second NIC. have 1 for the external interface, one for the private LAN.

rerun the CIEW connect to the Internet wizard from the "things to do list". Then run the remote access wizard.

by bulk3

OK. That makes perfect sense. However, no one connects to the server directly. It is ONLY used for BCM db and it is on the inside of the firewall- one nic to it. so I don't have a private lan 'side' to the server. It's just another box on the router/hub.

I've thought about moving it outside the router/firewall and doing the two nic thing, but it's up and running this way for a year and I prefer not to mes with it. Will it be possible for people to remotely access the BCM database using RWW or VPN? The router has a vpn in it two I suppose I could use; but don't know anything about that either .

by cg it

if this is just a database, you should have gone with the Windows Server 2003 and not the SBS box. SBS is an an Enterprise level Active Directory domain geared for the small business. If you don't have any familiarity with Active Directory, you decided on the wrong software [unless of course you got it for "free"] in which case, your trying to do something the software wasn't intended to do and jury rigging it.

Microsoft has a whole help and support section for Small Business Server as well as Microsoft's Tech Net.

by bulk3

Actually I asked this question over in the MS newsgroups and was told to go ahead and do SBS for the easier install and mgmt. I have the action pack and could do either one. So, the question is. Now that it's working just fine internally do I need to start all over or can I make remote access (other than remote desktop which works just fine now but I don't think will work with this) to the db work properly?

by cg it

well I'd ask the guys over at MS about a db server with SBS. unless your running a dual processor, mega memory, SCSI drive server, running a db on a SBS box user access will be very slow. think 30 second wait for one user accessing the DB.

afterthought....you know that if the action pack is not renewed the software is supposed to be uninstalled. MS does check as over 50% of the litigation against businesses selling counterfeit software were using action pack stuff. That's why most software offered in the action pack are upgrades rather than full version.

by bulk3

Yes, action pack. It's how I'm learning about all this. I'm not abusing the license and I'm not worried about performance. I'll only have one person hitting it remotely; me. Maybe one other to test multi user access.

So my question still is, can I do this with SBS as I was recommended or not, as was implied earlier in this thread. If not, how hard will it be to install Win03 server and SQL server?

by cg it

if your going to run Small Business Server and don't really know anything about it, here's my suggestion

go to Amazon.com and get the Windows Small Business Server 2003 Administrators companion. $37.99 USD

This book will guide you on all phases of the Small Business Server including SQL 2005

Again, Small Business Server 2003 is an Enterprise level Active Directory domain geared for the small business. If you don't need an Active Directory domain for your database application, then Small Business Server is not right for your objectives.

for your second question, how hard is W2003 server and SQL server to install? not any harder than Small Business Server. If you have limited knowledge of SQL 2005 I also suggest you get some books on SQL. 2005 is quite different than 2000.

here's a link for the SBS administrator's companion on Amazon.com

http://www.amazon.com/Microsoft-Business-Administrators-Companion-Pro-Administrators/dp/0735622809/ref=pd_bbs_sr_1/103-9397494-8966231?ie=UTF8&s=books&qid=1180724335&sr=1-1

This discussion is closed to new replies.