Unable to add new sessions - SQL Server

Let us start with comparing your DB schema to make sure all is good.

File -> Data Sources -> Upgrade (tab) -> Email Schema to Support

Please add "Attn: Stefane" to the message body.

I will analyse the schema and get back to you.

Best regards,

Done, thanks Stefane :)

Jonathan,

Your database schema is missing many things:
- all defaults
- all primary keys (tables are not heaps)
- all indexes
- all triggers
- all viewsSomething must have happened to your database in the last few days. Usually we see this when a database is moved/scripted using third party tools or SSMS and some options are left unchecked.

I will send you a compared report via private message of what is missing. Check with your DBA to see if they can help you.

You have a few options, each option has pros/cons:
1-restoring from backup
2-create a new DB, export from old & import into new
3-re-create missing schema objects using compare scriptBest regards,

Thanks Stefane,

This makes sense. We moved from Amazon's RDS service, to a fully-hosted SQL Server instance, and since RDS will not allow you to create physical backup files, I moved the database using SSMS. I did not appreciate that this would cause problems.

I think Option 2 looks like the best choice for this situation.

Keep in mind that with option #2 you will lose users & user specific settings. But since you've just moved the DB using SSMS scripting chances are you've already encountered this situation.

You can follow this: http://help.remotedesktopmanager.com/index.html?tipsandtricks_data_migration.htm

Best regards,

The weird thing is, we've been using it without any issues for over a month! I think we just never noticed a problem because we hadn't tried to add any new sessions for a while.

Thanks for the assist.