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 |
|
skybvi
Posting Yak Master
193 Posts |
 Posted - 2011-11-23 : 11:40:28
|
| Hi,I am pretty confused, If we can have 2 sa on an instance in sql server 2005.I mean 2 logins such as sa and sa1, whcih have same privileges and all permissions of an sa..Is that possible.Regards,SushantDBAWest Indies |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-11-23 : 12:17:32
|
| I made sa and sa1 identical(permissions,privileges) in SSMS,but when I go to MS dynamics GP ( front end) which is using SQL server at back end and login with sa1...I can't do custmization ( importing packages) whcih i can do with sa only..How is that possible?Regards,SushantDBAWest Indies |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-11-23 : 12:29:16
|
| I already give sa1 as sysadmin server role.No change.Regards,SushantDBAWest Indies |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-11-23 : 12:43:49
|
| ok I got it..After setting it as sa1 ..a role has to be set from Dynamics GP side.(Poweruser role for sa1)Thanks a lot.Regards,SushantDBAWest Indies |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
2 sa