Re: Security Account Delegation

Hi

Why not? If you use WINDOWS Authentication your computer name can be a
login name to SQL Server.

"MorDeRor" <MorDeRor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51D816B1-94B8-4C68-ADCF-E295E18132C3@xxxxxxxxxxxxxxxx
Hi Uri, I don't think I understand what you mean. How can a computer name
and
a login name be same?

"Uri Dimant" wrote:


Is it possible that your Computer Name ( you're trying to run the query)
and
the Login to the SQL Server ( rinning query from Query Analyzer) are
diffrerent?


Also, if I physically log in to Server A and launch the QA from there,
the
remote query works. But if I launch the QA from my workstation, I get

"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL
Server connection. "




.

Relevant Pages

  • Re: Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
    ... You may be able to use Lenin a calculated query field to determine if the count of characters is not what you expect. ... I have some backend tables in a SQL Server 2000 Database linked into ... User daemon value rlogin is true ... User bin value login is true ...
    (microsoft.public.access.queries)
  • Problem with query using linked tables and vba function
    ... I have a select query which uses two tables linked to SQL Server via ODBC. ... When I run it for the first time, I get the SQL Server login prompt (which ... execution is stopped in a line where I try to open a recordset. ...
    (microsoft.public.access.queries)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)