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 |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2007-08-09 : 06:05:45
|
| Hi Guys,I'm trying to add the securityadmin server role to the sa user but have been unable to due to an error occuring. The error says "Add member failed for server role 'securityadmin'. Cannot use the special principal 'sa' Microsoft SQL Server error 15405."I assumed that the sa account would already have the required permission to perform most operations on the server but I have been asked to try assiging this server role to sa by a support guy for our third party product.Has anyone got any ideas why this error is occuring? I have been looking on loads of forums but cannot find anything relevant to me.Thanks in advance for any help! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-09 : 06:34:02
|
| sa should be sysadmin and already have that permission.People sometimes have problems if a database isn't owned by sa and they assume it is. Check that and ask what the product expects.(Also ask why they are using sa).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-09 : 22:21:47
|
| Don't mess up sa account. |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-08-10 : 06:48:16
|
Are you trying to say that hosing the SA account is not a good idea? Is that because it is used by 99.99998273% of "Third party" applications to connect to SQL Server?  [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
Problem adding securityadmin role to sa in 2005