Error 15151 Sql Server
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers sql server error 15247 or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Microsoft Sql Server Error 15151
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them;
Sql Server Error 15535
it only takes a minute: Sign up sql server 2012: cannot alter the login sa up vote 2 down vote favorite 1 I'm trying to create a database on my local machine using SSMS version 11.0.2100.60. I've run the application
Sqlserver 15151
as administrator, logged in using Windows authentication, and I've added MYDOMAIN\my-username to the Logins. However if I try to create a db with this login I get the message CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) If I try to add the privelage dbcreator to my user, I get the following error. User does not have permission to perform this action. (Microsoft SQL Server, Error: 15247) I can't log in as sa as I don't msg 15151 level 16 state 1 line 1 cannot find the object know/remember the password (is there a preset default?), and if I try to change the password I get the message: Cannot alter the login 'sa', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15151) 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? Version info: Microsoft SQL Server Management Studio 11.0.2100.60 Microsoft Analysis Services Client Tools 11.0.2100.60 Microsoft Data Access Components (MDAC) 6.2.9200.16384 Microsoft MSXML 3.0 4.0 6.0 Microsoft Internet Explorer 9.10.9200.16635 Microsoft .NET Framework 4.0.30319.18051 Operating System 6.2.9200 ssms sql-server-2012-express share|improve this question asked Jul 22 '13 at 13:27 tdc 2,33042351 Try running SSMS as administrator –gerrytan Jun 17 '14 at 2:37 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted I found the answer here: In order to start SQL Server in single-user mode, you can add the parameter “-m” at the command line. 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: Open the Configuration Manager tool from the "SQL Server 2005| Configuration" menu Stop the SQL Server Instance you need to recover Navigate to the
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: ALTER LOGIN for "cannot alter the user" "because it does not exist or you do not have permission" SA fails with 15151 error SQL Server 2005 SQL Server > recovering sql server password SQL Server Manageability Question 0 Sign in to vote I need to change the password for the cannot alter the server role 'sysadmin', because it does not exist or you do not have permission. SA account on a SQL Server 2005 instance using TSQL. I can change the password using Management Studio if I select the "Map Credential" option but this http://stackoverflow.com/questions/17788853/sql-server-2012-cannot-alter-the-login-sa needs to be done via an automated process so I have to use TSQL. SMO isn't viable and I've not tried it since I have instances ranging from SQL Server 7.0 to SQL Server 2012. The exact error text is: Msg 15151, Level 15, State 1, Line 1 Cannot alter login 'SA', because it https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8106b8bb-90de-46ec-908f-c618283f45ae/alter-login-for-sa-fails-with-15151-error-sql-server-2005?forum=sqlkjmanageability does not exist or you do not have permission. I've tried several different syntactical variations of the ALTER LOGIN command but without success. It is supporting a commercial application so I can't really afford to experiment with altering server settings. Can someone offer the correct way to change the SA password via TSQL? Edited by Ira Davis Wednesday, April 10, 2013 3:02 PM Wednesday, April 10, 2013 2:57 PM Reply | Quote Answers 0 Sign in to vote After some additional exploration, it looks like I can use SMO. None of the instances I need to automate the password change on is lower than SQL Server 2000 and the ChangePassword method of the Login object works on versions 2000 and above. Using SMO simplified the code in that I no longer need to connect use a SQLCommand and submit TSQL. For anyone else needing to do this here isbrief Powershell function to accomplish the task. Function reset-sapwd([string] $instance, [string] $password) {
up http://www.sqlservercentral.com/Forums/Topic1242004-391-1.aspx Recent PostsRecent Posts Popular TopicsPopular Topics Home https://www.youtube.com/watch?v=uSmjWcREgC4 Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 - General » Unable to login to SQL Server Unable to login to SQL Server Rate Topic Display Mode Topic Options sql server Author Message SaggySaggy Posted Thursday, January 26, 2012 3:03 AM Valued Member Group: General Forum Members Last Login: Monday, April 21, 2014 12:41 PM Points: 65, Visits: 234 Hi guys......I have Windows Authentication but at the time of changing password it porompts the following error:TITLE: sql server error Microsoft SQL Server Management Studio------------------------------Change password failed for Login 'sa'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Change+password+Login&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Cannot alter the login 'sa', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15151)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=15151&LinkId=20476------------------------------BUTTONS:OK------------------------------Also "sa" is disable.Reply.........thnx Post #1242004 Koen VerbeeckKoen Verbeeck Posted Thursday, January 26, 2012 5:17 AM SSCoach Group: General Forum Members Last Login: Thursday, October 6, 2016 2:02 AM Points: 15,414, Visits: 13,137 Why are you trying to change the sa password if you have Windows Authentication?The sa login is used with SQL Server Authentication. How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?Member of LinkedIn. My blog at SQLKover. MCSA SQL Server 2012 - MCSE Busine
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ Reset SA password in SQL Server Barlet Hamzai AbonnierenAbonniertAbo beenden2424 Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Transkript Statistik 38.656 Aufrufe 34 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 35 0 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 1 Wird geladen... Wird geladen... Transkript Das interaktive Transkript konnte nicht geladen werden. Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 04.06.2014In this video you will see how to reset your SA (System Administrator) password in SQL server by using very simple query or using GUI of SQL Server Management Studio... Kategorie Bildung Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Anzeige Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video How to recover SA password on Microsoft SQL Server 2008 R2|| Forgot Password For Sql Server Recovery - Dauer: 5:35 Skytuts 87.437 Aufrufe 5:35 Recover SA Password for SQL Server 2005 / 2008 / 2012 / 2014 - Dauer: 2:47 Ting Xiao 6.85