Configuring BCM to use an SQL database ksurvell 4/20/2007 7:20:01 PM I've used the new BCM DB Tool to create a BCM database on a server that has a full SQL Server instance. My workstation connects to this database fine, using the following connection string: SERVERNAME\MSSQLSERVER,1433 However - when I install BCM on the server itself, after the fact, and try to use the same exact connection string... (using the "Select an existing Database" option) it doesn't work. It times out and says "Cannot access the database server on computer SERVERNAME. For more information, click Help." I'm at a loss. I've even stopped the MSSMALLBIZ instance of SQL Express that BCM installs itself, just in case it was conflicting with it somehow. Does anyone have any suggestions on what to try or do? I'm really at a loss, and I need to get BCM going on that computer.

Re: Configuring BCM to use an SQL database "Lon Orenstein" <Lon[ at ]pinpointtools.com> 4/20/2007 11:14:29 PM ksurvell: Create an instance on your full SQL named MSSMALLBIZ and BCM should work just fine. Then attach your existing BCM db to that instance. 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 "ksurvell" <ksurvell[ at ]discussions.microsoft.com> wrote in message news:65C6654B-C2B1-4FD0-8CF8-A6E5FA9DFEA8[ at ]microsoft.com... [Quoted Text] > I've used the new BCM DB Tool to create a BCM database on a server that > has a > full SQL Server instance. My workstation connects to this database fine, > using the following connection string: > > SERVERNAME\MSSQLSERVER,1433 > > However - when I install BCM on the server itself, after the fact, and try > to use the same exact connection string... (using the "Select an existing > Database" option) it doesn't work. It times out and says "Cannot access > the > database server on computer SERVERNAME. For more information, click Help." > > I'm at a loss. I've even stopped the MSSMALLBIZ instance of SQL Express > that > BCM installs itself, just in case it was conflicting with it somehow. > > Does anyone have any suggestions on what to try or do? I'm really at a > loss, > and I need to get BCM going on that computer.

Re: Configuring BCM to use an SQL database ksurvell 4/23/2007 7:18:02 PM I will try that, although wasn't the default instance name for SQL Express that comes with BCM "MSSMLBIZ," not "MSSMALLBIZ?" Just checking... re-installing SQL server (which is what I have to do to change the instance name) takes a looooong time, and I want to make sure I've got the right instance name. "Lon Orenstein" wrote: [Quoted Text] > ksurvell: > > Create an instance on your full SQL named MSSMALLBIZ and BCM should work > just fine. Then attach your existing BCM db to that instance. > > 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 > > > "ksurvell" <ksurvell[ at ]discussions.microsoft.com> wrote in message > news:65C6654B-C2B1-4FD0-8CF8-A6E5FA9DFEA8[ at ]microsoft.com... > > I've used the new BCM DB Tool to create a BCM database on a server that > > has a > > full SQL Server instance. My workstation connects to this database fine, > > using the following connection string: > > > > SERVERNAME\MSSQLSERVER,1433 > > > > However - when I install BCM on the server itself, after the fact, and try > > to use the same exact connection string... (using the "Select an existing > > Database" option) it doesn't work. It times out and says "Cannot access > > the > > database server on computer SERVERNAME. For more information, click Help." > > > > I'm at a loss. I've even stopped the MSSMALLBIZ instance of SQL Express > > that > > BCM installs itself, just in case it was conflicting with it somehow. > > > > Does anyone have any suggestions on what to try or do? I'm really at a > > loss, > > and I need to get BCM going on that computer. > >

Re: Configuring BCM to use an SQL database "Lon Orenstein" <Lon[ at ]pinpointtools.com> 4/23/2007 9:01:57 PM OOPS! My bad -- Yes, it is MSSMLBIZ... Thanks, 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 "ksurvell" <ksurvell[ at ]discussions.microsoft.com> wrote in message news:38CCA49A-213F-4625-A159-15DB3D7E756E[ at ]microsoft.com... [Quoted Text] >I will try that, although wasn't the default instance name for SQL Express > that comes with BCM "MSSMLBIZ," not "MSSMALLBIZ?" > > Just checking... re-installing SQL server (which is what I have to do to > change the instance name) takes a looooong time, and I want to make sure > I've > got the right instance name. > > "Lon Orenstein" wrote: > >> ksurvell: >> >> Create an instance on your full SQL named MSSMALLBIZ and BCM should work >> just fine. Then attach your existing BCM db to that instance. >> >> 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 >> >> >> "ksurvell" <ksurvell[ at ]discussions.microsoft.com> wrote in message >> news:65C6654B-C2B1-4FD0-8CF8-A6E5FA9DFEA8[ at ]microsoft.com... >> > I've used the new BCM DB Tool to create a BCM database on a server that >> > has a >> > full SQL Server instance. My workstation connects to this database >> > fine, >> > using the following connection string: >> > >> > SERVERNAME\MSSQLSERVER,1433 >> > >> > However - when I install BCM on the server itself, after the fact, and >> > try >> > to use the same exact connection string... (using the "Select an >> > existing >> > Database" option) it doesn't work. It times out and says "Cannot access >> > the >> > database server on computer SERVERNAME. For more information, click >> > Help." >> > >> > I'm at a loss. I've even stopped the MSSMALLBIZ instance of SQL Express >> > that >> > BCM installs itself, just in case it was conflicting with it somehow. >> > >> > Does anyone have any suggestions on what to try or do? I'm really at a >> > loss, >> > and I need to get BCM going on that computer. >> >>

Re: Configuring BCM to use an SQL database ksurvell 4/23/2007 10:02:03 PM Thanks! That was it. Re-installing the SQL Server Instance with the name "MSSMLBIZ" worked. Thank you!! "Lon Orenstein" wrote: [Quoted Text] > OOPS! My bad -- Yes, it is MSSMLBIZ... > > Thanks, > 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 > > > "ksurvell" <ksurvell[ at ]discussions.microsoft.com> wrote in message > news:38CCA49A-213F-4625-A159-15DB3D7E756E[ at ]microsoft.com... > >I will try that, although wasn't the default instance name for SQL Express > > that comes with BCM "MSSMLBIZ," not "MSSMALLBIZ?" > > > > Just checking... re-installing SQL server (which is what I have to do to > > change the instance name) takes a looooong time, and I want to make sure > > I've > > got the right instance name. > > > > "Lon Orenstein" wrote: > > > >> ksurvell: > >> > >> Create an instance on your full SQL named MSSMALLBIZ and BCM should work > >> just fine. Then attach your existing BCM db to that instance. > >> > >> 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 > >> > >> > >> "ksurvell" <ksurvell[ at ]discussions.microsoft.com> wrote in message > >> news:65C6654B-C2B1-4FD0-8CF8-A6E5FA9DFEA8[ at ]microsoft.com... > >> > I've used the new BCM DB Tool to create a BCM database on a server that > >> > has a > >> > full SQL Server instance. My workstation connects to this database > >> > fine, > >> > using the following connection string: > >> > > >> > SERVERNAME\MSSQLSERVER,1433 > >> > > >> > However - when I install BCM on the server itself, after the fact, and > >> > try > >> > to use the same exact connection string... (using the "Select an > >> > existing > >> > Database" option) it doesn't work. It times out and says "Cannot access > >> > the > >> > database server on computer SERVERNAME. For more information, click > >> > Help." > >> > > >> > I'm at a loss. I've even stopped the MSSMALLBIZ instance of SQL Express > >> > that > >> > BCM installs itself, just in case it was conflicting with it somehow. > >> > > >> > Does anyone have any suggestions on what to try or do? I'm really at a > >> > loss, > >> > and I need to get BCM going on that computer. > >> > >> > >