![]() Keep in mind that this will remove the instance completely, so if you'd make any changes to that instance, you wouldĪfter uninstalling the SQLEXPRESS instance, you can reinstall it again, this time selecting the correct admin settings for your needs. See other SQL Server entries in Add/Remove Programs, but uninstalling the "SQL Server 2008" entry first will remove and dependencies. There it will ask you what you want to uninstall and you can select the SQLEXPRESS instance. Basically, you go to Add/Remove Programs, select the entry for "SQL Server 2008", and click uninstall. 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. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |