problem connecting to sql server when I run from another PC

[Guest]

Hi, I'm working on a window based application. It's running just fine from
my machine where the SQL server is installed. I tried running from another
PC on the network by creating a shortcut to the application's .exe file and I
got error message about not alble to access SQL server because user 'null'
and that it's not a trusted connection. Can someone tell me how to correct
this problem?

string conStr = @"Server=Support\NetSDK; user id=tis;
password=tis;Integrated Security = SSPI; database = VMS";
conDB = new SqlConnection(conStr);

Thanks, Alpha

 

[Oleg Kap]

Hello Alpha,
Try following:
1. Make sure that Support machine is visible from the server you running
your application from.
2. Remove "Integrated Security = SSPI;" from connection string.
3. Make sure that 1433 port is not blocked ( by firewall ot other software)

Hope it helps,
Oleg

 

[Guest]

I removed the "Integrated Security = SSPI;" and it works. Thank you.