|Thank you, I tried that today. I tried these two connection strings:|
Data Source=10.200.362.22;Initial Catalog=WHLDATA;Trusted_Connection=False;User ID=username;Password=password
Data Source=10.200.362.22,1433;Initial Catalog=WHLDATA;Network Library=DBMSSOCN;Trusted_Connection=False;User ID=username;Password=password
In both cases I got:
failed to connect to server, login failed for username
I have repeatedly read the link you included in the past few days along with many others.
Are these connection strings trying to use sql server authentication?
I might need to setup a sql server user because I can't log directly on to sql server using this username and password with sql server authentication. It's what I use to log onto the server itself.
Plus, I want to distribute this solution to many customers so it would be better if each did not have to have a username/password embedded in the connection string.
But I will do it if it's the only way.