Problem During Installation
While installaing the Archive service strictly as per the Installation guide, using Default instance name as SQLExpress, the following error message is noticed. Please let us know how to go about solving the problem.
The following is the instance observed in command prompt of the server, in installation step 6.
C:\Program Files\Microsoft Research\ConferenceXP\Archive Service>osql.exe -E-S .
\SQLExpress -i AddDatabase.sql
Failed to load resource file OSQL.rll. The system cannot find the file specified
.
C:\Program Files\Microsoft Research\ConferenceXP\Archive Service>osql.exe -E-S .
\SQLExpress -i AddSPs.sql
Failed to load resource file OSQL.rll. The system cannot find the file specified
.
C:\Program Files\Microsoft Research\ConferenceXP\Archive Service>The OSQL.rll file exists in the C:\Program Files\Microsoft Research\ConferenceXP\Archive Service directory.
Thanks
All Replies
- I believe that the setup for Archive Service assumes that MSSQL is installed as the DEFAULT instance - i.e. machine name, so it will not work without some manual steps after setup has completed - i.e. you have to run the SQL install scripts by hand (or install SQL to the default instance - probably the better option)
Sharmila,
Here is a more detailed explanation that I put together with Chris' help...
Our setup script which is called during installation expects to use the default instance name – . (dot) – which means the local machine name. If you have installed SQL Express 2005 (with Visual Studio 2005) or you want to install Archiver to a non-default instance, here is what needs to happen manually.
1. Install the SQL management tools. For SQL Express 2005, they are called “Microsoft SQL Server Management Studio Express” and they can be found at http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
2. Launch the SQL Management Studio and point it at your appropriate instance (SQLEXPRESS).
3. Choose File, Open and choose < ArchiverInstallPath >\AddDatabase.sql
a. When challenged, log into the instance in order to complete the following steps
b. Search and Replace “MSSQLServerLocation” (both instances) with the path to your SQL installation. We have 2 example installation paths in AddDatabase.sql, one for SQL 2000 and one for SQL 2005. SQL Express 2005 installs to the same location as the full SQL 2005. It is, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
c. Save the script
d. Execute the script (it should complete with one error, the initial drop of a non-existent database)
4. Choose File, Open and choose < ArchiverInstallPath >\AddSPs.sql
a. Log into the instance
b. Execute the script (it should complete without error)
5. In Windows Explorer, navigate to <ArchiverInstallPath>
6. Edit (using e.g. notepad) <ArchiverInstallPath>\ArchiveWindowsService.exe.config
a. Change “source=.” to “source=.\SQLEXPRESS” (or the appropriate name for your instance)
b. Save the file
7. Edit (using e.g. notepad) <ArchiverInstallPath>\ArchiveAdmin.exe.config
a. Change “source=.” to “source=.\SQLEXPRESS” (or the appropriate name for your instance).
b. Save the file
8. Stop the Archive service and restart it (Services can be found from Control Panel, Administrative Tools, Services)
