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.
- 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
MS SQL Server 2005 SP2 Feature Pack Link – 9.00.3042
MS SQL Server 2005 SP1 Feature Pack Link – 9.00.1399
MS SQL Server 2008 Links
Microsoft SQL Server 2008 Feature Pack – 10.00.1600.60
Microsoft® SQL Server® 2008 R2 Feature Pack – 10.50.1600.1
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












