Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Unable to connect to ACTDB hosted on SQL2005
21 views
Skip to first unread message
DMo
Jan 27, 2010, 5:29:01 PM1/27/10
to
I have provided our SQL team with the SQLCreate.sql script. I am able to
connect just fine, but the Database drop down is empty and when I manualy
enter the DB I am warned with "This database is not compatible with this
application". I know it see the database b/c if I enter a non-existing
database, the 'Create' button is enabled. I have not have any issues with
doing this on a separate SQLExpress that I manage. I have confirmed that
rights have been granted because I can connect via SQL Server manager on the
same ACT server i'm having issues on. Is there rights or settings that might
have been configured on the production SQL box that would prevent this? Why
would the database not be valid?
connect just fine, but the Database drop down is empty and when I manualy
enter the DB I am warned with "This database is not compatible with this
application". I know it see the database b/c if I enter a non-existing
database, the 'Create' button is enabled. I have not have any issues with
doing this on a separate SQLExpress that I manage. I have confirmed that
rights have been granted because I can connect via SQL Server manager on the
same ACT server i'm having issues on. Is there rights or settings that might
have been configured on the production SQL box that would prevent this? Why
would the database not be valid?
DMo
Jan 29, 2010, 2:28:07 PM1/29/10
to
My fix, the service account id must be the “real” database owner rather than
a member of the db_owner role of the act database.
a member of the db_owner role of the act database.
0 new messages