본문 바로가기
About Computer/서버관리

MSSQL Server 2008 - Remote Access Configuration (원격접속 설정)

by leanu 2010. 10. 4.
  • Set "SQL Server Authentication" when you install the DB.
  • Click : Start -> All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager
  • In the left window, Click : SQL Server Network Configuration -> YOUR DB NAME
    • Change the status of "Named Pipes" and "TCP/IP" from Disabled to Enabled.
    • Double Click "TCP/IP"
    • Click a tab "IP Addresses" -> type 1433 to TCP Port in "IPAll" section.
  • Click "SQL Server Services" -> SQL Server (YOUR DB NAME) at the left side.
  • Right click and "restart" your server.

댓글