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!
|
|
Slight Problem with Slx 7.0.1 + SQL Server 2005 + Citrix
Posted: 07 Jun 07 4:12 PM
|
For one of our clients, I installed Slx 7.0.1 (an upgrade from 6.2.4) on SQL Server 2005 on one physical server. This client uses Citrix on 2 physical Citrix Servers with load balcancing. I downed each Citrix Server, installed the Slx Client (7.0.1 with SP1), ran \\..\\SlxSystem.EXE \Install (to install as a service). The problem is that SlxSystem seems to drop out on the Citrix boxes after a short time. The only thing I can think of is that I used the normal MS OLE DB Provider rather than the SQL Native Client for the access method. I've never had a problem with the OLE DB Provider on SQL2005 before (no matter what the literature said). But maybe I should rethink this one. And so finally a question: Should I change it to use the Native Client?
 |
|
|
|
Re: Slight Problem with Slx 7.0.1 + SQL Server 2005 + Citrix
Posted: 07 Jun 07 7:23 PM
|
My understanding is the the MS OLEDB Provider is, in reality, the SQL2000 client components, and that the SQL Native Client contains and updated OLEDB components intended for use with SQL2005. In addition, I have heard rumors of intermittant problems when using this configuration with Slx 7.x. Note: If you switch to the Native Client the Citrix boxes, it is my understanding, that you will need to use teh Native Client components on every system.
Since the native client configuration is the only configuration that SalesLogix recommends why don't you test it and see if it solves your issue? |
|
|
|
Re: Slight Problem with Slx 7.0.1 + SQL Server 2005 + Citrix
Posted: 08 Jun 07 3:27 AM
|
Robert - check you are actually running as a service - check the Services list - as it should actually be /Install (not the \) - and you *must* do this when no slxsystem.exe is already running (kill it if necessary).
Using the Native Client is fine - we've been using it for ages in TS. And, as it is TS/Citrix - it only needs installing once - unless you happen to have any full clients installed as well - in which case you need to install the native client for connectivity purposes (sqlncli.msi) - make sure both are SP2. |
|
|
| |
|
Re: Slight Problem with Slx 7.0.1 + SQL Server 2005 + Citrix
Posted: 08 Jun 07 8:32 AM
|
Also, I've thought of one more thing. I saw the same issue with TS and resolved this doing this:
Stop all clients
reboot
c:\pf\saleslogix\slxsystem.exe /Uninstall
reboot
c:\pf\saleslogix\slxsystem.exe /Install
reboot
This seems to clear some things and installs the service correctly. The reboots are very important.
Mike
|
|
|
|
Re: Slight Problem with Slx 7.0.1 + SQL Server 2005 + Citrix
Posted: 08 Jun 07 12:59 PM
|
| Also check the registry key that tells it how log to run before unloading (can't remember the name) - I had the situation where it was installed OK as a service, but that value in the registry was 3, this caused the service to stop after 3 minutes. |
|
|
| |
|
Re: Slight Problem with Slx 7.0.1 + SQL Server 2005 + Citrix
Posted: 08 Jun 07 4:17 PM
|
Thank you all,
Mike really gave me (actual us: me & our network guy) the key. I had not uninstalled before I upgraded and also did not re-boot like I should have. We did a complete uninstall including Citrix. And before doing our re-installs, guess what. Stuart was absolutely correct. The registry settings were still there!
And Yes,..Stuart hid the nail on the head. When the SlxSystem service would start, it would also go down just about 3 minutes later. You called that one!
Anyway, we wiped out those settings, re-installed everything (re-booting too), and guess what. The setting for: HKEY_LOCAL_MACHINE\SOFTWARE\SalesLogix\ShutdownDelay was again set at 3. This time, we re-set it to 0. And now everything seems to be running correctly. (I hope...!).
Thank you all very much!
 |
|
|
| |
| |
|