Reflections over the current computer issues from an struggling network technician
Wednesday, January 16, 2013
Sharepoint 2013 and SQL Management Studio
Issue:
Just installed Sharepoint Server 2013 in standalone mode. We need to migrate a sharepointsite to new environment. But for me to able to a attach-databaseupgrade I need to get into the SQL Server and do a restore of databases. Problem is, Management Studio wasn’t included with the Sharepoint SQL Expressinstallation. Unfortunatly the good old days of SQL Management Studio 2005 are now gone. Then, all I needed to do was download the management pack and install it. Then it was good to go. Not so now.
Firstly, there is no such nice standalone package. All I find to download are fully packaged solutions where basicly goes through the same tedious process you have to when installing SQL Server like you ordinary do, check all prereqs, install setuppackage, think a bit, check bla bla bla.
So I do this, choose add features to existing instance. Gets some error about “instance id required but missing” or even better when installing gets pass this point, instead there is no Management feature to found. What the #%¤
I just wanna restore a bloody database!
Fine, I get tired of this. Boot up a real SQL Management Studio from another server and tries to connect to sharepointinstance, but all to avail.
now I ready to punch things.
Back to searching for an answer. I briefly consider installing a proper SQL 2008 r2 standard instead, but no, I can’t give in now.
Finally I found something
When I instead choose New installed or add shared features in the installation package, I finally get the much sought after Management Tools – Basic option!
Right, now be sure to uncheck Database Engine! Otherwise you’ll get a whole new instance dragging down your poor server.
Ok, so the solutions was pretty simple. Once you know where to go, but I did this is in a labenvironment and could be somewhat more casual about doing the new installationoption. In a production environment I usually tread more lightly.
Anyway why must it be so unlogical Microsoft?
Searching the net for this issue gave me plenty of peers with the same issue so at least Im not the only dumbfounded out there.
References:
http://goneale.com/2009/05/24/cant-install-microsoft-sql-server-2008-management-studio-express/
http://www.microsoft.com/download/en/details.aspx?id=26729
http://www.benlittler.com/2009/06/how-to-install-sql-management-studio-express-2008/
http://stackoverflow.com/questions/3536023/how-to-install-sql-server-management-studio-2008-component-only
Subscribe to:
Post Comments (Atom)
Powershell and Uptimerobot
Uptimerobot can be quite tedious when you need to update many monitors at once. For example say you bought the license for Uptimerobot and n...
-
Problem: In a customer environment they wanted to install RDS and DC on the same server. A nice cheap solution, which have worked perfectly...
-
Error received for no apparent reason when creating workflow. Errors were found when compiling the workflow. The workflow files were save ...
-
I had some problems with the old familiar "Working on it" for mysites in Sharepoint 2019. It was difficult to find information ab...
No comments:
Post a Comment