Log In Failed for User '' The user is not associated with a trusted SQL Server connection
Well, that's the full title of my problem.
I'm working on a C# program that supposedly could access a database run by SQL Server Express. I know the program works, because it works on the PC where I installed the SQL server. If I run the program from another PC on the network, though, the error happens.
Here's my connection string:
\SQLEXPRESS;Database=GGDBase;Integrated Security=SSPI;Trusted_Connection=true;Persist Security Info=False;
Variations include removing the Trusted_Connection, setting Trusted_Connection to 'false', and removing Persist Security Info. I also set the SQL Server Express authentication to 'Mixed' mode, and enabled the TCP/IP stuff. All return the error I noted above.
(The program adds the Computer name before the "\")
Some people say "add a username / password something something" while others say "add User Instance=true" (which has its own problems). All involve dealing with a very user-unfriendly SQL Server management program, and if I have to do it, I can imagine anyone who wants to use the program will have to fiddle with SQL Server as well. So, as you can guess, user-friendliness is a requirement, and typing in IP addresses and port numbers are out of question.
Is there some way I can resolve this problem via codes in C#? Perhaps I can add user instances from C# itself, or something?
Thanks in advanced.
Edited 5 Years Ago by zack_falcon: n/a