Error 18456 Sql 2008
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 error 18456 sql 2008 r2 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask sql server error 18456 severity 14 state 5 Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join sql 2008 error 18456 state 1 them; it only takes a minute: Sign up Unable to log in 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 sql 2008 error 18456 state 38 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 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”
Sql 2008 Error 18456 State 11
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, but a server login (like your sa login) is necessary to connect to the SQL Server instance using Windows or SQL Server authentication. Mapping the new login to a database user (in the Login - New dialog's User Mappings page) will create a new user in the mapped database if you specify a username that does not already exist; alternatively you can map the new login to an existing database user. Another SO question speaks to the differences between server logins and
Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs
Sql 2008 Error 18456 Sa
TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet sql 2008 error 18456 state 58 Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud and Datacenter Security sql 2008 error 233 Virtualization Downloads Updates Service Packs Security Bulletins Windows Update Trials Windows Server 2012 R2 System Center 2012 R2 Microsoft SQL Server 2014 SP1 Windows 8.1 Enterprise http://stackoverflow.com/questions/23667670/unable-to-log-in-to-server-in-sql-server-2008-r2-management-studio 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 Certification overview MCSA: Windows 10 https://technet.microsoft.com/en-us/library/ms366351(v=sql.105).aspx 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 the Other End of the Pipe Troubleshooting: Login Failed for U
360 games PC games https://support.microsoft.com/en-us/kb/555332 Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators https://katieandemil.academy/microsoft-sql-server-error-18456-login-failed-for-user Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet error 18456 Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All sql 2008 error Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
you how you may be able to resolve it. Contents 18456 Error Overview Before you dive in Potential causes SQL Server Authentication not enabled Invalid login name Invalid password Common reasons State 1 explanations 18456 Error State List 18456 Error overview When connecting to Microsoft SQL Server and trying to use usually SQL Authentication method you may get event IDerror 18456 login failed for useryou provided. See below example. This usually means that your connection request was successfully received by the server name you specified but the server is not able to grant you access for a number of reasons and throws error: 18456. This eventID sometimes provides also state 1 which actually isn’t that useful as due to security reasons any error is converted to state 1 unless you can check logging on the server. Microsoft does not provide very useful message boxes so below are some explanations why you get the error. Want to easily improve your SQL Server Skills? Before you dive in If you are NOT a DBA (Server Administrator) then read this. We had a number of online private chats using our website chat feature and we have identified there are a number of situations where you cannot do anything about it! We are aware some of you might be very new to this so I will provide you with simple list of questions or steps to check if you are in the 'cannot do anything about it' group. Before you start "fixing" it please go through the list below: Are you the person managing the server or the person who installed sql server (e.g. personal pc/laptop)? If no or you don't know, then there is a high chance you don't have permissions to fix it. What does it mean? It means you can only do what you are in control of (typing username, password) or trying steps that don't involve changing server configuration. If nothing works contact your server administrator (DBA). Are