If the SQL Server instance is not on the same server as ServiceDesk, you must install additional SQL Server components on the ServiceDesk server. These components are part of a feature pack for Microsoft SQL Server.
This task is a step in a process.
To install SQL Server support components on the ServiceDesk server
Log on to the ServiceDesk server with the ServiceDesk installation account.
Depending on your SQL Server version, download the correct feature pack from the following locations:
SQL Server 2005 SP4 Feature pack
SQL Server 2008 SP2 Feature pack
SQL Server 2008 SP3 Feature pack
SQL Server 2008 R2 SP1 Feature pack
SQL Server 2008 R2 SP2 Feature pack
SQL Server 2012 Feature pack
Install the following components from the feature pack:
Microsoft SQL Server Native Client
Microsoft SQL Server Management Objects (SMO)
Microsoft SQL Server Analysis Management Objects (AMO)
Depending on your version of SQL Server, Microsoft may require you to install additional feature pack components. For example, you may be required to install SQL Server CLR Types feature pack components before installing Microsoft SQL Server Management Objects (SMO).