Simplesoft Solutions Blog

Database migration MS SQL Server 2000 to 2005 post changes

December 20th, 2011 by Paul

I have been thinking about the changes that occur with the differences between MS SQL Server 2000 and MS SQL Server 2005.  Here are some specific steps that should be taken to ensure that you proactively avoid problems with your SalesLogix database.  One big item is to adjust the compatibility level.

These steps are very specific to make sure that the process is completed in the best possible manner. I would confirm them with your DBA to determine if he suggests anything additional. There is no ‘undo’ button on the setting changes and it is per database on a SQL server instance setting.

===========================================

Standard Disclaimers

1.      Kick off the users.

2.      Perform off hours.

3.      Back up your database.

===========================================

Steps

1.      Change the compatibility level (2000 to 2005 etc.)

2.      Run the following scripts in Query Analyzer on the appropriate SalesLogix database

a.      Run the statement and review the results

b.      If there are messages in the first statement (step 3), run query statement (step 4)

DBCC CHECKDB with all_errormsgs

– This statement may take a while to run, on average 7 to 10 minutes

DBCC UPDATEUSAGE (databasename)

– Will update the database for the differences in the pages and row counts, etc. Replace (databasename) with the actual database name

EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’)”

– This is a standard MS SQL Server 2005 reindex statement

EXEC sp_updatestats

– This is a stored procedure for updating the stats

DBCC CHECKDB with all_errormsgs

– Check the database at the end to make sure everything looks fine

3.      Make sure the normal database maintenance tasks and jobs are fully operational

Here is also a helpful reference link: http://msdn.microsoft.com/en-us/library/ms176064.aspx. Let me know if you need additional assistance. We are more than willing to assist, but wanted you to have the information at your disposal.

“Any fool can make things bigger, more complex, and more violent. It takes a touch of genius-and a lot of courage-to move in the opposite direction.”

Albert Einstein

If you would like to learn more tips, or if you have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

How to Add a License to Sage SalesLogix

September 29th, 2011 by Paul
  1. Open Start | Programs | Sage SalesLogix | Administrator.
  2. Log into application as the Admin user.
  3. Select Systems from the navigation bar.
  4. Select the Licenses Tab
  5. Right- click and add the license number

If you would like to learn more tips, or have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

How to reset IIS website for SalesLogix

September 19th, 2011 by Paul

How to reset IIS with the IIS Reset command

You might need to restart Internet Information Services (IIS) before certain configuration changes take effect or when applications become unavailable. Restarting IIS is the same as first stopping IIS, and then starting it again.

1. From the Start menu, click Run.

2. In the Open box, type cmd, and click OK.

3. At the command prompt, type iisreset /stop. IIS will attempt to stop all services and will return confirmation once all services have been stopped.

4. At the command prompt, type iisreset /start.

If you would like to learn more tips, or have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

How to Complete a Manual SalesLogix Database Backup

July 5th, 2011 by Paul

Steps to Backing Up SalesLogix DatabaseIn preparation for upgrade testing, backing up your database  is a very important step. Here are the steps to manually back up your SalesLogix MS SQL Server 2005 database to disk (SQL Server Management Studio):

1.  Start | All Programs | MS SQl Server 2005 | SQL Server Management Studio

2. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine in Object Explorer, click the server name to expand the server tree

3. Expand databases and highlight the appropriate SalesLogix database

4. Right-click the database, point to Tasks, and click Back Up. The ‘Back Up Database – SalesLogix’ dialog box appears

5. In the Database list box, verify the database name

6. You can perform a database backup for any recovery model, but in our case select or confirm FULL in the list box

7. In the Backup type list box, select Full

8. For Backup component, click Database

9. Either accept the default backup set name suggested in the Name text box, or enter a different name for the backup set

10. Optionally, in the Description text box, enter a description of the backup set

11. Ignore the information about when the backup set will expire, unless it is needed for some reason. Note: To have the backup set expire on a specific date, click On and enter the date on which the set will expire

12. Choose the type of backup destination by clicking Disk

13.  To remove a backup destination, select it and click Remove

14. To view or select the advanced options, click Options in the Select a Page pane

15. Select an Overwrite Media option, by clicking one of the following:

16.  Select Add to provide a destination for saving the database backup location

17.  In the Select Backup Destination screen, select the square icon with four dots at the end

18.  MSQL will open the Locate Data Files Dialog screen to the default location for backups. Make sure you choose a location that is local to the server and has adequate space

19.  In the File Name text box enter the name of the database backup, like SalesLogixBackup20110426.bak

20.  Select OK

21.  Select OK

22.  In the upper left hand side, select the Options page

23.   Confirm Overwrite is selected

24.  In the Reliability section, optionally check: Verify backup when finished. Perform checksum before writing to media and continue on checksum error

25. Select the General page again

26.  Select OK

27.  The database will back up and go through a verify phase. After it is completed, you will see a dialog, Microsoft SQL Server Management Studio, with the message, ‘The backup of database ’saleslogix’ completed successfully.’

28. Select OK

You have successfully completed a manual backup of your SalesLogix database!

If you would like to learn more tips, or have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Tips on Creating a Faster SalesLogix Environment

May 24th, 2011 by Paul
The purpose of this article is to give you some helpful tips to improve the environment that SalesLogix runs in while at the same time piquing your interest on this topic. On Tuesday, June 14th the Heartland SalesLogix Users Group Event – Grilling Burgers and Blazing SalesLogix will address this topic in much more detail. A BBQ lunch begins at 12:00 p.m. and the topic will begin at 1:00 p.m. EST. We will have Sage and Simplesoft consultants providing not just the What you need to do (as in the article)  but How to do it. Discover how you can improve SalesLogix speed with navigation and group lookups in this article and at the meeting by fine tuning the database and Web server.  I have also included  tips to enhance your SalesLogix configurations and  performance.   
 
 
Listed below are some suggestions for optimizing the Windows environment for speeding up SalesLogix.  The recommendations are in order of greatest impact to speed up the server, to lesser impact, including items that will take a lot of time.  My suggestion is to make each change one a time and measure between changes to determine which item makes the biggest impact. Some of these improvements might need to be long-term projects because they are not short-term fixes and take time to properly implement.  The key is to have a baseline test and measure against the test consistently. The Windows environment and SalesLogix configuration adjustments can have a huge impact with the operational results.  Always keep the client speed in mind to give them the best experience.

1.  Maximize RAM (huge impact and an easy change to make with today’s virtual machines and affordable hardware)

- The more memory, the better (especially with 64 bit environments).

- Don’t rely on RAM alone for optimization, because it may be covering up areas that would be considered a bottleneck.

2. Maximize the database settings (huge impact, see enclosed scripts)

- Back up the database and run base SalesLogix database optimization scripts (30 minutes).
– Back up database before
– See v7.5 DVD media in the database folder  for the sql file and run in query analyzer
– back up database afterwards
- Review primary keys, indexing and clustering v. stock database (takes longer to review and implement).
- Check database maintenance jobs (backups, indexing, truncate logs, etc.).
- Run SLXProfiler to review slow queries and diagnose further and optimize (takes longer to review and implement).

3.  Browser version and optimizations (high impact)

- Recommend using FireFox 3.x or above v. Internet Explorer 7 or above
- Optimize browser settings

4. Maximize Windows network settings

- Review and adjust services and network settings
– Turn off what can be turned off
- Maximize data throughout
- Defrag hard drives

5. Optimize IIS  configurations

- Turn on compression (this is the equivalent of zipping large files before sending them)
- Adjust other IIS settings (turn off logs, separate the application pools, etc.)

6.  Work on SalesLogix configurations for optimizations (these items can take a while to implement)

- Reduce unneeded, unrelease and/or bundle and remove older groups (high impact)
- Reduce unneeded, unrelease and/or bundle and remove older plugins (reports, etc.)
- Reduce data/duplicates/archive, etc.
- Optimize customizations (using SLXProfiler, etc.)

7. Adjust firewall network throughput settings

The trick to performance tuning is to make your changes one at a time then monitor the results. Just remember one registry setting, such as disabling, caching can have a tremendous impact on your server. Once you are happy with the results move the configurations and settings from your SalesLogix TEST environment to your PRODUCTION server. Continue to use performance tuning regularly over time because when your database grows and more users are using the Web site things might need to be reviewed again.

Life is like a ten speed bicycle. Most of us have gears we never use.
Charles M. Schulz

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Using MS SQL for SalesLogix? A Collection of Helpful Links to Feature Pack Articles

March 29th, 2011 by Paul

SalesLogix MS SQL Articles I had this bright idea…. I could bring it all together in one blog.  See my attempt below at gathering links to several helpful articles for MS SQL deployment  to assist our  SalesLogix customers.  When deploying multiple servers,  with an on premise deployment of SalesLogix,  there is the need to ensure that the MS SQL Native Client is installed on the servers that are not the database server itself.  Here are the links to download the appropriate and corresponding SQL Native client and the related tools of the feature pack.

  1. First you need to identify the version of MS SQL Server that you are currently using.  Here is a helpful article by Microsoft to help.

How to identify your SQL Server version and edition

http://support.microsoft.com/kb/321185

2.  Find the webpage with the corresponding Microsoft SQL Server Feature Pack link

MS SQL Server 2005 Links

MS SQL Server 2005 SP3 Feature Pack Link – 9.00.4035

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en

MS SQL Server 2005 SP2 Feature Pack Link – 9.00.3042

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en

MS SQL Server 2005 SP1 Feature Pack Link – 9.00.1399

http://www.microsoft.com/downloads/en/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

MS SQL Server 2008 Links

Microsoft SQL Server 2008 Feature Pack – 10.00.1600.60

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

Microsoft® SQL Server® 2008 R2 Feature Pack – 10.50.1600.1

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52

3.  Once the right page is found, you will need to scroll down the page to find the Microsoft SQL Server 2008 Native Client files.

Download the appropriate installation files for the bit edition of the client workstations (32 bit vs. 64 bit etc.)  The download file will be named (sqlncli.msi) for 32 bit or (sqlncli_x64.msi) for 64 bit edition.

4. Lastly, copy the file(s) to a shared installation point on the network.  A good tip is to place them in a well named folder and copy the link of the download URL as well.

I tend to create folder like ‘MS SQL SQL native client – 64 bit for MS SQL 2008 SP1′ so that when I come back to the folder later I will know what the folder means.

5. If you find that your version of MS SQL Server is not patched up, then you can take the time to plan to patch to the latest server pack that is on the compatibility list.  When you do that, make sure that you review your backup plans and patch the client computer and other server computers that have client connectivity back to the server.

How to obtain the latest service pack for SQL Server 2008

http://support.microsoft.com/kb/968382

This little article will help you find the links that you need to keep your installations updated and SalesLogix running smoothly.

Upon the subject of education, not presuming to dictate any plan or system respecting it, I can only say that I view it as the most important subject which we as a people may be engaged in. That everyone may receive at least a moderate education appears to be an objective of vital importance.

Abraham Lincoln (1809 – 1865)

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Something different with my SalesLogix database

February 8th, 2011 by Paul

Every once in a while I will get a question like, “I am receiving this error message when I log in to such and such database.” I will search the knowledgebase and there is not a matching error message.  I will try to determine if the issue is a missing view, table, field, index, etc.  I will help the customer if something is missing or different because something has been altered on the backend. (We can bundle up what is missing or export a view, etc., and provide it to the customer, and voila, the issue goes away.) The next question I get is, “I am still worried that there might be something else missing. What else can we do to check further? And why did it happen?”  I can only conjecture as to why objects are missing or are altered. (Maybe a missing bundle or a script failed to run during the upgrade or a prior upgrade – who knows?)

spot the difference

Here are a couple of simple procedures to check out the situation and spot the issue:

Use the SLXProfiler

First, use the SLXProfiler.exe to watch the SQL traffic between the client and the server and pay attention to anything on the errors tab for certain. There is a SalesLogix knowledgebase article for the proper usage.

Set up a base database

Secondly, use a tool to perform a complete database schema comparison. You would need to set up a blank SalesLogix database from your current stock SalesLogix version. You can get the blank database script off of the DVD media from Sage SalesLogix. Let’s assume that you have SalesLogix v7.5 SP3 and it is on premise.  Attach the blank database v7.5 in your test environment with a different name from your production database.  Add your appropriate test licenses and patch it up to the current SP3 bundles. Now you have a stock v7.5 SP3 baseline for a comparison.

Check the schema for differences

Next, use a tool for a database schema comparison. We have used tools such as RedGate SQL Compare  (http://www.red-gate.com/products/sql-development/sql-compare/) to compare a production SalesLogix database and a stock blank database of the same version (with all the stock bundles) side-by-side to understand what is different or missing. This reference tool is designed for MS SQL Server, and there is a similar tool for Oracle databases (http://www.red-gate.com/products/oracle-development/schema-compare-for-oracle/).

Note: We have no financial relationship with this company. There are other tools that will perform similar database system checks. We do like this tool.

We have used this valuable tool to find missing fields, views, indexes, etc., in the past. It will not check for data differences within the database. If something is missing, such as data in a stock table, there are other tools for that check. If you find something is missing or is different than expected, then you can perform the research to find the starting point to resolve the issue. You can confirm the schema before you upgraded or installed from a backup database, etc.

A side bonus for using Redgate is that this type of schema check provides visibility to items that have been customized on your system as well.

We have used these procedures to help customers fix database indexes, find missing views, and trace missing fields from tables.

Any tool is a weapon if you hold it right.
Ani DiFranco

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Dear Paul, should we give SalesLogix users the ability to delete?

January 17th, 2011 by Paul

An Administrator writes:

Dear Paul,

Are there any issues with giving a SalesLogix user the ability to delete ‘Contacts’  in the LAN client?

Answer:

There are two philosophies on how to do this.  The first is to create a policy and to keep the permissions as an Administration function or secondly to just provide the user with the capability.  There are pros and cons to both.

What I mean by policy is to add an item to the contact/account status pick list with a value of ‘Delete’.  Next, have the user provide a note explaining the reason on why it needs to be deleted or archived to team that only the admin user can access.  Then the Administrator can review a group based on the status field of delete on a periodic basis and take appropriate action.  Creates work on your part, but pretty easy.

If you provide the user the ability to delete contact, account, etc. (Administrator | user profile | Security tab and feature security tab to adjust the delete item menu access) then you will not have to monitor the group or take action.  But if the user deletes an account or contact by accident that is very important then you will need to restore a copy of the database with a new name.  Then use a tool called ‘Group Copy’ to bring the data back into the production database.  This takes time also and is a reactive way to manage your system.

I tend to prefer the first option of creating an admin policy.  It creates more maintenance work for me but is proactive data management.  It prevents headaches from data loss and working in emergency mode (reactive).

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Tips on Managing users in SalesLogix

November 22nd, 2010 by Paul

“Truth is simple, life is complex” – Anonymous

In the real world, changes happen, and you need to be ready for the “normal” changes that can be ascribed to the life cycle of a system. I recently performed an upgrade that had a set of user management change requests that needed attention. The changes involved the usual requests of adding a new user or two, retiring a few users, and realigning some data. I wanted to review some typical tasks and provide some tactical advice to help others who might be needing answers in similar situations.

User Management in SalesLogix

1. How to change a user type

Users never change roles, right? Not in the real world; people move to new departments and are promoted and/or transferred. Let’s assume a change in user’s role and walk through a couple of situations. The basics of the changes are the same for both [ remote user to network user] and [remote user to web user].

In Sage SalesLogix, it is an easy procedure to change user types. (Note: Let’s assume the remote user is all synchronized and doesn’t have any TEF files to send to the server.)

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

Select the Users button in the Navigation icon.

Note: Now you have two choices in how to perform the user type change.

A. You can highlight the user that needs the change in the list, right-click the user and select Change Type.

B. You can double-click the user and on the first tab use the drop-drop on the Change Type field.

Your user has now been changed from one type to another.  It only takes a few clicks, so be careful.  The happy result,  the change is made and away you go!

2.  How to retire a user

Note: When a user leaves your company, the best option is to convert them to a retired user. Retired users do not use a license and cannot log on, but their name is preserved in the database. This prevents history records from displaying “Unknown User” because the user was deleted. Use the following checklist when a user needs retired.  When a user is retired it frees up a SalesLogix license and their system history is preserved.  We don’t recommend the delete feature except in rare circumstances.

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

In the Users view, double-click the user to open the User Profile dialog box

- If the user is active deactivate the user (see below).

- If the user is a remote, then make sure the Sync settings are unchecked, site code is recorded and the synchronization files are cleaned up and managed properly. (If you are a customer, you can ask for the ‘SalesLogix Cleaning Up Remote User TEF files.doc’ document.

Note: It might be necessary to manually remove TEF files from the Outfiles and Archives folders under the Host logging path. This should only be done if a Remote user leaves the company or is out of the office for an extended period of time (after which a new database needs to be created). To delete the TEF files in the Outfiles and Archives folders, sort by File Type (the file extension is the site code) and remove any files that have types that match the current active user’s site code that will be retired.

- If the Manager box is selected, clear it. (You cannot retire a user if he or she is a manager.)

- If the user has other users reporting to them, the other users will need to report to another user (at minimum the Admin user).

- In the Name box, type _RET or something similar in front of the user’s name. This step is not essential; however, it makes it easier to identify the person as a retired user in other areas of SalesLogix.

In the User Type list, select Retired User to change the user’s settings.

Press the F5 (Refresh) icon to refresh SalesLogix Administrator to ensure all changes have been made.

3.  How to reinstate a user

Note: Make sure a license is available for the reinstated user. You might need to set up the synchronization settings for the user as well.

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

In the Users view, double-click the user to open the User Profile dialog box

Note: You might need to select the Retired Users tab.

Change the user type from retired to the appropriate user type

On the General Tab, clear the Login Active check box

Click OK

Note: It is not a bad idea to have the user’s password reset.

4.  How to deactivate a user

Note: When a user is deactivated they can not log in to SalesLogix, but they are still taking up a license. Users can be deactivated for many reasons, such as maternity leave, military leave or extended sickness.

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

In the Users view, double-click the user to open the User Profile dialog box

You can highlight the user that needs the change and right-click the user

On the General Tab, clear the Login Active check box

Click OK

-If the user is a remote, it’s a good idea to clear the ‘Synchronize Changes’ and ‘Sequence Files’ check boxes on the remote tabs. This ensures that files will not write out for synchronization and sit on the server without reason.

To keep the Sage SalesLogix system running smoothly, you should perform certain administrative tasks on a regular basis. This is especially true when it comes to managing users. There are other data and user management tasks that might need to be performed along with user management like realigning data and activities. This will be a future blog entry. I hope these tips have been helpful in some way to help perform some common tasks in SalesLogix.

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Simplesoft Solutions Bottom
Register | Log in