Install nService Manually

SQL Server Preparation | Download from Avensoft | Download from MS Web Application Gallery

1.	Deploy nService4 Files Download nService4.zip (7M). Copy the nService4 folder in the zip file to the `\inetpub\wwwroot` folder on the server.
2.	Create Database and Tables (screen shots) Sign into SQL Server Management Studio using a SQL Server user account, create a new database named `nService4`. If you don't have SQL Server, download the free Express Edition. Load `Inetpub\wwwroot\nService4\App_Data\ns4ms.sql` into SQL Server Management Studio, select the `nService4` database next to the Execute button, run it to create tables.
3.	Configure Database Connection Open up \inetpub\wwwroot\nService4\web.config in Notepad, correct the server name in the connection string. The server name is in the form of server_name\instance_name. Suppose your sql server is local and the instance name is sqlexpress, you can keep the default name localhost\sqlexpress. Change `Integrated Security=True;` to `User ID=abc;Password=def`. Replace `abc`, `def` with the SQL user account you used to sign into SQL Server Management Studio.
4.	Create IIS Application (screen shots) Run Administrative Tools, Internet Information Service (IIS Manager), right click Application Pools and select New to create a new application pool called nService4AppPool. Go back to IIS Manager, right click `Default Web Site, nService4`, click Properties and then click the Create button to create an application. Set it to run in the nService4AppPool application pool. Go to the ASP.Net tab, select 4.0x in the version drop down list. If you don't see it, you need to download and install .Net 4.0, then relaunch IIS Manager to select it. Go back to IIS Manager, click Web Service Extensions, select ASP.Net 4.0xxx on the right pane and then click the Allow button to enable it if needed.
5.	Request a Trial License Without a license, nService allows one technician and unlimited end users. To request a trial license that allows multiple concurrent technicians, send an email to sales5@avensoft.com. To access nService, point your browser to http://localhost/nService4/. Sign in as `ns4.admin` with no password. If you are testing from another computer, change the localhost to the IP address or the fully qualified domain name of the server. Keep in mind that your nService web site is slow the first time you use it because IIS needs to compile its web pages.

Common Problems

Server not available. Create an application pool for nService4 according to step #2.

Page cannot be found. Go to IIS Manager, allow ASP.Net in Web Service Extensions.

Invalid object name 'ns4_registry'. Set the default database to nService4 when you set up the ODBC data source.

SQL Server Authentication

When a user access the nService4 website, IIS connects to your SQL Server through an ODBC data source. If your SQL Server is set up to use Windows integrated authentication, you need to set up database access for NETWORK SERVICE which is the Windows account IIS 6 uses to access your database. Step 3 and 4 do that. If your SQL Server is set up to use mix mode authentication, you can use a SQL Server user account to log on to your database by taking the following steps.

3b. Create a SQL Server login called ns4 using Enterprise Manager or SQL Server Management Studio and assign it datareader and datawriter role to the nService4 database.

4b. When updating the connection string, change it to use SQL Server authentication and enter the user name and password of the new database user.


									Server=localhost;Database=nService4;User
									ID=ns4;Pwd=ns4_password;

Moving nService

To move nService, copy the \wwwroot\nService4 folder from the current server to the new server. Convert it to a Web Application in IIS. Instead of creating a new database, detach the current nService4 database from the old server and attach it to the new server.