Install SQL Server 2012 in Stand Alone Machine

Requirements for Installing SQL Server 2012:

1.       Operating system Requirement :

You can install in below operating systems

Windows Server 2012,

Windows 8,

Windows server 2008 R2 SP1,

Windows 7 SP1.

You can also install in below operating systems but you require to install update http://support2.microsoft.com/?kbid=956250 on below operating system before initiating the installation.

Windows Vista SP2

Windows Server 2008 SP2

2.       NET Framework

.NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step.

You must enable or install.NET 3.5 SP1, If you select to install Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, SQL Server Management Studio on Windows Vista SP2 or Windows Server 2008 SP2 operating systems. OS wont have .NET 3.5 SP1 Framework 

3.       Windows Powershell

Powershell 2.0 is mandatory to install SQL Server 2012. If  SQL Server setup reports Powershell 2.0 is not present, you can install or enable it.

4.       Internet Explorer 7 or a later version.

5.       Hard Disk : SQL Server 2012 requires minimum of 6 GB.

6.       Memory

 Minimum :  

<![if !supportLists]>1.       <![endif]>Express : 512 MB

<![if !supportLists]>2.       <![endif]>Other  : 1 GB

       Recommended

<![if !supportLists]>                                                         i.            <![endif]>Express : 1 GB

<![if !supportLists]>                                                       ii.            <![endif]>Other  : 4 GB

Installation Steps:

Go to setup file location  click on setup.exe

Next you will see the SQL Server Installation Center  page. In Left side pane select Installation Tab

In installation page, right side pane you will found 4 option 

               

Option 1 : New SQL Server stand-alone installation or add features to existing installation 

                                Using this option you can install Stand-alone server  or add SQL Server features to an existing installation

Option 2 : New SQL Server failover cluster installation

                                Using this option you can install a SQL Server in Failover Cluster

Option 3 : Add Node to the SQL Server failover cluster

                                This option is used to add a node to an existing failover cluster

Option 4 : Upgrade from SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2

                                Using this option we can upgrade the existing SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 to SQL Server 2012

Now we are performing SQL Server stand-alone installation so click on Option 1.

It will initiate the stand-alone installation process of SQL Server 2012

                               

Next screen displays you Setup Support Rules screen, click on  button to see all the rules information.

Click on Ok

Above screen will provide you the available latest updates.

Click on the Next.

In next screen you need to select weather is it new installation are adding features to an existing installed instance.

Select Perform a new installation of SQL Server 2012 radio button for fresh installation

In next screen need to select weather is it free edition or need to provide product key and click on Next

Next  is the license  terms screen. You need to accept the license terms and click on Next.

l

Select All features with defaults to install all features with default values and select Next

Select the what ever you want install in the instances. If this is the first installation you can select what ever shared features you want. If it is another instance already installed shared features are grayed out. Click on Next

Error messages when restoring from different versions of SQL Server.

We can't restore the backups taken in Newer version of SQL Server instance on older version of SQL Server. 

SQL Server 2008 R2 to SQL Server 2008

Msg 3169, Level 16, State 1, Line 1

The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

SQL Server 2008 R2 to SQL Server 2005

Server: Msg 3241, Level 16, State 7, Line 1

The media family on device 'f:\temp\test001_sql2008r2.bak' is incorrectly formed. SQL Server cannot process this media family.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

SQL Server 2008 R2 to SQL Server 2000

Server: Msg 3169, Level 16, State 1, Line 1

The backed-up database has on-disk structure version 661. The server supports version 539 and cannot restore or upgrade this database.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

SQL Server 2008 to SQL Server 2005

Server: Msg 3241, Level 16, State 7, Line 1

The media family on device 'f:\temp\test001_sql2008.bak' is incorrectly formed. SQL Server cannot process this media family.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

SQL Server 2008 to SQL Server 2000

Server: Msg 3169, Level 16, State 1, Line 1

The backed-up database has on-disk structure version 655. The server supports version 539 and cannot restore or upgrade this database.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

SQL Server 2005 to SQL Server 2000

Server: Msg 3169, Level 16, State 1, Line 1

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Migrating SQL Server 2005 DTSX Packages to SQL Server 2012

Migrating SQL Server 2005 DTSX Packages to SQL Server 2012

Login into the SSMS of sql server 2005 Expand the Management à Legacy à Data Transfarmation Services tab in object explorer shown as below pic it displayes all the dtsx packages located in source server i.e. SQL Server 2005

Right click on Data Transfarmation Services and select Migration Wizard

In Package Migration Wizard – Choose Source Location Screen the source as Microsoft SQL Server and give the server name and select the authentication mode(either windows authentication or SQL Server authentication) .  And click on Next button

Next  screen In Package Migration Wizard – Choose Destination Location, select the destination as DTSX File specify the Folder name where you saving  these packages. And click on Next

Next  screen In Package Migration Wizard – List Packages, here select the DTSX Packages to you want to migrate. And click Next

Next  screen In Package Migration Wizard – Specify a Log file, give the path and log file name, it will log all migration information. And click Next

Next  screen In Package Migration Wizard – Complete the Wizard, This will provide the summary of migration. Finally click on Finish.

Next  screen In Package Migration Wizard – Migration the Packages, Last screen indication what are the packages migration any errors/warnings given information.

And you can find the DTSX files which are selected to migrate in Destination folder shown in  above image. And copy the DTSX package files into destination server i.e SQL Server 2012

Login into the Destination server i.e. SQL Server 2012  . select Project Conversion Wizard from program files    

It will start Integration Services Project Conversion Wizard click Next on initial screen

In Locate Package screen select the Source as File System and give files location copied from SQL Server 2005 in Folder.  And click on Next

It will display the list of all available DTSX packages in the folder. Select the packages which you want to migrate. Shown as in below screen. And Click on Next

It will ask the Path and Project Name to store upgraded packages as ispac (Integration Services Project Deployment File)  format. Click Next till Review Screen.

Click on Convert button in Review & click on close button in success screen, it creates DTSUpgrate2005.ispac in above mentioned output path.

Select the Deployment Wizard in Integration Services

In Integration Deployment Wizard – Select Source Screen Select Project Deployment file radio button and in path section give the .ispac file location to deploy all dtsx package files

In Integration Deployment Wizard – Select Destination screen Enter the destination server name in Server name and select the path by clicking Browse button.

Click next and click Deploy in Review screen.

It will create dtsx files in Integration Services Catelogs à SSISDB à your prject name folder

Note  :If any DTSX package file will have any deprecated task or files used while converting you will get the errors.

SQL Server and Build Numbers

Build chart lists all of the known Service Packs (SP)

	RTM	SP1	SP2	SP3	SP4
SQL Server 2014	12.0.2000.8 12.00.2000.8
SQL Server 2012	11.0.2100.60 11.00.2100.60	11.0.3000.0 or 11.1.3000.0	11.0.5058.0 or 11.2.5058.0
SQL Server 2008 R2	10.50.1600.1	10.50.2500.0/ 10.51.2500.0	10.50.4000.0/ 10.52.4000.0	10.50.6000.34/ 10.53.6000.34
SQL Server 2008	10.0.1600.22 10.00.1600.22	10.0.2531.0 10.00.2531.0 or 10.1.2531.0	10.0.4000.0 10.00.4000.0/ 10.2.4000.0	10.0.5500.0 10.00.5500.0/ 10.3.5500.0	10.0.6000.29 10.00.6000.29/ 10.4.6000.29
SQL Server 2005	9.0.1399.06 9.00.1399.06	9.0.2047/9.00.2047	9.0.3042/ 9.00.3042	9.0.4035/ 9.00.4035	9.0.5000/ 9.00.5000
SQL Server 2000	8.0.194 8.00.194	8.0.384 8.00.384	8.0.532 8.00.532	8.0.760/ 8.00.760	8.0.2039 8.00.2039
SQL Server 7.0	7.0.623 7.00.623	7.0.699 7.00.699	7.0.842 7.00.842	7.0.961 7.00.961	7.0.1063

Create SQL Login

<![if !supportLists]>1.       <![endif]>CREATE a login for SQL Server  for windows authentication

      CREATE LOGIN [domainName\loginName] FROM WINDOWS;    

                                                     

<![if !supportLists]>2.       <![endif]>CREATE a login with password –( SQL Login) this will work from SQL 2000 onwards

CREATE LOGIN VenkatSangu WITH PASSWORD = 'password'

<![if !supportLists]>3.  <![endif]> CREATE a login with password and password must change when the user first time connecting to SQL Server  this will not support in older version i.e SQL Server 2000/2005

CREATE LOGIN VenkatSangu WITH PASSWORD='pwd@123pdw' MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON

     

To use MUST_CHANGE keyword must passwords must meet the following guidelines

<![if !supportLists]>·         <![endif]>The password does not contain the account name of the user.

<![if !supportLists]>·         <![endif]>The password is at least eight characters long.

<![if !supportLists]>·         <![endif]>The password contains characters from three of the following four categories:

<![if !supportLists]>·         <![endif]>Latin uppercase letters (A through Z)

<![if !supportLists]>·         <![endif]>Latin lowercase letters (a through z)

<![if !supportLists]>·         <![endif]>Base 10 digits (0 through 9)

<![if !supportLists]>·         <![endif]>Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).

Thanks

Venkat Sangu

Operating System Requirements to install SQL Server 2012

SQL Server 2012 edition	Operating system
SQL Server 2012 x64 Enterprise, Business Intelligence, and Web	Windows Server 2008 R2 SP1 Datacenter, Enterprise, Standard, and Web or above Windows Server 2008 SP2 Datacenter, Enterprise, Standard, and Web or above
SQL Server 2012 x86 Enterprise, Business Intelligence, and Web	Windows Server 2008 R2 SP1 Datacenter, Enterprise, Standard, and Web or above Windows Server 2008 (x64 and x86) SP2 Datacenter, Enterprise,Standard, and Web or above
SQL Server 2012 x64 Standard	Windows Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or above Windows Server 2008 SP2 Datacenter, Enterprise, Standard, and Web or above Windows 7 SP1 x64 Ultimate, Enterprise, and Professional Windows Vista SP2 x64 Ultimate, Enterprise, and Business
SQL Server 2012 x86 Standard	Windows Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or above Windows Server 2008 (x64 and x86) SP2 Datacenter, Enterprise,Standard, and Web or above Windows 7 SP1 (x64 and x86) Ultimate, Enterprise, and Professional Windows Vista SP2 (x64 and x86) Ultimate, Enterprise, and Business
SQL Server 2012 x64 Developer, Express, Express with Tools, and Express with Advanced Services	Windows Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or above Windows Server 2008 (x64) SP2 Datacenter, Enterprise, Standard,and Web or above Windows 7 SP1 (x64) Ultimate, Enterprise, Professional, Home Premium, and Home Basic Windows Vista SP2 (x64)
SQL Server 2012 x86 Developer, Express, Express with Tools, and Express with Advanced Services	Windows Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or above Windows Server 2008 (x64 and x86) SP2 Datacenter, Enterprise,Standard, and Web or above Windows 7 SP1 (x64 and x86) Ultimate, Enterprise, Professional, Home Premium, and Home Basic Windows Vista SP2 (x64 and x86) Ultimate, Enterprise, Business, Home Premium, and Home Basic