username for sql server

  • hi

    how can i change the default username "sa" for sql server 2005 ?

    please telll!!!!!!!!!!

  • If you leave it with SQL login authentication (either alone or in mixed mode), you can't change that. The only way to remove it is to operate purely on Windows Authentication (which doesn't actually remove it, but does mean you can't log in directly as it).

    Why do you want to remove it?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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