Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Login failed for WINDOWS Administrator login. (Microsoft SQL Server, Error: 18456) Expand / Collapse
Author
Message
Posted Tuesday, September 7, 2010 12:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 6:10 AM
Points: 350, Visits: 429
Right click on Expand security -> Logins ->Right click on the domain user account -> Delete

This action will throw information/confirmation window as shown in attachment

Once you click on OK, it will delete logged in domain user account.


- SAMJI
If you marry one they will fight with you, If you marry 2 they will fight for you


  Post Attachments 
delete logged in user.docx (8 views, 50.98 KB)
Post #981346
Posted Tuesday, September 7, 2010 12:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:22 AM
Points: 1,109, Visits: 370
I also did the same thing, But my question when we login with say for example 'Login1' account and is it possible to delete the same Login 'Login1'. You said it is possible, but when i try i m grtting following error as in attachment.

  Post Attachments 
Login Error.doc (5 views, 93.00 KB)
Post #981350
Posted Tuesday, September 7, 2010 12:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 6:10 AM
Points: 350, Visits: 429
Yes… Now I understood your issue. From the screenshot, I can make it out that you are logging as SQL user but not as Domain user (Eg: Domainname\Username)

Try logging in as domain user with trusted connection you will be able to delete your own account.


- SAMJI
If you marry one they will fight with you, If you marry 2 they will fight for you
Post #981358
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse