Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Employee
Employee
Posts: 23
Registered: ‎08-27-2009
Accepted Solution

Database login failed:invalid object name systeminfo

Hi there:

 

I got a error message about "Database login failed:invalid object name systeminfo" when i try to log into the 'Administrator' after installation for 7.5.

What should i to deal with it?

 

Thank you in advance! 

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Database login failed:invalid object name systeminfo

Did you run the sysdba fix against the db?

  SP_CHANGE_USERS_LOGIN 'UPDATE_ONE','SYSDBA','SYSDBA' 

 

Had you assigned ANY server roles to the sysdba user?.. if so.. remove all of them. 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101
alt
".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
Employee
Employee
Posts: 23
Registered: ‎08-27-2009

Re: Database login failed:invalid object name systeminfo

Great! After removing the sysadmin role from sysdba. The error disappears like a charm.

 

Now i get a new error 'The provider on server ***** is no longer in use. Please change your connection to the correct provider', but the connection test successes when i edit the data connection.

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Database login failed:invalid object name systeminfo

Good.. the back-end is now just fine. Now you have to deal with the "front end" (client side).

 

When you finally got the connection manager (SalesLogix Server) correct you probably overwrote another connection to the physical db. The DataLink client side is attempting to communicate w/that (original) back end.

 

In the SalesLogix SYSTEMINFO table there is a field called the "PINGSERVER". It contains the name of the Windows (SalesLogix) server where the connection Manager is located that actually "owns" the connection to the SalesLogix physical database.

 

SalesLogix db connection 101:

   A - A physical (SalesLogix) database can only have ONE (1) has it's owner/master

   B - A SalesLogix Server (Connection Manager)  can manage/own many physical SalesLogix databases. They do not have to be on the same server as the database since they use the db's native OLEDB connection.

   C - The client DataLink connection to the SalesLogix database is actually made to a SalesLogix Server managing/owning that physical database.

   D - There can be many client DataLink connections to a SalesLogix Server.

 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101
alt
".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Database login failed:invalid object name systeminfo

Yep, I just say that last nite. Thanks!
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101
alt
".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Employee
Employee
Posts: 23
Registered: ‎08-27-2009

Re: Database login failed:invalid object name systeminfo

Amazing!

After adding the server name into the particular filed, i can log into the admin tools.

Thank you  ,RJLedger

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Database login failed:invalid object name systeminfo

You're welcome.
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101
alt
".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
New Member
Posts: 1
Registered: ‎11-05-2009

Re: Database login failed:invalid object name systeminfo

So - If I installed the saleslogix connection manager using the local account on one SQL server, I should still be able to create a connection to a database on another SQL Server ? 

 

Thanks

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Database login failed:invalid object name systeminfo

Possible - but why are you using a "local" account and not doing it the way recommended in the SalesLogix documentation?
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101
alt
".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Tuned Listener
Posts: 5
Registered: ‎08-17-2009

Re: Database login failed:invalid object name systeminfo

I upgraded a 7.2.2 database running on sql 2k on win server 2003 to 7.5.3 running on sql 2008 R2 win server 2003 dev server.  Luckily there's no sync server.  This has been working in dev for about 2 weeks.  Yesterday I installed 7.5.3 on the new production server from the same source files running win server 2003 and sql server 2008 R2.  I ran the sql script to update sysdba, verified the sysdba users has no server rolls, and now I am getting this error message on both the dev and production server.  I set the pingserver to the new server name, but that did not fix it?  What else can I look for?