Instaliran je MSDE u lokalu . Koristi se Windows prijava za pristup bazi podataka.
Kada se koristi Windows korisnički nalog sa administratorskim privilegijama sve je OK, ali kada
se koristi user koji nije administrator tada javlja da nije moguće bristupiti bazi(nešto kao: Login failed for user MojKomp\Pera). Inače kada koristim SqlServerExpress taj problem ne postoji.
Koristim ovaj ConnectionString:
Server=(Local);database=DB_moja_baza;Integrated Security=true;Connection timeout=5
Pregledao sam sve postove , tražio na Googlu ali nešto ne ide... Možda je neko imao sličan problem?
zasto sto se prilikom instalacije MSDE-a u kreira login (tacnije grupa) "BUILTIN Admin" koju cine administratori. Napravi novi login sa userom koji ti treba i radice.
inicijalno samo win administratori mogu. dakle ili kreiraj usera (na msde-u) koji nije win administrator ili se loguj preko administara (ili koristi sql usera)! Ne mozes sa nekim "obicnim" userom ako mu prethodno nisi dao pravo pristupa, logicno zar ne?
1.. In Control Panel, open the Services tool, and then stop MSSQLSERVER and all other related services (such as SQLSERVERAgent).
2.. On the Start menu, click Run, type regedt32, and then click OK to start Registry Editor.
3.. Locate either of the following subkeys (depending on whether you installed MSDE as the default MSDE instance or as a named instance):
a.. HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\
-or-
b.. HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\
4.. In the right pane, double-click the LoginMode subkey.
5.. In the DWORD Editor dialog box, set the value of this subkey to 2, verify that the Hex option is selected, and then click OK.
6.. Restart the MSSQLSERVER service and the SQLSERVERAgent service for this change to take effect.