problem connecting to sql server when I run from another PC

[Alpha]

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

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

[Alpha]

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

"Oleg Kap" wrote:

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

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