Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I had Management Studio 2011 Denali CTP1 installed before but I have uninstalled it.

Now I have installed the Management Studio 2012 SP1 Express without any database instances.

I have a webserver with a few SQL server instances, one of them was installed by the Denali CTP1 installer. I'm able to connect to it wothout problems with a Denali CTP 1 SSMS but not with the 2012SP1.

When I connect with SSMS2012SP1 I immediately get the error:

Invalid object name 'sys.database_filestream_options'. (Microsoft SQL Server, Error: 208)

Although I'm connected to the database (and able to create or modify users for example), nearly every item throws some error when I expand it.

For example expanding "Databases" throws:

Invalid column name 'synchronization_state'. (Microsoft SQL Server, Error: 207)

"Some authorization problem" - I thought. But after creating a new user and setting every possible right to it and trying to logging in with it, there is no difference.

I'm not able to figure out the problem.

I can access the database through code just fine, here is my connectionstring:

server\web11;Initial Catalog=a_database;Persist Security Info=True;Trusted_Connection=True;

So I figured that this is something Management Studio does.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

You'll want to upgrade the database to the full version of SQL Server 2012. I'm not surprised that the beta database engine doesn't work with the full release of the management tool. There's no guarantee that beta and RTM products will work together.

share|improve this answer
    
It's not that easy actually. I have said that 'I have a webserver' but I don't actually own it, and I'm not in the liberty to freely reinstall the SQL server instances. Installing SQL Server 2012 will also require licences not yet owned, so actually downgrading the database seems more possible. Still I don't want to touch the sql server instance if that is possible. –  SoonDead Mar 18 '13 at 15:46
    
@SoonDead: Soon there won't be a choice. sqlblog.com/blogs/aaron_bertrand/archive/2011/04/21/… –  Jon Seigel Mar 18 '13 at 17:12
    
Yeah, there's that problem as well. You're best bet will be to get a copy of the CTP1 bits from somewhere (god only knows where) and uninstall the RTM software from your machine and install the matching version's bits. –  mrdenny Mar 18 '13 at 19:41
    
@JonSeigel yes we have run into that issue. Luckily we have managed to dig up an old installer of the CTP1, installed an other database instance and a management studio, attached the databases, scripted them out and created them back on an SQL Server 2008 R2 instance. –  SoonDead Jun 9 '13 at 10:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.