B16B Publish time 7-1-2011 12:09 PM

sql server 2005 remote connection

siapa tahu cara nak buat remote connection pakai sql server 2005 express edition? apa yg aku maksudkan kat sini ialah, aku nak connect ke sql server kat office aku dari rumah aku. aku pakai skrg sql server management studio 2008 (sbb ada dts wizard - bleh import export databse) dan sql server 2005 database engine. sape2 bleh bantu aku.

B16B Publish time 7-1-2011 03:12 PM

sekor haram xmo tolong aku..aduss

acesecure Publish time 7-1-2011 08:32 PM

Dulu masa aku jaga server aku wat port forwarding kat router. Ko search port forwarding untuk router kat Mr Google nnti pilih router office ko. Cari cara nak setup. Pastu kena ada Telnet untuk akses server tuh. Tp server aku pakai linux la. Untuk windows server tak sure bleh ke tak..

naikAntena Publish time 26-1-2011 08:22 PM

sekor haram xmo tolong aku..aduss
B16B Post at 7-1-2011 15:12 http://mforum2.cari.com.my/images/common/back.gif


    hik3;P ..
cuba cakap... "saya Upah" atau "saya bayar".... mesti ramai org datang tolong;P :loveliness: ...


anyway.. ai assume awak dah buat
(destination)
*enable services sql server browser > services.msc
*enable remote connection > database engines
*enable tcp/ip protocol > sql server network configuration
then >>>>>>>>>>>>setting ipaddress & port > sql server configuration manager
*set account logon > sql server browser properties
*add exception Windows Firewall
(home)
*server registration
*create,desgin and execute package

So step mana yang problem????

if ada problem .. meh print screen...

naikAntena Publish time 26-1-2011 08:23 PM

Post Last Edit by naikAntena at 26-1-2011 20:25

ehh cup! sy agak server kt

opis static IP dan pc kt umah ada lah dynamic IP

dulu ada sorang forumer nama Oobi.. dia terer bab nih...

ultra78 Publish time 26-1-2011 08:49 PM

google is your friend

:lol:
Pages: [1]
View full version: sql server 2005 remote connection


ADVERTISEMENT