|
ACT Database Creation
|
On Friday, November 28th 2008 at 07:52 AM
By Anonymous |
|
Hi all,
As part of our proposition we are using ACT 5.0. We want to implement this
at our customer to start a scan. But now I found a issue.
Our customer has a seperate managed SQL server environment. So I can not
install it on my own "SQL ACT" server. I asked the SQL operators to use the
SQL scripts to create the ACT database. They obliged but they found in the
scripts that the creation of the DB also wanted to write in de "Master.db" of
the SQL server.
And this is NO option at this customer. They wont allow anybody to write in
to the Master.db. As a result I get an error when running the Setup of ACT,
because it does not find the table in the master db.
Anyone with a solution for this? Can i run setup with a workaround. The ACT
database is there and created with the ACT sql scripts! So that should not be
the issue.
I woukld also suggest to MS to not write to the master.db but just be able
to select the database from SQL itself and not via the master.
Hope someone can help. Cheers, Ton van den Berg |
Re: ACT Database creation by Ajith Alexander [MSFT] on Tuesday, December 2nd 2008 at 06:55 PM
|
Ton
Unfortunately, there isn't a workaround for it just yet. If the customer was
willing to allow a write to that table just temporarily while the database
is being configured on ACT, you can safely drop the table from the master.db
after that. However, I suspect this is not an option. Writing to the master
database was done to improve performance in ACT 5.0 although we have moved
away from this approach in our upcoming release. We have fixed this for the
next version of ACT (ACT 5.5) which should be out in spring '09.
Ajith
"Ekennot" <Ekennot@discussions.microsoft.com> wrote in message
news:3BA681C6-274F-4B13-8CF5-FCC03F5687E4@microsoft.com...
> Hi all,
>
> As part of our proposition we are using ACT 5.0. We want to implement this
> at our customer to start a scan. But now I found a issue.
>
> Our customer has a seperate managed SQL server environment. So I can not
> install it on my own "SQL ACT" server. I asked the SQL operators to use
> the
> SQL scripts to create the ACT database. They obliged but they found in the
> scripts that the creation of the DB also wanted to write in de "Master.db"
> of
> the SQL server.
>
> And this is NO option at this customer. They wont allow anybody to write
> in
> to the Master.db. As a result I get an error when running the Setup of
> ACT,
> because it does not find the table in the master db.
>
> Anyone with a solution for this? Can i run setup with a workaround. The
> ACT
> database is there and created with the ACT sql scripts! So that should not
> be
> the issue.
>
> I woukld also suggest to MS to not write to the master.db but just be able
> to select the database from SQL itself and not via the master.
>
> Hope someone can help. Cheers, Ton van den Berg
>
>
> |
Re: ACT Database creation by Anonymous on Thursday, December 4th 2008 at 07:01 PM
|
Ajith,
Thanks for the answer. Not very happy with it though.
So for how long does the table be in there. I understood from collegues
until ACT was finished completely and not only the configuration. And that
again is not an option.
Glad you (MS) moved away from this. Its giving me some major discussions at
the customer.
Final approach: I am willing to try the beta of 5.5 for you, If you got a
stable version :). Have not seen this version on connect.microsoft. Am in the
ACT 5.0 group.
Thanks again
"Ajith Alexander [MSFT]" wrote:
> Ton
> Unfortunately, there isn't a workaround for it just yet. If the customer was
> willing to allow a write to that table just temporarily while the database
> is being configured on ACT, you can safely drop the table from the master.db
> after that. However, I suspect this is not an option. Writing to the master
> database was done to improve performance in ACT 5.0 although we have moved
> away from this approach in our upcoming release. We have fixed this for the
> next version of ACT (ACT 5.5) which should be out in spring '09.
> Ajith
>
>
>
> "Ekennot" <Ekennot@discussions.microsoft.com> wrote in message
> news:3BA681C6-274F-4B13-8CF5-FCC03F5687E4@microsoft.com...
> > Hi all,
> >
> > As part of our proposition we are using ACT 5.0. We want to implement this
> > at our customer to start a scan. But now I found a issue.
> >
> > Our customer has a seperate managed SQL server environment. So I can not
> > install it on my own "SQL ACT" server. I asked the SQL operators to use
> > the
> > SQL scripts to create the ACT database. They obliged but they found in the
> > scripts that the creation of the DB also wanted to write in de "Master.db"
> > of
> > the SQL server.
> >
> > And this is NO option at this customer. They wont allow anybody to write
> > in
> > to the Master.db. As a result I get an error when running the Setup of
> > ACT,
> > because it does not find the table in the master db.
> >
> > Anyone with a solution for this? Can i run setup with a workaround. The
> > ACT
> > database is there and created with the ACT sql scripts! So that should not
> > be
> > the issue.
> >
> > I woukld also suggest to MS to not write to the master.db but just be able
> > to select the database from SQL itself and not via the master.
> >
> > Hope someone can help. Cheers, Ton van den Berg
> >
> >
> >
> |
|
|
Tutorials
Code
Knowledge Base
News
Forums
Pictures
Videos
Bargains
Icons
Newsgroups
PageRank™ Checker
Alexa Rank Checker
Domain-Name Lookup
Bargains RSS Feed
View More Magazines
View More Downloads
