Hi Jeff,
We believe that this has to do with the connection's user name or
password. This error will come up when establishing a new connection to your
server in order to script the triggers. Have you tried to script the
database with a different user?
Brian Donahue
Technical Support Engineer
Red Gate Software Ltd.
+44 870 1600 037
mailto:
brian.donahue@red-gate.com
"Jeff Hamm" <
jhamm@nospam.com> wrote in message
news:
0VPnlnNwCHA.1348@server53...
> We have one of our SQL Development Server that we have been unable to get
> any databases to register in SQL Compare (running bundle version 2.03).
> When we try to register a DB, the progam goes through and appears to be
> scripting the DB and objects. However, when it finishes, we get the
> following error messages:
>
> "Couldn't Register the Database, please check the registration
properties."
>
> "Error Loading database ccgsqldev.jeffhammtest
> Getting on cascade/on delete trigger information"
>
> "Format of the intialization string does not conform to the OLE DB
> specification"
>
>
> Any Ideas?
>
> Thanks in advance,
> Jeff Hamm
>
>
We believe that this has to do with the connection's user name or
password. This error will come up when establishing a new connection to your
server in order to script the triggers. Have you tried to script the
database with a different user?
Brian Donahue
Technical Support Engineer
Red Gate Software Ltd.
+44 870 1600 037
mailto:brian.donahue@red-gate.com
"Jeff Hamm" <jhamm@nospam.com> wrote in message
news:0VPnlnNwCHA.1348@server53...
> We have one of our SQL Development Server that we have been unable to get
> any databases to register in SQL Compare (running bundle version 2.03).
> When we try to register a DB, the progam goes through and appears to be
> scripting the DB and objects. However, when it finishes, we get the
> following error messages:
>
> "Couldn't Register the Database, please check the registration
properties."
>
> "Error Loading database ccgsqldev.jeffhammtest
> Getting on cascade/on delete trigger information"
>
> "Format of the intialization string does not conform to the OLE DB
> specification"
>
>
> Any Ideas?
>
> Thanks in advance,
> Jeff Hamm
>
>