Error in signing up in my website

Question

I recently uploaded my website files and MSSQL database to plesk. and when I opened my site in a browser it opened perfectly. I then tried to create a new account which will insert my data into the database, but I got an error which states:

Server Error in '/' Application.
Login failed for user 'quirverT'.

Please forum, I need your help on this. how do I resolve this issue?

Here is the connection string I used to connect to the database; may I please know if its correct the way I use it?
am I to use or include username and password?

(SqlConnection con = new SqlConnection ="Data Source=N1NWPLSK12SQL-v02.shr.prod.ams1.secureserver.net;Initial Catalog=Quirver_DB;User ID=quirverT;Password=***********");

here is a screenshot of the error
]1

Answer 1

Hi @Donald Symmons ,

Please use SSMS to connect to your SQL server instance. Then check whether the login quirverT is existed under SQL server security login folder. Your SQL server instance has been enabled SQL server authentication. Right click SQL server instance, click security properties. You need to restart your SQL server service to make this change effect. And this login has permission to connect to SQL server instance.

> SqlConnection ="Data Source=N1NWPLSK12SQL-v02.shr.prod.ams1.secureserver.net;Initial Catalog=Quirver_DB;User ID=quirverT;Password=***")

You have some mistakes in your connection string, we use IP address, port number or instance name for data source. Please correct it, refer to this blog SQL Server connection strings. Such as below;

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;  
Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Login failed for user 'quirverT'.

A clear error message, the SQL login 'quirverT' don't have permission to logon to the SQL Server.
Make care that SQL Server is running in Mixed Mode = Win+SQL Auth, the SQL login exists, have permissions to logon and permission to access the database in mind.