BCM 2007 & Vista: Connecting over a VPN giles 6/12/2007 11:49:02 AM Hi, I've set up our BCM db on SQL Server 2005 and my laptop can connect fine on the LAN. I have also an offline db on the laptop for when I'm out of the office. It syncs fine when I get back to the LAN. Now I have a vpn client that enables me to connect to the office when I'm out but the db refuses to go online, saying that it cannot connect to the server. At the same time, Outlook is connected over the VPN just fine and I can connect to the File shares on the same server that runs the SQL db. Am I missing something here? I've scoured the internet for about 4 hours to find an answer but nothing so far. I see other posts here that suggest people have bcm working over vpn but I'm not sure if that's with 07 on Vista. Any thoughts greatly appreciated!

Re: BCM 2007 & Vista: Connecting over a VPN "Scott S Sikora" <ScottSikora[ at ]tricoequipment.com> 6/12/2007 3:15:15 PM I'm now having the same problem...any pointers greatly appreciated. -Scott "giles" <giles[ at ]discussions.microsoft.com> wrote in message news:09CDB45B-F540-49CC-9BD4-C5AA0905CE79[ at ]microsoft.com... [Quoted Text] > Hi, > > I've set up our BCM db on SQL Server 2005 and my laptop can connect fine > on > the LAN. I have also an offline db on the laptop for when I'm out of the > office. It syncs fine when I get back to the LAN. > > Now I have a vpn client that enables me to connect to the office when I'm > out but the db refuses to go online, saying that it cannot connect to the > server. At the same time, Outlook is connected over the VPN just fine and > I > can connect to the File shares on the same server that runs the SQL db. > > Am I missing something here? I've scoured the internet for about 4 hours > to > find an answer but nothing so far. I see other posts here that suggest > people > have bcm working over vpn but I'm not sure if that's with 07 on Vista. > > Any thoughts greatly appreciated!

Re: BCM 2007 & Vista: Connecting over a VPN giles 6/13/2007 9:15:01 AM Hi Scott, you say "now having" this suggests that it was once working - is this the case? Cheers, Giles "Scott S Sikora" wrote: [Quoted Text] > I'm now having the same problem...any pointers greatly appreciated. > > -Scott > > > "giles" <giles[ at ]discussions.microsoft.com> wrote in message > news:09CDB45B-F540-49CC-9BD4-C5AA0905CE79[ at ]microsoft.com... > > Hi, > > > > I've set up our BCM db on SQL Server 2005 and my laptop can connect fine > > on > > the LAN. I have also an offline db on the laptop for when I'm out of the > > office. It syncs fine when I get back to the LAN. > > > > Now I have a vpn client that enables me to connect to the office when I'm > > out but the db refuses to go online, saying that it cannot connect to the > > server. At the same time, Outlook is connected over the VPN just fine and > > I > > can connect to the File shares on the same server that runs the SQL db. > > > > Am I missing something here? I've scoured the internet for about 4 hours > > to > > find an answer but nothing so far. I see other posts here that suggest > > people > > have bcm working over vpn but I'm not sure if that's with 07 on Vista. > > > > Any thoughts greatly appreciated! >

Re: BCM 2007 & Vista: Connecting over a VPN "Scott S Sikora" <ScottSikora[ at ]tricoequipment.com> 6/13/2007 12:28:56 PM It was working on my old machine but after migrating to a new one it has stopped. I'm thinking it may have to do with making sure the machine is part of the domain that Exchange and SQL are part of or maybe the security setup of BCM itself. "giles" <giles[ at ]discussions.microsoft.com> wrote in message news:345C1101-878F-4AAB-8CDF-92BEC915B0A3[ at ]microsoft.com... [Quoted Text] > Hi Scott, you say "now having" this suggests that it was once working - is > this the case? > Cheers, > Giles > > "Scott S Sikora" wrote: > >> I'm now having the same problem...any pointers greatly appreciated. >> >> -Scott >> >> >> "giles" <giles[ at ]discussions.microsoft.com> wrote in message >> news:09CDB45B-F540-49CC-9BD4-C5AA0905CE79[ at ]microsoft.com... >> > Hi, >> > >> > I've set up our BCM db on SQL Server 2005 and my laptop can connect >> > fine >> > on >> > the LAN. I have also an offline db on the laptop for when I'm out of >> > the >> > office. It syncs fine when I get back to the LAN. >> > >> > Now I have a vpn client that enables me to connect to the office when >> > I'm >> > out but the db refuses to go online, saying that it cannot connect to >> > the >> > server. At the same time, Outlook is connected over the VPN just fine >> > and >> > I >> > can connect to the File shares on the same server that runs the SQL db. >> > >> > Am I missing something here? I've scoured the internet for about 4 >> > hours >> > to >> > find an answer but nothing so far. I see other posts here that suggest >> > people >> > have bcm working over vpn but I'm not sure if that's with 07 on Vista. >> > >> > Any thoughts greatly appreciated! >>

Re: BCM 2007 & Vista: Connecting over a VPN Luther <enowning[ at ]gmail.com> 6/13/2007 10:16:31 PM On Jun 13, 5:28 am, "Scott S Sikora" <ScottSik...[ at ]tricoequipment.com> wrote: [Quoted Text] > It was working on my old machine but after migrating to a new one it has > stopped. I'm thinking it may have to do with making sure the machine is part > of the domain that Exchange and SQL are part of or maybe the security setup > of BCM itself. > > "giles" <g...[ at ]discussions.microsoft.com> wrote in message > > news:345C1101-878F-4AAB-8CDF-92BEC915B0A3[ at ]microsoft.com... > > > > > Hi Scott, you say "now having" this suggests that it was once working - is > > this the case? > > Cheers, > > Giles > > > "Scott S Sikora" wrote: > > >> I'm now having the same problem...any pointers greatly appreciated. > > >> -Scott > > >> "giles" <g...[ at ]discussions.microsoft.com> wrote in message > >>news:09CDB45B-F540-49CC-9BD4-C5AA0905CE79[ at ]microsoft.com... > >> > Hi, > > >> > I've set up our BCM db on SQL Server 2005 and my laptop can connect > >> > fine > >> > on > >> > the LAN. I have also an offline db on the laptop for when I'm out of > >> > the > >> > office. It syncs fine when I get back to the LAN. > > >> > Now I have a vpn client that enables me to connect to the office when > >> > I'm > >> > out but the db refuses to go online, saying that it cannot connect to > >> > the > >> > server. At the same time, Outlook is connected over the VPN just fine > >> > and > >> > I > >> > can connect to the File shares on the same server that runs the SQL db. > > >> > Am I missing something here? I've scoured the internet for about 4 > >> > hours > >> > to > >> > find an answer but nothing so far. I see other posts here that suggest > >> > people > >> > have bcm working over vpn but I'm not sure if that's with 07 on Vista. > > >> > Any thoughts greatly appreciated!- Hide quoted text - > > - Show quoted text - Are you the same user/password on the old and new machines?

Re: BCM 2007 & Vista: Connecting over a VPN "Scott S Sikora" <ScottSikora[ at ]tricoequipment.com> 6/14/2007 6:10:34 PM Yes, they are identical. "Luther" <enowning[ at ]gmail.com> wrote in message news:1181772991.067597.323470[ at ]i38g2000prf.googlegroups.com... [Quoted Text] > On Jun 13, 5:28 am, "Scott S Sikora" <ScottSik...[ at ]tricoequipment.com> > wrote: >> It was working on my old machine but after migrating to a new one it has >> stopped. I'm thinking it may have to do with making sure the machine is >> part >> of the domain that Exchange and SQL are part of or maybe the security >> setup >> of BCM itself. >> >> "giles" <g...[ at ]discussions.microsoft.com> wrote in message >> >> news:345C1101-878F-4AAB-8CDF-92BEC915B0A3[ at ]microsoft.com... >> >> >> >> > Hi Scott, you say "now having" this suggests that it was once working - >> > is >> > this the case? >> > Cheers, >> > Giles >> >> > "Scott S Sikora" wrote: >> >> >> I'm now having the same problem...any pointers greatly appreciated. >> >> >> -Scott >> >> >> "giles" <g...[ at ]discussions.microsoft.com> wrote in message >> >>news:09CDB45B-F540-49CC-9BD4-C5AA0905CE79[ at ]microsoft.com... >> >> > Hi, >> >> >> > I've set up our BCM db on SQL Server 2005 and my laptop can connect >> >> > fine >> >> > on >> >> > the LAN. I have also an offline db on the laptop for when I'm out of >> >> > the >> >> > office. It syncs fine when I get back to the LAN. >> >> >> > Now I have a vpn client that enables me to connect to the office >> >> > when >> >> > I'm >> >> > out but the db refuses to go online, saying that it cannot connect >> >> > to >> >> > the >> >> > server. At the same time, Outlook is connected over the VPN just >> >> > fine >> >> > and >> >> > I >> >> > can connect to the File shares on the same server that runs the SQL >> >> > db. >> >> >> > Am I missing something here? I've scoured the internet for about 4 >> >> > hours >> >> > to >> >> > find an answer but nothing so far. I see other posts here that >> >> > suggest >> >> > people >> >> > have bcm working over vpn but I'm not sure if that's with 07 on >> >> > Vista. >> >> >> > Any thoughts greatly appreciated!- Hide quoted text - >> >> - Show quoted text - > > Are you the same user/password on the old and new machines? >

Re: BCM 2007 & Vista: Connecting over a VPN Luther <enowning[ at ]gmail.com> 6/15/2007 8:01:23 PM On Jun 14, 11:10 am, "Scott S Sikora" <ScottSik...[ at ]tricoequipment.com> wrote: [Quoted Text] > Yes, they are identical. > > "Luther" <enown...[ at ]gmail.com> wrote in message > > news:1181772991.067597.323470[ at ]i38g2000prf.googlegroups.com... > > > > > On Jun 13, 5:28 am, "Scott S Sikora" <ScottSik...[ at ]tricoequipment.com> > > wrote: > >> It was working on my old machine but after migrating to a new one it has > >> stopped. I'm thinking it may have to do with making sure the machine is > >> part > >> of the domain that Exchange and SQL are part of or maybe the security > >> setup > >> of BCM itself. > > >> "giles" <g...[ at ]discussions.microsoft.com> wrote in message > > >>news:345C1101-878F-4AAB-8CDF-92BEC915B0A3[ at ]microsoft.com... > > >> > Hi Scott, you say "now having" this suggests that it was once working - > >> > is > >> > this the case? > >> > Cheers, > >> > Giles > > >> > "Scott S Sikora" wrote: > > >> >> I'm now having the same problem...any pointers greatly appreciated. > > >> >> -Scott > > >> >> "giles" <g...[ at ]discussions.microsoft.com> wrote in message > >> >>news:09CDB45B-F540-49CC-9BD4-C5AA0905CE79[ at ]microsoft.com... > >> >> > Hi, > > >> >> > I've set up our BCM db on SQL Server 2005 and my laptop can connect > >> >> > fine > >> >> > on > >> >> > the LAN. I have also an offline db on the laptop for when I'm out of > >> >> > the > >> >> > office. It syncs fine when I get back to the LAN. > > >> >> > Now I have a vpn client that enables me to connect to the office > >> >> > when > >> >> > I'm > >> >> > out but the db refuses to go online, saying that it cannot connect > >> >> > to > >> >> > the > >> >> > server. At the same time, Outlook is connected over the VPN just > >> >> > fine > >> >> > and > >> >> > I > >> >> > can connect to the File shares on the same server that runs the SQL > >> >> > db. > > >> >> > Am I missing something here? I've scoured the internet for about 4 > >> >> > hours > >> >> > to > >> >> > find an answer but nothing so far. I see other posts here that > >> >> > suggest > >> >> > people > >> >> > have bcm working over vpn but I'm not sure if that's with 07 on > >> >> > Vista. > > >> >> > Any thoughts greatly appreciated!- Hide quoted text - > > >> - Show quoted text - > > > Are you the same user/password on the old and new machines?- Hide quoted text - > > - Show quoted text - One thing to do is to try isolating the problem. Is it a database connection problem or something specific to BCM. Can you try connecting to the database using OSQL? Here's some additional info: http://beyng.blogspot.com/2005/06/how-to-run-sql-against-bcm-database.html

Re: BCM 2007 & Vista: Connecting over a VPN "Lon Orenstein" <Lon[ at ]pinpointtools.com> 6/19/2007 11:21:10 PM Check SQL to be sure port 5356 is open... That's been a problem before. HTH, Lon ___________________________________________________________ Lon Orenstein pinpointtools, llc Lon[ at ]pinpointtools.com Author of Outlook 2007 Business Contact Manager For Dummies Author of the eBook: Moving from ACT! to Business Contact Manager 800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104 www.pinpointtools.com "Luther" <enowning[ at ]gmail.com> wrote in message news:1181937683.210549.34410[ at ]i38g2000prf.googlegroups.com... [Quoted Text] > On Jun 14, 11:10 am, "Scott S Sikora" <ScottSik...[ at ]tricoequipment.com> > wrote: >> Yes, they are identical. >> >> "Luther" <enown...[ at ]gmail.com> wrote in message >> >> news:1181772991.067597.323470[ at ]i38g2000prf.googlegroups.com... >> >> >> >> > On Jun 13, 5:28 am, "Scott S Sikora" <ScottSik...[ at ]tricoequipment.com> >> > wrote: >> >> It was working on my old machine but after migrating to a new one it >> >> has >> >> stopped. I'm thinking it may have to do with making sure the machine >> >> is >> >> part >> >> of the domain that Exchange and SQL are part of or maybe the security >> >> setup >> >> of BCM itself. >> >> >> "giles" <g...[ at ]discussions.microsoft.com> wrote in message >> >> >>news:345C1101-878F-4AAB-8CDF-92BEC915B0A3[ at ]microsoft.com... >> >> >> > Hi Scott, you say "now having" this suggests that it was once >> >> > working - >> >> > is >> >> > this the case? >> >> > Cheers, >> >> > Giles >> >> >> > "Scott S Sikora" wrote: >> >> >> >> I'm now having the same problem...any pointers greatly appreciated. >> >> >> >> -Scott >> >> >> >> "giles" <g...[ at ]discussions.microsoft.com> wrote in message >> >> >>news:09CDB45B-F540-49CC-9BD4-C5AA0905CE79[ at ]microsoft.com... >> >> >> > Hi, >> >> >> >> > I've set up our BCM db on SQL Server 2005 and my laptop can >> >> >> > connect >> >> >> > fine >> >> >> > on >> >> >> > the LAN. I have also an offline db on the laptop for when I'm out >> >> >> > of >> >> >> > the >> >> >> > office. It syncs fine when I get back to the LAN. >> >> >> >> > Now I have a vpn client that enables me to connect to the office >> >> >> > when >> >> >> > I'm >> >> >> > out but the db refuses to go online, saying that it cannot >> >> >> > connect >> >> >> > to >> >> >> > the >> >> >> > server. At the same time, Outlook is connected over the VPN just >> >> >> > fine >> >> >> > and >> >> >> > I >> >> >> > can connect to the File shares on the same server that runs the >> >> >> > SQL >> >> >> > db. >> >> >> >> > Am I missing something here? I've scoured the internet for about >> >> >> > 4 >> >> >> > hours >> >> >> > to >> >> >> > find an answer but nothing so far. I see other posts here that >> >> >> > suggest >> >> >> > people >> >> >> > have bcm working over vpn but I'm not sure if that's with 07 on >> >> >> > Vista. >> >> >> >> > Any thoughts greatly appreciated!- Hide quoted text - >> >> >> - Show quoted text - >> >> > Are you the same user/password on the old and new machines?- Hide >> > quoted text - >> >> - Show quoted text - > > One thing to do is to try isolating the problem. Is it a database > connection problem or something specific to BCM. > > Can you try connecting to the database using OSQL? > > Here's some additional info: > http://beyng.blogspot.com/2005/06/how-to-run-sql-against-bcm-database.html > > >

PROBLEM SOLVED: BCM 2007 & Vista: Connecting over a VPN giles 6/22/2007 12:04:00 PM Hi, the problem was that the client was getting it's DNS via the ISP at home rather than over the VPN from the server in the office. Solution for others with the same problem: Set your VPN Client to use DNS and WINS servers on the LAN that you are connecting to. With the NCP VPN client I was also able to specify the Domain that I was connecting to. This probably helped also. Thanks to all those that helped!! Giles

Re: PROBLEM SOLVED: BCM 2007 & Vista: Connecting over a VPN "Scott S Sikora" <sssikora[ at ]tricoequipment.com> 6/23/2007 1:17:01 PM Unfortunately I can't seem to find settings for either of those items using the Cisco VPN client that I have. Any other ideas by anyone? "giles" <giles[ at ]discussions.microsoft.com> wrote in message news:230AC41B-4A7C-40A2-A127-BDFC1AAADF25[ at ]microsoft.com... [Quoted Text] > Hi, the problem was that the client was getting it's DNS via the ISP at > home > rather than over the VPN from the server in the office. > > Solution for others with the same problem: Set your VPN Client to use DNS > and WINS servers on the LAN that you are connecting to. With the NCP VPN > client I was also able to specify the Domain that I was connecting to. > This > probably helped also. > > Thanks to all those that helped!! > Giles