General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only