Problem configuring database using sd db configurator
Hi there, I have installed my sql server2000 with sp4 and have installed the server part of sd, when i run the Service Desk Database Configuration i get an error on the screen where i enter my username and password to connect to the db. the error is as follows: "Failed to open connection to service desk repository. java.io.InterruptedIOException: Receive timed out" I have tried to do an odbc connection from my sd server to the database server using the exact same credentials and this is working without any problems, however in the sd db configurator i am getting this error.
Any suggestions? NB: i am installing sd 4.5 on a Win2003 server and have am using the patch for installation on a 2k3 box to do this installation.
Re: Problem configuring database using sd db configurator
Are SD and SQL server situated on one host? On what host did you configure odbc connection? Did you use TCP\IP connection method in odbc options (see attach)? Try to check port availability: telnet sqlserver.hostname 1433 As Alexey Dukov said, you should configure your sql server so that it listens on TcP port (1433).