Views on Remotes

If you have a database view on your SalesLogix Remote clients, which you’re using for running Crystal reports off of, and which pulls data from the UserSecurity table, you may have encountered this:

“Crystal Report Runtime Error: This field name is not known.”

The way around that is to create the view using the T-SQL setuser function, in Management Studio, on each Remote database (you cannot run this SQL in WG Admin through the SLX Provider):

setuser N'sysdba'
GO

CREATE VIEW sysdba.USERREQV
AS
SELECT sysdba.USERINFO.USERID, sysdba.USERINFO.USERNAME,
sysdba.USERSECURITY.ENABLED, sysdba.USERSECURITY.TYPE
FROM sysdba.USERINFO INNER JOIN
sysdba.USERSECURITY
ON sysdba.USERINFO.USERID = sysdba.USERSECURITY.USERID

GO
setuser
GO

Without the setuser function, the code will execute, and the view will populate as if nothing was wrong; but you won’t be able to see the fields in your Crystal report, in design mode. (Same thing if you try running it in WG Admin, without that function.)

SLX Remote Users and MSXML 6.0 SP2

If you’re upgrading SalesLogix for Remote users, and doing that on SQL Server Express Edition 2005, and having to reinstall SSEE because they’ve lost the sa password (etc.), guess what?

Before you do that, if Microsoft MSXML 6.0 SP2 exists on the system (in Control Panel, Add/Remove Programs), you have to uninstall that, or the SSEE installation will fail, with an error message (displayed via a hyperlink to the setup log file, not via a dialog box) that DOES NOT give you much help in figuring out what actually went wrong.

And you can’t uninstall MSXML 6.0 SP2 from Control Panel (Add/Remove Programs), either. Instead, you have to download the Windows Installer CleanUp utility, and run that separately.