Skip to content

SQL SERVER PRECHECK REQUIREMENTS

I personally pre check the following requirements before installing SQL Server.

[1] Please confirm the Name and IP address of server.
[2] Please confirm that the [domain\User1] domain user needs granting full administrative rights on the server.
[3] Please inform us if the installation is for a production or a nonproduction environment.
[4] Please inform us of the business unit.
[5] Please confirm the full version of SQL Server to be installed :
[a] SQL Server 2008 R2 OR SQL Server 2012 OR SQL Server Version
[b] 32bit or 64bit SQL Server install
[c] Edition of SQL Server : Enterprise Edition or Standard Edition.
[6] Please confirm which SQL Server Service Pack is to be applied.
[7] Please confirm that only SQL Server database engine service is to be installed or Integration, Analysis, Reporting tools should also be installed.
[8] Please inform us of the Windows service account under which the SQL Server service [Database Engine] is to run.
[9] Please inform us of the Windows service account under which the SQL Server agent service is to run.
[10] Please inform us if Windows authentication or mixedmode authentication is required.
[11] If MixedMode authentication is required please inform us of the sa password.
[12] Please inform us of the drive on which the SQL Server binaries are to be installed.
[13] Please inform us of the drive on which the SQL Server data files are to be located.
[14] Please inform us of the drive on which the SQL Server transaction logs are to be located.
[15] Please inform us of the drive on which the SQL Backups are to be located.
[16] Please confirm if database backups are to be performed by the third party tool.
[17] Can you please give us the location where the source for the SQL Server Installation is located.
[18] Can you please make sure the source is Exe files as we cant open ISO files or please install the supporting software to open the source files.
[19] Please inform us if the work is to be booked to the bank of support days for the business unit requesting the work or if a PO will be raised for the work.
[20] Please inform us whether the work needs to be carried out remotely or onsite.(Default: Remotely, If we cant access the servers than we do work onsite)
[21] Please let us know when the work needs to be scheduled.
Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: