Cara Konfigurasi SQL Server 2005 Expresss
Supaya dapat digunakan remote connection
————————————————

1. Buka SQL Surface Area Configurator
– di Surface Area for Services and Connections
– di SQLExpress > Database Engine > Remote Connections
> Pilih Local and Remote Connections
> Pilih Both TCP IP and Named Pipes
2. Buka SQL Server Configuration Manager
– di SQL Server 2005 Network Configuration
> enable semua protocol
> masuk ke tcp/ip , ke tab ip adressess , enable semua IP Adress
– di SQL Native Configuration
> enable semua protocol
– di SQL Server 2005 Services .
> enable semua servis (termasuk browser) , start with windows start up semua
> restart SQLExpress service