![]() ![]() To start SQL Server Configuration Manager When using older versions of Windows, on the Start menu, point to All Programs, point to Microsoft SQL Server, and then select SQL Server Management Studio.On current versions of Windows, on the Start page, type SSMS, and then select Microsoft SQL Server Management Studio.Most of the examples that are described in SQL Server Books Online use the AdventureWorks sample databases. The sample databases and samples aren't included with SQL Server. This tool configures the more advanced connectivity elements but doesn't enable features. It lets you enable server protocols, configure protocol options such as TCP ports, configure server services to start automatically, and configure client computers to connect in your preferred manner. SQL Server Configuration Manager installs with both SQL Server and the client tools. The latest version can be used with older versions of the Database Engine. SQL Server Management Studio (SSMS) is the principal tool for administering the Database Engine and writing Transact-SQL code. SQL Server Express contains only a subset of the tools. For a complete description of the tools described below, search for them in SQL Server Books Online. Select the tools you want as part of the client components during setup. Some tools, such as SQL Server Management Studio (SSMS), aren't installed by default. All tools can be accessed from the Start menu. This topic describes the first tools you'll need, and helps you select the right tool for the job. The SQL Server Database Engine ships with various tools.This lesson contains the following tasks: This lesson reviews the principal tools, and shows you how to connect and perform a basic function (authorizing more users). When you install the SQL Server Database Engine, the tools that are installed depend upon the edition and your setup choices. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |