Toad World® Forums

[toadss] Windows authentication


#1

[toadss] Windows authentication


#2

Matt, I think you use another editor in conjunction with Toad-ss, do you have
the capability to login to another domain with different credentials than on
your current desktop system.

As an example my Window 7 Ultimate system is NOT connected to a domain
(userid=Hank_ Freeman), but the domain name(userid) I want to log into could be
h_freeman or hfreeman and what I wanted was the ability to specify either of the
later for a specific domain. So I want to put in the Domain name, userid and
password to as to connect Toad.

Lee, Let me know If there is anything, I can do to assist, Currently, I do not
have access to any domain server that has SQL Server, so testing is not
available at this time. I still think this is an idea worthy of your time

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image001.gif


#3

Matt, I think you use another editor in conjunction with Toad-ss, do you have
the capability to login to another domain with different credentials than on
your current desktop system.

As an example my Window 7 Ultimate system is NOT connected to a domain
(userid=Hank_ Freeman), but the domain name(userid) I want to log into could be
h_freeman or hfreeman and what I wanted was the ability to specify either of the
later for a specific domain. So I want to put in the Domain name, userid and
password to as to connect Toad.

Lee, Let me know If there is anything, I can do to assist, Currently, I do not
have access to any domain server that has SQL Server, so testing is not
available at this time. I still think this is an idea worthy of your time

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image002.jpeg


#4

Hank, I am using SQL Prompt which is a plug in for SSMS not a complete stand
alone tool.

I am not 100% certain but if one were able to select Windows Authentication and
the login and password were not grayed out, and you put
“Domain\UserName” in the user name and put in the password, it
should work as I think there are places where I can put that info in and it
works. But this might not work as MS might have designed SSMS to work like this.
But one cannot do that in Toad or SSMS because when you select Windows
Authentication, the user and password is grayed out.

Just for grins, I selected SQL authentication and tried to put
“Domain\UserName” but that did not work.
image002.jpeg


#5

Hank, I am using SQL Prompt which is a plug in for SSMS not a complete stand
alone tool.

I am not 100% certain but if one were able to select Windows Authentication and
the login and password were not grayed out, and you put
“Domain\UserName” in the user name and put in the password, it
should work as I think there are places where I can put that info in and it
works. But this might not work as MS might have designed SSMS to work like this.
But one cannot do that in Toad or SSMS because when you select Windows
Authentication, the user and password is grayed out.

Just for grins, I selected SQL authentication and tried to put
“Domain\UserName” but that did not work.
image001.gif