Menu
I have installed SQL Server 2008 express and logging in through windows authentication, it doesn't allow me to do anything. How do i change 'sa' password or gain full privilege in my local computers 2008 express ? I am using windows 7.
349
Log in as the SA user using SQL Server authentication and the current password. In the Object Explorer, expand Security and then Logins. Double click the SA login. Enter the desired password and confirm it.
Open SQL Server configuration manager and select the service of SQL Server instance. Right-click and click on the Properties option. After adding the startup parameter, click on the Apply button and then the OK button in the warning message window. Restart the SQL Server service to start SQL Server in single user mode.
FYI, there is no "default" password for SQL Server's sa account. It gets setup during installation, by you. If you didn't specify mixed mode authentication, then SQL Server is running in Windows Authentication mode, which means you cannot login using sa and a password.
If you want to change your 'sa' password with SQL Server Management Studio, here are the steps:
Change server authentication mode - Right click on root, choose Properties, from Security tab select "SQL Server and Windows Authentication mode", click OK 
Set sa password - Navigate to Security > Logins > sa, right click on it, choose Properties, from General tab set the Password (don't close the window) 
Grant permission - Go to Status tab, make sure the Grant and Enabled radiobuttons are chosen, click OK 
Restart SQLEXPRESS service from your local services (Window+R > services.msc)
193
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
