when the application wants to connect(ms sql serever), it shows this disturbing error
<< login failed for user ...>> or somthing like it that depends on connection string
As you know each computer has a different name ,
I've create the user name and pass( sql ) on client computer (should i do this for each client?)
,but the error occurred.
what do you suggest to fix it, and runs on each computer?
Hirendra SisodiyaPosted Apr 12, 2010, 1:25 AM
can you tell me that what is your connection string....
ok...try this connection string:
string SqlConnStr = "user id=" + userid + ";password=" + Password + ";Initial Catalog=" + Database + ";" & "Data Source= " + Environment.MachineName + "";
if you have any problem, tell me in detail...
thanks
Please mark as answere if it helps