Re: Cannot create a SQL user logon
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 07/01/04
- Next message: Andy Ball: "Re: Snap-in failed to initialize on Enterprise Mananger"
- Previous message: Andy Ball: "Re: configuration settings for a database"
- In reply to: GreenThumb: "Re: Cannot create a SQL user logon"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Jul 2004 08:44:04 +0200
Then just run the free GUI at:
http://www.dbmaint.com/SyncSqlLogins.asp
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "GreenThumb" <GreenThumb@discussions.microsoft.com> wrote in message news:895898FC-6E63-4F87-95D0-FAB1900F2836@microsoft.com... > seems like a lot of steps - can I just delete and re-create? if yes, how? > > Thank You > > "Narayana Vyas Kondreddi" wrote: > > > May be an orphan users problem. See: > > http://vyaskn.tripod.com/troubleshooting_orphan_users.htm > > -- > > HTH, > > Vyas, MVP (SQL Server) > > http://vyaskn.tripod.com/ > > Is .NET important for a database professional? > > http://vyaskn.tripod.com/poll.htm > > > > > > "GreenThumb" <GreenThumb@discussions.microsoft.com> wrote in message > > news:12CFC41B-4E5C-4584-AEC6-0EB5FA399293@microsoft.com... > > Hi, > > > > The logon exists in the syslogins table but it doesn't appear in the Users > > section in Enterprise Manager. > > > > Thanks for your help! > > > > "Hari" wrote: > > > > > Hi, > > > > > > Login to Query Analyzer and execute the below query to check if login > > exists > > > or not. > > > > > > select name from master..syslogins > > > > > > -- > > > Thanks > > > Hari > > > MCDBA > > > > > > "GreenThumb" <GreenThumb@discussions.microsoft.com> wrote in message > > > news:60D23201-D724-4BAB-8591-05F0E2B975E6@microsoft.com... > > > > Hello Everyone- > > > > > > > > I am trying to create a new logon in SQL 2000 using Windows > > > authentication. However, I am given a "21008 Login already exists" but > > this > > > login clearly does not already exist. Any ideas? > > > > > > > > Thanks, > > > > > > > > --GREG-- > > > > > > > > > > > > > > >
- Next message: Andy Ball: "Re: Snap-in failed to initialize on Enterprise Mananger"
- Previous message: Andy Ball: "Re: configuration settings for a database"
- In reply to: GreenThumb: "Re: Cannot create a SQL user logon"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
