Issue with sa username(Urgent, pl. help)

Last Post 17 Nov 2008 11:13 PM by ColinSarawan. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sqlserverdeveloper
New Member
New Member

--
10 Dec 2007 12:04 PM
Please help, it's urgent!!
we are using sql server 2000
Sa is trying to delete a user within the Great Plains application and got the follow error:
Deleting the login failed for an unknown reason, contact your sql server administrator for assistance.
Thanks.
nosepicker
New Member
New Member

--
10 Dec 2007 03:26 PM
One of the most common reasons for being unable to delete a login is that there is some object(s) in the database that is owned by that login (table, stored procedure, function, etc.). Check the database to see if this is true. Then, delete those objects first before deleting the login.
nosepicker
New Member
New Member

--
10 Dec 2007 05:51 PM
Yes, that's probably safer. Good point Russell!
ColinSarawan
New Member
New Member

--
12 Nov 2008 09:39 PM
I have the same issue...how did you resolve this
ColinSarawan
New Member
New Member

--
14 Nov 2008 01:05 AM
Howzit............I have 210 GP users that I need to delete. This due to naming conventions..we want to align our GP user account to be the same as our network account
ColinSarawan
New Member
New Member

--
16 Nov 2008 09:06 PM
Howzit Russell...will appreciate the script..........if you have the time....many thanks
ColinSarawan
New Member
New Member

--
17 Nov 2008 11:13 PM
Many thanks....will let you know how it goes
You are not authorized to post a reply.

Acceptable Use Policy