Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sharathcs
Starting Member
3 Posts |
 Posted - 2012-09-25 : 07:09:56
|
| 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
1974 Posts |
Posted - 2012-09-25 : 12:42:54
|
| Are you specifying the appropriate port?-Chad |
 |
|
|
Sharathcs
Starting Member
3 Posts |
Posted - 2012-09-26 : 02:34:24
|
| Yes I have specified the 1433 port and have enabled TCP/IP and port 1433 in SQL Server. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-26 : 12:29:05
|
| Is it a named instance or default?-Chad |
|
|
|
Sharathcs
Starting Member
3 Posts |
Posted - 2012-09-29 : 09:19:12
|
| Its a named Instance |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-30 : 02:15:32
|
| Then 1433 is not likely to be the correct port.-Chad |
|
|
|
|
|
|
Unable to connect SQL Server 2008 cluster using IP