Installing SQL Server 2012 using VM server
Posted on 2015-02-02
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...