Solved

SQL Express Authentication - Reset passord

Posted on 2007-04-04
3
2,215 Views
Last Modified: 2008-02-15
I installed SQL Express on my workstation some time ago and don't remember what password I assigned to sa.

I can login using Windows authentication, but it doesn't allow me to do any operations, such as add a database. Is there a way to reset the password, or do I have to remove and reinstall SQL in order to proceed.?

Thanks in advance!
0
Comment
Question by:AndrewJen
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18853096
Unfortunately the answer to this is no. You will have to un-install and reinstall. If you make a backup copy of any user database files you have, you can use sp_attach_db to reattach them to the new installation.
0
 
LVL 3

Author Comment

by:AndrewJen
ID: 18853134
Thank you. Oddly enough, I am logging in via Windows Authentication and I am an Admin on my local machine where this is installed. Isn't this supposed to give me admin privileges on the DB server?
0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18853166
It should unless the builtin\administrators group has been removed or been removed from the sysadmin role.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

757 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

17 Experts available now in Live!

Get 1:1 Help Now