Change SQL Server Instance

[Mike Nichols]

To integrate MS SBA 2007 with Outlook 2003 Business Contact Manager, the
process states that the two applications should use the same SQL Server
instance.

BCM installs using instance MICROSOFTSMLBIZ (v8.0.2039). SBA installs using
instance mssmlbiz (v9.0.2047). When I changed SBA to use MICROSOFTSMLBIZ, it
would not successfully complete a company creation process. It would create
a company using the original instance. Suspect this is an SQL Server
instance version issue.

The question is - how to change the instance that BCM uses (from
MICROSOFTSMLBIZ to mssmlbiz) so the two products can be integrated.

Thanks in advance,

 

[Leonid S. Knyshov]

To integrate MS SBA 2007 with Outlook 2003 Business Contact Manager, the
process states that the two applications should use the same SQL Server
instance.

BCM installs using instance MICROSOFTSMLBIZ (v8.0.2039). SBA installs
using
instance mssmlbiz (v9.0.2047). When I changed SBA to use MICROSOFTSMLBIZ,
it
would not successfully complete a company creation process. It would
create
a company using the original instance. Suspect this is an SQL Server
instance version issue.

The question is - how to change the instance that BCM uses (from
MICROSOFTSMLBIZ to mssmlbiz) so the two products can be integrated.

Integration process from SBA 2007 should take care of this for you
automatically.

I haven't actually tested using SBA 2007 with BCM 2003, but it works very
nicely with BCM 2007. I'll add this to my list of things to test.
--
Leonid S. Knyshov, CEO
Crashproof Solutions, LLC - http://www.crashproofsolutions.com
MCP Exchange 2003/Small Business Server 2003
Microsoft Small Business Specialist Partner
See the tips and tricks section on my website for video tutorials on BCM
Send a smile to Microsoft (Office 2007 Beta feedback tool)!
http://tinyurl.com/m4omy