SQL Server 2012 Support

Question

Hello,

Anyone know if an update will soon be ready to support SQL Server 2012?

Regards!
Victor Alameda

Answer 1

Hi,

It is suggested you raise a feature request for the support of the new sql server version:

How to request a Feature
http://social.msdn.microsoft.com/Forums/en-US/wspdiscuss/thread/e8d18b28-d828-469e-a585-f1606528b2b3

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 2

You can do it by yourself. This is just a guess (on the other hand I'm 90% it will work) but I think changing only SQL Server version for detecting SQL Server in SQL Server provider source will do the trick (of course you will have to compile it and upload to WSP Server bin directory too).

Answer 3

Simply a case of amending line 127 of the DatabasePage.cs file located at:

http://websitepanel.svn.sourceforge.net/viewvc/websitepanel/WebsitePanel.Installer/Trunk/Sources/WebsitePanel.Setup/Wizard/DatabasePage.cs?view=log

Change to:

if (!sqlVersion.StartsWith("9.") && !sqlVersion.StartsWith("10.") && !sqlVersion.StartsWith("11."))

I just tried but I have never worked on this code before and got so many build errors that it will more time than I have available to setup my environment; if any other developer who is already configured to build this code could make this extremely quick change then we could use WebsitePanel on servers that have SQL Server 2012 installed. Anybody?

Thanks.

Answer 4

Have just tried on a test server upgrading SQL server 2008 that was working with WebsitePanel to SQL Server 2012.

At first did get a few exceptions thrown in Websitepanel when creating a database, but for some odd reason after creating the first database user from websitepanel it began to work.

I guess more testing would need to be done, but does look like the SQL Server 2008 provider can work with SQL Server 2012 with a little tweaking.

So it looks like the work around for the moment is install SQL Server 2008 R2, get it to work with WebsitePanel, then upgrade SQL Server 2008 R2 to SQL Server 2012.

Answer 5

Have been doing some more testing and although it did initially work keep getting exception errors in websitepanel adding databases and users. Although the database or user is created in SQL Server 2012, websitepanel throws an exception error and does not add them in the control panel.

Also there are allot of other errors for example if you try and truncate the database you get the following error:-

'TRUNCATE_ONLY' is not a recognized BACKUP option

It looks like more work would need to be done to the SQL Server provider other than just getting it to see SQL Server 2012.

Answer 6

Thanks for the effort, think we'll live without WebsitePanel for the present - SQL Server 2012 is a more important requirement for us on the server we're currently configuring. Would definately like to see it supported ASAP though, as it will limit our ability to migrate and upgrade other servers.

Answer 7

Common guys, we all need 2012 support !
Please vote:
http://websitepanel.codeplex.com/workitem/156

Answer 8

JimJamm - there is an open fork open for SQL support. You could help the creator test his build and make sure it works. Comment on the Work Item. The only way we will get the things we all want is by working together, otherwise it will not happen. The only benificiaries of WSP is ourselves. I updated the exchange module without any programming experience. I wish I would see more of you do the same instead of asking for these things of an invisible person who doesnt exist =) I am here to assist all of you on any questions you might have on the contribution process and help you get any additions evaluated and merged if they are good and benifit everyone.

At the current rate SQL 2012 will be in Beta soon, so we really just need testers.

Omar

---

Omar Armenteros Virtuworks

Answer 9

Sorry for my ignorance,

How can i help to move it forward when nobody is assigned to it?
Willing to help, just need guidance..

I am unsure exactly what the fork means.

Will have a 2012 (live but not in production) server up this week, so if i can help testing if needed.

Its not obvious who to contact with results or feedback, especially when the issue is not assigned?

Thanks m8.

Answer 10

It is not assigned because the contributor has not signed a CLA yet but it is in the process. We will only assign tasks to Developers who have signed CLA agreements with Outercurve Foundation. It's like checking someone's ID before I commit their code to Main branch =) Please download and compile this fork:

https://hg.codeplex.com/forks/portada/mssql2012

You can also write on the work item the user working this fork has commented there, you can collaborate with him and see what help he needs. I am here to help everyone who has general questions, you might be able to arrange with him a private build for download and testing but thats between you and him. I need to know his fork is bug free before we consider it for merge and I cannot confirm all forks, so if the community doesnt do it for us it will be hard to commit.

I have also put this page together so that users better understand what it takes to build the project. This page has been created based on my personal trouble with getting this project going and I will keep adding to it.

http://www.websitepanel.net/contribution

I am a volunteer here, so is the rest of the team. We are all going to have to have the attitude of if we want something, we need to make it happen one way or the other.

You can write to [e-mail] I apologize on the un-clear process right now, give me a couple of weeks to organize everything better, I promise things will become more clear, I'm just learning in the process as well.

---

Omar Armenteros Virtuworks

Answer 11

Omar,
Your doing a great job, i really appreciate it. I totally understand its open source and we all have to pull together.
That page you have linked is fantastic, and will be a welcome source of info for contributors. You are a star for doing that. Somebody needed to.

The contribution to alpha/beta code/fork testing for non-developers (but people willing to test on their servers) does need to be made more clear.
I'm sure more people with servers (but no coding skill) would then contribute to testing, I know i would.

PS: Thanks for the link, i'm not a dev myself, so asking me to compile and test versions is not gona happen. However we do have one dev on team so i will ask him to look at the link you supplied. Its much appreciated.

I realise a couple of companies/people have started hiring devs to work on it now, if anyone is working on some of the basics and want any financial input to get it done by a hired dev then let me know, i am willing to help fund some of the dev if needed. I appreciate its open source, but sometimes money talks...