RE: Not associated with a trusted SQL connection
From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 12/18/03
- Next message: Kevin McDonnell [MSFT]: "RE: truncate a table via a stored procedure"
- Previous message: Mariyan: "Protect DataBAse which is distributed on many SQL Servers"
- In reply to: Glen Sheidan: "Not associated with a trusted SQL connection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 17 Dec 2003 23:26:20 GMT
Hi Glen,
You need to first add the NT user or NT group as a valid login in SQL
Server. You can use Enterprise Manager to do this.
Logins are added by Expaning the Security Folder in SQL Enterprise Manager.
Or from Query Analyser you can use the following commands.
sp_grantlogin [@loginame =] 'login'
sp_grantdbaccess [@loginame =] 'login'
[,[@name_in_db =] 'name_in_db' [OUTPUT]]
You can get more information in SQL Books Online
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
- Next message: Kevin McDonnell [MSFT]: "RE: truncate a table via a stored procedure"
- Previous message: Mariyan: "Protect DataBAse which is distributed on many SQL Servers"
- In reply to: Glen Sheidan: "Not associated with a trusted SQL connection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
