I am trying to test the deployment of the security tables to my test server from which the application runs.  I setup a profile in the DDT, then began the wizard.  After selecting Role Based Security Type for the DDT, I was then asked about the source DB.  Of course, this is the local SSE2005 database used only by my development environment.  That was no problem.  When I go to the next window, I am asked about the destination database.  The drop down list is not populated.  I cannot choose anything.  I clicked finished anyway (knowing I would get an error) and I received an error box with the typical object not found error.  I clear the error window and now I am stuck on the wizard.  I cannot cancel, break, esc or anything.  Time to kill the process.

What do I need to do to fill that list of potential destinations?

Thanks,
Bill

SQL server doesn't care about casing. So...



Use master



and



Use master



both work.

Actually, the defaults were changed on your server to be case sensitive...this is generally a bad idea.  There are certain developers out there that swear by case-sensitive SQL Servers, but it can complicate things, as you have learned.  When you install SQL Server, by default, it will assume Case-Insensitive.  You can change this through the SQL Server Management Studio, but this is what is happening to you...good eye

The old SQL Server on which I placed the app data is one of the original RDBMSs in our company.  It started at v7 (maybe even 6.5!) and one of the requirements by the software that we bought it for was case-sensitivity.  It is often a headache to work around.  That is why I got a second SQL Server to do the other heavy lifting.  The main app data will have to reside on the old one, unfortunately.

Jeesh, I completely forgot about that option.





I certainly understand swearing at developers who turn this option on...