Using Sql Server

We will assume that you already have SQL Server installed and can connect to the database. The Sql Server installation must be case-insensitive (which is the default option when installing MS Sql Server).

Open SQL Server Query Analyzer and connect to your Sql Server machine. open the 'create.sql' file which can be found in the MSSql folder supplied with LBE Web Helpdesk. This sql script will create:

• The same tables as in the Access database (above).
• A stored procedure named sp_lbesendmail which is just a wrapper around xp_sendmail and means that you don't have to grant execute permission to xp_sendmail.
• Creates a database login called lbe_user with a password set to 'lbe'. If you wish to your Guest users to use NT Authentication:
  • create a local user account on the SQL Server machine that corresponds to the user details from the anonymous user defined in the Directory Security tab of the Web Server options (usually called IUSR_machinename).
  • Make the anonymous user a member of the SQL Server domain.
  • Map the IIS anonymous user account to a SQL Server Guest account.
• Grants SELECT, INSERT, DELETE, UPDATE on all the tables to the lbe_user login
• Grants EXECUTE on sp_lbesendmail to the lbe_user login.

If you wish to set up different logins/roles/grants please feel free to amend this script.

After running the create.sql, assuming there are no errors, open the 'data.sql' file (again, found in MSSql.zip), and run it. This will seed the tables with their initial values.

Home