Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi,
>I am having trouble setting up an ODBC connection to my MSDE (SQL) server. When I try to test my connection the computer tells me that my connection is not associated with a trusted SQL connection.
>Do I need to add a trusted user to my MSDE server? (How do I do that?)
>
>Please help.
>
>Thanks,
>Einar
You can use enterprise manager to add a user to SQL server. When you do, there is a radio button for "Windows Authentication", this would be considered a trusted connection and there is "SQL Server Authenticaion".
If you don't have EM, you have to send an sp_addlogin command to the server, then use the GRANT command to give permissions to that user.
BOb
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement