bcm 2007 database of an MS SQL-Server 2000

Similar Threads:

1.BCM 2007 auf MS SQL-Server 2000 verlagern

Hallo an Alle,

bin mir nicht sicher, ob ich hier richtig bin. Hoffe es aber.
Ich habe folgende Frage. Ich habe Outlook 2007 und mhte die Datenbank auf
einen MS SQL-Server 2000 verlegen.
Kann mir jemand sagen, wie das geht?

Vielen Dank an alle

Peter

2.BCM database on SQL Server 2000

Hello. We are investigating using BCM for some of our sales people. We would 
like to have the BCM database setup on our existing SQL Server 2000. When I 
setup the BCM client (Outlook 2007 with BCM) it asks if I want to connect to 
an existing database, which can be on another computer, but there is no 
option to create the database on a remote server. Is this possible? If so, 
can someone point me to documentation on this?
Thanks,
Alan

3.Run the BCM database on a SQL server 2000

Hello everybody, i have som questions about the migrations of BCMs databse 
from a MSDE to a SQL server.

1. is this possible and does it work, i have all the the questions and 
answer and it seems like it shold work, but does it work 100%. so if someone 
have done this migration, please just write som words and tell me about is.

2. I have contacted the Microsoft support and the limitations of the MSDE 
databse is 5 users and a BCM databse can be 2 GB big. If you migrate the BCM 
databse to a SQL server 2000, does the limitations disappears?

3. Can you use the BCM database in some sort of "offline" status, so you 
will be able to use the BCM database when you open Outlook 2003 outside of 
the office, example when you are home. When i do this now, is says it cant 
find the BCM database, beacause a work with a shared database that is on our 
server.
Does anyone know if the "offline" databse i possible?

I appreciate all the help, tips and suggestions that you know of, i think 
this is som questions that more people than me would like to know.

Best regards
Tom

4.Sharing BCM database on SQL 2000 Server

I installed BCM 2003 on on XP computer, shared it and then copied it to our 
SQL 2000 server.  I enable dnamed pipes and TCP/IP to use port 56183.  
However,  when I try to connect my users to the database they can not locate 
any databases on our server.  Any thoughts would be greatly appreciated.

5.Moving BCM 2007 Database to a SQL 2005 Server

One of our users has been testing BCM and we now want others to start
using it, they have just been using a local database but now I want to
move it to SQL Server. I thought I could just backup the database and
restore it on the server using the BCM Database admin tool. I first
created a new database on the server with the admin tool then backed
up his local database and restored this onto the server.
This seemed to work however although user1 was still the dbo of the
database he could not access the database but users that I shared the
database to could access it just not the dbo. In Studio Manager when I
right clicked on the database and click properties under database it
had the owner listed as administrator. Administrator is the user I ran
the admin tool as. Is this owner different from the dbo? I even tried
using the command sp_changedbowner to make sure the dbo is set
correctly and it now shows in Studio Manager as user1 instead of
administrator but the user still cannot access the db.
If I try and connect using sqlcmd -E -S 'servername'\'instance','port
no'
I get the following error:
C:\>sqlcmd -E -S 'servername'\'instance','port no'
Msg 18456, Level 14, State 1, Server 'servername, Line 1
Login failed for user 'domain\user1'.
I have read that instead of restoring the database I could just export
the data then the dbo would be administrator. However I think I will
then have a problem where user1 will no longer be able to create new
fields in BCM which they need to be able to do.
Any help much appreciated.

6. BCM 2007 on SQL 2000 server

7. Can BCM database be installed on a standard SQL Server

8. BCM Database on central SQL server?