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
QuestionGuy
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?

Thanks


Acceptable Use Policy
---