SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Reinstalling SQL Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cidr
Posting Yak Master

United Kingdom
206 Posts

Posted - 08/19/2013 :  06:17:51  Show Profile  Reply with Quote
I have a request to reinstall SQL server 2012 because something has become corrupt.

SharePoint databases are installed on the SQL server and just wondered is there is any special requirements before reinstalling SQL server and anything more than reattaching mdf files. i.e. maintaining logins, permissions etc.

Thanks

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 08/19/2013 :  14:32:50  Show Profile  Reply with Quote
I would be very hesitant to solve a problem with 'corruption' by uninstalling/reinstalling SQL Server. I would find this corruption and figure out what the actual problem is and correct it - instead of taking this approach.
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
206 Posts

Posted - 08/20/2013 :  07:18:52  Show Profile  Reply with Quote
In all truth, it's not a corruption, we had a trial version of SQL Server and when connecting, a dialogue stated it had expired so we couldn't access anything. When we attempted to upgrade to developer edition, we were advised our installed SQL version wasn't viable for that upgrade path.

I was personally advised we attempted several things to upgrade to the developer but that none of them worked.

I agree with you, however, that reinstalling is a last step. If we have not choice... we have no choice
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 08/20/2013 :  14:07:23  Show Profile  Reply with Quote
Okay - you do have a problem, but it is bigger than you are aware of. You cannot upgrade to the developer version - and run Sharepoint on that version - unless this is truly a development server and only licensed developers (each developer must have a license for the developer edition) are accessing the system.

If that is not the case, then you either need the standard edition or enterprise edition depending on your system requirements.

With that said - uninstalling/reinstalling doesn't require anything special. What you need to make sure you do is script out all logins (use sp_help_revlogin for this), script out all jobs, export any SSIS packages - and any other user objects in the system databases (tables, views, etc...).

Once everything is either scripted or exported, uninstall the current version - install the new version and attach the databases. Script in the logins, jobs, etc...

If you use a different instance name, then you will need to update the connection information - so I would recommend that you keep the same instance name when installing.
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
206 Posts

Posted - 08/21/2013 :  11:20:43  Show Profile  Reply with Quote
quote:
Originally posted by jeffw8713

Okay - you do have a problem, but it is bigger than you are aware of. You cannot upgrade to the developer version - and run Sharepoint on that version - unless this is truly a development server and only licensed developers (each developer must have a license for the developer edition) are accessing the system.


Thanks for the help. We have the developer licences which is fine. In terms of reinstalling... this is a path we went down yesterday. I said to the DBA the same thing as you... script everything but this wasn't possible due to the fact that we couldn't access SQL server from the expiration dialog. Luckily, the Authentication group model is fairly simple and easy to replicate.

We've had a host of problems including MS dynamics not working correctly and multiple SharePoint errors so we are starting afresh:)

Cheers
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000