I tried to be lazy, I have Stored Aliases for one of my database. E.g. Called “A”. From the same database Server I have several Database. E,g, Called “A”, “B” …etc.
Today I tried to load the Stored Aliases and tried to change the database by selecting Initial Catalog to use to “B” and then Click “OK” and CLick “OK” again on Connection String dialog box. Then I click Next all the way until the stage “Tables”, It still selecting the table from the Database “A”. I think it is something that could be improve. I tried again by on the Connecting stage, and click on “Test Connection” button. It seems to work fine (sometime). I think it may be easier as soon as the user click on the button on the “Connection String” dialog box and it will test the connection to make sure it refresh the selected database.
Please let me know if you want me to explain more.
I’d like to ask you some questions regarding the problem to be sure we take the same steps as you:
Do you reverse sql server 2000 or 2005?
Do you:
a) Select Alias, click Load Alias and then click the Previous button to get to the step Connecting
OR
b) Select Alias and click Next, Next… to the step Connecting?
Please see the attached screenshot of Data Link Properties dialog. Is it here where you change the database?
Do you change anything else here?
Do you enter the same passwords in the Data Link Properties dialog and the RE Wizard? (You can have db without a password…)
(I select the db - sql server 2000, test the connection, confirm password in the wizard, go to step Tables and appropriate tables are listed there.)