MachineName\UserName transfer on restore?

I am restoring a client's database from the test environment to the
production environment. The server names are completely different. However,
all the usernames include the servername of the test server.

I restored the WSS3.0 site successfully, but all my SharePoint users still
have the old machine name in front of their username.

Is there some global update I can do to replace the old machine name with
the new one?

(Crossing fingers hoping for an easy way to get this done).

Thanks in advance!

Charlene

Charlene
Thu Jul 17 17:46:32 CDT 2008

I found the answer to my own question; here it is in case someone else needs
to know how to do it:

The SQL Server database behind the SharePoint site has two tables which
reference the machine name in front of the username. I had to change the
machine name in the following tables:

Table name: Dbo.UserInfo
Columns: tp_login and tp_title.
Action: Updated each occurrence of the OldMachineName with the
NewMachineName.

Table name: dbo.AllUserData
Columns: nvarchar1, nvarchar2, nvarchar3
Action: same action as above.

Once this is complete, the users on the new machine can successfully log in
to SharePoint with all their other permissions intact.

So happy this worked!

Charlene



On 7/16/08 4:08 PM, in article C4A3CD84.63EA%charlene@charsoft.com,
"Charlene Banks" <charlene@charsoft.com> wrote:

> I am restoring a client's database from the test environment to the
> production environment. The server names are completely different. However,
> all the usernames include the servername of the test server.
>
> I restored the WSS3.0 site successfully, but all my SharePoint users still
> have the old machine name in front of their username.
>
> Is there some global update I can do to replace the old machine name with
> the new one?
>
> (Crossing fingers hoping for an easy way to get this done).
>
> Thanks in advance!
>
> Charlene
>