hi..rekan...rekan...
setiap kali saya (client) ingin melakukan koneksi ke sql server2005
(SERVER) tidak bisa,
mohon bantuan dari rekan2 sekalian.
trim's ye.....
ini error nya:
Menggunakan SQl server:
========================
SQLState : 01000
SQL Server Error :10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnetionOpen(Connect())
sql state :08001
Sql Server Error :17
SQL Server does not exist or access Denied
Menggunakan SQL NAtive Client:
=============================
SQLState : 08001
SQL Server Error :10061
[Microsoft][SQL NAtive Client]TCP Provider: No Connetion Could be made because
the target machine actively refused it.
SQLState : 08001
SQL Server Error :10061
[Microsoft][SQL NAtive Client] an error has occurred while establishing a
connection to the server.
when connection to sql server 2005, this failure may be be caused by the fact
under the default
settings SQL Server does not allow remote connections.
saya menggunakan windows server 2003 Enterprise sebagai sever dan
XP prof sebagai client.
bagaimana caranya agar SQL Server 2005 yang ada di Server bisa di pakai oleh
client ?
padahal di Server sudah di buat user account melaui Active Directory.
