Cannot seem to use BCM Database Tool on SQL Server 2008

cbeckman · External Since: Jul 21, 2009 Posts: 2

I am trying to install BCM onto a sql 2008 server for shared usage. The
server is running Windows 2008 32 bit.

I have an instance "CSSSQL01\MSSMLBIZ" that I installed as a local admin
account "CSSSQL01\sqlsmlbizadmin" I can use SSME to connect to this
instance, using Windows Authentication (logged in as this user).

However, when I use Business Contact Manager for Outlook 2007 Database Tool
to try to Create a New Database, I receive this error message "Cannot
retrieve the list of SQL Server instance. Please make sure that SQL Server
2005 or SQL Server 2005 Express is installed and that the service is
running." Clicking OK closes the program.

Any ideas?

I only saw one other thread about this and it ended in August 2008 without
an answer.

Thank you,
chuck

Raul Thomas · External Since: Jun 30, 2007 Posts: 7

This could happen if you are running a 64 bit edition of SQL 2005 . Also
note that the BCM admin tool will not work with SQL 2008

--
Regards

Rahul Thomas [MSFT]

The posting is provided "AS IS" with no warranties and confers no rights.
https://blogs.msdn.com/rathomas

"cbeckman" <cbeckman DeleteThis @discussions.microsoft.com> wrote in message
news:D386361B-6B15-4528-94CE-4847D1B577DD@microsoft.com...
> I am trying to install BCM onto a sql 2008 server for shared usage. The
> server is running Windows 2008 32 bit.
>
> I have an instance "CSSSQL01\MSSMLBIZ" that I installed as a local admin
> account "CSSSQL01\sqlsmlbizadmin" I can use SSME to connect to this
> instance, using Windows Authentication (logged in as this user).
>
> However, when I use Business Contact Manager for Outlook 2007 Database
> Tool
> to try to Create a New Database, I receive this error message "Cannot
> retrieve the list of SQL Server instance. Please make sure that SQL
> Server
> 2005 or SQL Server 2005 Express is installed and that the service is
> running." Clicking OK closes the program.
>
> Any ideas?
>
> I only saw one other thread about this and it ended in August 2008 without
> an answer.
>
> Thank you,
> chuck
>

cbeckman · External Since: Jul 21, 2009 Posts: 2

Thank you, this is the first time I have explicitly seen that BCM Admin Tool
does NOT work on sql 2008.

Any problems with backing up a BCM database from an existing 2005 instance
and restoring that onto sql 2008?

Again, thank you for the info about the BCM admin tool NOT working on sql
2008.

chuck

"Raul Thomas" wrote:

> This could happen if you are running a 64 bit edition of SQL 2005 . Also
> note that the BCM admin tool will not work with SQL 2008
>
> --
> Regards
>
> Rahul Thomas [MSFT]
>
> The posting is provided "AS IS" with no warranties and confers no rights.
> https://blogs.msdn.com/rathomas
>
> "cbeckman" <cbeckman.TakeThisOut@discussions.microsoft.com> wrote in message
> news:D386361B-6B15-4528-94CE-4847D1B577DD@microsoft.com...
> > I am trying to install BCM onto a sql 2008 server for shared usage. The
> > server is running Windows 2008 32 bit.
> >
> > I have an instance "CSSSQL01\MSSMLBIZ" that I installed as a local admin
> > account "CSSSQL01\sqlsmlbizadmin" I can use SSME to connect to this
> > instance, using Windows Authentication (logged in as this user).
> >
> > However, when I use Business Contact Manager for Outlook 2007 Database
> > Tool
> > to try to Create a New Database, I receive this error message "Cannot
> > retrieve the list of SQL Server instance. Please make sure that SQL
> > Server
> > 2005 or SQL Server 2005 Express is installed and that the service is
> > running." Clicking OK closes the program.
> >
> > Any ideas?
> >
> > I only saw one other thread about this and it ended in August 2008 without
> > an answer.
> >
> > Thank you,
> > chuck
> >

Raul Thomas · External Since: Jun 30, 2007 Posts: 7

Not that I have heard of , but clients connecting to the shared database
will not be able to recognize the change

--
Regards

Rahul Thomas [MSFT]

The posting is provided "AS IS" with no warranties and confers no rights.
https://blogs.msdn.com/rathomas

"cbeckman" <cbeckman.TakeThisOut@discussions.microsoft.com> wrote in message
news:AADADDA0-249B-4AB7-B7B5-6578F30D0590@microsoft.com...
> Thank you, this is the first time I have explicitly seen that BCM Admin
> Tool
> does NOT work on sql 2008.
>
> Any problems with backing up a BCM database from an existing 2005 instance
> and restoring that onto sql 2008?
>
> Again, thank you for the info about the BCM admin tool NOT working on sql
> 2008.
>
> chuck
>
>
> "Raul Thomas" wrote:
>
>> This could happen if you are running a 64 bit edition of SQL 2005 . Also
>> note that the BCM admin tool will not work with SQL 2008
>>
>> --
>> Regards
>>
>> Rahul Thomas [MSFT]
>>
>> The posting is provided "AS IS" with no warranties and confers no
>> rights.
>> https://blogs.msdn.com/rathomas
>>
>> "cbeckman" <cbeckman.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:D386361B-6B15-4528-94CE-4847D1B577DD@microsoft.com...
>> > I am trying to install BCM onto a sql 2008 server for shared usage.
>> > The
>> > server is running Windows 2008 32 bit.
>> >
>> > I have an instance "CSSSQL01\MSSMLBIZ" that I installed as a local
>> > admin
>> > account "CSSSQL01\sqlsmlbizadmin" I can use SSME to connect to this
>> > instance, using Windows Authentication (logged in as this user).
>> >
>> > However, when I use Business Contact Manager for Outlook 2007 Database
>> > Tool
>> > to try to Create a New Database, I receive this error message "Cannot
>> > retrieve the list of SQL Server instance. Please make sure that SQL
>> > Server
>> > 2005 or SQL Server 2005 Express is installed and that the service is
>> > running." Clicking OK closes the program.
>> >
>> > Any ideas?
>> >
>> > I only saw one other thread about this and it ended in August 2008
>> > without
>> > an answer.
>> >
>> > Thank you,
>> > chuck
>> >

Luther Blissett · External Since: Feb 23, 2009 Posts: 14

On Jul 21, 5:45 pm, "Raul Thomas" <v_2r....DeleteThis@hotmail.com> wrote:
> Not that I have heard of , but clients connecting to the shared database
> will not be able to recognize the change
>
> --
> Regards
>
> Rahul Thomas [MSFT]
>
> The posting is provided "AS IS" with no warranties and confers no rights.https://blogs.msdn.com/rathomas
>
> "cbeckman" <cbeck....DeleteThis@discussions.microsoft.com> wrote in message
>
> news:AADADDA0-249B-4AB7-B7B5-6578F30D0590@microsoft.com...
>
>
>
> > Thank you, this is the first time I have explicitly seen that BCM Admin
> > Tool
> > does NOT work on sql 2008.
>
> > Any problems with backing up a BCM database from an existing 2005 instance
> > and restoring that onto sql 2008?
>
> > Again, thank you for the info about the BCM admin tool NOT working on sql
> > 2008.
>
> > chuck
>
> > "Raul Thomas" wrote:
>
> >> This could happen if you are running a 64 bit edition of SQL 2005 . Also
> >> note that the BCM admin tool will not work with SQL 2008
>
> >> --
> >> Regards
>
> >> Rahul Thomas [MSFT]
>
> >> The posting is provided "AS IS" with no warranties and confers no
> >> rights.
> >>https://blogs.msdn.com/rathomas
>
> >> "cbeckman" <cbeck....DeleteThis@discussions.microsoft.com> wrote in message
> >>news:D386361B-6B15-4528-94CE-4847D1B577DD@microsoft.com...
> >> > I am trying to install BCM onto a sql 2008 server for shared usage.
> >> > The
> >> > server is running Windows 2008 32 bit.
>
> >> > I have an instance "CSSSQL01\MSSMLBIZ" that I installed as a local
> >> > admin
> >> > account "CSSSQL01\sqlsmlbizadmin" I can use SSME to connect to this
> >> > instance, using Windows Authentication (logged in as this user).
>
> >> > However, when I use Business Contact Manager for Outlook 2007 Database
> >> > Tool
> >> > to try to Create a New Database, I receive this error message "Cannot
> >> > retrieve the list of SQL Server instance. Please make sure that SQL
> >> > Server
> >> > 2005 or SQL Server 2005 Express is installed and that the service is
> >> > running." Clicking OK closes the program.
>
> >> > Any ideas?
>
> >> > I only saw one other thread about this and it ended in August 2008
> >> > without
> >> > an answer.
>
> >> > Thank you,
> >> > chuck- Hide quoted text -
>
> - Show quoted text -

The BCM Sql instance must be using a specific TCP port that BCM
clients use to connect to sql.
http://beyng.blogspot.com/2006/05/port-for-bcm.html