Windows Login Disabled

  • Hi Experts,

    In one of our local servers having only windows authentication is not able to access now as the windows login is disabled in SQL server.

    How can i connect to server without loggin in as another user or administrator on that machine.??

  • windows login methods are never disabled...but a domain login might not work yet, is that what you mean?

    can you right click on the link to SSMS and choose Run As... a different user?

    can you login as the local administrator and add domain accounts?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • 1.yes

    2.Not able to login as u sadid as its rpompting the same login

    3.How to do that??

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply