建站
咨詢
售后
建站咨詢
新聞中心
訪問SQL Server數(shù)據(jù)庫根據(jù)系統(tǒng)平臺(tái)的不同，訪問方法也不太一樣。下面就為您詳細(xì)介紹Windows Server2008上訪問SQL Server的方法，希望對(duì)您學(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)端口打開。
以下腳本自動(dòng)配置打開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版本和組件
文章題目：WindowsServer2008上訪問SQLServer的方法
網(wǎng)頁網(wǎng)址：http://www.fisionsoft.com.cn/article/dphhhop.html
