Unable to reconnect to database: failed to load string for error 658 when deploying to SQL Server 2012 SP1

Question

Hi,

when I try to deploy to our new SQLServer 2012SP1 server I get this error:

"Unable to reconnect to database: failed to load string for error 658 [...]"

According to some internet research error 658 has to do with increased partitions :

"Could not enable support for increased partitions in database '%.*ls' because %S_MSG."

On MSDN it says that this is enabled by default in SS2012 and the stored proc to enable it should no longer be used. Seems like a bug?

Answer 1

Can you connect to the database manually in SQL Server Object Explorer or via SSMS?

Thanks,

Janet Yeilding

Answer 2

Yes. The connection test is also successful in Visual Studio. I'm using VS2012 with the November SSDT and all the other updates.

Also the error appears almost immediately, so no timeout.

Answer 3

Does publishing an empty database project to the server result in the same error?  If not, can you pass a minimal repro from your project to recreate the issue?  Also please confirm whether or not it occurs when the advanced publish setting "Ignore partition schemes" is enabled.

Thanks,

Janet Yeilding

Answer 4

Ignore partition schemas has no effect. Will try the empty database tomorrow.

Answer 5

Ok turns out this is fairly easy to reproduce. It happens when your solution target is set to SQL server 2008 and you try to deploy to SQL server 2012. I can't change my solution target because our production servers are still on SQL server 2008. Can this be fixed?

Answer 6

Thanks for clarifying the repro.  SSDT doesn't make guarantees about the deployment to a target server that is different than the platform specified in the project.  If the platform is incompatible, it may or may not work.  You can uncheck Allow incompatible platform in the Advanced publish settings if you wish to block in this case.

Answer 7

Ok, I would certainly appreciate a better error message than "error 658" though ;)

Answer 8

I tried again after setting the target to SQL server 2012. And it still doesn't work if you reference any dacpac file. The referenced dacpac file also has the target set to SQL server 2012. I can send you a sample dacpac file if you want, but a dacpac file created from an empty db project should already do the trick.

Answer 9

Are you getting the same error or a different one?  Also, please elaborate on the structure of the project(s)-- what kind of reference is it (Same database, different database, etc)?

Answer 10

Same error. The reference is same server, different database.