SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Unable to connect SQL Server 2008 cluster using IP		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sharathcs
Starting Member

India
3 Posts
Posted - 09/25/2012 :  07:09:56  Show Profile  Reply with Quote
Hello,

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.

Please help in resolving this issue.

chadmat
The Chadinator

USA
1961 Posts
Posted - 09/25/2012 :  12:42:54  Show Profile  Visit chadmat's Homepage  Reply with Quote
Are you specifying the appropriate port?

-Chad
Go to Top of Page

Sharathcs
Starting Member

India
3 Posts
Posted - 09/26/2012 :  02:34:24  Show Profile  Reply with Quote
Yes I have specified the 1433 port and have enabled TCP/IP and port 1433 in SQL Server.
Go to Top of Page

chadmat
The Chadinator

USA
1961 Posts
Posted - 09/26/2012 :  12:29:05  Show Profile  Visit chadmat's Homepage  Reply with Quote
Is it a named instance or default?

-Chad
Go to Top of Page

Sharathcs
Starting Member

India
3 Posts
Posted - 09/29/2012 :  09:19:12  Show Profile  Reply with Quote
Its a named Instance
Go to Top of Page

chadmat
The Chadinator

USA
1961 Posts
Posted - 09/30/2012 :  02:15:32  Show Profile  Visit chadmat's Homepage  Reply with Quote
Then 1433 is not likely to be the correct port.

-Chad
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000