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

Well, I thought it was simple.  Another error has popped up.  The server is telling me that it is refusing connections.

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

This doesn't make much sense.  It is a 2K server and name pipes are the active protocol and there is no limit set on connections.  Also, how could I deploy the database, but not be able to access it?

Interesting!
Bill

Solved. 

It had to be in the data source string.  So, after reviewing it, I realized that the instance name was not represented properly. 

Wrong: Data Source=SERVER/INSTANCE

Right: Data Source=SERVER\\INSTANCE

Hey, what's a back slash between friends?

Bill

LOL...glad you found your problem