Setting SQLServer untuk Multi User Vb.Net

Setting SQLServer untuk Multi User Vb.Net

Tahap - Tahap nya adalah sebagai berikut :

-masuk SQL SERVER surface area configuration
-klik surface area config for services and connections
-pilih database engine -> remote connections-> local and remote connections -> using both TCP/IP and named pipes
-restart service di database engine
-pilih sql server browser --> start service
-masuk sql server management studio
-klik kanan pada sql server computer name --> properties
-pilih security
-pilih SQL Server and windows authentication
-kemudian restart SQL server computer name

Membuat user baru di SQL Server :

-security --> login --> klik kanan --> new login
-isi login name, pilih sql server authentification -> enforce hilangin -> pilih default database nya, isi juga server role dan user mapping sesuai kebutuhan -> kasi hak akses nya...
-uda skrg tinggal pake connstring: data source=ip-address\sqlexpress; initial catalog=nama database;uid=usernamemu;pwd=passwordmu

Browse More Articles

Tweet

Written by thoestone

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.