In in BIDS and have 2 connections in the Connection Manager tab. All I want to do is point the connections to a different server by changing the servername property. One the first connection, I simply type in the new server name. On the second connection, I type in the servername, but when I click my mouse off the property, it goes back to the old value. This same behavior occurs whether I try to edit the servername or initialcatalog setting. It occurs when I type it in, or when I try to edit the connection string, or when I try to select a different server in the connection window. I see absolutely no reason why it changes in one connection but not that other.
Is something bound that will not allow me to edit these editable settings?