1. Configuration Manager2. Network Config - Protocol SQL Express3. IP Address - Enabled Yes4. Browser harus otomatis hidup
Membuat SQL Dual Mode: Windows dan SQL Server AuthenticationHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQL.ServerLogin Mode = 2
Surface ConfigurationRemoteConnection = Using TCP/IP
Jika Database ReadOnly1. Buka sql server configuration tools ->Sql server configuration manager -> clicksql server service -> click kanan sql server disebelah kanan -> pilih properties-> pada tab Logon ->opsi pilih built in -> dan pilih local system -> atach lagi database tsb2. maka cek diformat apa database disimpan Di NTFS atau Fat32 jika di NTFS maka set semua user menjadi Full Control
Thursday, March 5, 2009
Setting Instalasi Sql Server 2005 Express
Subscribe to:
Post Comments (Atom)
Topik
- SQL SERVER (4)
- Error (2)
- Pemerograman VB.Net (2)
- Kegiatan Ku (1)
- MY SQL (1)
No comments:
Post a Comment