Remote server security
From: PRW (PRW_at_discussions.microsoft.com)
Date: 01/06/05
- Next message: Sam Berry: "Securing a SQL 2000 Server Checklist"
- Previous message: Uri Dimant: "Re: Application Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 6 Jan 2005 04:55:03 -0800
Came across this with remote server security and wonder whether I am
interpreting this incorrectly or whether it is a bug.
When configure a remote server login in SQL Server 7.0, have option to
select 'check password' box which according to BOL indicates:
trusted = password not checked
untrusted = pwd checked
However, when run SQL Profiler when eg check the password box so all the
remote logins which are mapped to the local login are untrusted, the sql that
is written is:
exec sp_remoteoption N'XX_SQLSRV', N'sa', null, trusted, true,
which is the opposite of what BOL states (and BOL by its definition makes
sense, since untrusted would indicate the pwd is not checked).
The reverse is also true that when uncheck the password box, which would
indicate don't check the password so trusted, the trusted option is set to
false.
Am I missing something here or is this a bug ?
- Next message: Sam Berry: "Securing a SQL 2000 Server Checklist"
- Previous message: Uri Dimant: "Re: Application Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
