Microsoft C360 manual Error, Appendix a Installing SQL

Page 54

established. This happens when you omit 5544 from http://localhost:5544/

5. Error 27502.

This error window will be encountered, when the SQL Database ImportManager needs, isn’t present!

This can happen if the login information provided during installation was for a user with insufficient permissions to the database. You need to reinstall ImportManager and be sure to provide a SQL login with administrative permissions to the database!

Alternatively you can run a SQL script, provided from CRM Extensions.

Appendix A - Installing SQL

SQL Express 2005 can be downloaded from Microsoft using the following link:

http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-

dcc397514b41&displaylang=en

Simply run the .exe file and follow the instructions.

Alternatively you can run the installer from a command console like this:

sqlexpr32.exe /qn addlocal=all instancename="SQLExpressIM2008" SECURITYMODE=SQL SAPWD=Password#1 SQLAUTOSTART=1

This will install a SQL Express instance named “SQLExpressIM2008”, which you can log into (see

step 6 in the detailed version for installing ImportManager 2008) using the login “sa” and the

password “Password#1”.

Image 54
Contents C360 Import Manager User Guide Table of Contents Features IntroductionInstallation and Setup Short Version Installer StartupRequirements Detailed VersionWelcome End-User License Agreement Destination FolderReady to Install Database ServerInstalling CompletedEdit web.config ConnectFile Download Security Warning IE Security WarningSelect Installation Folder Confirm Locate login information CompleteLogin Start ImportManagerStarting up/connecting FinishedCreate Server LicenseCreating a Server Choose Server TypeConnection Information Choose licensing methodCreating a User Add UserUser Details Save User Associating ServerUser Associated Log CheckSetting up the Data Source Upload File Simple ImportText Source Browse to the file New Data Source Data SourceText File Settings Setting up the Package New Package DoneOverview Page Setup Import Rule Import Rules Overview Matching Add Filter Add Conditions Page Field Mapping Page Run Import Page Done Setting up the Data Source New Data Source Odbc SourceData Source Selection Odbc Settings Select * from ContactsSetting up the Package Create Package Package OverviewSetup Import Rule Create Rule Rule Overview Matching Field Mappings Save & Run Finished FAQ and Common Errors Login failedRemote name could not be resolved ‘local Error Appendix a Installing SQL