Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Thursday, September 24, 2020 
 
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 ThreadView:  Search:  
 Author  Thread: Will SLX6.2.1 work with SQL Server 2008 R2?
Marty
Posts: 5
 
Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 04 Nov 13 3:20 PM
fiogf49gjkf0d

I am in the process of moving over copies of some applications that reside on a SQL Server 2005 box. I am wanting to upgrade the db to 2008 R2 and wanted to know if the version of Sales Logix I'm using is supported by SQL Server 2008 R2.


All of the documentation that I have do not have any information about SQL Server 2008 since it's an older version.


 


Thanks,


 


MG

[Reply][Quote]
LeVar Berry
Posts: 47
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 05 Nov 13 4:14 AM

No offense , but a bigger question would be why only 6.2.1 ?   You should at least get the latest service pack of 6.2



With SQL Server 2008 you can make the database compatiable with 2005.   I've never done this but I don't see why it would not work.  In theory it could also work with 2012.

[Reply][Quote]
Marty
Posts: 5
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Nov 13 12:09 PM

Sorry, the version is 6.2.6.1007


 


I've tried to have it connect, but it's giving me errors:


Test Connect failed


Invalid object name 'plugin'

[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Nov 13 12:47 PM

The sysdba is disconnected. Fix this via the fixsysdba script.

[Reply][Quote]
Marty
Posts: 5
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Nov 13 5:58 PM

Thanks Mike. I have inherited this system without much concerning with the original CD that may contain that script. Do you happen to have that?


 


Thank you,


 


Marty

[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Nov 13 10:57 PM
I don't have it to hand - as I'm propping up the bar in Scottsdale right now at an SLX conference - will get and post later !
[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Nov 13 11:55 PM

This is the script you need (logged in as sa against the database)



sp_change_users_login 'Update_One', 'sysdba', 'sysdba'


You should execute:



select * from userinfo 


When logged into SQL Studio as sysdba. NB: Do not use the sysdba qualifier. The SQL should run as above and return rows. If it doesn't - then the database is not restored correctly.


 

[Reply][Quote]
Marty
Posts: 5
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Nov 13 11:29 AM

Thanks Mike. That worked like a charm.


 


Thanks for your help.


 


Marty

[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: Will SLX6.2.1 work with SQL Server 2008 R2?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Nov 13 11:44 AM

No probs!

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

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 9/24/2020 10:07:36 AM