Post reply

Why some login requires instance name

  • April 29, 2009 at 5:38 am

    #202646

    ;-)When I tried to login to one of the 2005 SQL SERVER, I typed server name “computer name”, then typed correct username and password. But didn’t allow to log in

    Then I tried

    Server name as computername\instance name (as same computer name) this allowed me to login

    My question, why some sql servers allows to login without instance name and others must have instance name?

    Thanks

  • April 29, 2009 at 6:28 am

    #985834

    it would depend on whether or not the server has been setup with an instance or not.

  • April 29, 2009 at 9:21 am

    #986023

    linda_web (4/29/2009)

    ;-)When I tried to login to one of the 2005 SQL SERVER, I typed server name “computer name”, then typed correct username and password. But didn’t allow to log in

    Then I tried

    Server name as computername\instance name (as same computer name) this allowed me to login

    My question, why some sql servers allows to login without instance name and others must have instance name?

    Thanks

    I've only seen this when logging in to a named instance. Is that true in your case?

    Greg

  • April 29, 2009 at 11:40 am

    #986157

    Yes, I think that is the case

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

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