April 12, 2010 at 1:48 am
I have installed SQL SERVER 2008 with SP1, I need to connect SQL 2000 and new registration in Database Engine ->under -> Central Management Server, But it is not connect.
SQL 2008 SP1 - with mixed mode authentication
SQL 2000 SP4 - Only windows authentication.
I know SQL SERVER 2008 in Central Management Server allowed only windows authentication.
In SQL 2008 SP1 box there is no any firewall, TCP/IP enabled, eventhough telnet serverIP 1433 this command also not connecting.
Error no - 40 and 1326
Is there additional parameter required for port opening? pls suggestion.
thanks
April 12, 2010 at 11:19 am
Ananda,
I did not understand what you meant with this sentence.. "Is there additional parameter required for port opening? pls suggestion."
If you cannot telnet to the SQL Server 2000 machine on 1433, then you will not be able to connect using any client. Keep in mind that the SSMS connects using 1434 UDP port as well.
Check with your Network admins if the ports are open.
-Roy
April 14, 2010 at 4:13 am
I ran one batch file for status of SQL ports, it showing all the ports service has not been started, But all sql services were started, I could not get clear, Can any one clarify what could be reason? telnet serverIP 1433, does not running.
as following SQL version installed
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
Checking sql port status thru batch file.
D:\SQLPort>opensqlserverport.bat
D:\SQLPort>echo ========= SQL Server Ports ===================
========= SQL Server Ports ===================
Enabling SQLServer default instance port 1433
D:\SQLPort>netsh firewall set portopening TCP 1433 "SQLServer"
The service has not been started.
Enabling Dedicated Admin Connection port 1434
D:\SQLPort>netsh firewall set portopening TCP 1434 "SQL Admin Connection"
The service has not been started.
Enabling conventional SQL Server Service Broker port 4022
D:\SQLPort>netsh firewall set portopening TCP 4022 "SQL Service Broker"
The service has not been started.
Enabling Transact-SQL Debugger/RPC port 135
D:\SQLPort>netsh firewall set portopening TCP 135 "SQL Debugger/RPC"
The service has not been started.
========= Analysis Services Ports ==============
Enabling SSAS Default Instance port 2383
D:\SQLPort>netsh firewall set portopening TCP 2383 "Analysis Services"
The service has not been started.
Enabling SQL Server Browser Service port 2382
D:\SQLPort>netsh firewall set portopening TCP 2382 "SQL Browser"
The service has not been started.
========= Misc Applications ==============
Enabling HTTP port 80
D:\SQLPort>netsh firewall set portopening TCP 80 "HTTP"
The service has not been started.
Enabling SSL port 443
D:\SQLPort>netsh firewall set portopening TCP 443 "SSL"
The service has not been started.
Enabling port for SQL Server Browser Service's 'Browse' Button
D:\SQLPort>netsh firewall set portopening UDP 1434 "SQL Browser"
The service has not been started.
Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
D:\SQLPort>netsh firewall set multicastbroadcastresponse ENABLE
The service has not been started.
thanks
April 20, 2010 at 9:33 am
Security is a most important .It gives me lots of pleasure and interest.All people security have.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply