Reference solution for WebService deployment

1. problems encountered when the WebService cannot be connected to the configuration database for deployment:
The following is copied from Microsoft msdn:

Symptom

Cause

Solution

Method 1: Verify that the SQL database is running

Method 2: Verify that IIS is not run in IIS 5.0 Isolation Mode

Method 3: Make sure that the account used by the application pool has the required permissions for the SQL Server database.

Make sure that you have the correct name resolution method between the network connection and the server 4:

Symptom

When you try to view your Microsoft Windows SharePoint Services 2.0 web site, you receive the following error message:

Unable to connect to the configuration database. Cause

This occurs if one of the following conditions is true:

•	The SQL database is not running.
•	Internet Information Service (IIS) is configured to run in IIS 5.0 Isolation Mode.
•	ApplicationsProgramThe pool account does not have permission to access the sqlserver database.
•	The network connection has been lost between the windowssharepointservices server and the microsoftsqlserver server.

 

Solution

To solve this problem, use one of the following methods.

Method 1: Verify that the SQL database is running

1.	Point to programs, point to management tools, and start services in turn.
2.	Service. Find the MSSQLServer service in the list. This service may also be listed as MSSQL $ Sharepoint.
3.	Note the value of the Status column. If the Status column lists started, the database server runs. If the Status column is empty, the database server does not run. To start the database server, right-click the MSSQLServer service and click Start.

 

Method 2: Verify that IIS is not run in IIS 5.0 Isolation Mode

1.	Point to programs, point to administrative tools, and start with Internet Information Service (IIS) manager.
2.	In the left pane, right-click the server name and expand the local computer.
3.	Right-click the Web site and click Properties.
4.	Click the service tab.
5.	Click the clear check box to run the WWW Service in IIS 5.0 Isolation Mode.
6.	Click OK
7.	To start the WWW Service, click yes.

 

Method 3: Make sure that the account used by the application pool has the required permissions for the SQL Server database.

First, you must first identify the application pool. To do this, follow these steps:

1.	Point to programs, point to administrative tools, and start with Internet Information Service (IIS) manager.
2.	Double-click the website folder.
3.	Right-click the virtual server to run Windows SharePoint Services 2.0, and then click Properties.
4.	Click main directory.
5.	Note: In the application Name box (this is the application pool name and information, and then click Cancel.
6.	In the left pane, right-click the application pool and click Properties.
7.	Click the ID tab.
8.	Note: In the application pool ID pane, click Cancel.

Then, you must verify that this account has the required permissions for the sqlserver database. To do this, follow these steps:

1.	click Start to point to program, point to microsoftsqlserver, and then click Enterprise Manager.
2.	In the left pane, double-click Microsoft sqlservers and double-click the SQL server group.
3.	double-click your server.
4.	double-click Security.
5.	In the left pane, click log on.
6.	In the right pane, double-click to record the user who has logged the process before step 8.
7.	In the sqlserver logon Properties dialog box, click server role.
8.	click to select the securityadministrator and databasecreator check boxes at the same time, and then click Database Access.
9.	In the allowed column, click to select the windowssharepointservices database.
10.	click OK.

 

Make sure that you have the correct name resolution method between the network connection and the server 4:

To do this, follow these steps:

1.	Verify that the correct IP address of the windowssharepointservices server is used for the sqlserver server. In this case, run the ping command on the windowssharepointservices server.
2.	Verify that the windowssharepointservices server obtains the correct IP address for the SQL server from the DNS. In this case, run the NSLookup command from the windowssharepointservices server.
3.	Make sure that there are no correct entries for the SQL server. To run this command, check the hosts file on the windowssharepointservices server. The file is located in the following locations: % SystemRoot % \ system32 \ drivers \ etc \ hosts
4.	Find the SQL client alias on the Windows Sharepoint Server. To do this, follow these steps: A. Click Start, click run, and then typeCliconfgIn the dialog box that appears. B. Click the alias tab. By default, none of them have an SQL client alias. If any alias is SQL Server, verify that they are correct or delete them.

 

Keywords:

Kbdatabase kbwebservices kbtshoot kberrmsg kbprb kb823287 kbmtzh kbmt

2. Still WebService

modify web. the trust level of config is full
System . web >
trust level =" full " />