Shared database greyed out and cannot connect

Status
Not open for further replies.
R

Russell Reid

We are an SA license holder and have downloaded the RTM 2010 versions of

office and BCM. We are trying to set up a test database for BCM on an

existing SQL 2008 server using the BCM 2010 database admin tool beta (since

the i cannot find the RTM of this tool). The database gets created without

error. I am able to add users to the shared database without error. But

when i try to connect to the remote database with a client BCM, the database

is greyed out and it will not let me connect. Is this because the database

was created with the beta admin tool while the BCM install is RTM? Or am i

missing permissions on the database that will allow the client to connect?

Russell Reid
 
Hi Russell

Do you encounter any error when connecting to the database from the client

computer ?

Also can you try connecting to the server machine using sqlcmd (as per

KB953745)

Regards

Rahul Thomas

MSFT

"Russell Reid" <RussellReid> wrote in message

news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> We are an SA license holder and have downloaded the RTM 2010 versions of
> office and BCM. We are trying to set up a test database for BCM on an
> existing SQL 2008 server using the BCM 2010 database admin tool beta
> (since
> the i cannot find the RTM of this tool). The database gets created
> without
> error. I am able to add users to the shared database without error. But
> when i try to connect to the remote database with a client BCM, the
> database
> is greyed out and it will not let me connect. Is this because the
> database
> was created with the beta admin tool while the BCM install is RTM? Or am
> i
> missing permissions on the database that will allow the client to connect?
> > Russell Reid
 
I found this KB article when i was searching. I followed through on the

steps and am able to successfully connect to the remote database using

sqlcmd. But when i try to connect with BCM the database is greyed out. I

set up the remote database using the Database Admin Tool (beta). Could that

be the problem? When will the Full release of the Database Admin Tool be

available?

What else can i check to determine if i have the correct permissions on the

database?

Russell Reid

"Raul Thomas" wrote:


> Hi Russell

> Do you encounter any error when connecting to the database from the client
> computer ?

> Also can you try connecting to the server machine using sqlcmd (as per
> KB953745)
> > Regards

> Rahul Thomas

> MSFT

> "Russell Reid" <RussellReid> wrote in message
> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> > We are an SA license holder and have downloaded the RTM 2010 versions of
> > office and BCM. We are trying to set up a test database for BCM on an
> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> > (since
> > the i cannot find the RTM of this tool). The database gets created
> > without
> > error. I am able to add users to the shared database without error. But
> > when i try to connect to the remote database with a client BCM, the
> > database
> > is greyed out and it will not let me connect. Is this because the
> > database
> > was created with the beta admin tool while the BCM install is RTM? Or am
> > i
> > missing permissions on the database that will allow the client to connect?
> > > > Russell Reid

>
 
Hi Russell

I haven't tested it so cant tell you for sure. The RTM build of the tool

should be posted once the product is available of the shelf for consumers .

I'm hopefully that this would be taken care by the end of this month.

Also if you can check the permission if you have SQL management studio for

SQL 2008 installed.

Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?

Because it 64 then the clients connecting to it need to be 64 bit .

Regards

Rahul Thomas

MSFT

"Russell Reid" <RussellReid> wrote in message

news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> I found this KB article when i was searching. I followed through on the
> steps and am able to successfully connect to the remote database using
> sqlcmd. But when i try to connect with BCM the database is greyed out. I
> set up the remote database using the Database Admin Tool (beta). Could
> that
> be the problem? When will the Full release of the Database Admin Tool be
> available?
> What else can i check to determine if i have the correct permissions on
> the
> database?
> > Russell Reid

> "Raul Thomas" wrote:
>
> > Hi Russell
>

>> Do you encounter any error when connecting to the database from the
> > client
> > computer ?
>

>> Also can you try connecting to the server machine using sqlcmd (as per
> > KB953745)
> > > > Regards
>

>> Rahul Thomas
>

>> MSFT
>

>> "Russell Reid" <RussellReid> wrote in message
> > news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> > > We are an SA license holder and have downloaded the RTM 2010 versions
> > > of
> > > office and BCM. We are trying to set up a test database for BCM on an
> > > existing SQL 2008 server using the BCM 2010 database admin tool beta
> > > (since
> > > the i cannot find the RTM of this tool). The database gets created
> > > without
> > > error. I am able to add users to the shared database without error.
> > > But
> > > when i try to connect to the remote database with a client BCM, the
> > > database
> > > is greyed out and it will not let me connect. Is this because the
> > > database
> > > was created with the beta admin tool while the BCM install is RTM? Or
> > > am
> > > i
> > > missing permissions on the database that will allow the client to
> > > connect?
> > > > > > Russell Reid

> >
 
The only way I could get this working was to create a local database in BCM.

Detach the database and copy to your server. Attach the copied database in

sql.

After it is attached run the following in a command window:

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

SharedServer = N'{ServerName}'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

OrgName = N'{databasename}'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

LocaleID=N'en-US'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "exec

PublicTurnOnSharing 1"

After this you will want to add your users:

sqlcmd -S {server\instance} -E -Q "exec sp_grantlogin [domain\user]"

sqlcmd -S {server\instance} -d {databasename} -E -Q "exec ir_AddSharedUser

[domain\user]"

That's it. The beta tools will not work due to the db version being

different. I couldn't get it to upgrade using the scripts either (too many

conflicts).

Thanks.

-Chris

"Raul Thomas" wrote:


> Hi Russell

> I haven't tested it so cant tell you for sure. The RTM build of the tool
> should be posted once the product is available of the shelf for consumers .

> I'm hopefully that this would be taken care by the end of this month.

> Also if you can check the permission if you have SQL management studio for
> SQL 2008 installed.

> Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?
> Because it 64 then the clients connecting to it need to be 64 bit .
> > Regards

> Rahul Thomas

> MSFT

> "Russell Reid" <RussellReid> wrote in message
> news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> > I found this KB article when i was searching. I followed through on the
> > steps and am able to successfully connect to the remote database using
> > sqlcmd. But when i try to connect with BCM the database is greyed out. I
> > set up the remote database using the Database Admin Tool (beta). Could
> > that
> > be the problem? When will the Full release of the Database Admin Tool be
> > available?
> > What else can i check to determine if i have the correct permissions on
> > the
> > database?
> > > > Russell Reid
> > "Raul Thomas" wrote:
> >
> >> Hi Russell
> >
> >> Do you encounter any error when connecting to the database from the
> >> client
> >> computer ?
> >
> >> Also can you try connecting to the server machine using sqlcmd (as per
> >> KB953745)
> >> > >> Regards
> >
> >> Rahul Thomas
> >
> >> MSFT
> >
> >> "Russell Reid" <RussellReid> wrote in message
> >> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> >> > We are an SA license holder and have downloaded the RTM 2010 versions
> >> > of
> >> > office and BCM. We are trying to set up a test database for BCM on an
> >> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> >> > (since
> >> > the i cannot find the RTM of this tool). The database gets created
> >> > without
> >> > error. I am able to add users to the shared database without error.
> >> > But
> >> > when i try to connect to the remote database with a client BCM, the
> >> > database
> >> > is greyed out and it will not let me connect. Is this because the
> >> > database
> >> > was created with the beta admin tool while the BCM install is RTM? Or
> >> > am
> >> > i
> >> > missing permissions on the database that will allow the client to
> >> > connect?
> >> > > >> > Russell Reid
> >>
 
Russell,

The only way I could get this working was to create a local database in BCM.

Detach the database and copy to your server. Attach the copied database in

sql.

After it is attached run the following in a command window:

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

SharedServer = N'{ServerName}'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

OrgName = N'{databasename}'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

LocaleID=N'en-US'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "exec

PublicTurnOnSharing 1"

After this you will want to add your users:

sqlcmd -S {server\instance} -E -Q "exec sp_grantlogin [domain\user]"

sqlcmd -S {server\instance} -d {databasename} -E -Q "exec ir_AddSharedUser

[domain\user]"

That's it. The beta tools will not work due to the db version being

different. I couldn't get it to upgrade using the scripts either (too many

conflicts).

Thanks.

-Chris

"Raul Thomas" wrote:


> Hi Russell

> I haven't tested it so cant tell you for sure. The RTM build of the tool
> should be posted once the product is available of the shelf for consumers .

> I'm hopefully that this would be taken care by the end of this month.

> Also if you can check the permission if you have SQL management studio for
> SQL 2008 installed.

> Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?
> Because it 64 then the clients connecting to it need to be 64 bit .
> > Regards

> Rahul Thomas

> MSFT

> "Russell Reid" <RussellReid> wrote in message
> news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> > I found this KB article when i was searching. I followed through on the
> > steps and am able to successfully connect to the remote database using
> > sqlcmd. But when i try to connect with BCM the database is greyed out. I
> > set up the remote database using the Database Admin Tool (beta). Could
> > that
> > be the problem? When will the Full release of the Database Admin Tool be
> > available?
> > What else can i check to determine if i have the correct permissions on
> > the
> > database?
> > > > Russell Reid
> > "Raul Thomas" wrote:
> >
> >> Hi Russell
> >
> >> Do you encounter any error when connecting to the database from the
> >> client
> >> computer ?
> >
> >> Also can you try connecting to the server machine using sqlcmd (as per
> >> KB953745)
> >> > >> Regards
> >
> >> Rahul Thomas
> >
> >> MSFT
> >
> >> "Russell Reid" <RussellReid> wrote in message
> >> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> >> > We are an SA license holder and have downloaded the RTM 2010 versions
> >> > of
> >> > office and BCM. We are trying to set up a test database for BCM on an
> >> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> >> > (since
> >> > the i cannot find the RTM of this tool). The database gets created
> >> > without
> >> > error. I am able to add users to the shared database without error.
> >> > But
> >> > when i try to connect to the remote database with a client BCM, the
> >> > database
> >> > is greyed out and it will not let me connect. Is this because the
> >> > database
> >> > was created with the beta admin tool while the BCM install is RTM? Or
> >> > am
> >> > i
> >> > missing permissions on the database that will allow the client to
> >> > connect?
> >> > > >> > Russell Reid
> >>
 
Thanks Chris, i will give this a try. We are just setting up our BCM system,

so i am trying to do a test system before i deploy.

Russell Reid

"ChrisF" wrote:


> Russell,

> The only way I could get this working was to create a local database in BCM.
> Detach the database and copy to your server. Attach the copied database in
> sql.
> After it is attached run the following in a command window:

> sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> SharedServer = N'{ServerName}'"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> OrgName = N'{databasename}'"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> LocaleID=N'en-US'"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "exec
> PublicTurnOnSharing 1"

> After this you will want to add your users:

> sqlcmd -S {server\instance} -E -Q "exec sp_grantlogin [domain\user]"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "exec ir_AddSharedUser
> [domain\user]"

> That's it. The beta tools will not work due to the db version being
> different. I couldn't get it to upgrade using the scripts either (too many
> conflicts).

> Thanks.

> -Chris

> "Raul Thomas" wrote:
>
> > Hi Russell
> > I haven't tested it so cant tell you for sure. The RTM build of the tool
> > should be posted once the product is available of the shelf for consumers .
> > I'm hopefully that this would be taken care by the end of this month.
> > Also if you can check the permission if you have SQL management studio for
> > SQL 2008 installed.
> > Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?
> > Because it 64 then the clients connecting to it need to be 64 bit .
> > > > Regards
> > Rahul Thomas
> > MSFT
> > "Russell Reid" <RussellReid> wrote in message
> > news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> > > I found this KB article when i was searching. I followed through on the
> > > steps and am able to successfully connect to the remote database using
> > > sqlcmd. But when i try to connect with BCM the database is greyed out. I
> > > set up the remote database using the Database Admin Tool (beta). Could
> > > that
> > > be the problem? When will the Full release of the Database Admin Tool be
> > > available?
> > > What else can i check to determine if i have the correct permissions on
> > > the
> > > database?
> > > > > > Russell Reid
> > > > > "Raul Thomas" wrote:
> > > >> Hi Russell
> > >
> > >> Do you encounter any error when connecting to the database from the
> > >> client
> > >> computer ?
> > >
> > >> Also can you try connecting to the server machine using sqlcmd (as per
> > >> KB953745)
> > >> > > >> Regards
> > >
> > >> Rahul Thomas
> > >
> > >> MSFT
> > >
> > >> "Russell Reid" <RussellReid> wrote in message
> > >> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> > >> > We are an SA license holder and have downloaded the RTM 2010 versions
> > >> > of
> > >> > office and BCM. We are trying to set up a test database for BCM on an
> > >> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> > >> > (since
> > >> > the i cannot find the RTM of this tool). The database gets created
> > >> > without
> > >> > error. I am able to add users to the shared database without error.
> > >> > But
> > >> > when i try to connect to the remote database with a client BCM, the
> > >> > database
> > >> > is greyed out and it will not let me connect. Is this because the
> > >> > database
> > >> > was created with the beta admin tool while the BCM install is RTM? Or
> > >> > am
> > >> > i
> > >> > missing permissions on the database that will allow the client to
> > >> > connect?
> > >> > > > >> > Russell Reid
> > >>
 
So if i deploy the BCM database to our Server 2008 x64 SQL server, the

clients will need to be 64 bit Office 2010 to connect to it? I cant connect

to a database from a 32bit client? MS itself recommends only installing the

32bit version of office. So why would i be forced to install the 64bit

office to connect to a database?

Russell Reid

"Raul Thomas" wrote:


> Hi Russell

> I haven't tested it so cant tell you for sure. The RTM build of the tool
> should be posted once the product is available of the shelf for consumers .

> I'm hopefully that this would be taken care by the end of this month.

> Also if you can check the permission if you have SQL management studio for
> SQL 2008 installed.

> Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?
> Because it 64 then the clients connecting to it need to be 64 bit .
> > Regards

> Rahul Thomas

> MSFT

> "Russell Reid" <RussellReid> wrote in message
> news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> > I found this KB article when i was searching. I followed through on the
> > steps and am able to successfully connect to the remote database using
> > sqlcmd. But when i try to connect with BCM the database is greyed out. I
> > set up the remote database using the Database Admin Tool (beta). Could
> > that
> > be the problem? When will the Full release of the Database Admin Tool be
> > available?
> > What else can i check to determine if i have the correct permissions on
> > the
> > database?
> > > > Russell Reid
> > "Raul Thomas" wrote:
> >
> >> Hi Russell
> >
> >> Do you encounter any error when connecting to the database from the
> >> client
> >> computer ?
> >
> >> Also can you try connecting to the server machine using sqlcmd (as per
> >> KB953745)
> >> > >> Regards
> >
> >> Rahul Thomas
> >
> >> MSFT
> >
> >> "Russell Reid" <RussellReid> wrote in message
> >> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> >> > We are an SA license holder and have downloaded the RTM 2010 versions
> >> > of
> >> > office and BCM. We are trying to set up a test database for BCM on an
> >> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> >> > (since
> >> > the i cannot find the RTM of this tool). The database gets created
> >> > without
> >> > error. I am able to add users to the shared database without error.
> >> > But
> >> > when i try to connect to the remote database with a client BCM, the
> >> > database
> >> > is greyed out and it will not let me connect. Is this because the
> >> > database
> >> > was created with the beta admin tool while the BCM install is RTM? Or
> >> > am
> >> > i
> >> > missing permissions on the database that will allow the client to
> >> > connect?
> >> > > >> > Russell Reid
> >>
 
OK, i followed this procedure and got the database copied over to our SQL

server. Added the users. But when i try to connect using BCM the database

is still greyed out. Am i missing a permission? What database permissions

are required for shared users in the database?

Russell Reid

"ChrisF" wrote:


> Russell,

> The only way I could get this working was to create a local database in BCM.
> Detach the database and copy to your server. Attach the copied database in
> sql.
> After it is attached run the following in a command window:

> sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> SharedServer = N'{ServerName}'"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> OrgName = N'{databasename}'"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> LocaleID=N'en-US'"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "exec
> PublicTurnOnSharing 1"

> After this you will want to add your users:

> sqlcmd -S {server\instance} -E -Q "exec sp_grantlogin [domain\user]"
> sqlcmd -S {server\instance} -d {databasename} -E -Q "exec ir_AddSharedUser
> [domain\user]"

> That's it. The beta tools will not work due to the db version being
> different. I couldn't get it to upgrade using the scripts either (too many
> conflicts).

> Thanks.

> -Chris

> "Raul Thomas" wrote:
>
> > Hi Russell
> > I haven't tested it so cant tell you for sure. The RTM build of the tool
> > should be posted once the product is available of the shelf for consumers .
> > I'm hopefully that this would be taken care by the end of this month.
> > Also if you can check the permission if you have SQL management studio for
> > SQL 2008 installed.
> > Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?
> > Because it 64 then the clients connecting to it need to be 64 bit .
> > > > Regards
> > Rahul Thomas
> > MSFT
> > "Russell Reid" <RussellReid> wrote in message
> > news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> > > I found this KB article when i was searching. I followed through on the
> > > steps and am able to successfully connect to the remote database using
> > > sqlcmd. But when i try to connect with BCM the database is greyed out. I
> > > set up the remote database using the Database Admin Tool (beta). Could
> > > that
> > > be the problem? When will the Full release of the Database Admin Tool be
> > > available?
> > > What else can i check to determine if i have the correct permissions on
> > > the
> > > database?
> > > > > > Russell Reid
> > > > > "Raul Thomas" wrote:
> > > >> Hi Russell
> > >
> > >> Do you encounter any error when connecting to the database from the
> > >> client
> > >> computer ?
> > >
> > >> Also can you try connecting to the server machine using sqlcmd (as per
> > >> KB953745)
> > >> > > >> Regards
> > >
> > >> Rahul Thomas
> > >
> > >> MSFT
> > >
> > >> "Russell Reid" <RussellReid> wrote in message
> > >> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> > >> > We are an SA license holder and have downloaded the RTM 2010 versions
> > >> > of
> > >> > office and BCM. We are trying to set up a test database for BCM on an
> > >> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> > >> > (since
> > >> > the i cannot find the RTM of this tool). The database gets created
> > >> > without
> > >> > error. I am able to add users to the shared database without error.
> > >> > But
> > >> > when i try to connect to the remote database with a client BCM, the
> > >> > database
> > >> > is greyed out and it will not let me connect. Is this because the
> > >> > database
> > >> > was created with the beta admin tool while the BCM install is RTM? Or
> > >> > am
> > >> > i
> > >> > missing permissions on the database that will allow the client to
> > >> > connect?
> > >> > > > >> > Russell Reid
> > >>
 
This is extremely confusing; 64 or 32 bit, and not mixed? And what happened

between the Office 2010 Beta and RTM? I connected and worked perfectly with

the Beta, but the RTM is unable to connect.

If there is a solution available, please post it here.

"Russell Reid" wrote:


> So if i deploy the BCM database to our Server 2008 x64 SQL server, the
> clients will need to be 64 bit Office 2010 to connect to it? I cant connect
> to a database from a 32bit client? MS itself recommends only installing the
> 32bit version of office. So why would i be forced to install the 64bit
> office to connect to a database?
> > Russell Reid

> "Raul Thomas" wrote:
>
> > Hi Russell
> > I haven't tested it so cant tell you for sure. The RTM build of the tool
> > should be posted once the product is available of the shelf for consumers .
> > I'm hopefully that this would be taken care by the end of this month.
> > Also if you can check the permission if you have SQL management studio for
> > SQL 2008 installed.
> > Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?
> > Because it 64 then the clients connecting to it need to be 64 bit .
> > > > Regards
> > Rahul Thomas
> > MSFT
> > "Russell Reid" <RussellReid> wrote in message
> > news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> > > I found this KB article when i was searching. I followed through on the
> > > steps and am able to successfully connect to the remote database using
> > > sqlcmd. But when i try to connect with BCM the database is greyed out. I
> > > set up the remote database using the Database Admin Tool (beta). Could
> > > that
> > > be the problem? When will the Full release of the Database Admin Tool be
> > > available?
> > > What else can i check to determine if i have the correct permissions on
> > > the
> > > database?
> > > > > > Russell Reid
> > > > > "Raul Thomas" wrote:
> > > >> Hi Russell
> > >
> > >> Do you encounter any error when connecting to the database from the
> > >> client
> > >> computer ?
> > >
> > >> Also can you try connecting to the server machine using sqlcmd (as per
> > >> KB953745)
> > >> > > >> Regards
> > >
> > >> Rahul Thomas
> > >
> > >> MSFT
> > >
> > >> "Russell Reid" <RussellReid> wrote in message
> > >> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> > >> > We are an SA license holder and have downloaded the RTM 2010 versions
> > >> > of
> > >> > office and BCM. We are trying to set up a test database for BCM on an
> > >> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> > >> > (since
> > >> > the i cannot find the RTM of this tool). The database gets created
> > >> > without
> > >> > error. I am able to add users to the shared database without error.
> > >> > But
> > >> > when i try to connect to the remote database with a client BCM, the
> > >> > database
> > >> > is greyed out and it will not let me connect. Is this because the
> > >> > database
> > >> > was created with the beta admin tool while the BCM install is RTM? Or
> > >> > am
> > >> > i
> > >> > missing permissions on the database that will allow the client to
> > >> > connect?
> > >> > > > >> > Russell Reid
> > >>
 
Sorry, didn't see you were still having problems with this. I have

importing all our Siebel data into bcm for the last couple weeks.

Did you set the permissions and sharing on the Database? I remember that

the greyed out database issue was from different versions of the bcm

client. If you are using the final release, the new database must be

created in the final version. The beta client will not connect to a

final database, or the other way around.

These are the only permissions I set on the database to get it working.

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

SharedServer = N'{ServerName}'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

OrgName = N'{databasename}'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set

LocaleID=N'en-US'"

sqlcmd -S {server\instance} -d {databasename} -E -Q "exec

PublicTurnOnSharing 1"

You should be able to connect from the machine you created the database

on. By the way, i have not seen a difference between using a 32 or 64 bit

client. Both connect to the server. Just the fact you can see the

database means you have it on the server and have user permissions. The

final release database version number is 4.0.9812.0

Russell Reid wrote:

> OK, i followed this procedure and got the database copied over to our SQL
> server. Added the users. But when i try to connect using BCM the database
> is still greyed out. Am i missing a permission? What database permissions
> are required for shared users in the database?
> > Russell Reid

> "ChrisF" wrote:
>
> > Russell,
> > The only way I could get this working was to create a local database in


BCM.
> > Detach the database and copy to your server. Attach the copied database


in
> > sql.
> > After it is attached run the following in a command window:
> > sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> > SharedServer = N'{ServerName}'"
> > sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> > OrgName = N'{databasename}'"
> > sqlcmd -S {server\instance} -d {databasename} -E -Q "Update OrgTable Set
> > LocaleID=N'en-US'"
> > sqlcmd -S {server\instance} -d {databasename} -E -Q "exec
> > PublicTurnOnSharing 1"
> > After this you will want to add your users:
> > sqlcmd -S {server\instance} -E -Q "exec sp_grantlogin [domain\user]"
> > sqlcmd -S {server\instance} -d {databasename} -E -Q "exec ir_AddSharedUser
> > [domain\user]"
> > That's it. The beta tools will not work due to the db version being
> > different. I couldn't get it to upgrade using the scripts either (too


many
> > conflicts).
> > Thanks.
> > -Chris
> > "Raul Thomas" wrote:
> >
> > > Hi Russell
> > > > I haven't tested it so cant tell you for sure. The RTM build of the tool
> > > should be posted once the product is available of the shelf for


consumers .
> > > > I'm hopefully that this would be taken care by the end of this month.
> > > > Also if you can check the permission if you have SQL management studio


for
> > > SQL 2008 installed.
> > > > Also is the database hosted on the server a 32 or a 64 bit of SQL 2008 ?
> > > Because it 64 then the clients connecting to it need to be 64 bit .
> > > > > > Regards
> > > > Rahul Thomas
> > > > MSFT
> > > > "Russell Reid" <RussellReid> wrote in message
> > > news:2801F6FA-98FE-4472-9F82-218D1A2113F7@microsoft.com...
> > > > I found this KB article when i was searching. I followed through on


the
> > > > steps and am able to successfully connect to the remote database using
> > > > sqlcmd. But when i try to connect with BCM the database is greyed


out. I
> > > > set up the remote database using the Database Admin Tool (beta).


Could
> > > > that
> > > > be the problem? When will the Full release of the Database Admin Tool


be
> > > > available?
> > > > What else can i check to determine if i have the correct permissions


on
> > > > the
> > > > database?
> > > > > > > > Russell Reid
> > > > > > > > "Raul Thomas" wrote:
> > > > > >> Hi Russell
> > > >
> > > >> Do you encounter any error when connecting to the database from the
> > > >> client
> > > >> computer ?
> > > >
> > > >> Also can you try connecting to the server machine using sqlcmd (as per
> > > >> KB953745)
> > > >> > > > >> Regards
> > > >
> > > >> Rahul Thomas
> > > >
> > > >> MSFT
> > > >
> > > >> "Russell Reid" <RussellReid> wrote in


message
> > > >> news:8B213CF0-9BB3-4C49-86D1-4324E8D2A5B1@microsoft.com...
> > > >> > We are an SA license holder and have downloaded the RTM 2010


versions
> > > >> > of
> > > >> > office and BCM. We are trying to set up a test database for BCM on


an
> > > >> > existing SQL 2008 server using the BCM 2010 database admin tool beta
> > > >> > (since
> > > >> > the i cannot find the RTM of this tool). The database gets created
> > > >> > without
> > > >> > error. I am able to add users to the shared database without


error.
> > > >> > But
> > > >> > when i try to connect to the remote database with a client BCM, the
> > > >> > database
> > > >> > is greyed out and it will not let me connect. Is this because the
> > > >> > database
> > > >> > was created with the beta admin tool while the BCM install is RTM?


Or
> > > >> > am
> > > >> > i
> > > >> > missing permissions on the database that will allow the client to
> > > >> > connect?
> > > >> > > > > >> > Russell Reid
> > > >>


>


Posted from http://outlook-center.com

Outlook forums, articles, tips.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
K BCM - Connecting to Shared Database BCM (Business Contact Manager) 0
T Shared BCM database on remote server BCM (Business Contact Manager) 1
C My BCM Database is no longer available to be shared with the Database Tool BCM (Business Contact Manager) 3
wallisellener Server configuration for BCM 2013 shared database BCM (Business Contact Manager) 15
S Cannot Find Shared Database on Remote Computer BCM (Business Contact Manager) 13
J Unable to view History items in BCM 2007 shared database BCM (Business Contact Manager) 3
R Missing contacts and Opportunities in BCM 2010 Shared database BCM (Business Contact Manager) 1
R BCM 2010 error creating offline copy of shared database BCM (Business Contact Manager) 1
D Connecting BCM 2007 to a shared BCM 2003 Database BCM (Business Contact Manager) 3
A BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain BCM (Business Contact Manager) 1
S shared database BCM (Business Contact Manager) 2
D BCM 2010 and a shared BCM 2007 Database BCM (Business Contact Manager) 5
S Lost BCM shared database file BCM (Business Contact Manager) 1
A Protecting Shared Database BCM (Business Contact Manager) 1
L RE: Select Users in Shared Database BCM (Business Contact Manager) 1
B connecting to shared database BCM (Business Contact Manager) 1
J shared database BCM (Business Contact Manager) 2
D Setting up Shared Database on Windows 2003 Server - File Server BCM (Business Contact Manager) 2
U When opening shared Calendar "The set of folders cannot be opened" Using Outlook 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
V Unchecking my calendar and leaving shared one visible Outlook VBA and Custom Forms 1
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
C Outlook 365 Multiple different Signatures on Shared Mailbox Using Outlook 0
Fozzie Bear Shared Calendar For Scheduled Tasks Using Outlook.com accounts in Outlook 3
Z Outlook 365 Automatically assign categories to incoming mail in a shared folder Round Robin Outlook VBA and Custom Forms 1
J Outlook 365 Forward Email Subject to my inbox when new email arrive in shared inbox Using Outlook 0
J Hide/disable "Groups", "Shared Calendars" Using Outlook 2
T Never-ending Reminders in Shared Calendars Using Outlook 3
S Outlook 365 Shared mailbox contact group member numbers not matching Using Outlook 0
P Emails assigned with a certain category (within a shared inbox) to be copied to a specific folder. Outlook VBA and Custom Forms 2
S Copy Tasks/Reminders from Shared Mailbox to Personal Tasks/Reminders Outlook VBA and Custom Forms 0
peterbata Shared Tasks Outlook for Mac Using Outlook 5
Fozzie Bear Shared Public Folders Access and Use Exchange Server Administration 0
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 3
J O365 - Adding Shared Google Calendar ICS link issue in O365 Using Outlook 0
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
N Having Shared Calendar shift to Current day Using Outlook 0
R Assign Categories "Round Robin" style but in a shared mailbox but on specific emails only Outlook VBA and Custom Forms 8
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
P Auto assign shared mailbox Outlook VBA and Custom Forms 1
C Pull Outlook shared calendars items from Excel Outlook VBA and Custom Forms 4
C Create new Message with shared contacts & BCC'ing recipients Outlook VBA and Custom Forms 0
R VBA for copying sent email to current folder under a shared mailbox Outlook VBA and Custom Forms 17
M Outlook 365 Searching all shared calendars Outlook VBA and Custom Forms 4
S newly added shared mailboxes downloading 500GB data a day Exchange Server Administration 1
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
A New email notification on shared mailbox Outlook VBA and Custom Forms 0
N Shared mailbox in cached mode Using Outlook 0
B Vba to monitor time to respond to emails using a shared mailbox Outlook VBA and Custom Forms 5

Similar threads

Back
Top