Solved

Installing SQL Server 2012 using VM server

Posted on 2015-02-02
16
88 Views
Last Modified: 2016-02-18
Im somewhat new to installing SQL Server although I have done it before with success. I have never tried to install SQL Server 2012 and I have never installed this on a Virutal Server type system(Excuse my verbiage as I am not an admin of any kind). Anyway, I am remoted into this server and I have Admin privs. I installed the software and initially had a problem with Analysis Services so I did another install and it completed with no errors. I was able to open up Management Studio without a probelm but when I try to connect to Integration Services it asks me what i want to open it with, meaning it doesnt have the program installed or that I just cant see it?. Im having a hard time with all this. I personally dont think I have the permissions and its screwing up my install. My network guy says Im an admin on the domain level thought(highest I would think)  but how can I tell? Also, if I want to do a Backup and Restore, from my new server, which has SQL Server 2012 and I connect to my 2008 instance from there as well. Can I do the backup from the oder version, on the new server, and save that to the new server and then do a Restore from my new server? I have to get this done so any help is greatly appreciated...

Thanks
JK
0
Comment
Question by:jknj72
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 6
16 Comments
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 40584585
First, the administrator on the machine doesn't necessarily grant administrative rights in SQL... they changed that in SQL 2008, as I recall.  (There is a step that asks who should have administrative rights.  There is a button so you can add the account performing the install... and you can certainly add an administrative group, but it isn't done by default.)

If the last question is: Can you use the SQL Server Management Studio for SQL 2012, connect to your SQL 2008 database server, and perform a backup?  Assuming you have permissions on the 2008 server, and the ports are open - Absolutely.  
Can you then take that backup file, copy it to your 2012 server, and perform a Restore?  Again, assuming permissions and ports are okay -- Absolutely.
(You'll have a problem taking a backup file from SQL 2012 and restoring it on SQL 2008 though.)

Question: Do you really intend to use Analysis Server and Integration Services?  (I ask because I've seen it installed frequently by new administrators who go through and install everything, but really only need the Database Engine, and management tools.)
0
 

Author Comment

by:jknj72
ID: 40584614
I shouldnt even be doing this install, which I feel Im screwing up, so I need to get it fixed. What I ultimately wanna do is move the 08 database and then, move all the SSIS jobs and even an SSAS db to the new server and create my own jobs as well....

How/Where can I check my permissions and adjust accordingly. I just tried to script out the 08 DB and run it on the 2012 DB and I got access denied errors on the Create File which is the first line in the script.
Id prefer to do a backup and Restore to get the DB into 2012. But Im open to anything as long as I can get it to work

Yes, I was hired to create SSAS and SSIS jobs to transfer data, etc...So I will definitely need to get that installed correctly.

Please, anything you can do to help would be greatly appreciated
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 40584697
All evidence would indicate that you don't have SQL administrator rights to SQL.  If it were me, I'd uninstall SQL, reboot and reinstall SQL.  When you get to this screen (and I'm taking the screen shot from a blog)  Linking to credit the source.)
Specify SQL AdministratorBe certain to at least add your own account to the list of SQL Administrators.
(It wouldn't be a bad idea to create a group for SQL Administrators and add that group, (and/or add the local server administrators group -- depending on the security policy of the organization.)

It is possible to recover from where you are, and get yourself administrator access.  I can't swear, down the road that you won't have additional problems with SSIS or SSAS though, all having cascaded from the original permissions.  And I still maintain that it may be faster to remove SQL and reinstall.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:jknj72
ID: 40584721
Ok thanks for your help and I think Im going to do the Uninstall. When I go to into Add Remove programs there are many SQL Server items installed and I know I have to remove MS SQL Server(64 bit) which is the main program for SQL but I wanted to know if I need to uninstall anything else when Im done with this Uninstall??
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 40584733
How confident are you that SSIS and SSAS are correctly installed at this point?  If not, I'd remove those too.  Native Client, Management objects, Setup support files, etc should all be okay.
0
 

Author Comment

by:jknj72
ID: 40584747
Ok Im in the process of uninstalling now. Thanks for your help Rich
0
 

Author Comment

by:jknj72
ID: 40584762
Ok I have uninstalled SQL Server 2012. I do see there are some programs on the server but I think it is mostly unistalled. I wanted to know at this point how do I add myself to the SQL Server Administrator group before I install SQL? How can I do that for when I get to the screen you showed and I add myself(which is what I did last time) I want to make sure that I am in the SQL Admin group?
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 40584784
You add yourself during the install, at that point.  There isn't anything to do before the install.  As a safety though, lets go ahead and create a SQL Server Administrator group.

Open up Computer Management.  Under System Tools, Local Users and Groups, select Groups.  Right click groups, and select New Group.  Call it SQL Administrators, and add yourself as a member.

Now, when you reach the page during the install, when you need to specify SQL Server Administrators, add your user ID _and_ the SQL Administrator's group.
0
 

Author Comment

by:jknj72
ID: 40584819
ok will keep you updated and thanks again...
0
 

Author Comment

by:jknj72
ID: 40586153
Hey Rich I hope your online today cause I could really use your help. Im still struggling and I know its going to be something very small to fix it but I cannot find where. I created the SQL Administrators group and I have added myself. Is there something I have to do with the group as far as giving it specific access before I do the install again? My last attempt didnt work so Im doing another unistall and gonna try it again.
I just started this contract and its not doing me well for any kind of confidence they have in me so I really need to get past this. If you could help me out I would really appreciate it.
0
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 500 total points
ID: 40586189
That SQL Administrators group won't have permissions until after the SQL install is complete.

You can confirm that you have administrative permissions on the server itself by looking at the 'administrators' group on that server.  Either you are in that group, or because you say the local network folks gave you domain admin permissions, I would assume there is a domain group within that group which gives you permissions.

You had another install that also didn't work?  What error(s) or issues did you encounter this time?  Same as before?
0
 

Author Comment

by:jknj72
ID: 40586256
Update.....My network guy said he found an article about how Windows 2012 using VM caused a huge issue when trying to map to drives other than C. Im not sure what the actual issue is but Im trying to install again so hopefully it will fix the issue. I will keep you updated...Thanks
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 40586276
Not certain I understand.  I'm not certain where you'd be using mapped drives.  Do you have the installation media on mapped drive?  Or are there mapped drives to a scale-out file server on which you are doing the install?  Or is this a Hyper-V system where the virtual disks for the VMs are on a scale-out file server?  (I haven't heard anything yet which would lead me towards believing there is a virtualization issue.)

If you're interested, there is also a DBA Fundamentals, PASS Virtual Chapter lunch session today on Virtualization 101, as it related to MS SQL.  It doesn't start for about 150 minutes from now...
0
 

Author Comment

by:jknj72
ID: 40586359
Well the fix that my network guy did led me to be able to create a DB using my E as my data and the F for my log. It worked so Im very happy. He said it was something to do with how VM uses drives outside of C...I can get the actual error and fix if youd like but you have been a big help. Im getting an error now, which I got the first time I tried to install saying that it cant start the Service for Analysis service. So now I have to put this question in EE if you have any insight let me know.
0
 

Author Closing Comment

by:jknj72
ID: 40586360
Thanks
0
 

Author Comment

by:jknj72
ID: 40586572
Rich,

This is what fixed my issue...

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

Thanks
John

FYI, I have another question about how to configure permissions on my server. I got an error that the OLAP service couldnt be started and I was able to get it started once I switched to local account but I wanna do it the correct way instead of a quick fix, if thats what it is? Thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

736 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question