Introduction to Microsoft SQL Server |
|
Microsoft SQL Server Setup |
Introduction |
Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA). On this site, we provide lessons and other topics on how to use Microsoft SQL Server 2005. Before installing Microsoft SQL Server 2005, make sure you have installed all service packs on your operating system. Also install IIS: |
In order to follow the lessons on this site, you must have access to a computer in which Microsoft SQL Server is installed. To start, you must have a computer that runs an appropriate operating system. If you are just learning, which is assumed for all lessons on this site, you can use a Microsoft Windows XP Professional (in this case, you must install Microsoft SQL Server 2005 Developer Edition) or Windows Server 2003. To make it possible for you and other students to study databases and SQL, Microsoft made available a trial version of Microsoft SQL Server 2005. This full version is available from the Microsoft web site. This is something beneficial because most companies would not give such a long trial version of an important software product: for 120 days, you should be able to learn as must as possible and be able to move on, such as finding a job or starting a business. To get the trial edition of Microsoft SQL Server, go to the Microsoft web site, do a search on "trial software" (normally, there is usually a Trial Software link on the home page), and follow the links to locate the trial edition of Microsoft SQL Server 2005 Enterprise Edition (this is a very big file: 890.9 MB - 1050.0 MB).
If you purchased Microsoft Visual Studio 2005 Professional, it may have come with the SQL Server 2005 Developer Edition DVD. To install it, put the DVD in the drive. A white window with links will come up. You can click the link under x86 to install. If you are downloading, click the X86 Executable link. When a dialog box comes up, click Save, locate a folder on your computer where to save the file and click OK. The download will start. Depending on your connection speed and your computer, this may take a while. When the download is over, click Open
On the dialog box, click Next The InstallShield Wizard will start copying files to your hard drive. When it has finished, click Finish. After the files have been copied, click Open. If you have a DVD burner, from inside the SQLEVAL folder, create a DVD that contains the Servers folder, the Tools folder, and the autorun.inf file.
To use SQL Server, it must start as a service. You have two options. You can start it every time you want to use. You can also make it start whenever the computer comes up from booting:
The Connect To Server dialog box allows you to identify yourself (or the account you will use) to establish a connection with a server that is running Microsoft SQL Server. You must provide the necessary credentials. You can uss Windows Authentication. Here is an example: Alternatively, you can use an existing SQL Server account. To do this, select SQL Server Authentication from the Authentication combo box. Enter a username in the Login combo box and enter a password in the corresponding text box:
Once you are ready, click Connect.
|
|
||
Home | Copyright © 2007-2008 FunctionX, Inc. | Next |
|