Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to SQL through ODBC
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00828997
Message ID:
00829055
Vues:
21
>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
Fil
Voir

Click here to load this message in the networking platform