Test software for connections - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Test software for connections

Author

Topic

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-04-23 : 18:00:24

We are now changing all of our sql logins to be NT Logins via service accounts or by groups etc.

The problem comes when developers say connections can't be made. So i usually end up right clicking studio and putting in the DOMAIN/NT account& password to confirm this.

Anyone got of another way to easily test this that i can give to the developers

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-23 : 18:16:34

You can't input domain\account and password. SSMS and all other apps that use windows authentication use the current security context of the person that is logged in.

What error are they getting?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-04-23 : 22:36:38

We will use NT so only use DOMAIN\username when connecting not select sql.

But when i test i right click studio and do run as DOMAIN\Username and put password in (just as if i had login to the network as this user)...then when it says connect as to SQL i say NT.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-23 : 22:55:41

Sounds you have different kind of ssms, I like to know how. Tried to follow what you said but not even close.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-24 : 00:17:40

TRACEYSQL, you need to explain in much greater detail as what you have described is not possible Management Studio with Windows authentication. It is not possible to type in Domain\user. Windows authentication means to use the current security context of the person logged into the OS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-04-24 : 13:46:08

So Before launching Studio hold down shift key and do run as
Enter the Domain\Username (this is a group in AD or could be service account).

Then it says enter password which is password in AD.

Once Studio lauches - Then just click NT (which is now running studio as the Domain\Username (no pwd here)

Domain\Username must be in SQL as a NT Login.

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-04-24 : 14:00:44

For example i log into our domain network as
domain\tracey and i can just click on studio and im using NT authenciation and i choose NT.

But for testing the other domain\users i do not want to log entirely out of the domain and come in as domain\users so im doing the hold shift key and doing run as

Hope that helps clarify......

Basically kind of a long way around to keep testing the domain\users accessibility for tables db etc...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-24 : 14:10:02

That would be the easiest way to test it then.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-24 : 21:52:43

Ok, you use run as feature. Agree, no other way is easier.

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-04-25 : 17:51:18

Too bad .....perhaps i have to write a program for my developers
to be able to use..