11-13-2012 05:23 AM
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."
11-13-2012 06:46 AM
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.
07-10-2013 11:05 PM
How do i fix the installation of the Microsoft SQL server?