1 / 11

Ways To fix SQL Server Error 18456

If you want want to known more about this topic you are suggested to visit : http://www.sdrwins.com

williamluis
Download Presentation

Ways To fix SQL Server Error 18456

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ways To fix SQL Server Error 18456

  2. Go with the following post if you face error 18456 in your SQL Server. This error message usually noticed when the invalid login credential entered in server or have internal issues. From the post you will come to know how to determine administrative right to other user.Now, firstly login to SQL Server Management Studio, considering user don't have administrative permission to connect with server.

  3. Firstly you have to find out what type of user have right to SQL Server. Are you the user who installed SQL Server or the default administrator of the computer. To get list of user from machine (Assuming MS windows server 2012 or above) follow the steps.

  4. -> Launch Server Manager – Start – Click Server manager In upper right corner you will find 'Tools' option. Click on it and then 'Computer Management'.

  5. Now expend 'Local Users and Groups' which lies under Computer Management-System Tools and then choose Users You will notice 'Built-in account for administering...' under 'Description'. This is that account which has access to SQL Server. Try login to Windows using 'Built-in account for administering' then grant permission to the user you want to login to SQL Server. For further info:-http://www.sdrwins.com

  6. As you complete the above steps, you logged into Windows account having permission to connect with SQL Server, lets go and grant permission to the user.

  7. Again launch 'SQL Server Management Studio'and you should be able to Connect by clicking 'Connect' button. • Now you will get your log-in server name in left hand Expand your ServerName then Security → Right Click on Login → Choose New Login.

  8. Now a Windows appears on screen type 'User Name' to add as as SQL Administer. After this click on 'Check Names'. You can go with the advance option to select user from list.

  9. Now click on 'Server Roles' from the left pane and turn on the 'sysadmin' check box, then click OK.

  10. Now you can confirm that you have a rights. For this you have to double click on 'User Name' and by clicking Securables. • For details visit at:-http://www.sdrwins.com

  11. At last log out from Windows, login as user you just granted rights, hope all should work fine. • If you want want to known more about this topic you are suggested to visit : http://www.sdrwins.com

More Related