Both my Saleslogix Server and SQL Server are on the same box, so presumably when I set up a connection I should be able to use the "Shared Memory" protocal for speed? So, I set the "Network Library" value in the connection manager to "dbmslpcn", and a clicking the test button in the connection manager works a treat.
However, from the client end, it will not connect. I get a "Cannot initialise data dictionary" error when I test the connection at the client end. If I ignore the error and attempt to login using the connection anyway, I get the error "Cannot open database 'Saleslogix' requested by the login. Login failed."
Has anyone else successfully connected using the SQL Server "Shared Memory" protocol?
I'm using SLX 7.22.1871, on SQL Server 2005 (latest SP), and I've ensure the protocal is enabled in the SQL configuration.