Is thrown by SQL Server as 'unable to connect the server' then there couldīe following reasons why this could happen such as, If a connection is refused and an exception Is running in a remote machine then there may be a firewall blocking theĪbove mentioned issues matches then contact your system administrator. Name or the port number is misspelled or incorrect. # cd /mysql/binĮnter the command: # mysql -u root -S. (Most often, mysql should be under path, if not, you may add the complete path to mysql command under PATH variable in the bashrc file. Once this is accomplished, make sure that the command "mysql" is in path. Install the MYSQL client which supports your Linux version. You can connect to MYSQL database only from the server console. ServiceDesk Plus - MSP uses root account to connect to the database and does not use any password. 33366 is the port on which ServiceDesk Plus - MSP database runs. Go to \ mysql \ bin in the command prompt.Ĭ:\> cd ManageEngine\ServiceDeskPlus - MSP\mysql\binĮnter the command: mysql.exe -u root -P 33366 servicedeskĬ:\> cd ManageEngine\ServiceDeskPlus - MSP\mysql\bin> mysql.exe -u root -P 33366 servicedesk ServiceDesk Plus - MSP uses MYSQL as its default database. # cd /pgsql/binĮnter the command: pgsql.exe -U postgres -h localhost -p 65432 servicedesk (Most often, mysql should be under path, if not, you may add the complete path to psql command under PATH variable in the bashrc file. Once this is accomplished, make sure that the command "psql" is in path. Install the PostgreSQL client which supports your Linux version. You can connect to PostgreSQL database only from the server console. 65432 is the port on which ServiceDesk Plus - MSP database runs. Go to \ pgsql \ bin in the command prompt.Ĭ:\> cd ManageEngine\ServiceDeskPlus - MSP\pgsql\binĮnter the command: pgsql.exe -U postgres -p 65432 -w servicedeskĬ:\> cd ManageEngine\ServiceDeskPlus - MSP\pgsql\bin> psql.exe -U postgres -p 65432 -w servicedesk ServiceDesk Plus - MSP uses PostgreSQL as its default database. It will get the DB Server necessary information from the console. Run the changeDBServer.bat under command prompt by passing parameterĬ:\\bin>changeDBServer.bat -console This opens the database wizard page.īutton and check the availability of the connection. MySql server and do not want to use the inbuilt server then, Specify the Host Name, Port, User Name & Password.Ĭlick Test button and check the availability of the connection.Īre established, save the details and start the MSSql server and do not want to use the inbuilt server then, The default port is 1433.ĭefault the database name will be servicedesk in non-editable format.Ī pop up window pops up showing 'ConnectionĬlick Save button to save the SQL server settings. Host Name: Enter the IP Address/ host name in which the database is available. Server Type: Select the server type from the combo box. Fill in the details of the form to configure SQL server. ServiceDesk Plus - Database Configurationīy default ServiceDesk Plus - MSP supports PostgreSQL database, to switch over to SQL database, you need to configure SQL server credentials to establish connection and start the server.Įxecute the changeDBServer.bat file presented under the ServiceDesk Plus - MSP
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |