SQLRT TESTCONNECTION 2 returns 1 -What could be possible problem

Question

Hello all ,

I am using this function SQLRTTESTCONNECTION2() to connect to SQL server. Its returning me as value 1 ,which means failure to establish a connection. What could be possible cause for this?Any ideas please?

Answer 1

Assuming the server is setup to allow remote TCP/IP connections (off by default) and you have eliminated firewall issues, try to connect with something (SQL mngmnt. studio) that will give you more detail than "FAIL".