Create SQL Server Deployment script using database publishing wizard

Question

I'm getting the following error when using the Database Publishing wizard to script a SQL Server Express database for deployment. I have googled for hours unsuccessfully. Anyone had this isssue or know how to solve it?

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

Answer 1

Is the database held remotely? - Have you checked firewall settings...?

The error is what it says it is...it's timed out trying to connect.

Make sure you can connect via other means (SQL Management Studio, the app itself). Check the connection string, even try copying the database locally and scripting it that way.

Answer 2

So I downloaded the latest Database Publishing Wizard and it seems to work :-)