Re: Need help w/ SA password

By default I believe with SQL Express Mixed mode authentication is going to
be disabled. SA requires this enabled. You will need to enable this mode and
set a strong password for SA.

I suggest having your systems administrator either assign you local admin
rights temporarily (presuming that the default setup was followed and local
admins are mapped into the sysadmin fixed server role in your SQL Express
installation). Then you may login and make the changes required and go back
to not being a local admin.
"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:970A2D51-E96C-4535-9169-0C077EB12D87@xxxxxxxxxxxxxxxx
Hi,

I had our network guy install VS.NET 2005 and SQL Server 2005 Express on
my
computer. He doesn't remember entering an SA password. I can't log into
SQL
server using SA password as I don't know what it is. I can't change it
either
as my network account does not have admin rights.

Could someone recommend a way for me to get admin access to my local
version
of SQL Server Express?

--
Thanks,

Sam


.

Relevant Pages

  • Re: Registry
    ... If you use FTS you need to add a login for ... there's nothing stopping a domain admin adding ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • RE: local admin account password
    ... Subject: local admin account password ... > 4) Only use domain accounts so delete the local ones. ... > The DB file would be encrypted with EFS so only the limited user SQL ... > backup user can make a zip backup of the DB whenever it gets changed ...
    (Focus-Microsoft)
  • RE: local admin account password
    ... Say you have more then 1000 systems, how do you handle the local admin ... Only use domain accounts so delete the local ones. ... The DB file would be encrypted with EFS so only the limited user SQL ... There would be basically two stored procs, ...
    (Focus-Microsoft)
  • Re: New install, login not accepted
    ... I tried to upgrade the site, which was running with MSDE, to SQL ... install SPS. ... I got through the install following the steps in the Admin. ... a admin account, that account needs admin rights to SQL and the local ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Linux...Is it REALLY FREE? How much is YOUR TIME WORTH?
    ... Any admin worth his ... MS SQL ... Sounds to me like you've not tried to manage MS SQL server. ... I've been an admin for Solaris, Windows NT 4, Windows 2000 server and ...
    (alt.os.linux.suse)