Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not associated with a trusted SQL Server connection
Message
De
03/10/2005 03:32:27
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
 
 
À
02/10/2005 01:23:46
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
01055301
Message ID:
01055421
Vues:
12
Through Enterprise Manager, right click on the instance and click properties. Select the Security Tab and make sure the authentication mode is set to SQL Server and Windows and not just Windows. If you need to change it you must restart SQL Server in order for it to take effect.

Regards

Jon

>I am having big problems with SQL 2000 and a DSN login.
>
>I have used it before, but I have restored the SQL database from a .BAK file from another SQL server.
>
>I can go to the SQL machine and open Enterprise manager, open the desired database and see a list of users. My ID is there and I always use the same password.
>
>Thinking it is possible the password is wrong, I went to the security tab then logins at the server level. I double clicked on sa and changed the password.
>
>However I can NOT setup a DSN using sa and the password.
>
>It tells me:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
>
>Has the restore brought in different IDs and SA on server is not SA on database?
>
>HELP! :-((
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform