SQL connection

[Former Member]

I am trying to connect with sql data base from MII 12.2, but connection status is in error state. In log viewer, i am getting error

" connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall "

Please help.

[swaroop_anasane]

Hi Manjiri,

Couple of questions:

1. Are you able to connect to the db from SQL server management console?

2. Are you using server name or IP in the connection url?

3. Are you able to ping your server?

Thanks,

Swaroop

[Former Member]

Hi Swaroop,

Thax for the reply.

Answers to your questions are given below.

1. yes, I am able to connect to the db from SQL server management console.

2. I am using server IP in the connection url.

3.I am not able to ping my server.

Regards,

Manjiri

[swaroop_anasane]

Hi Manjiri,

That's the problem. You should be able to ping the server to connect it.

For now, you can update your server's host file and add the IP address there. Then try pinging it, if it succeeds, check the connect status.

Thanks,

Swaroop