I'm trying to install the helpdesk for the first time - could anyone offer me any advice on previously unanswered posts by other users asking whether it is possible to use the helpdesk with SQL Server Management Studio Express, and if so does anyone have any documentation or could anyone tell me how to install it this way? I'm quite new to SQL, having only used iSQL in a module at college about 3 years ago!!
Thanks,
Laura
Just use "File---->Open" from the Studio Express main window (you'll want to have launched it by right-clicking the start menu shortcut and choosing "Run as Administrator") and browse to the ".sql" script included in the "db" directory of the installation package. That will load the script in Sudio Express. From there, you'll need to alter the paths for the database and log files (you can browse the directories on your server until you find where the server's keeping it's other database files). Then execute the script. That's the basics. The rest can be gleaned from the "readme" file included in the installation package. Pay close attention to what it says about altering one of the .asp files and the last section on databases.