訪問SQL Server數(shù)據(jù)庫根據(jù)系統(tǒng)平臺的不同，訪問方法也不太一樣。下面就為您詳細(xì)介紹Windows Server2008上訪問SQL Server的方法，希望對您學(xué)習(xí)訪問SQL Server方面能有所幫助。

Windows Server 2008上的Windows防火墻有助于防止未經(jīng)授權(quán)的訪問計(jì)算機(jī)資源。但是，系統(tǒng)默認(rèn)沒有打開SQL Server及相關(guān)服務(wù)的端口。若要訪問的是在防火墻后面SQL Server實(shí)例，必須將服務(wù)器防火墻相關(guān)端口打開。
以下腳本自動配置打開SQL Server的默認(rèn)服務(wù)端口：

@echo =========  SQL Server Ports  ===================@echo Enabling SQLServer default instance port 1433netsh firewall set portopening TCP 1433 "SQLServer" @echo Enabling Dedicated Admin Connection port 1434netsh firewall set portopening TCP 1434 "SQL Admin Connection" @echo Enabling conventional SQL Server Service Broker port 4022  netsh firewall set portopening TCP 4022 "SQL Service Broker" @echo Enabling Transact-SQL Debugger/RPC port 135 netsh firewall set portopening TCP 135 "SQL Debugger/RPC" @echo =========  Analysis Services Ports  ==============@echo Enabling SSAS Default Instance port 2383netsh firewall set portopening TCP 2383 "Analysis Services" @echo Enabling SQL Server Browser Service port 2382netsh firewall set portopening TCP 2382 "SQL Browser" @echo =========  Misc Applications  ==============@echo Enabling HTTP port 80 netsh firewall set portopening TCP 80 "HTTP" @echo Enabling SSL port 443netsh firewall set portopening TCP 443 "SSL" @echo Enabling port for SQL Server Browser Service's 'Browse' Buttonnetsh firewall set portopening UDP 1434 "SQL Browser" @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)netsh firewall set multicastbroadcastresponse ENABLE
 

【編輯推薦】

SQL Server默認(rèn)端口--1433端口

SQL Server導(dǎo)出導(dǎo)入某數(shù)據(jù)庫

SQL Server死鎖測試

深度探究SQL Server死鎖的原因

SQL Server2008版本和組件