[es] - problem sa pravljenjem baze u SQL MSDE

pile_naucnik
NS

Član broj: 70493
Poruke: 67
*.149.eunet.yu.

Profil

problem sa pravljenjem baze u SQL MSDE

^{09.10.2005. u 18:39 - pre 231 meseci}

Treba mi pomoc kod pravljenja baze.

U pitanju je SQL MSDE

kada odaberem opciju

Use SQL Server Authentication.

dobijam poruku <<ADO Error:'Login failed for user 'sa'
Reason: Not associated with a trusted SQL Server connection.'

Pokusavao sam i sa administratorskom sifrom i svim ostalim ali ne vredi.

Na netu sam nasao samo da se ovaj problem resava u Enterprise manager-u gde
se Authentication postavi na SQL server and Windows.

Ne znam kako to da napravim posto SQL MSDE nema Enterprise manager.

Inace u pitanju je WIN XP profesional i Visual studio 2003.net.

hvala

Odgovor na temu

ventura

Član broj: 32
Poruke: 7781
81.93.80.*

+6455 Profil

Re: problem sa pravljenjem baze u SQL MSDE

^{09.10.2005. u 18:42 - pre 231 meseci}

Da jeste, potrebno je da prebacis na "mixed authentication" to se i meni desava na win2k serveru... (znam, lose je oslanjati se na mixed authentiction al sta cu) ...

Pogledacu bas kako se to radi na MSDE-u, mislim da imam to negde...

Odgovor na temu

ventura

Član broj: 32
Poruke: 7781
81.93.80.*

+6455 Profil

Re: problem sa pravljenjem baze u SQL MSDE

^{09.10.2005. u 18:45 - pre 231 meseci}

KJ

http://support.microsoft.com/default.aspx?scid=kb;en-us;325022
Turn on Mixed Mode Authentication After You Install MSDE
WARNING: If you modify the registry incorrectly, serious problems may occur that require you to reinstall your operating system. Microsoft cannot guarantee that the problems can be solved. Modify the registry at your own risk.

Microsoft recommends that you back up the registry before you modify it. If you are running Microsoft Windows NT or Microsoft Windows 2000, also update your Emergency Repair Disk (ERD).

By default, the value of the LoginMode Windows registry subkey is set to 1 for Windows Authentication. To turn on Mixed Mode authentication after you install MSDE, you must change this value to 2. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance.
a.. If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

b.. If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name \MSSQLServer\LoginMode

To change the value of LoginMode to 2, follow these steps:
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.
A registry-t matató xp-k:
http://www.databasejournal.com/features/mssql/article.php/1462641

Odgovor na temu

pile_naucnik
NS

Član broj: 70493
Poruke: 67
*.54.EUnet.yu.

Profil

Re: problem sa pravljenjem baze u SQL MSDE

^{09.10.2005. u 19:50 - pre 231 meseci}

Ventura, hvala ti puno.

Uspeo sam, sve radi.

Moram priznati da jos ne znam razliku izmedju Mixed i Windows authentication posto sam jos uvek pocetnik, ali nadam se da cu uskoro doci i na taj nivo.

hvala jos jednom

Odgovor na temu

ventura

Član broj: 32
Poruke: 7781
81.93.80.*

+6455 Profil

Re: problem sa pravljenjem baze u SQL MSDE

^{09.10.2005. u 21:13 - pre 231 meseci}

Citat:

pile_naucnik: Moram priznati da jos ne znam razliku izmedju Mixed i Windows authentication posto sam jos uvek pocetnik, ali nadam se da cu uskoro doci i na taj nivo.

To je pitanje sigurnosti... U principu svi preporucuju da se oslonis na windows autentifikaciju, jer se onda briga o loginima poveruje domain kontroleru, sto je mnogo sigurnije nego da se sql-u direktno pristupa preko sql logina... Ovako i ako se desi neki ispad, napadac mora prvo da upadne u domain pa tek onda na sql, a u drugom slucaju ima direkt prolaz do baze...

Odgovor na temu

DarkMan
Darko Matesic

Član broj: 20445
Poruke: 572
*.metrohive.neobee.net.

Jabber: DarkMan

Profil

Re: problem sa pravljenjem baze u SQL MSDE

^{18.10.2005. u 11:56 - pre 230 meseci}

Uz MSDE dobija sigurno OSQL pa i sa njim mozes da dodajes usere i menjas passworde.

Sledece sacujva u neki batch fajl (na primer run_osql.bat):

Code:

echo Windows authentication: LOGIN=-E
echo SQL Server Authentication: LOGIN=-U <username> -P <password>

set SERVER=(local)
set DATABASE=<tvoja baza>
set LOGIN=-E

osql -S %SERVER% -d %DATABASE% %LOGIN%

Naravno ne zaboravi da izmenis podesavanja pre pokretanja.

Ako ti ne radi Windows authentikacija, gore ti je navedeno kako ukljuciti (tacnije mixed mode). Ovo je kraca verzija.

Code:

1. Zaustaviti servis
2. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer LoginMode staviti na 2
3. Pokrenuti servis

Dodavanje novog usera (ovo kucas u osql konzoli):

Code:

exec sp_addlogin <user>,<password>
exec sp_addsrvrolemember <user>, sysadmin
go

Promena sifre usera (takodje u osql-u):

Code:

exec sp_password NULL,<password>,<user>
go

Ovo sa userima mozes da testiras sa gore navedenom batch fajlom tako sto probas da se ulogujes sa kreiranim username-om i passwordom.

Pozdrav

_{[Ovu poruku je menjao DarkMan dana 27.10.2005. u 23:37 GMT+1]}

Odgovor na temu