Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to SQL through ODBC
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00828997
Message ID:
00829055
Views:
22
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform