Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problems creating a remote database

New Member
Posts: 1
Country: United_Kingdom

Problems creating a remote database

Error message recieved after trying to create a remote database.  Any help or ideas much appreciated.

 

I am running Windows 7 and ACT! 2010.  I have disabled UAC and have tried right clicking and running ACT as an administrator.

 

"Running DBRights...
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
*** Setting rights on procedures...
*** Setting rights on tables and views...
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.PRC_UPD_USER_COLUMNACCESS'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.PRC_UPD_USER_COLUMNACCESS'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists."

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Problems creating a remote database

Hello Vickiduduu,

Welcome to the Sage ACT! Online Community!

 

- Verify if database or installation issue; to do this: open the Demo database (or create a new one) and attempt to create remote.

 

If able to create a remote: the issue is database specific.  Run Tools > Database Maintenance > Check and Repair.  Then attempt to create remote. 

 

If same error attempting to create remote from demo database, then the issue appears to be with the installation of Microsoft SQL Server. 

 

Greg Martin
Sage
New Member
Posts: 3
Country: USA

Re: Problems creating a remote database

How do i fix the installation of the Microsoft SQL server?