In my webconfig and in the web pages I have the connection string.
connectionString="server=(local);database=Kansascity;trusted_connection=true" and this works fine
When as during creating a dataset to use what is in webconfig I choose yes. However the connection string it puts on the dataset is
connectionString="Data Source=(local);Initial Catalog=Kansascity;Integrated Security=True"
This shows up as a problem on the webservice using the dataset which gives a login error. I can seem to figure out why its making this connection string or how to change it. Also don't know why it isn't working when the test in query builder are fine.
View Complete Post