Close This Window

Connectivity: Login failed for user 'soapuser' or Access to selected database has been denied.

SYMPTOMS

When you start SOAPware you receive one of these two errors:

Connection failed:
SQLState:'08004'
SQL Server Error:4060
Server rejected the connection; Access to selected database has been denied

or

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
Microsoft ODBC SQL Server Driver SQL Server Login failed for user 'soapuser'.

These two errors can arise from the "soapuser" user account not being in the SQL/MSDE SOAPware databases. This happens many times when users have restored from a backup. The backup contains all the data, but not the users information and rights. It can also happen when a SQL Administrator inadvertently removes the soapuser account. This soapuser account is what the SOAPware client program submits for permissions to the database to access the data within. If this account is not present or someone has changed the password for the soapuser account the errors above will result.

SOLUTION

Add the soapuser account to the databases. Accomplish this by using the SOAPware Datamanager.

1. On the Server, click Start, All Programs, SOAPware, Server and finally Datamanager.
2. Login to your server using the sa account by clicking OK.
3. Most sa accounts don't have passwords assigned to them. If a blank password doesn't work, consult your System Administrator to find the password.  Once the Datamanager is open, from the menu item choose Actions, Add SOAPware Account.  You should then receive the notice "SOAPware User account added". Click OK.
4. Close the Datamanager.
5. Try to run SOAPware.
   
   If your using SQL Standard or Enterprise without the datamanager, see note below.

NOTE:  For those who are using SQL Standard and don't want to install or use the data manager, you can add the soapuser account manually to each database using "Enterprise Manager. The username is "soapuser" and the password is "soapware". The Database User Properties/rights for the soapuser account should be public, db_ddladmin, db_datareader and db_datawriter. If using NT Authentication, each user will need the same access to the databases. SQL Administration is not in the scope of the SOAPware, Inc. support agreement. Only SQL Administrators should attempt adding account information or altering account information. Incorrectly setting account information can render databases and servers unusable.

MORE INFORMATION
 

For more information on this topic, call the support team at 800-455-7627. 

Close This Window

The information provided in the SOAPware, Inc. Knowledge Base is provided "as is" without warranty of any kind. SOAPware, Inc. disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall SOAPware, Inc. or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if SOAPware, Inc. or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.