MS Sql Server Installation Make Easy

This blog is intended to help the first time users of sql server to interact sql server easily. So let's understand what we should know while installing sql server.

SQL server is very interactive database engine. You will find this far more interesting when you install and start using this. Sql server comes in many editions specific to usage.

a. SQL Server Enterprise Edition - Specific for enterprise environment
b. SQL Server Developer Edition  - This has all the features same as Enterprise Env. This edition can be used only for development work just like writing codes but can't be used as a back end for the application in any enterprise.
c. SQL Server Standard Edition  - This supports four cpus. "How to find the number of physical and logical
CPUS?". This some lesser features than the enterprise and developer editions. As I am writing this wire for the users who are using for the first time so I shall not go deep defining the difference between these editions. Small organizations can use this edition.
d. SQL Server Workgroup Edition - This supports two cpus on your system and lesser features even than Standard edition.
e. SQL Server Express Edition   - This is free and is used only for learning purpose. This uses only one CPU on the system.

Now you are prepared to install the sql server. Most important thing is to decide whether you will have named instance or the default instance. Named instance means you name this instance while installation. If you don't name then this will become your default instance. There can be only one default installation on one system while many (with a limitation) named instances per server.

Let's also talk about choosing the service account. Service account is nothing but the account that the service uses to deal with requests. There are three types of service accounts for a sql server: a) built-in System Account b) Local User Account c) Domain user account. a and b are meant for local usage which means that sql server is not available on n\w. c gives sql server access over n\w.

Before we wrap up the wire let's talk about authentication mode:
a) Windows Authentication Mode: This is secure as the users are authenticated by windows. 
b) Mixed Authentication Mode: Here you create a user account specifically for the sql server installtion. Mixed Authentication Mode allows access to all the eligible windows account.

Reader of this topic also read following two articles so having them here:
General Installation Errors: SQL Server Error: “A network related or instance-specific error occurred”
SQL Server DBA “Interview Questions And Answers”


Regards,
http://tuitionaffordable.webstarts.com

Comments

Popular posts from this blog

MSSQL Interview Question Clustering- Part2

Error 1067: The cluster service is stopped on passive node of my two node sql cluster. It throws following error when I try to start this:

Handle Sexual Harassment