Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

SQL Server 2005 Configuration Manager

By Exforsys | on December 18, 2005 |
SQL Server 2005

SQL Server Configuration Manager

In this tutorial you will learn about SQL Server Configuration Manager, Manage Server & Client Network Protocols, To start the default instance of SQL Server, To start an instance of SQL Server with startup options, To stop the default instance of SQL Server, To connect to another computer with SQL Server Configuration Manager, To connect to another computer with Windows Computer Management, To stop the default instance of SQL Server using net commands, To set an instance of SQL Server to start automatically and To start or Start the SQL Server Agent service

SQL Server Computer manager or Configuration manager mainly combines three SQL Server tools into one. Client Network utility, Server Network utility and Service manager. Provides the basic configuration management requirements of SQL Server services, Server protocols, Client protocols, client aliases, report services and report manager. SQL Computer manager is backward compatible with SQL Server 2000 and 7.0 and supports older versions of Analysis Services and Reporting services.

The SQL Server Configuration manager opens from the SQL Server Management Studio and is a snap in to the Microsoft Management console. However, it can be accessed directly from the Start Menu and added to any other Management Console display. The Microsoft Management Console draws on SQLServerManager.msc file under Windows System 32 folder to open the SQL Server configuration manager.

Windows Management Instrumentation(WMI) is used by the SQL Server Configuration Manager and SQL Server Management studio to view and change settings on the server. It provides an unified way of managing and interfacing with the API calls that manage the registry options requested by the SQL Server tools.

The Configuration Management tools can be used to start or stop, pause or resume services. Service properties can be viewed or changed. If passwords are changed using the SQL Server Configuration Manager, SMO or WMI are immediately impacted without having to restart the service.

Manage Server & Client Network Protocols

The Configuration manager tool is used to configure server and client network protocols. Connectivity options can also be defined using this tool. Enabling the required protocols does not require a change of server network connections. However if the server connections have to be reconfigured to ensure that the SQL server listens on a particular network, this tools comes in use. The Configuration Manager also comes with an ability to force protocol encryption, view alias properties or enable/disable a protocol. The order of usage of protocols can also be changed.

Before proceeding further, let us briefly look at some definitions:

Server Alias is an alias used for the computer to which the client is connecting. Protocol is the network protocol used for the configuration entry. Connection parameters are parameters associated with the connection address for the network protocol configuration.

The available Network Protocols are Shared Memory, TCP/IP, Named Pipes and VI A Protocols. SQL Server 2005 does not support Banyan VINES Sequenced packet Protocol(SPP), Multiprotocol, AppleTalk or NWLink IPX/SPX network protocols. If there are clients connecting to these protocols a different protocol must be selected. Winsock Proxy cannot be configured using the SQL Server configuration manager.

Microsoft SQL Server can be stopped and started from SQL Server Configuration Manager. To ensure orderly shutdown of the SQL Server, it is important to pause the SQL Server, then stop the SQL Server Agent Service and thereafter stop the instance of the server. The SQL Server Configuration manager allows users to do the entire process from the interface.

To start the default instance of SQL Server

1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, expand Services, and then click SQL Server.

3. In the details pane, right-click SQL Server (MSSQLServer), and then click Start.

4. A green arrow on the icon next to the server name and on the toolbar indicates that the server started successfully.

To start an instance of SQL Server with startup options

1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, expand Services, and then click SQL Server (MSSQLSERVER).

3. In the details pane, right-click the instance of SQL Server, and then click Properties.

4. In the SQL Server < instancename > Properties dialog box, click the Advanced tab, and then click STARTUPPARAMETERS.

5. At the end of the original text, in the Value column, type the startup parameters you want, and then click OK. Separate parameters with a space, for example, –c -m.

6. Stop and restart SQL Server for the parameters to take effect.

To pause and resume the default instance of SQL Server

1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, expand Services, and then click SQL Server.

3. In the details pane, right-click SQL Server (MSSQLServer), and then click Pause.

4. A pair of vertical blue bars on the icon next to the server name and on the toolbar indicates that the server paused successfully.

5. To resume the server, right-click SQL Server (MSSQLServer), and then click Resume.

6. A green arrow on the icon next to the server name and on the toolbar indicates that the server started successfully.

To stop the default instance of SQL Server

1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, expand Services, and then click SQL Server.

3. In the results pane, right-click SQL Server (MSSQLSERVER), and then click Stop. If SQL Server Agent is running, you will receive a notice that SQL Server Agent will also stop.

4. A red box on the icon next to the server name and on the toolbar indicates that the server stopped successfully.

To connect to another computer with SQL Server Configuration Manager

1. In SQL Server Management Studio, on the Object Explorer toolbar, click Connect, and then click Database Engine. The Connect to Server dialog box appears.

2. In the Connect to Server dialog box, in the Server name box, type the name of the server to connect to. Complete the authentication information, and then click Connect.

3. In Object Explorer, right-click the server name, and then click Manage Service.

To connect to another computer with Windows Computer Management

1. On the Start menu, right-click My Computer, and then click Manage.

2. In Computer Management, right-click Computer Management (Local), and then click Connect to another computer.

3. In the Select Computer dialog box, in the Another computer text box, type the name of the computer you want to manage, and then click OK.

4. Computer Management displays the services running on the remote computer. The top-level node changes to Computer Management < remotecomputer >.

5. In the console tree, expand Services and Applications, and then expand SQL Server Configuration Manager to manage the remote computer’s services.

To stop the default instance of SQL Server using net commands

1. From a command prompt, enter one of the following commands:

2. net stop "SQL Server (MSSQLSERVER)"

-or-

3. net stop MSSQLSERVER

To set an instance of SQL Server to start automatically

1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, expand Services, and then click SQL Server.

3. In the details pane, right-click the name of the instance you want to start automatically, and then click Properties.

4. In the SQL Server < instancename > Properties dialog box, set Start Mode to Automatic.

5. Click OK, and then close SQL Server Configuration Manager.

To start or Start the SQL Server Agent service

1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, expand Services, and then click SQL Agent.

3. In the results pane, right-click any instance, and then click Start.

4. A green arrow on the icon next to the SQL Server Agent and on the toolbar indicates that SQL Server Agent started successfully.

5. Click OK.

« « SQL Server 2005 – Using the Sqlcmd Utility
SQL Server 2005 – Populating the Database » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 392 Followers
  • Popular
  • Recent
  • Using XML in SQL Server 2005

    October 26, 2005 - 0 Comment
  • SQL Server 2005 – Using the Database Tuning Advisor

    December 24, 2005 - 0 Comment
  • SQL server 2005 Editions

    November 23, 2005 - 0 Comment
  • SQL Server 2005 – Using Event Notifications

    December 13, 2005 - 0 Comment
  • XML Data Types in SQL Server 2005

    October 26, 2005 - 0 Comment
  • Managing SQL Server 2005 Security

    December 24, 2005 - 0 Comment
  • SQL Server 2005 Installation

    November 23, 2005 - 0 Comment
  • Getting started with SQL Server 2005

    August 9, 2005 - 0 Comment
  • Using SQL Sever Management Studio – Part 1

    December 15, 2005 - 0 Comment
  • Native HTTP Support in SQL Server 2005

    November 1, 2005 - 0 Comment
  • SQL Server 2005 – Configuring Replication

    January 11, 2006 - 0 Comment
  • SQL Server 2005 Replication Enhancements

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Mirror Server

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Introduction to Data Availability

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Backing up a Database

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Using Database Snapshots

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Disaster Recovery

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Certificates

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Permissions

    December 26, 2005 - 0 Comment
  • Managing SQL Server 2005 Security

    December 24, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • SQL Server 2005 – Configuring Replication
  • SQL Server 2005 Replication Enhancements
  • SQL Server 2005 – Mirror Server
  • SQL Server 2005 – Introduction to Data Availability
  • SQL Server 2005 – Backing up a Database

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT