Chapter 13 SQL problem

harvazad · October 28th, 2016, 07:22 AM

Hi,

I seem to be having a problem after the exercise on page 471. When I create a new review it seems to update the reviews table which I can see in the server explorer on VS2015. However when i try to load the PlanetWrox db in MSSM2012 it doesnt load up and i get the message that says:

"TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
Property Collation is not available for Database '[PlanetWrox]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)"

OR THIS:

"TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
ADDITIONAL INFORMATION:
The database 'PlanetWrox' cannot be opened because it is version 852. This server supports version 706 and earlier. A downgrade path is not supported. (Microsoft SQL Server, Error: 948)"

I think it's something to do with the versions and that everytime VS2015 updates the table it affects something with the versions.

Has anyone else had this problem?

Thanks

Harv

Imar · October 31st, 2016, 10:36 AM

Hi Harv,

Sounds like you're running two different versions of SQL Server against the same database. 706 is SQL Server 1012, while 852 is 2016.

The following might help:

http://sqlserverbuilds.blogspot.nl/2...-versions.html
http://stackoverflow.com/questions/2...er-supports-ve

Cheers,

Imar

harvazad · November 5th, 2016, 10:41 AM

Thanks Imar,
Not sure what is going on with my machine. I seem to have a SQL Server 2016 installation from somewhere. I don't remember installing this unless it got installed with SSDT with VS2015. I've tried using the database provided with the download resources but everytime VS2015 goes anywhere near it, it tries to convert it and then it becomes unaccessable through the SSMS2012.

Really confused!!!?? :-(

Imar · November 6th, 2016, 07:44 AM

Try uninstalling the 1016 Express version and then install Express 2012. Alternatively, install 2012 Express side by side (you need to give it a new instance name during installation) and then in VS configure the express version to use under Tools | Options | Database Tools | Data Connections.

You also need to update your connection strings in web.config.

Another alternative is to skip Express altogether and point to your 2012 server in all your connections and connection strings.

Cheers,

Imar

harvazad · November 7th, 2016, 07:56 AM

Cheers Imar,

I'll give it a go.

Harv