Wednesday, June 11, 2008

SQL Server 2005 on testing environment

These are the things need to follow in order to enable remote access.
SQL Server 2005でRemote Accessを有効にする時のステップ

1. Open SQL Server 2005 Surface Area Configulation, expand target server instance, click 'Database Engine', 'Remote Connections' and choose 'Using TCP/IP only' on the right hand side of the screen then click OK.
2. Open SQL Server Configuration Manage and start SQL Server Browser if it's not started.
3. Disable Windows Firewall from Services.

0 comments: