Monday, January 8, 2018

How to install MSSQL on Windows servers

These steps should be similar on other versions of Windows, however some prerequisites may be required on older versions of Windows.
If you haven’t already downloaded SQL Server 2012 Express, you can get it from Microsoft here. I downloaded the Advanced version because it includes Management Studio, although you can download that separately.
Step 1
To begin, launch the install program and choose the top option to install a new stand-alone installation.
Step 2
On the End User License Agreement page, read the license agreement, and then select I accept the licensing terms and conditions check box. Click Next.
Step 3
At this point you can choose the features that you want to install(mostly the features will be selected by default). Click Next to continue.
Step 4
Now you can configure the SQL instance. If this is the first instance of SQL Server on your computer, you probably want to change this setting to Default instance. If you already have another instance of SQL Server, you will want to use Named Instance and give it a name.
Click Next to continue.
Step 5
The next step is server configuration. Don't do any changes and click on Next.
Step 6
Now we come to the Database Engine configuration. On the Server Configuration tab you can select whether SQL Server will only authenticate using Windows accounts or you can choose Mixed Mode which will allow Windows accounts and SQL accounts. We usually set this to mixed mode and set a password for the “sa” account. You can also add or remove accounts that will be SQL administrators. (example: e2enetworks user)
Click Next to continue.
Step 7
The next step configures Reporting Services. Set this to Install Only if you don’t need reporting services or may need them in the future. You can always go back and configure it later.
Click Next to continue.
Step 8
On the Error Reporting step, you can choose whether or not you would like to send error reports to Microsoft to help them improve future releases of SQL server.
Click Next to continue.
At this point, SQL server will install on your computer. This could take a while to complete.
Once the installation has completed, you will receive a screen showing the details of what was completed and if there were any problems.
Installation done and you can now login SQL server Management studio with below credentials
username: sa
password: xxxxxx(which has been set)

No comments:

Post a Comment

TicTic v2.2 - Android media app for creating and sharing short videos

Facebook Twitter Tiktik – Android app for creating and sharing short videos. The customizable social video application to build ...

Popular Posts