Article Details
Product : ServiceDesk Plus
Category : ServiceDesk Plus>> Troubleshooting
 #100010 - MSSQL Startup Issues

I/O Exception:

Check whether the IP of the SQL server and its name are resolved in the DNS server.

Check whether TCP/IP is enabled under SQL Server configuration Manager--->Select SQL Server Network Configuration --->Protocols for MSSQL Server--->Right click on TCP/IP and select Enable

Also check whether TCP/IP is configured in port 1433 or any other different port. Right click on TCP/IP properties ---->IP Address-->TCP Port and check in which port it is configured.

After Enabling the TCP/IP make sure the SQL Server service is restarted once.


Failed to Start the Server:

Check for the collation for the database:

Right click on the database and select the properties-->Options-->SQL Collation must be SQL_LATIN1_General_CP1_CI_AS

Also check whether SQL browser service is running.


ERROR TRACE IN SERVEROUT FILE will be:


Depends On Me: javax.management.MBeanException: com.adventnet.persistence.PersistenceException: Invalid object name 'SYSCOMMENTS'.

ObjectName: adventnet.deployment:service=DeploymentManagertate: FAILED

I Depend On: jboss.system:service=MainDeployer

Depends On Me: java.lang.IllegalArgumentException: Row instantiated for an unknown table: TierComponent

SQL BROWSER STOPPED:

Please check whether SQL Browser service is running under Services


CANNOT CREATE THE DATABASE:

Go to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and check whether there is any .mdf or .ldf files with name of the database that you are trying to create. For Example if the database name you are trying to create is servicedesk, check whether there is any files named servericedesk_log.mdf or servicedesk_log.ldf

If so move those files to a different directory and try to create the database again using changeDBserver.bat option.


CANNOT OPEN DATABASE AS REQUESTED BY THE LOGIN:

Check for the user permission under SQL server manager Studio-->Security-->Logins

Right click on the login name--->Properties

Go to Server Roles and check whether Public and Sysadmin is enabled

Go to User Mapping and check whether dbo.owner and public option is selected for the master database

Also check Server authentication. Right click on SQL instance--->Properties--->Server authentication--->select Windows and SQL authentication


Login Failed:

Check whether the username and password for the given account is correct and also check whether the user account is locked.

The login account given for creating the database must have sysadmin,public and dbcreator roles.