I'm trying to create a database on my local machine using SSMS version However if I try to create a db with this login I get the message.
Finally I note that the account 'sa' is disabled, and if I try to enable it I get the same error as before. Is there any way around this or do I need to re-install? I found the answer here :. You can also use the SQL Server Configuration Manager tool, which provides proper controls for the file access and other privileges. To use the Configuration Manager tool to recover your system, use the following steps:. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
Collectives on Stack Overflow. Learn more. Asked 8 years, 5 months ago. Active 1 year, 11 months ago. Viewed 52k times. Hi, We are getting the below error when we are trying to reset the password of 'sa' using a Security admin user. Error: Cannot alter the login 'sa' because it does not exist or you do not have permission. Thursday, October 13, AM. When you want to alter a different principal you need at least the same or higher permissions; and SysAdmin is already the role with the highest permissions.
Marked as answer by winoa Thursday, October 13, PM. Hello, To alter the "sa" account you need "System Admin" permissions, because "sa" is a System admin; "Security Admin" permission are not enough. I just give brief of my situation, I am running SQL server r2 in that around 8 database was created, it was running with no problem since 2 years, but recently i m getting issue like suddenly my entire database say any one complete database got deleted that means all tables of that database became blank.
DO you have any idea, how this cause is keep on coming from past 2 weeks. Please Note:- I am hosting one internal website in IIS server with windows server and sql server last 1 year or so currently and earlier. He holds a Masters of Science degree and numerous database certifications. Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service.
Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline. Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future. Leave new Imran Mohammed. Hoang Nguyen. Hi Mr Dave! I had abig trouble and need to explrore so much. I believe you missed a couple of items while installing SQL Server --missed clicking "Add current user" as the administrator and typing password for the "SA" user while on the installation wizard, which seems to have caused this.
Nevertheless, there are ways you can hack into SQL Server through back door if you're the local admin on the windows box where SQL is hosted. Once you are in, you can grant yourself sysadmin rights and then you'll be able to log in using SSMS normally as the sysadmin user. Another not-so-good approach only if you're working with a brand new instance is to reinstall SQL instance and this time make sure to add "sa" password to allow mixed authentication and add yourself as the admin on the installation wizard.
Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way. Tried to logon with my password and also leaving it blank, but none of these options worked for sa. My fault. I was connecting to the company server. My server was not showing up because it was set to be Stopped when I start the computer.
0コメント