Post reply

Unable connect to sql server ?

  • March 24, 2009 at 10:40 am

    #130039

    Hi guys,

    Until Yesterday i was easily accessing server with same login and password. Today mid-day onwards i am unable to access to sql server. As a DBA how can we solve this problem?

    Thanks in advance

    Vijay

  • March 24, 2009 at 10:42 am

    #965394

    Are you seeing any error messages being returned?

    Are you aware of any changes to the server that have been made recently?

  • March 24, 2009 at 10:52 am

    #965406

    Hey actually that is interview question? for that i dont have at that time.

    Simply i told him never come across this type of problem

    If anybody knows answer of that or what are reasons for that, please tell me. It will be helpful for future interviews

    Thanks in Advance

    Vijay

  • March 24, 2009 at 10:56 am

    #965410

    Could be any number of things but I suppose that the two most obvious might be:-

    *Account locked out because of too many incorrect login attempts.

    *SQL Server authentication changed from Mixed Mode to Integrated.

    Hope that helps.

  • March 24, 2009 at 10:58 am

    #965415

    I'd also check and be sure the server is running.

  • March 24, 2009 at 11:01 am

    #965419

    Steve Jones - Editor (3/24/2009)

    I'd also check and be sure the server is running.

Viewing 6 posts - 1 through 5 (of 5 total)

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