slxdeveloper.com Community Forums

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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: SQL Server 2005 and remote databases

Lloy Sanders
Posts: 69

SQL Server 2005 and remote databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Mar 07 9:44 AM

I have recently installed a test environment to upgrade a database to 7.0.1. Since the planning guide suggests that SQL Server 2005 is supported, I decided to implement that upgrade as well. Everything works as planned (with a few minor modifications needed to deal with toolbars) except that I cannot create a remote user database. I cannot find any documentation on this, but does anyone know if I need to change anything to get this to work? The error message I get is:
Database creationfailed : The specified module could not be found

[Reply][Quote]

Sandeep Gaykhe
Posts: 9

Re: SQL Server 2005 and remote databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Mar 07 1:33 AM

With 7.0 also I don't think SQL 2005 is still fully supported. You would have to install SLX admin along with MSDE and then can use SQL native drivers to cut the remote databases. You can find the procedure on support site or saleslogix newsgroups.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: SQL Server 2005 and remote databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Mar 07 4:38 AM

This is correct - SQL2005 is only supported in a host database environment. If you have remotes - you need to install MSDE on a sep. machine and cut them from there.

[Reply][Quote]

Lloy Sanders
Posts: 69

Re: SQL Server 2005 and remote databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Mar 07 8:19 AM

Got the instructions from SalesLogix Support. BTW, one thing to keep in mind, especially in a test environment is that you cannot install the SLX Server on the same machine as the SQL Server. (At least according to SLX Support).

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: SQL Server 2005 and remote databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Mar 07 7:25 AM

Quote:

Originally posted by Lloy Sanders

Got the instructions from SalesLogix Support. BTW, one thing to keep in mind, especially in a test environment is that you cannot install the SLX Server on the same machine as the SQL Server. (At least according to SLX Support).

??
There's no "rule" about that... In fact we encourage our clients to install the SalesLogix Server ON their SQL Server systems.
--
rjl

[Reply][Quote]

Lloy Sanders
Posts: 69

Re: SQL Server 2005 and remote databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Mar 07 8:11 AM

Well, you know SalesLogix tech support.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: SQL Server 2005 and remote databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 07 7:35 AM

You want the SLX Server as close to the SQL db as possible. If it's on the SQL server than you get memory-to-memory transfers and NOT over the net transfers.. Remember, all of your users' data travels THRU the provider..BOTH ways..

Put it ON the SQL server.
--
rjl

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/8/2025 3:28:57 PM