Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Thursday, April 25, 2024 
 
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 - Upgrades
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Upgrades | New ThreadView:  Search:  
 Author  Thread: Cannot login with Admin Workstation 7.5 to 7.0 slx db...
doug evans
Posts: 2
 
Cannot login with Admin Workstation 7.5 to 7.0 slx db...Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 23 Jul 10 9:39 PM
1. SQL Server 2008, Windows 2008, SLX Server 7.5 all on same server.

I would like to use the 7.5 admin ws to install the 'upgrade 7 to 7.2' and 'upgrade 7.2 to 7.5' bundles so i can convert our 7.0 db to 7.5. I am able to setup a 7.5 connection manager connection successfully (using native) to the 7.0 db but in the 7.5 admin ws using the datalink connection to 7.0 db, i get an error 'test connection failed' when clicking the 'test connection'. I am using the 'admin' user with default pwd of 'password' (which works with 7.5 default and eval db's).
This v7.0 slx db works on a 7.0 server i have setup on a virtual machine environment. I detached the mdf file from the 7.0 server, copied the mdf to the 7.5 server and attached. I also ran "sp_change_users_login 'update_one', 'sysdba', 'sysdba'" on the v7.0 db.

Any insight how to get my 7.5 admin ws working with my 7.0 db so i can run the install upgrade bundles would be greatly appreciated. Any other methods to get my 7.0 db upgraded to 7.5?

Thanks in advance!
[Reply][Quote]
Derek
Posts: 115
 
Re: Cannot login with Admin Workstation 7.5 to 7.0 slx db...Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Oct 11 8:02 AM
fiogf49gjkf0d

Hi Doug,


have you come right with this yet? If not does your Saleslogix system have any customizations?

[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: Cannot login with Admin Workstation 7.5 to 7.0 slx db...Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Oct 11 11:18 AM
fiogf49gjkf0d

SalesLogix Customizations typically wouldn't cause this problems.


Things to check:


a) Verify that the Connection defined within "Connection Manager" did Save the PAssword (Editing and clicking on the Test button, if the password is saved, it would work with no problem).


b) Verify that the Admin WorkStation has the Correct SQL Client Installed. For Example, if you are using SQL 2008, but your workstation doesn't have SQL Native Client 10.x it won't run.


c) Make sure that Name Resolution is in Place. If you define the Connection with "SERVERNAME" then the workstation should be able to resolve "SERVERNAME"


d) Using SQL Configuration MAnager (on the client), restrict the Protocols to TCP/IP


e) Use netstat to check what Connections are being established. You should be able to see the Connection to Server:1706 for SLX, and one for SQLServer:1433 (unless using a diff port) for SQL Server.


 


When using different Versions of SLX, you ussually don't get "Connection" errors. You may get an error telling you that the DB is not of the Correct Version and/or that it will be Updated (depending on the Circumstances)....

[Reply][Quote]
Derek
Posts: 115
 
Re: Cannot login with Admin Workstation 7.5 to 7.0 slx db...Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Oct 11 1:41 AM
fiogf49gjkf0d

Hi Raul, I was trying to find out if there were customizations to back them up first and then carry out the following:


 

[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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 4/25/2024 9:16:04 AM