SQL-Server

What is SQL server 2008??

SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment.

Originally released in 1989 as version 1.0 by Microsoft, in conjunction with Sybase, SQL Server and its early versions were very similar to Sybase. However, the Microsoft-Sybase partnership dissolved in the early 1990s, and Microsoft retained the rights to the SQL Server trade name. Since then, Microsoft has released 2000, 2005 and 2008 versions, which feature more advanced options and better security.

Examples of some features include: XML data type support, dynamic management views (DMVs), full-text search capability and database mirroring.

SQL Server is offered in several editions with different feature set and pricing options to meet a variety of user needs, including the following:

  • Enterprise: Designed for large enterprises with complex data requirements, data warehousing and Web-enabled databases. Has all the features of SQL Server, and its license pricing is the most expensive.
  • Standard: Targeted toward small and medium organizations. Also supports e-commerce and data warehousing.
  • Workgroup: For small organizations. No size or user limits and may be used as the backend database for small Web servers or branch offices.
  • Express: Free for distribution. Has the fewest number of features and limits database size and users. May be used as a replacement for an Access database.

 How to Install SQL server 2008 on Win-7 Professional????

Step:-1
Prerequisite Task

1. Hardware and Software Requirements


Processor Type
  • x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
  • x86 Processor: Pentium III-compatible processor or faster
 .NET Framework
 .NET 3.5 SP1 is a requirement or
Visual Studio 2010 or VS 2008 SP1.
 Hard Disk
 6 GB of available hard-disk space.
 RAM
 1GB or More
 Processor Speed
Minimum:
  • x86 Processor: 1.0 GHz
  • x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or faster

 Step:-2

  .NET 3.5 SP1 Download URL:-
 http://www.microsoft.com/en-us/download/details.aspx?id=22




Step:-3
SQL Server Setup Download URL:-
http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

Step:-4 Double click on the installer. It will take some time to extract. After that an window  will open as follow.
First window of installation


Step:-5: From this window click on the Installation menu (See Left). Now there will be appear some option under Installation. From right, click on the option New SQL Server stand-alone installation or add features to an existing installation.
Note: After Clicking on that a window may appear as bellow. Just click on the button Run Program of that.

Click Run Program


Step:-6 Now setup will take a moment to complete some operation. To continue there can not be any operation with status failed. If any operation fails then it will not be possible to continue installation. Click OK.

Every operation should be passed

Step:-7 This is express edition so I do not need to enter any product key. Just Click on Next

Next


Step:-8 Check Accept the terms and click NEXT

Check Accept Terms & Condition and Click Next


Step:-9 Now Click Install button. Some setup support files will be installed.

Install Setup Support Files


Step:-10 Now again It needs some operation to be completed. Every operation must be  passed or warning or skipped. If any operation fails then it is not possible to continue. Click Next.

There can not be any operation with failed status


Step:-11 Now select the features which do you need. Here I am selecting Database Engine Services, Busines Intelligence Development Studio, Management Tools basic & SQLl Client Connectivity SDK. Click Next.

Select Services


Step:-12 Here we need the name and instance ID. I am selecting Default Instance but keep the name “SQLExpress” in your mind for future use. Click Next. 

Check Default instance


Step:-13 Now a window will appear  and it will show the space required and available. Click Next.

Click Next

Step:-14 Here select the account name from the dropdown list for SQL Server Database Engine-
NT AUTHORITY\NETWORK SERVICE and Click Next.

Select NT AUTHORITYNETWORK SERVICE

Step:-15 Now select which mode do you want to use. Here I am selecting the Mixed mode.
For mixed mode I have to provide the password for the root account (username “sa” default) and adding my current user by which i will also be able to access database engine without default administrator account (username : sa ).

Select NT AUTHORITY\NETWORK SERVICE


Step:-16 Click Next

Click Next


Step:-17 Now again every operation must be passed or skipped. If there is any operation with status failed then installation will not be possible. Click Next

There must not be any operation with status failed.


Step:-18 Now finally it is going to start the installation. Click Install

Start Installation


Step:-19 Now wait till installation is complete. Setup is complete. Click Next

Next

Step:-20 Now Close this window
Close

Exit this

 Close it.

Installation is complete.

No comments:

ORA-08004: sequence IEX_DEL_BUFFERS_S.NEXTVAL exceeds MAXVALUE

 Error:- IEX: Scoring Engine Harness Error - ORA-08004: sequence IEX_DEL_BUFFERS_S.NEXTVAL exceeds MAXVALUE (Doc ID 2056754.1) SYMPTOMS:- Yo...