qualcuno puo' aiutarmi dopo installazione MSDE2000

[fegat\\n0]

dopo aver creato l'istanza non riesco a farci inserire nessun database.
Mi da il solito errore.

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Qualcuno puo' aiutarmi?
Grazie 1000.

[Gioba66]

devi crearti un utente con accesso sqlserver.
se usi MSDE ti conviene scaricarti un sw di interfaccia con il quale puoi creare utenti, db, ecc..
se fai una ricerca in rete ne trovi tanti, anche free, che ti offrono le stesse potenzialità di Enterprise Manager.

[comas17]

Il problema credo sia perchè la versione di MSDE che si trova generalmente nei CD di Office XP (o Visual Studio, etc) si installa di default con la modalità di autenticazione di Windows NT e non con quella mista (SQL + Windows NT). Inoltre il classico utente 'sa' (password vuota) è disabilitato.
E' possibile modificare (l'ho già fatto senza problemi) una voce del registro per modificare la modalità di autenticazione e portarla a quella "mista"
Qui di seguito ti copio una parte che ho trobato nel sito www.sqlmag.com (eccellente) che spiega come (e dove...) modificare
Spero sia chiaro

Changing MSDE's Security Mode

I have a copy of Microsoft SQL Server Desktop Engine (MSDE) installed on a Windows 2000 Professional PC. By default, MSDE is configured to use Windows authentication. The database developer didn't provide an MSDE management utility to let us change the security mode. Can we change the authentication mode to SQL Server authentication?

You can easily change the security mode to SQL Server authentication by tweaking the registry. As you do when you make any registry change, be sure you have good backups and use caution because a registry mistake can cripple your system.

Your Windows registry should have a subkey similar to

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQL2000_1\MSSQLServer\LoginMode.

This subkey name is from my machine. Your subkey name will depend on what instances of MSDE and SQL Server you have installed.

A value of 2 for this subkey will set login security mode to support both SQL Server and Windows authentication. A value of 1 will configure SQL Server to support only Windows authentication. You must restart SQL Server to put this change into effect.

[comas17]

Questo l'ho trovato invece nel sito Microsoft:

Turn on Mixed Mode Authentication During Installation
During installation, you can change the authentication mode that MSDE uses by running the installation with the following command parameter:
SECURITYMODE=SQL

This command parameter causes MSDE to install with Mixed Mode authentication. With this authentication mode, you can connect to MSDE by using Windows Authentication or SQL Server Authentication.

NOTE: By default, for Windows NT and later, MSDE installs by using Windows Authentication. On computers running Windows 98, MSDE uses SQL authentication.

back to the top
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.
If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode

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:
In Control Panel, open the Services tool, and then stop MSSQLSERVER and all other related services (such as SQLSERVERAgent).
On the Start menu, click Run, type regedt32, and then click OK to start Registry Editor.
Locate either of the following subkeys (depending on whether you installed MSDE as the default MSDE instance or as a named instance):
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\ MSSqlServer\

-or-
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\
In the right pane, double-click the LoginMode subkey.
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.
Restart the MSSQLSERVER service and the SQLSERVERAgent service for this change to take effect.
Ciao

[nicrom]

non so se può esserti utile...

ma io accedo a MSDE tramite Access (2000 o 2002)....
prova: File|Nuovo|Progetto(dati nuovi)...

usando NT Itegrated Security non devi specificare ne la login
na la pw.

ciao