SQL SERVER SA ACCOUNT DEFINITION INSTALL
SQL SERVER SA ACCOUNT DEFINITION WINDOWS

From the sounds of the thread, this may be a possible option for you. Would want to backup any database objects that you've created on this instance.

SQL SERVER SA ACCOUNT DEFINITION INSTALL

If the answer is yes to these, one option would be to uninstall your Express instance and reinstall it again, this time selecting the admin users during install and also setting the sa password during install. A few questions:ДЎ) Did you perform the install for this Express instance?Дў) Are you the only one using this Express instance? Essentially you're in a spot where you've locked yourself out of the database (from a sysadmin perspective)ДЄnd the link Rick supplied has workarounds. The signs are pointing to the permissions issue that Rick pointed out, but I was hoping to find a somewhat simpler solution to get the problem solved. During installation, there is a button to 'Add Current User' to the SQL Server admin group, which would have eliminated the need to run this step. You should be able to run the script above to enable sa. Once you add your account to the sysadmin role, This assumes that your account is a admin on the local machine.

SQL SERVER SA ACCOUNT DEFINITION WINDOWS

Replace the string with your domain and user account that you are using to log in through Windows Authentication. If not, can you run the following script: EXEC sp_addsrvrolemember '', 'sysadmin' Did you happen to add any accounts there as admin accounts? If so, you can log in using one of those accounts and run the script. Where you supply the authentication method and also supply the users who will have admin rights on the instance. When you install SQL Server, there is a screen In order to enable the sa account, you need to be logged in to the instance using an account that has system admin permissions. This sounds like a permission issue with the currently logged in user. This can be beneficial to other community members reading the thread. Please remember to click 'Mark as Answer' and 'Vote as Helpful' on posts that help you. This posting is provided 'AS IS' with no warranties, and confers no rights. Using the sa account you've just enabled. After doing so, restart theВ SQL Server service and from then on you'll be able to connect either through Windows AuthenticationВ using your Windows account (as you seem to be now) OR SQL Authentication This will execute the query to enable the sa account and set the After changing the text, click on the Execute button (F5 keyboard shortcut). Replace the string with a strong password to use for your sa account. Click on 'New Query' to open a new query window and paste in the following TSQL syntax: ALTER LOGIN sa ENABLE It sounds like you are connected to your instance (SQLEXPRESS) through SSMS.

Sql server sa account definition