Sa is unable to delete user(urgent Pl. help)

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Sa is unable to delete user(urgent Pl. help)

Author

Topic

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2007-12-10 : 16:09:06

Please help, it's urgent!!
Sa is trying to delete a user from the Great Plains application and got the follow error:
Deleting the login failed for an unknown reason, contact your sql server administrator for assistance.
DB is sql server 2000

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-10 : 16:23:22

Not sure how we can help when the error says "for an unknown reason".

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

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-10 : 16:30:04

Is this error message originating from SQL Server or from Great Plains application?

E 12°55'05.25"
N 56°04'39.16"

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2007-12-10 : 16:30:09

I looked at the properties of the login sa, under server roles: only the system administrators is checked, I tried to check the security administrators which is for managing the logins for the server, I get the below error within SQL:
Error 15405: Cannot use the reserved user or role name 'sa'
Thx.

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2007-12-10 : 16:30:47

quote:
Originally posted by Peso

Is this error message originating from SQL Server or from Great Plains application?

E 12°55'05.25"
N 56°04'39.16"

Within the GreatPlains.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-10 : 16:31:15

Sysadmin is the highest level. It does not require anything else. Never, ever attempt to modify the sa account.

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

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-10 : 16:34:29

Is SA user trying to delete itself?

E 12°55'05.25"
N 56°04'39.16"

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2007-12-10 : 16:35:10

quote:
Originally posted by Peso

Is SA user trying to delete itself?

E 12°55'05.25"
N 56°04'39.16"

No, SA user is trying to delete another user.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-10 : 16:37:39

I don't think this is a SQL Server problem.
I think Great Plains is having trouble deleting a user within the GP application.

E 12°55'05.25"
N 56°04'39.16"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-12-11 : 07:23:39

what user is it trying to delete?

capture the statement by using dbcc inputbuffer(spid)
you can get spid by selecting from sysprocesses where dbid=GreatPlains_DBID

hope this helps...

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources