slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Synchronization
Forum to discuss SalesLogix synchronization and remote database management. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Synchronization | New Thread

View: Search:

Author

Thread: Starting Remote Client "You must be the database owner" - error?

Marty05
Posts: 68

Starting Remote Client "You must be the database owner" - error? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jan 10 10:13 AM

Hi,

I have just installed SLX 7.5 SP2 on two different pcs, both with same problem:

SQL2005 Express was installed within the Sage-MSI-installer.
Attaching a remote worked fine.

Using same windows-user (local admin): After second(?? - first it wasn't...) start of Remote Client I get the error-message "You must be the database owner or "Admin" to use this application.".

But: Clicking OK and then logging in into SLX works fine.

Do you have any idea what this error means? Could there be an options/configuration-problem when creating the remote database?

Thanks for any help...
Marty

[Reply][Quote]

Marty05
Posts: 68

Re: Starting Remote Client "You must be the database owner" - error? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jan 10 10:49 AM

addition:

using SQLCMD on SALESLOGIX instance reveals:
1> EXEC sp_helplogins
2> go
LoginName DBName UserName UserOrAlias
------------------------------------------------------------ ------------------ ------------------------------------------------------------ -----------
sysdba SLXRemote db_owner MemberOf
sysdba SLXRemote sysdba User
.....

So for me it seems sysdba is the owner.

Maybe this isnt connected to the SQL DB at all?? I have no idea...

[Reply][Quote]

Pankaj Phukane
Posts: 33

Re: Starting Remote Client "You must be the database owner" - error? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Sep 13 5:37 AM

Check for Password Policy of sysdba user.

Reset password for sysdba password.

It works for me!

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 5:39:47 AM