Quote:
Originally Posted by Backmaan95
I've got a problem, when you install server (UAC is off) it says: Failed to load resource file OSQL.rll. Can't find the file or such... What have I done wrong? I followed every step in the windows 7 video. Ty in advance 
|
i found thisd.. hope it helps..
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)
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
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.co nfig
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)