SQL Server Database Connection Error


#1

Hi I need help connecting to my gearhost sql server database, I created a database in Gearhost, created a schema compare in visual studio since I don’t have SSMS and then successfully micrrated the schema and data over to my gearhost db. I then copied the connectionstring into my webconfig file but im getting a connection error. can anyone advise

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ‘amazondb2’.

Data Source=den1.mssql7.gear.host;User ID=amazondb2;Password=********;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False


#2

I believe you resolved this in chat. Do you mind posting your solution here for future users?