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


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

How to change the login name for the dbo account?

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server
 

I need to change the login name for the dbo account on several databases to the SQL sa name instead of using a Windows authentication domain name.  I haven't been able to find a way to make this change. 




View Complete Post


More Related Resource Links

stsadm change in 2010? login as system account problem

  
Hey,

I have installed SharePoint 2010 beta 2 on a HP Blade in a Domain Environment. SQL Server 2008 SP1 CU2 is on a seperate Blade. Installation and configuration went ok. Everything runs under my Domain-Admin Account (SQL, Farm, ...)

The first few sites went smooth, after a while i noticed that not my Domain-Admin Account was written in the top-right corner, but "System Account". I remembered that problem from MOSS 2007 and tried stsadm updatefarmcredentials. Result after 30 seconds of waiting:
Value cannot be null.
Parameter name: farm

To be exactly i tried: stsadm -o updatefarmcredentials -userlogin XXX -userpassword XXX

There is definatly no typo and i tried varios different things like with "" and without "", with -identitytype and withou, and so on..

When i change the Farm-Account at the GUI, to a normal Account, i see my Domain-Admin Account in the top right corner again instead of System Account. When i change back, the same problem occurs.

Im pretty sure i resolved the issue in 07 with the command written above. Did the syntax change? Do i have to use Powershell? It looks like i have to specify the farm somehow (even thou there is only one farm consisting of one server on which im running the command)

Of course i'd be happy for any other solution to th

System.Data.SqlClient.SqlException: Login failed for user . Reason: The account is disable

  

Hi All,

Thank you for advance.

I created a widows service for mail schedule with c#.net and sql server 2005 and it is working fine for past one year.

now sometimes i am getting the "System.Data.SqlClient.SqlException: Login failed for user '<UserName>'. Reason: The account is disabled." error.

then i restarted the windows service manually and working.

what is the problem in my sql server connection and how to fix that issue?


Change the Timer Service Account

  
I did an install with Sharepoint 2010 RTM and have it working well but when I checked the Monitoring - Review Problems and solutions it states a security concern that the Farm Account should not be used for other services.  At this stage I have to change out the timer service since it is using the farm account.  But I don't see the timer service in the "Security - Manage service Accounts" location.  I created a timer account with no problems but how does one go about changing the timer service to use this account?  I know I can go to services and change it there but I am wondering if there is a need to do this within Sharepoint?  Am I missing a credential management piece that did not show up in the list of services? Any help would be appreciated Workerbee09  By the way, The problem points to a failing service SPTimerService (SPTimerV4) but its started and working cause I can see services being started and history of the service where it was successfull. 

Failed to change Farm Account in Sharepoint 2010 server, now Central Administration is not accessibl

  
Hello, I have a problem, that I no longer can access Central Administration Website, only the Sharepoint itself. I was running installation of Sharepoint 2010 Server with administrative account ImTheAdmin, who is a Domain Admin in the domain on one of the Windows 2008 R2 member servers. Besides that, I made ImTheAdmin the primary administrator of the Sharepoint. ImTheAdmin became the only user of this Sharepoint 2010 server after installation.  I installed everything on one box with default installation settings. I used builtin SQL server, not Standard or Enterprise. What then happened is: Using ImTheAdmin account, I opened Central Administration Website, and it said, that I need to change the Farm Account, for the account for Farm was the default one (I think it was network service). So I created a regular domain user MYDOMAIN\SharepointFarmAccount. The account name was too long to be as a Windows 2000 name, so it showed there without last 't', e.g. MYDOMAIN\SharepointFarmAccoun. I thought, Windows 2000 is long gone, so I didn't pay much attention, I think everywhere the account SID is important. I don't know if that is the real problem with my failure later, but it might be one of the reasons. I put MYDOMAIN\SharepointFarmAccount down in to the form of Central Administration Website, added the check mark, that it would react to password changes, and pre

Change the Timer Service Account

  
I did an install with Sharepoint 2010 RTM and have it working well but when I checked the Monitoring - Review Problems and solutions it states a security concern that the Farm Account should not be used for other services.  At this stage I have to change out the timer service since it is using the farm account.  But I don't see the timer service in the "Security - Manage service Accounts" location.  I created a timer account with no problems but how does one go about changing the timer service to use this account?  I know I can go to services and change it there but I am wondering if there is a need to do this within Sharepoint?  Am I missing a credential management piece that did not show up in the list of services? Any help would be appreciated Workerbee09  By the way, The problem points to a failing service SPTimerService (SPTimerV4) but its started and working cause I can see services being started and history of the service where it was successfull. 

Unable to change the Service account??

  
Followed this guide: http://support.microsoft.com/kb/832770 I have setup my account SPadmin to have access to my SQL DB i went into IIS and attempted to change it there for my Default sharepoint site in the applications pool page > Properties>Identity Nada, i changed it his apply reset IIS and back to my old account(very frustrating) so further reading showed attempting to change it via Central administration.   Went there and chose Operations>Service accounts chose my webservice,Application pool and configurable and setup my SPadmin, reset IIS and still no change.   Thoughts? i feel like there is  some stupid step i'm missing because it will not change regardless.   Thanks Steve K

change system account to username?

  
HI, I have created out-of-box workflow ,in the version history the modifiedby column  showing as system account instead of username. so want to display actual username instead of system account. help is appreciated. Thanks.

How to change the System Account into Domain Administrator account in Sharepoint?

  
I'm attaching the captured image from the Central Admin of our Sharepoint Server. (http://www.experts-exchange.com/images/346242/Central-Admin.jpg) As you can see from the Central Admin image, the user account shown is "System Account", in whereas I logged in as our Domain Administrator. Then when you check it's info from My Settings, the details from the captured image System Account Info was shown. ( http://www.experts-exchange.com/images/346243/System-Account-Info.jpg) How can I change it as be DOMAIN\Administrator & not SHAREPOINT\system or System Account? Please advise...  

newbie question: change login name of dbo user

  

My database has a user "dbo" which is dbo of all database objects. The login name for this user is e.g. "Login1". Now I need to change the login name for user "dbo" from "Login1" to a new login name "Login2".

It is not possible to change the related login name of the user "dbo" in the user's properties dialog. And it is also not possible to change or remove the dbo relation in the login name's properties dialog (because a dbo user can not be removed).

Is there any possibility to change the login name of an dbo user? How can I do it?


How to create separate login account for members ?

  

I have developed a web application in which i manage details of different companies,,,for that i as admin add companies and their details in my database...right now my role is administrator in my web application

The problem is everytime i have to update company details and other information

I want companies to update their own information...

so how i can create a role and create usernames for companies so that they can login to their individual accounts and update the company information by themselves ?

One important thing of my requirement: One company can have multiple usernames accounts...

How to accomplish this ? please guide me ...



Login failed for user 'XXX'. Reason: Attempting to use an NT account name with SQL Server Authenti

  

Under a network service account. I want to perform some operations on the SQL server DB.

I am passing the user id and password of the admin on that box. Still I am getting Login failed for user 'XXX'. Reason: Attempting to use an NT account name with SQL Server Authentication.

Is there any way i can connect to Sql server with user id and password?

Connection string i am using is Data Source=imdbstrs22;Initial Catalog=DataStore;Integrated Security=false;user Id=XXX;password =Imdbaug#10;

 

 

 

 


login form change ASPNETDB.mdf

  

Hi guys.


i have a database with username and passwords. Can anyone please help me showing how can i make the login form point to my database and do not create a new ASPNETDB.mdf file???I am thinking about using a web service to check if the user is present (is that a good idea??).


Is there PowerShell command to change service application account?

  

I associated User Profile Synchronization Service with managed account "svcebrd" in CA. For some reason this created duplicated managed account. Now there are two "svcebrd" under Configure Managed Account. If I try do delete one of the accounts in CA I get "key has already been added in dictionary". Running Remove-SPManagedAccount fails with "The account Dev\svcebrd is still being used by ... User Profile Syncronization Service".

Does anybody know powershell command to changed service application account?

 


SQL Job not able to sen email after SQL Server Service Account change

  

Hi,

I changed on the SQL Server service account to a least priviledge domain user.  However after the change, one of my sqljob which use sp_send_dbmail is not functioning. after checking on the log, it mentioned no permission. i tried to set the MSSQLUser Group as db_owner of msdb database, but it was not helping. When i set the MSSQLUser group as sysadmin ,then only the job able to send email. what could be the least priviledge of the service account so that i able to send email via sql job?


How to change the Display name upon Login

  

Hi,

 

Am using below code to display UserName, I want to display First Name instead of username, Please give me ideas how can i change this.

Need it urgent.

<WebPartPages:DataFormWebPart runat="server" ShowWithSampleData="False" AllowRemove="True" AllowHide="True" SuppressWebPartChrome="True" PartImageLarge="" ViewContentTypeId="" ExportMode="All" Dir="Default" MissingAssembly="Cannot import this Web Part." ID="g_4e78e68a_a414_49b6_84e4_6e841afbdca8" DataSourceID="" IsIncludedFilter="" DetailLink="" AllowEdit="True" UseSQLDataSourcePaging="True" HelpMode="Modeless" IsIncluded="True" Description="" NoDefaultStyle="TRUE" FrameState="Normal" AllowConnect="True" ViewFlag="0" AllowZoneChange="True" AllowMinimize="True" Title="Channel Configuration" PartOrder="1" PageSize="-1" FrameType="Default" HelpLink="" PartImageSmall="" ConnectionID="00000000-0000-0000-0000-000000000000" ExportControlledProperties="True" IsVisible="True" __MarkupType="vsattributemarkup" __WebPartId="{4E78E68A-A414-49B6-8

The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)

  

 

Hi,

 

I have two databases xxx and yyy.

I added a new user to xxx named as "Admin". It ownes some schemas.

Afterwards I added a new user to yyy named as "Admin". It ownes the same schemas.

Then I pressed ok button, got the error:" The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)".

 

 

Could you please give me some advice?

 

Thanks


Change Farm Account?

  

Hello,

SharePoint 2010, I am trying to change the Farm Account. I made the change to a new farm account under Central Admin > Security > Configure Service Accounts. The change seems to have gone through, however, when I delete the old user account that was being used for the Farm Account and I try to backup sharepoint it fails. If I re-create the old farm account in Active Directory (don't change anything in Central Admin) I can backup again. The specific error I get from STSADM is "The specified user or domain group cannot be found". I'm assuming that the old Farm Account still have something it's holding onto in SharePoint 2010 that the new farm account should have and doesn't.

Any help?


Owner, Quilnet Solutions
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