Re: Need help w/ SA password

Hello,

You may need to do 2 steps, first one is to change the authentication mode
to SQL Server and Windows. After that chnage the SA password.


Use the below steps:-

1. Login as a local admin in SQL Server machine
2. Open the SQL Server express management studio
3. Connect to SQL Server using windows authentication (Work only if you
login into OS using a previleged user in the local machine)
4. Right click the mouse above the server name and choose properties
5. Go to security tab...Change the server authentication to "SQL Server and
Windows Authentication mode"
6. Click OK and restart SQL Server service
7. Reconnect to SQL Server again using SQL Server studio management express
8. Expand the server and choose security and expand logins
9. Right click above SA, properties...modify the password and confirm
password

After this you should be able to login into SQL server using SA.

Thanks
Hari



"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: login 101..
    ... On Windows 2003, SQL Server 2005 can enforce the Windows password complexity ... Windows authentication - SQL Server uses a special protocol to ask ... user is in the list of allowed logins, ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... What do you mean by "creating a Windows login"? ... To login SQL Server 2000 using trusted connection, grant the Windows ... Group" in SQL Server Books Online to get the concept, ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to SQL from a Windows Service
    ... There is probably some way to debug this, but that's deeper Windows knowledge than I can dredge up right now. ... I looked into the Event Log and found that when my service ... 1st Login succeeds. ... You can try turning on login auditing in SQL Server and then check the ...
    (microsoft.public.sqlserver.connect)
  • Re: Trusted SQL Server connection (SQL 2005)
    ... To be able to login to SQL Server using a Windows account, then a login must be created in SQL Server Security\Login for that account or for a Windows group which consists that Windows account. ... Create login for the Windows group who you want them to be able to login to your SQL Server and assign them necessary permissions for your database objects or whatever. ...
    (microsoft.public.sqlserver.security)