.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Unable to delete orphan user from sysusers

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
 
SQL Server 2005 I have an orphan user in the application database called  [ \opdbo]These are the following these i have tried       sp_droplogin   '[\opdbo]' go sp_dropuser   '[\opdbo]' go sp_dropalias   '[\opdbo]'   EXEC   sp_addlogin '[\opdbo]' , 'Test123', 'opprod' GO EXEC   sp_change_users_login 'update_one','[\opdbo]' , '[\opdbo]' zero rows come up with this query SELECT   UserName = name FROM sysusers WHERE   issqluser = 1 and (sid is not null and sid <> 0x0) and   suser_sname(sid) is null ORDER   BY name     But the user shows up in select * from sysusers   I did find some articles where it says to sign in as DAC.  Is there any other way to delete this user? Lori


View Complete Post


More Related Resource Links

Unable to search Custom User Property Created in User Profiles in SharePoint 2010

  

Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise


unable to delete a column from library in sharepoint 2007

  
Hi When deleting  any column in document library we are getting the below error Unable to validate data.   at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)    at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString) Also tried to hide/remove the search content place hoder in master page but nothing works. Removed our custom master page with default master page still no changes are being observed. Thanks & Regards. Prerna

Unable to start user profile synchronization service

  
Hello, I have the following problem. user profile synchronization service doesn't start up, with the following error in log: The service encryption keys could not be found. User Action Verify that the service account has permissions to the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Forefront Identity Manager\2010\Synchronization Service If the problem persists, run setup and restore the encryption keys from backup. Permissions for registry are availabele. Thank you.    

Unable to validate data in User Agent: Mozilla

  
Hi All,Thank you for advance.Error Details : User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows XP)Message: Unable to validate data.Source: System.WebTargetSite: Byte[] GetDecodedData(Byte[], Byte[], Int32, Int32, Int32 ByRef)StackTrace:    at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)   at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)OS Environment : Microsoft Windows Server 2003 Statandard x64 Edition and Service back 1Application Environment : Asp.net 2.0/C#We have lot aspx files but we are getting this error in register and login page only.I added the machineKey in web.config file reference with codeproject article (http://www.codeproject.com/Articles/43637/Weird-Error-Unable-to-Validate-Data-in-ASP-NET-web.aspx)but still i am getting the error.

Cannot drop a "orphan" user because it does not exist

  
I have a user identified as a orphan user that I cannot drop.  The user is not listed in the Logins folder or the Users folder for the database but when I query the database with select * from sysusers where name = '\xyz' it returns a row.  I get the following error when I try to DROP USER [\xyz]; OR exec sp_revokedbaccess '[\xyz]'.  Any ideas?  Msg 15151, Level 16, State 1, Line 2 Cannot drop the user '\xyz', because it does not exist or you do not have permission

Unable to authenticate to web services for a SharePoint 2010 logged in user

  
Hi, I have a requirement to connect to a webservice from SharePoint 2010 without passing Network credentials explicitly. If i am already logged into the SharePoint 2010 portal , I should be able to click on Search (which is a web service(wsdl file) which retrieves search results from Oracle UCM) and retrieve the result. I tried localhost.ServiceX myProxy = new localhost.ServiceX(); myProxy.Credentials = System.Net.CredentialCache.DefaultCredentials; also myProxy.UseDefaultCredentials = True Still i am unable to authenticate. Default credentials returns null value.   Kindly help.

Unable to authenticate to web services for a SharePoint 2010 logged in user

  
Hi, I have a requirement to connect to a webservice from SharePoint 2010 without passing Network credentials explicitly. If i am already logged into the SharePoint 2010 portal , I should be able to click on Search (which is a web service(wsdl file) which retrieves search results from Oracle UCM) and retrieve the result. I tried localhost.ServiceX myProxy = new localhost.ServiceX(); myProxy.Credentials = System.Net.CredentialCache.DefaultCredentials; also myProxy.UseDefaultCredentials = True Still i am unable to authenticate. Default credentials returns null value.   Kindly help.

Unable to start SQL Express 2005 service as a network user

  
I am trying to start ms sql server 2005 express as a network user from originally starting as local system. I cannot start the service.I have given this network user administrator access to sql express from the sql server surface area configuration "Add New Administrator". I have went into the local users/groups and added this network user to the 3 security groups SQLServer2005MSSQLServerADHelperUser$SQL1SQLServer2005MSSQLUser$SQL1$SQLEXPRESSSQLServer2005MSSQLBrowserUser$SQL1I receive one alert int he event logs/applicationEventID: 26010The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.I receive five errors in the event logs/applicationEventID: 26014Unable to load user specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.EventID: 17182TDSSNIClient initialization failed with error 0x80092004, status code 0x80EventID: 17182TDSSNIClient initialization failed with error 0x80092004, status code 0x1EventID: 17826Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately prceding this one in the error log.EventID: 17120SQL Serve

Unable to Customize Custom Lists. Sharepoint Error: User cannot be found.

  
I am not sure what the best way to put/describe my issue . I am unable to customize my custom list. Steps: 1. Login to sharepoint site. 2. Site Actions -> Site Settings 3. Under Site Administration -> Site Libraries and lists 4. Clicked on a custom list.   Error: Error User cannot be found.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 4063bf58-9cb7-4204-8cc4-cc2889abffe3 Date and Time: 9/9/2010 5:51:58 PM   I figured this may be an issue with site permissions, so I have went into site permissions and removed and re-added Administrator into Homeowners group.   Thank you in advance.   Howie

what happens with the sharepoint documents of a concrete user when you delete his user account DA

  
Hello, I need remove a user account from Active Directory. I don't know exactly what happens with the documents uploaded in sharepoint (on both parts, the general part and "my site") by a concrete user when I remove its user account from the Active Directory.   Thanks in advance.    

Delete User Account

  
Hi,   I'm trying to find out what is the best way to remove a user from MOSS 2007?   What happens if I go into Site Admin and just delete the profile, does this remove the person from Search? Will this interfere with any places in the site where their name is evident in a people look up.   If you can provide me with any suggestions I would be grateful.   Thanks.

User unable to edit there own announcement

  
I have a really strange issue where a user has created an announcement and posted it with no problem at all. Now they want to go back to it and edit it but as soon as they click on their announcement it pops up with Access Denied page. I have given the user Approve permissions but this still keeps happening. A full administrator, like myself, can go in and edit it quite happily so not sure what is going on here. Our system was upgraded from 2007 to 2010 and the new 2010 interface has not yet been applied. Has anyone else seen this before?

Unable to see Active Directory Groups in the User Profile Database after Profile Import

  
SharePoint Server 2010 Enterprise RTM. W2K8R2 w/multi-server setup: AD/DNS SQL 2008 WFE APP Claims Mode Web App only using Windows Integrated Auth So, this was never a problem in 2007, and I didn't even realize it was a problem in 2010 until I started to build a solution that utilized my blog article: InfoPath - User Roles in Browser-Enabled Forms Using AD Groups.  I went to utilize the same web method of the same web service, but I noticed that no data was showing up at all.  Typically, the GetUserMembership/GetCommonMembership methods return the specified user's memberships: AD Security Groups, AD Distribution Lists, and SharePoint Sites (not SharePoint Groups, though). My user profile sync is working.  All AD users are pulled in with the proper profile data. "Users and Groups" is selected in the Synchronization Entities section of my Sync Settings. Security groups are working for permissions and audience targeting.  Confirmed my users are affected properly by the use of Security Groups. My query to the GetUserMemberships web method (and GetCommonMemberships) is running (not failing), but it's not returning anything even though my user is in some Security Groups and has explicit membership to multiple sites. The GetUserProfileByName method of the same UserProfileService.asmx web service returns all the regular profile data

Unable to delete groups in SharePoint Foundation 2010

  
I have a test group I created in SharePoint that I want to delete (I'm the only user in the group). In the "People and Groups: All Groups" screen I click the edit icon next to the group and then click on the "Delete" button and ok the following warning dialog. However, the group doesn't get deleted. Any idea why this is happening and how to finally delete this group? Thanks.

Unable to delete a "Web Application" In sharepoint central administration

  

Hello All..

I am struck here with a peculiar problem I have created a new web application to work with.

And now i want to delete that but sharepoint is not enabling some icons in ribbon like delete option.

Please enlighten me how can I delete that web application.


Is there a way to undo/remove/delete an active directory user profile syncronization? [SP 2010]

  

I successfully managed to synchronize the active directory with Sharepoint 2010.  Unfortunately, the farm I was on has different FQDN /Netbios domain names.  So all ~1000 user profiles are now imported with the wrong domain, and the subsequent errors one would expect.

 

Is there a way to get back to a blank slate?  technet has an article on "resetting" profile synchronization (http://technet.microsoft.com/en-us/library/ff681014.aspx), but that requires being able to verify the GUID of the user profile synchronization database, which I am also unaware of how to do.

 

Please help, and thank you in advance.


Unable to Edit & Update user Profile Information

  
I Have a sharepoint Site.. I am trying to configure alter in the site..But Email ID are not available bel for all the users..I tried to Update the user Profile info by clicking the edit Item button in the user profile information.But it is not showing any editable content...It is just showing user NTlogin?This site is not connected to active directory.. We are adding users manually..How to update user details?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend