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.!!
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
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.!!
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.!!
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.!!
