Solved

change SQL sa password SBS2008 SSEE

Posted on 2013-11-05
5
591 Views
Last Modified: 2013-12-01
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
Comment
Question by:WORKS2011
5 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 39626713
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
 
LVL 36

Expert Comment

by:Jian An Lim
ID: 39626948
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
 
LVL 14

Accepted Solution

by:
BlueCompute earned 500 total points
ID: 39627106
Hi,

have you reviewed MS KB 2000544 - "SharePoint database log file is getting large in Windows SBS 2008"  ?
0
 
LVL 17

Author Comment

by:WORKS2011
ID: 39628102
@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
 
LVL 14

Expert Comment

by:BlueCompute
ID: 39628226
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft  Partnership 1 68
SQL Backup skipping a few tables 7 36
Selection from table2 where criteria for table1 10 32
Can't Decide: Office 365 Premium or Status Quo 7 94
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now