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 - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

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

View: Search:

Author

Thread: HELP PLEASE:- SLX 7.2 with SQL 2008 Express

Gareth Hall
Posts: 8

HELP PLEASE:- SLX 7.2 with SQL 2008 Express Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 09 6:25 AM

Hi All,

I am having issues with SLX 7.2 and SQL 2008. The new software within our company uses SQL 2008 s my users are starting to use this more and more often. The problem I have is that 7.2 isn't deemed compatible with SQL 2008 (not tested).

So when I attach a DB to a machine running SQL 2008 I get errors. Is there any way of getting around this either by a known fix or somehow manually setting up the connection?

I appreciate any help on this one.

Gareth Hall

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: HELP PLEASE:- SLX 7.2 with SQL 2008 Express Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jun 09 3:32 AM

Basically, you need to make sure that the sysdba user exists, and that its password matches whatever you use on Connection Manager.
Then, after the DB is attached, you need to make sure that the sysdba from the attached DB is linked to the sysdba user on the SQL instance.
You should be able to script it, and then save and reuse.

I may be missing a step in here, but basically:
- Create a sysdba login (SQL login).
- set its password and remove the password policy settings
- Attach the database (you need to do an Attach Single File DB call)
- Fix the sysdba user on the DB (sp_change_Users_login with UPDATE_ONE parameter)

I think that would cover it, but you may want to document all steps you take to make it work.

[Reply][Quote]

Derek
Posts: 115

Re: HELP PLEASE:- SLX 7.2 with SQL 2008 Express Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Sep 10 7:01 AM

Hi Gareth,

A question to ask is what errors are you getting when you attach the database and is this for a remote a client? If you are trying to attach a database to Saleslogix remote user make sure of the following:
(a) you have installed SQL 2008 express on the remote client machine. Also when you installed SQL 2008 express use Saleslogix for the instance name and have set the sa password in the SQL. Also in SQL 2008 setup sysdba as user and carry out what Raul has suggested (run the sysdba SQL script fix) normally found on the Saleslogix install cd.
(b) Installed SQL 2008 Native Client
(c) Installed SQL 2008 B.C. on the remote client machine
(d) Make sure that the connections in the Saleslogix Connection Manager are setup and work.
(e) test to attach the database.

[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 10:45:14 AM