what are credentials in sql server 2005

Question

Post reply

what are credentials in sql server 2005

sanketahir1985

SSCarpal Tunnel

Points: 4473
More actions
August 4, 2010 at 5:45 am

#236148

Hi friends,
What are the CREDENTIALS?
Where are they used?
How to use them?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Assuming you mean the actual object called a Credential

http://msdn.microsoft.com/en-us/library/ms189522%28SQL.90%29.aspx

http://msdn.microsoft.com/en-us/library/ms190703%28SQL.90%29.aspx

If you mean something else, please give more detail

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sanketahir1985 SSCarpal Tunnel Points: 4473 More actions · Answer 2

Hi Gail,

i have already seen the links u provided, my concern is where & how those credentials are used?

do u have any practical example ?

Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......

Brandie Tarvin SSC Guru Points: 173064 More actions · Answer 3

Apparently you didn't read the first line of the second article.

A credential is a record containing the authentication information needed to connect to a resource outside of SQL Server.

Real life examples depend on what you're trying to connect to. I'd say Linked Servers probably use Credentials, though the GUI refers to "security context".

Here's another brief link

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

sanketahir1985 SSCarpal Tunnel Points: 4473 More actions · Answer 4

how will i map logins to those credentials?

Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Did you bother to read those links I gave you?

Straight from the first one:

After creating a credential, you can map it to a SQL Server login by using CREATE LOGIN or ALTER LOGIN.

If you want the exact syntax, open books online and look under CREATE LOGIN or ALTER LOGIN.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Suresh B. SSC-Insane Points: 22986 More actions · Answer 6

sanketahir1985 (8/4/2010)
Where are they used?

You need to create a Credential firstly to create a Proxy (under SQL Server Agent).