03-08-2010 02:07 PM - edited 03-08-2010 02:08 PM
I'm not sure where to even begin. Initially, our users were able to log into their databases without any problems. Then one by one, some of them have had problems logging into their database/saleslogix. At the login prompt, they would get this Database Login Failed: Catastrophic failure. Some just required a reboot of their computer and then were able to login again. Some others not so lucky, they're locked out from getting in Saleslogix (version 7.5).
I tried doing the Test Connection but that failed as well. The users arent network users.
Any help is appreciated. Thank you
03-10-2010 08:27 AM
This is not what gets loaded on the SQL Server.. but rather what is on the client workstations.
All PC's (servers, laptops, desktops) that are to run a SalesLogix app (ex: Client, Admin, Architect, etc) must have the appropriate SQL Native Client installed on them - manually. It's just not there. When MS released SQL2005 (and2008) they released a new "driver" and it's not part of the OS, MDAC, etc as it was w/SQL2000.
You have to do this to each and every system yourself. It's in the SalesLogix (upgrade/install) documentation as well.
The error you describe fits the "missing SQL Native Client" issue to a "T".
03-10-2010 02:14 PM
RJLedger, about 3% of users are encountering this catastrphoic failure error message, the rest have not reported the same issue. I may have been misinformed, could you elaborate more on what you said in the previous post? Thanks
I noticed under Computer Management > Services and Applications > SQL Server Configuration, under there is SQL Server 2005 Services, SQL Server 20005 Network Config, and SQL Native Client Services. Not sure if that helps.
03-10-2010 02:44 PM
Are we talking about remote LAN version users? If so, make sure the local instance of SQL Server is running. Make sure the clients are running the same version and SP level as the Saleslogix server. If the remotes are running MSDE 2000, this is not supported in SLX 7.5, and should be upgraded to SQL 2005 or 2008 Express.
If the remote users have SQL 2005 Express and production database server is SQL 2008, you have to cut the database on a SQL 2005 Express instance.
03-12-2010 04:39 AM
One of our customers had today the same issue. Over 50 Users are working but some user receive
the following error message when login: "Database login fail: Catastrophic failure" - Login Error
Our customer is using the SLX LAN Client over Citrix 7.5.1. I hope it is not something completly new...
Have you tried to restart the following services?
Service SalesLogix Server
Service SalesLogix System Service
Is there something in the eventlog?
Hope this will help
03-12-2010 09:04 AM
I have tried restarted the local Salelogix server and the SQLserver. Also tried detaching and reattaching the database.
There's nothing unusual in the eventlog.