koobas.hobune.stream
Can't connect to SQLServerExpress from unity2020.1
I read all the other answers but sadly they do not answer my question.
some of them bypass it by moving to a different server.
some of them are unanswered.
my situation: my connection string is simple and works on several c# projects already:
using (SqlConnection connection = new SqlConnection(@"Server=.\SQLExpress;Database=MyDB;Trusted_Connection=True;"))
{
// if open then the connection is established
connection.Open();
as I said this works on all the other projects, but not in the unity project. I checked the SQLServer logs (with all attempts logged), and it writes:
Login succeeded for user '------\User'. Connection made using Integrated authentication. [CLIENT: <local machine>]
but then nothing... happens. with my usual projects this happens:
Login succeeded for user '------\User'. Connection made using Integrated authentication. [CLIENT: <local machine>]
Starting up database 'MyDB'.
Parallel redo is started for database 'myDB' with worker pool size [2].
Parallel redo is shutdownfor database 'myDB' with worker pool size [2].
so for some reason.... connection successful, but then its killed. not sure what to do. also tried loading the server on a specific port, doesnt work.
