![]() On current versions of Windows, on the Start page, type Configuration Manager, and then click SQL Server version Configuration Manager.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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |