I have created a dev database in SQL Server and added a table in SSMS. I have created a .NET 6 application and created the database project and data project and now I am trying to import the database.
When I click select connection, it can find the database, if I select the Windows authentication option, it looks like it worked, but then the start button is greyed out.
If I select SQL Server authentication and try to use the login I have set up as db_owner in SSMS, I get this error:
Login failed 18456
I can login fine in SSMS as that login.
I am now stuck as to whether this is an issue with how I have set up the database and login user or whether this is an issue in Visual Studio. Please help!
I have checked that the login is set up as db_owner and systemadmin which it is.
I have also changed the default connection database for that user to the database rather than default or master.