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

• 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.