NoCoolHandle
Programmer
(bottom line - [red]don't use[/red][blue] trusted_connections=yes[/blue] and [green]do use[/green] [blue]integrated security=sspi[/blue] in your connection strings!)
a story from the trenches.....
Yesterday I experienced an interesting situation when setting up a server that was about to be deployed. The server hosts a suite of applications that all talk to a local instance of SQL server.
After changing its IP address and subnet mask for the remote site, we booted it to test the apps.
To my surprise one of the apps behaved like there were no records in the database for it. I ran some queries and tests with the OSQL tool, everything looked normal. I went back to my desktop and stepped through my code. Everything looked good for system in question.
However this single app kept misbehaving. Thinking about an error I saw on the server boot (about a duplicate IP address on the network) I changed the ip to DHCP and rebooted the system.
To my surprise (slight and happy) the application in question found records.
The only difference in the apps, is that in the connection strings, the ones that work had [blue]integrated security=sspi[/blue] and the app that wasn't had [blue]trusted_connections=yes[/blue].
I guess if there were a moral to this story, it would be this.
Use the new arguments, and don't rely on the stuff that has worked for years. and Just because all the docs say something, doesn't make it true.
(just look at the Wright bros myth - some people still think they were the first to fly!)
For what it is worth
Rob
a story from the trenches.....
Yesterday I experienced an interesting situation when setting up a server that was about to be deployed. The server hosts a suite of applications that all talk to a local instance of SQL server.
After changing its IP address and subnet mask for the remote site, we booted it to test the apps.
To my surprise one of the apps behaved like there were no records in the database for it. I ran some queries and tests with the OSQL tool, everything looked normal. I went back to my desktop and stepped through my code. Everything looked good for system in question.
However this single app kept misbehaving. Thinking about an error I saw on the server boot (about a duplicate IP address on the network) I changed the ip to DHCP and rebooted the system.
To my surprise (slight and happy) the application in question found records.
The only difference in the apps, is that in the connection strings, the ones that work had [blue]integrated security=sspi[/blue] and the app that wasn't had [blue]trusted_connections=yes[/blue].
I guess if there were a moral to this story, it would be this.
Use the new arguments, and don't rely on the stuff that has worked for years. and Just because all the docs say something, doesn't make it true.
(just look at the Wright bros myth - some people still think they were the first to fly!)
For what it is worth
Rob
