I have installed SQL Server 2008 Enterprise R2 (64bit) in cluster mode on Windows 2008 Server cluster. when ever I try to access SQL server from via IP address from any of the client, ODBC or from the same server get an error mesasge " Server doesnot exist or access denied" but I am able to connect from same server from same clinet, ODBC with the Instance name. I am using Virtual IP address of the SQL Server and reverse lookup is working properly, I have enabled TCP\IP in SQL Server configurations and the SQL Server Agent resource in Oline in Cluster Manager.Everything is working normal except am unble to connect via IP Address
I have tested by installing SQL Server 2008 Enterprise R2 (64bit) standalone on Windows 2008 Server and am able to connect to database by both Instance name and IP address.
I am trying to install a Clinet which will only connect to database using IP address.