This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I recently uploaded my files and folders. Everything was working fine until I tried to create a new account on the site, but I got an error that says "Login failed for user ..........."
Please how do I solve edd
"Login failed for user "Sammy user"
The error message mean, that the user connecting to SQL Server (with the used connection string) don't have permissions to logon.
So check you app which SQL login is used, create the login on your cloud SQL Server and grant permissions for it.
Do you mean to check my website the SQL login used?
It's SQL Server Authentication login
And the credentials are correct; I reviewed it.
So should I create a new user for the database on plesk, and use the new user login details and include in my connection string?
How do I login to my live SQL server and grant permissions for user?
I please ask for directions and guidance
Check the SQL Server errorlog, where you find more details about why the login failed.. An easy way to access the errorlog is to run xp_readerrorlog.
I have finally found the answer to the issue "Login failed for user 'quirverT'.
In my connection string I copied the password exactly as it were with the asterisk. I initially thought that the asterisks in the password represented the exact database user password. So I had to remove the asterisk and typed-in my user password, and it connection. I was able to insert record into a database table.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Donald Symmons ,
Welcome to Microsoft Q&A!
Here is a detailed article about error 18456: https://www.liquidweb.com/kb/troubleshooting-microsoft-sql-server-error-18456-login-failed-user/
Please follow the steps of checking in the article.
Hope you can get some help from this.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
I recently uploaded my files and folders
To where?
Login failed for user ..........."
When do you get the error and what's the complete error message?
That's really to less on information and no one could guess what's one, so please provide (much) more details about the situation and what happens when.
I created MSSQL database on my plesk account and imported my local database.
After uploading my files, my website was live. I then tried to create a new user account on my site, I got the error
"Login failed for user "Sammy user"
Does this mean that a visitor to my website will it be able to create a new account and login? Is it only the user created for the MSSQL database will be able to create new user account on my website ?