BIDS Not saving connection manager setting

Last Post 14 Jan 2010 12:44 PM by QuestionGuy. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

14 Jan 2010 12:44 PM
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?


Acceptable Use Policy