Trying the following connection string:
Data Source=.\SQLEXPRESS;Initial Catalog=Octopus;Integrated Security=True
On “Save and Test” I get
Octopus Configuration
Error connecting to the database: Login failed for user ‘’.
OK
I am a domain user, not a regular user, if that helps. (I also tried the user and password instead of integrated security, same error message.)
Data Source=.\DEV;Initial Catalog=Octopus;Integrated Security=True;MultipleActiveResultSets=True
It works for me. Have you created empty database ? Do your user have permission to access that Octopus database?
Yes to both; I could connect to it from within Visual Studio without any problem.
HOWEVER - the error happened while running the server tools on the initial install. I tried running the program again, to add the MultipleActiveResultSets setting, which I didn’t have, and it works both with it and without it. I don’t know why… anyway, problem solved
Does it work if you use:
…Integrated Security=SSPI
?
I tried that during the install, but it didn’t work. However, as I said, after I closed that window and re-launched the program about 20 minutes later, it suddenly worked. I have no idea why, unfortunately.
I had similar problems, a restart helped me too…
Aha, the restart issue was caused by the connection string being cached It’s fixed in the latest build: