|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sa passwordIs there default password for sa user in SQL Server 2005 Express Edition?
Hi Igor,
By default SQL Express will be set to Windows Authentication, to use SQL authentication you need to change authentication to mixed mode and enable the SA account -- Show quoteHTH. Ryan "Igor Solodovnikov" <IgorSolodovni***@discussions.microsoft.com> wrote in message news:op.s3ob0mo1n8ihmu@iw2k.helpmicro.local... > > Is there default password for sa user in SQL Server 2005 Express Edition? I already switched to mixed mode. But how can i enable sa account?
On Fri, 20 Jan 2006 13:43:42 +0200, Ryan <Ryan_Waight@nospam.hotmail.com> wrote: Show quote > Hi Igor, > > By default SQL Express will be set to Windows Authentication, to use SQL > authentication you need to change authentication to mixed mode and enable > the SA account > ALTER LOGIN sa ENABLE
-- Show quoteHTH. Ryan "Igor Solodovnikov" <IgorSolodovni***@discussions.microsoft.com> wrote in message news:op.s3od9vy0n8ihmu@iw2k.helpmicro.local... >I already switched to mixed mode. But how can i enable sa account? > > On Fri, 20 Jan 2006 13:43:42 +0200, Ryan <Ryan_Waight@nospam.hotmail.com> > wrote: > >> Hi Igor, >> >> By default SQL Express will be set to Windows Authentication, to use SQL >> authentication you need to change authentication to mixed mode and enable >> the SA account >> > Thank you. Now my sa account is enabled. But i dont know its password. Of
course i can try to set it up with sp_password. But is there any default for this? Or this password is random? On Fri, 20 Jan 2006 14:38:31 +0200, Ryan <Ryan_Waight@nospam.hotmail.com> wrote: Show quote > ALTER LOGIN sa ENABLE > Your best bet would be to connect as a sysadmin via a trusted connection and
then issue :- ALTER LOGIN sa WITH PASSWORD = 'letmeinplease' -- Show quoteHTH. Ryan "Igor Solodovnikov" <IgorSolodovni***@discussions.microsoft.com> wrote in message news:op.s3oh4kiyn8ihmu@iw2k.helpmicro.local... > Thank you. Now my sa account is enabled. But i dont know its password. Of > course i can try to set it up with sp_password. But is there any default > for this? Or this password is random? > > On Fri, 20 Jan 2006 14:38:31 +0200, Ryan <Ryan_Waight@nospam.hotmail.com> > wrote: > >> ALTER LOGIN sa ENABLE >> > > ALTER LOGIN sa WITH PASSWORD = 'letmeinplease' This is probably the most intuitive password ever. :)ML --- http://milambda.blogspot.com/ Yes, it is random. If you specify mixed authentication from the start,
setup will ask you to specify a password but if you install with Windows authentication, a random password is generated. It sounds like you understand how to give it the password you want so you should be OK. -- Show quoteThis posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "Igor Solodovnikov" <IgorSolodovni***@discussions.microsoft.com> wrote in message news:op.s3oh4kiyn8ihmu@iw2k.helpmicro.local... > Thank you. Now my sa account is enabled. But i dont know its password. Of > course i can try to set it up with sp_password. But is there any default > for this? Or this password is random? > > On Fri, 20 Jan 2006 14:38:31 +0200, Ryan <Ryan_Waight@nospam.hotmail.com> > wrote: > >> ALTER LOGIN sa ENABLE >> > Thank you.
On Fri, 20 Jan 2006 17:19:12 +0200, Roger Wolter[MSFT] <rwol***@online.microsoft.com> wrote: Show quote > Yes, it is random. If you specify mixed authentication from the start, > setup will ask you to specify a password but if you install with Windows > authentication, a random password is generated. It sounds like you > understand how to give it the password you want so you should be OK. >  |
|||||||||||||||||||||||
Other interesting topics