Error 18456 Sql Server 2008 R2
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
Microsoft Sql Server 2008r2 Error 18456
About Us Learn more about Stack Overflow the company Business Learn more about microsoft sql server error 18456 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Login Failed For User 'sa'. (microsoft Sql Server Error 18456)
Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Unable to log in sql server 2014 error 18456 to server in SQL Server 2008 R2 Management Studio up vote 3 down vote favorite I have a SQL Server 2008 R2 instance and can log in using the sa user. But I want to define another user (administrator) to log in with SQL Server Management Studio, so I did the following: Logged in to the server in Management Studio as sa. Right clicked on login failed for user sa error 18456 the database name. Clicked on properties. Then under permission, I select the required username (administrator). And I grant him all the permission. But when I tried to log in using administrator, I got the following error: Login failed for user “administator” Error 18456. Can anyone advise what might be the problem? sql-server authentication sql-server-2008-r2 ssms share|improve this question edited Feb 15 at 1:57 J0e3gan 6,29493059 asked May 15 '14 at 1:11 John John 23231232 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted You need to add a server login: Connect to your SQL Server with SSMS as sa. Drill into the server's Security folder in SSMS's Object Explorer pane. Right-click on the server's Security > Logins folder that appears in Object Explorer. Click on New Login... in the context menu that appears. Provide details of the new login in the Login - New dialog that opens - particularly its General, Server Roles, and User Mappings pages (along the left). (See the screenshots of each page with sample input at the bottom of the answer.) You may need to add a database user depending on your needs
Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet
Ms Sql Error 18456
Blogs TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet mssql error 18456 Magazine TechNet Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud and
Login Failed For User 'sa' In Sql Server 2012
Datacenter Security Virtualization Downloads Updates Service Packs Security Bulletins Windows Update Trials Windows Server 2012 R2 System Center 2012 R2 Microsoft SQL Server 2014 http://stackoverflow.com/questions/23667670/unable-to-log-in-to-server-in-sql-server-2008-r2-management-studio SP1 Windows 8.1 Enterprise See all trials » Related Sites Microsoft Download Center TechNet Evaluation Center Drivers Windows Sysinternals TechNet Gallery Training Training Expert-led, virtual classes Training Catalog Class Locator Microsoft Virtual Academy Free Windows Server 2012 courses Free Windows 8 courses SQL Server training Microsoft Official Courses On-Demand Certifications https://technet.microsoft.com/en-us/library/ms366351(v=sql.105).aspx Certification overview MCSA: Windows 10 Windows Server Certification (MCSE) Private Cloud Certification (MCSE) SQL Server Certification (MCSE) Other resources TechNet Events Second shot for certification Born To Learn blog Find technical communities in your area Support Support options For business For developers For IT professionals For technical support Support offerings More support Microsoft Premier Online TechNet Forums MSDN Forums Security Bulletins & Advisories Not an IT pro? Microsoft Customer Support Microsoft Community Forums United States (English) Sign in Home Library Wiki Learn Gallery Downloads Support Forums Blogs We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Troubleshooting Troubleshooting Concepts (Database Engine) Troubleshooting Database Engine Connectivity Troubleshooting Database Engine Connectivity Troubleshooting: Login Failed for User 'x' Troubleshooting: Login Failed for User 'x' Troubleshooting: Login Failed for User 'x' Troubleshooting: Timeout Expired Troubleshooting: Connection Forcibly Closed Troubleshooting: No Process Is on th
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in https://www.youtube.com/watch?v=aU8RhjdkCoE 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 http://dba.stackexchange.com/questions/5971/sql-server-2008-r2-error-18456-state-12-nothing-i-find-helps-me verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ Microsoft SQL Server Error 18456 Login Failed for User BTNHD AbonnierenAbonniertAbo beenden24.19024 Tsd. error 18456 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 microsoft sql server unangemessene Inhalte zu melden. Anmelden Transkript 163.455 Aufrufe 841 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 842 20 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 21 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 06.08.2013Notes on SQL Server Error 18456http://goo.gl/NmpvKgHope you guys enjoyed. I really appreciate the feedback. Hit the like button & show support it doesn't hurt :)Windows 8 App (BJTechNews):http://goo.gl/54iBATech Blog: http://bjtechnews.orgTwitch.tv Channel:http://twitch.tv/bjtechnewsHere's how I get free Amazon Gift Cards:http://goo.gl/NkiRhhttps://www.copy.com/home/Tech Forum: http://bjtechnews.the-talk.net/Facebook: http://facebook.com/BJTechNewsTwitter: http://twitter.com/BJTechNewsInstagram: http://instagram.com/bj
log in tour help Tour Start 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 or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL Server 2008 R2 - Error 18456 State 12 - nothing I find helps me up vote 4 down vote favorite First off let me state that I'm not a DBA, I don't have access to a DBA, I'm just a programmer who has to get a CMS working. I'm generally pretty good at getting random servers working, but this is doing my head in. I have a trail of SQL Server 2008 installed, with a database that I imported from a backup. The CMS starts up, connects to the DB but tells me [SqlException (0x80131904): Login failed for user 'kentico'.] Checking the logs shows me Error: 18456, Severity: 14, State: 12. I googled it, and every answer has state 11 and 12 in lumped together, and I think I've done what is mentioned in the posts. but really im just stumbling in the dark. I don't even know what other information I can provide that will help people help me! I have created a user in in the \security\logins folder, and this login is mapped to a user of the same name in the \databases\