locked
Change SharePoint user & password RRS feed

  • Question

  • Background on this post can be found here:

    http://social.technet.microsoft.com/Forums/en-US/sharepointadminlegacy/thread/970534b1-3178-4c42-b6be-a3b3fbdb4972

    Long story short, attempting to move all of the databases for WSS3 from an old SQL 2005 server to a new SQL 2008 server while leaving the WSS front end server in place by following the directions here:

    http://technet.microsoft.com/en-us/library/cc512723(office.12).aspx

    Seems to work ok but SharePoint never comes back up.  I created a test.udl and found that the alias was working but according to the application log the login for SA was failing.  My SQL 2005 and SQL 2008 servers have different SA passwords.  I ran out of time last night and had to attempt to roll back to the old SQL server.  Took me until about an hour ago to get everything back running correctly.

    What's the best way to know what parts of SharePoint are using SA and how do I go about changing them without breaking everything again?

    Thanks in advance.

    Wednesday, November 14, 2012 8:13 PM

Answers

  • Hi,

    You can check the content database authentication type in Central Administration: Open Central Administration> Application Management> Content Databases. Click on the content database to view the setting. You will find the database authentication type: SQL or windows authentication. If the authentication is set to SQL and you want to change it to Windows authentication, you will need to first move the content database and add it again. Be careful when you add the content database back, you need to specify the right application, database server name and database name.

    For more information, please refer to this site:

    Sharepoint content database user: http://stackoverflow.com/questions/2782542/sharepoint-content-database-user

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.


    Entan Ming

    TechNet Community Support

    Friday, November 16, 2012 3:30 AM
    Moderator

All replies

  • There is no ooo way to confirm where this account is in use , but may be some code customization can achieve that data for you.

    Wednesday, November 14, 2012 10:59 PM
  • All I really care about is being able to change content database from SQL Authentication to Windows Authentication.  How the heck do I do that?
    Thursday, November 15, 2012 7:18 PM
  • Hi,

    You can check the content database authentication type in Central Administration: Open Central Administration> Application Management> Content Databases. Click on the content database to view the setting. You will find the database authentication type: SQL or windows authentication. If the authentication is set to SQL and you want to change it to Windows authentication, you will need to first move the content database and add it again. Be careful when you add the content database back, you need to specify the right application, database server name and database name.

    For more information, please refer to this site:

    Sharepoint content database user: http://stackoverflow.com/questions/2782542/sharepoint-content-database-user

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.


    Entan Ming

    TechNet Community Support

    Friday, November 16, 2012 3:30 AM
    Moderator