Results 1 to 5 of 5

Thread: Enterprise Manager/Server Connection Question

  1. #1
    Gary Andrews Guest

    Enterprise Manager/Server Connection Question


    When I startup EM it automatically starts up the console
    root which contains the server groups (and servers within
    the groups).

    How do I specify whether I want to connect to a server
    as a trusted NT connection or connect using SQL server
    login facilities?

    I can right click the server (withing a server group) and
    get a popup menu which says CONNECT or DISCONNECT
    depending on the current connection state.

    But I can not modify the CONNECT sub-menu item.

    Instead of choosing the CONNECT or DISCONNECT I can
    choose the PROPERTIES sub-menu and from there select
    the SECURITY tab.

    However the SECURITY tab shows that the circle for
    "SQL Server and Windows NT" authentication as
    being selected.

    I am trying to find if it has the same capability as SQL
    QUERY ANALYZER where you pick the method of login:

    As an NT trusted connection or as a SQL Server login.

    Thanks for any help, suggestions, etc.!!



  2. #2
    Joe Miller Guest

    Enterprise Manager/Server Connection Question (reply)


    ...'However the SECURITY tab shows that the circle for
    "SQL Server and Windows NT" authentication as
    being selected.'...

    Selecting 'Windows NT only' will require trusted connections.

    jm



  3. #3
    Gary Andrews Guest

    Enterprise Manager/Server Connection Question (reply)

    The circle which says "Windows NT Only" is
    not selected. The circle which says SQL
    login and Windows NT is the "selected"
    circle.

    Thanks.

    ------------
    Gary Andrews at 7/26/00 11:07:09 AM


    When I startup EM it automatically starts up the console
    root which contains the server groups (and servers within
    the groups).

    How do I specify whether I want to connect to a server
    as a trusted NT connection or connect using SQL server
    login facilities?

    I can right click the server (withing a server group) and
    get a popup menu which says CONNECT or DISCONNECT
    depending on the current connection state.

    But I can not modify the CONNECT sub-menu item.

    Instead of choosing the CONNECT or DISCONNECT I can
    choose the PROPERTIES sub-menu and from there select
    the SECURITY tab.

    However the SECURITY tab shows that the circle for
    "SQL Server and Windows NT" authentication as
    being selected.

    I am trying to find if it has the same capability as SQL
    QUERY ANALYZER where you pick the method of login:

    As an NT trusted connection or as a SQL Server login.

    Thanks for any help, suggestions, etc.!!



  4. #4
    Toni Guest

    Enterprise Manager/Server Connection Question (reply)

    It seems to me that you just need to edit the SQL Server
    registration properties. To do this, right click on
    the server in question and select 'Edit SQL Server
    Registration Properties..' This will enable you to
    modify your connection information.

    HTH
    Toni



    ------------
    Gary Andrews at 7/26/00 11:40:22 AM

    The circle which says "Windows NT Only" is
    not selected. The circle which says SQL
    login and Windows NT is the "selected"
    circle.

    Thanks.

    ------------
    Gary Andrews at 7/26/00 11:07:09 AM


    When I startup EM it automatically starts up the console
    root which contains the server groups (and servers within
    the groups).

    How do I specify whether I want to connect to a server
    as a trusted NT connection or connect using SQL server
    login facilities?

    I can right click the server (withing a server group) and
    get a popup menu which says CONNECT or DISCONNECT
    depending on the current connection state.

    But I can not modify the CONNECT sub-menu item.

    Instead of choosing the CONNECT or DISCONNECT I can
    choose the PROPERTIES sub-menu and from there select
    the SECURITY tab.

    However the SECURITY tab shows that the circle for
    "SQL Server and Windows NT" authentication as
    being selected.

    I am trying to find if it has the same capability as SQL
    QUERY ANALYZER where you pick the method of login:

    As an NT trusted connection or as a SQL Server login.

    Thanks for any help, suggestions, etc.!!



  5. #5
    Gary Andrews Guest

    Enterprise Manager/Server Connection Question (reply)

    Toni, you are correct.

    Thank you very much!!!


    ------------
    Toni at 7/26/00 2:47:56 PM

    It seems to me that you just need to edit the SQL Server
    registration properties. To do this, right click on
    the server in question and select 'Edit SQL Server
    Registration Properties..' This will enable you to
    modify your connection information.

    HTH
    Toni



    ------------
    Gary Andrews at 7/26/00 11:40:22 AM

    The circle which says "Windows NT Only" is
    not selected. The circle which says SQL
    login and Windows NT is the "selected"
    circle.

    Thanks.

    ------------
    Gary Andrews at 7/26/00 11:07:09 AM


    When I startup EM it automatically starts up the console
    root which contains the server groups (and servers within
    the groups).

    How do I specify whether I want to connect to a server
    as a trusted NT connection or connect using SQL server
    login facilities?

    I can right click the server (withing a server group) and
    get a popup menu which says CONNECT or DISCONNECT
    depending on the current connection state.

    But I can not modify the CONNECT sub-menu item.

    Instead of choosing the CONNECT or DISCONNECT I can
    choose the PROPERTIES sub-menu and from there select
    the SECURITY tab.

    However the SECURITY tab shows that the circle for
    "SQL Server and Windows NT" authentication as
    being selected.

    I am trying to find if it has the same capability as SQL
    QUERY ANALYZER where you pick the method of login:

    As an NT trusted connection or as a SQL Server login.

    Thanks for any help, suggestions, etc.!!



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •