Results 1 to 5 of 5

Thread: sql server 2005 login

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2006
    Posts
    719

    sql server 2005 login

    i create a new user in sql server 2005 using "SQLEXPRESS" as login



    then i try to login using what i've created



    but this error message appear:



    PLS INSTRUCT ME WHAT TO DO? PLS PLS?

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: sql server 2005 login

    At least you're closer than you were last time but you've STILL ignored what we told you in your last post on this topic: your server is named "SQLEXPRESS". You are trying to log into an unnamed instance of SQL Server, which you don't have. You have a named instance and its name is "SQLEXPRESS". As such you MUST specify the server name in the form <server>\<instance>, not just <server> as you are now. In your case it should be "localhost\SQLEXPRESS". You could use your actual machine name in place of "localhost" but "localhost" will just always refer to the local system, whatever its name is.

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2006
    Posts
    719

    Re: sql server 2005 login

    oh i see? can i create a new login w/o using sqlexpress? because upon installation of SQL Server 2005 Edition, i have no option to go to the
    "Default Instance"

    thanks for replying my post.. i am really a newbie to sqlserver 2005.. pls dont get mad.. i really dont know what to do..

  4. #4
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: sql server 2005 login

    I've already told you more than once how to log into the instance you have. Why exactly is that not good enough? Why do you want a default instance exactly?

  5. #5

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2006
    Posts
    719

    Re: sql server 2005 login

    oh sorry.. i will try it then

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width