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.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-12-13 : 15:37:30
|
| Hi,How to script out credentials under security tab in sql server 2005.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-13 : 16:34:37
|
| Thanks Tara for reply. There is one tab under security tab called Credentials. Under credentials we can create credentials from login. I want to script those credentials not logins. |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-12-14 : 11:58:21
|
| This is what we use. You may need to augment it if you're using EKM.[CODE]select 'CREATE CREDENTIAL ' + name + ' WITH IDENTITY = ''' + credential_identity + ''', SECRET = ''<Put Password Here>'';'from sys.credentials order by name;[/CODE]BTW, the SECRET clause is optional so you could probably do without it.=======================================Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-14 : 12:42:12
|
| Thanks Bustaz, it works. Another question is if I ignore SECRET clauase, how password will be copied? I dropped a credentials, used script created by your select statement and remove secret part, new credential created with password, I don't know from where it copied password. May be this password different from previous. |
|
|
|
|
|
|
script out credentials