• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 652
  • Last Modified:

change SQL sa password SBS2008 SSEE

I found the following database files taking up too much space
logon error I'm trying to change the sa account password to mange the database and logs, running the below command fails, any ideas how to change the sa account?

Commands:
C:\Windows\system32>Osql -S computername\SQLEXPRESSinstance -E
1> EXEC sp_password NULL, 'sa', 'sa'
2> GO

I get the following error:
logon error
0
WORKS2011
Asked:
WORKS2011
1 Solution
 
David ToddSenior DBACommented:
Hi,

It looks like you are in Windows authentication mode, and not mixed mode. sa is valid only under mixed mode.

If you have the rights to change the sa password, then surely you have admin rights yourself and don't need to be sa?

Regards
  David
0
 
Jian An LimSolutions ArchitectCommented:
usually domain admins will have access to the SQL

and in order to reduce LDF, do a full backup usually helps.
p/s: how long ago you did a backup?
0
 
BlueComputeCommented:
Hi,

have you reviewed MS KB 2000544 - "SharePoint database log file is getting large in Windows SBS 2008"  ?
0
 
WORKS2011Austin Tech CompanyAuthor Commented:
@dtodd:
It looks like you are in Windows authentication mode, and not mixed mode. sa is valid only under mixed mode.
how to change to mixed mode?

If you have the rights to change the sa password, then surely you have admin rights yourself and don't need to be sa?
I don't have access to the SA account or I would change it.

@limjianan:
usually domain admins will have access to the SQL
I get the following error above.

and in order to reduce LDF, do a full backup usually helps. p/s: how long ago you did a backup?
One of the pitfalls of imaging software, the full backups are done through imaging software.

@Bluecompute: check article now.
0
 
BlueComputeCommented:
Hi WORKS2011,

In general, it's not usually wise or necessary to start 'administering' the SSEE instance.  However,

If the article doesn't resolve your issue, you can simply log in to SQL Server Management Studio Express by copying the following into the 'Server' field and using windows authentication:
\\.\pipe\mssql$microsoft##ssee\sql\query

Open in new window


http://www.mssqltips.com/sqlservertip/1577/administering-your-windows-internal-database-microsoftssee-instance/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now