Windows Authentication

From: David Havard (dave_at_exploreworldwide.com)
Date: 05/29/03


Date: Thu, 29 May 2003 02:30:37 -0700


Hi

We use windows authentication from a 2k domain to our sql
7 server. Two of our employees have just got married and
so changed their surname. As a result a of this we changed
there login name.

Since doing this they are no longer detected using
xp_logininfo - does anyone have any ideas why not? sp_who
will still have them listed with a fully qualified name!

Thanks in advance.

Dave



Relevant Pages

  • Re: How query between databases
    ... Server). ... Vacations is linked to Employees by EmployeeId. ... In SQL how would I join the 2 tables, even though they are from 2 different dbs? ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)