Entry

Database: Microsoft SQL server: Server: Create: New: How to create a new server registration?

Dec 22nd, 2003 15:00
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 22 December 2003 - 11:58 pm -------------------

Database: Microsoft SQL server: Server: Create: New: How to create a 
new server registration?

---

Steps: Overview:

 1. -Open Microsoft SQL server 'Enterprise Manager'

 2. -Expand 'Microsoft SQL Servers' in the left pane
     (by clicking on the '+')

 3. -Right click on 'SQL Server Group' in the left pane

 4. -select from list 'New Server Registration'

 5. -A dialog box 'Register SQL Server' wizard opens

 6. -click button 'Next'

 7. -Type the name of your Microsoft SQL server in
     the box 'Available servers:'

      e.g.

       mysqlserver

     (you will have to adapt this to that Microsoft SQL server
      available on your system)

     ---

     Note: this Microsoft SQL Server might also be available via
     the Internet.

 8. -click button 'Add'

 9. -click button 'Next'

10. -enable radio button 'SQL Server authentication'

     1. -Supply your (provider's) login name

     2. -Supply your (provider's) password

11. -click button 'Next'

12. -accept (for example)
     'Add the SQL Server(s) to an existing SQL Server group'

13. -click button 'Next'

14. -click button 'Finish'

15. -If everything goes allright, you should see a message box showing

      'Register SQL Server messages'

     Status:

      <your Microsoft SQL server name> - Registered successfully

16. -To connect, click on the icon for this server

     1. That will show e.g. 'databases',

     2. You will have to choose one particular database
        that is the database as assigned to you by your
        provider (as there might be more persons who have
        bought databases at your provider)

        1. In this database you are the administrator, and there
           you can add tables, ...

---
---

Internet: see also:

---

Database: Microsoft SQL server: SQL: Operation: Overview:Can you give 
an overview of SQL operations?
http://www.faqts.com/knowledge_base/view.phtml/aid/27560/fid/147

----------------------------------------------------------------------