Solved

Installing SQL Server 2012 using VM server

Posted on 2015-02-02
16
76 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
  • 10
  • 6
16 Comments
 
LVL 29

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 29

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
 

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 29

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 29

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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

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 29

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 29

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Dynamics crm 2011 8 43
Access recordset not updateable 8 38
Params not declared?  T-SQL syntax question 3 18
Test a query 23 11
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now