SQL Server credentials - 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

General SQL Server Forums

New to SQL Server Programming

SQL Server credentials

Author

Topic

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2010-05-18 : 16:42:36

HOW TO KNOW I INPUT RIGHT PASSWORD for the Windows User? Because even if you type in the wrong password it will still let you click oK.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-18 : 18:55:20

You can't type in a password for a Windows user in SSMS. You can do "Run As", but that sounds different than what you are doing. Userid/password combo is only used for SQL authentication.

If a password is wrong, then it will error.

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

Subscribe to my blog

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2010-05-19 : 18:26:16

I'm talking about Security\Credentials

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-19 : 18:44:01

Oh ok, that feature is rarely used from what I understand. Just curious, what are you using it for?

I would assume you'd need to test it in order to know you input the right password. For instance, credentials are used for .NET assemblies that need external access. To test the password, you'd run the assembly.

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

Subscribe to my blog

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2010-05-19 : 19:29:59

I use it to create a proxy in order to run a SQL job that runs a SSIS package.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources