Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Wednesday, July 9, 2025 
 
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 - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to General Administration | New ThreadView:  Search:  
 Author  Thread: Database login failed: Invalid object name 'SYSTEMINFO'
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Database login failed: Invalid object name 'SYSTEMINFO'Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Jun 07 1:41 AM
We just started getting this tonight. Has anyone ever run into this issue? No one has access to any of the SalesLogix databases on the server. The version is 7.0.1.

I went to the SalesLogix server, opened the Connection Manager and all of the connections test OK. But whenever I try to login through the Administrator or Client I am getting a

Database login failed: Invalid object name 'SYSTEMINFO'

If I edit the datalink from the client side and click Test Connection I am getting a slightly different error.

Unable to initialize data dictionary. Invalid object name 'SYTEMINFO'.,

We have a development server and I tested connecting to the SalesLogix database there. All worked fine. So this seems to be an issue with our production SalesLogix server and/or production SalesLogix database server.

At this point we are at a complete standstill. No one can access any of the databases!

Any help/suggestions would be appreciated.

Thanks,
John G.
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: Database login failed: Invalid object name 'SYSTEMINFO'Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Jun 07 1:53 AM
Figured this out. Earlier, the SYSADMIN database role was added to the sysdba user. I don't know why this would have created the above issue, but it did. After removing the role all was well again.

Thanks for listening!
John G.
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: Database login failed: Invalid object name 'SYSTEMINFO'Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Jun 07 1:54 AM
Figured this out. Earlier, the SYSADMIN database role was added to the sysdba user. I don't know why this would have created the above issue, but it did. After removing the role all was well again.

Thanks for listening!
John G.
[Reply][Quote]
Bob (RJ)Ledger
Posts: 1103
Top 10 forum poster: 1103 posts
 
Re: Database login failed: Invalid object name 'SYSTEMINFO'Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Jun 07 8:29 AM
VERY common and WELL KI.. In fact if you use the SalesLogix on-line knowledge base it will point you to the exact solution you performed.

Also, it's very clear in documentation that the sysdba use must have NO server roles - never

Good to see you were able to work it out.

--
rjl
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: Database login failed: Invalid object name 'SYSTEMINFO'Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Jul 07 6:38 AM
I'll have to keep that in mind for the future!

Thanks much!
John G.
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: Database login failed: Invalid object name 'SYSTEMINFO'Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Jul 07 7:11 AM
I'll have to keep that in mind for the future!

Thanks much!
John G.
[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 7/9/2025 12:42:29 PM