Posted my question here because I'm pretty sure it's less of a program problem and more of a Server problem.
I'm developing a C# program that will access a database on a server. If I run the program on my PC (the Server, Server-PC), it works fine.
Copying the programs to two other computers (tried it just one at a time, though) connected to my PC via network, and suddenly the program just fails to connect.
On a XP-based PC, the error message is "Login failed for user Server-PC\Guest"
Wwhile on a Vista based PC, the error message is "Login failed for user 'null'. The user is not associated with a trusted SQL Server connection."
This is my connection code:
\SQLEXPRESS;Database=GGDBase;Integrated Security=SSPI;Trusted_Connection=true;Persist Security Info=False;
Now, I don't know much about SQL Server setup, adding user permissions and the such, but I have done the following:
- Enabled the TCP/IP Protocol in the Server Configuration Manager
- Set the server to "SQL Server and Windows Authentication Mode"
- Allowed the program through the firewall.
Could I please have some advice on this? It simply won't work. What else could I do? Thanks to all who answered.
P.S. In case it is important:
- My Server is running Windows 7.
- The other two computers I used to try and connect are running Windows XP (SP3) and Vista. They are all connected to a network. Yes, they can share files with each other.
- I'm using the EXPRESS edition of SQL Server 2005.
- The program I am developing is a desktop application created in C#, so I doubt those "do something in IIS" solutions will apply.