"This is not about miles, every mountain has its own beauty to climb"

Konfigurasi SQL Server 2005 Express Untuk Remote Connection

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

2 responses

  1. ihwan

    terima kasih atas infonya

    13 August 2010 at 12:24 pm

    • rankga

      Sama-sama. Semoga dapat bermanfaat

      16 August 2010 at 7:46 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s