How to rename Sharepoint database server

In some cases User Profile service is in “starting” mode but not started after a while getting “stopped” . one of the cause this situation is Sharepoint server name is using an ip address instead of using netbios name. You can check if from Central Administration -> Servers in farm section.

How can we change the ip address of SQL server to netbios name? Answer is simple use stsadm.
Run the following command to rename the server from IP address to netbios name sucessfully:

Stsadm -o renameserver -oldservername <ipaddress> -newservername <netbios name of the sql server>

Example: Stsadm -o renameserver -oldservername 192.168.10.2 -newservername POSTSQL

Now you can try starting the User Profile Synchronization Service. It should start successfully, unless there is some other User Profile Sync Service related issue.

..

 

Advertisements

Change your ip and dns using netsh easily

Sometimes i am connecting different networks at home,school,work or a cafe and every connections are different and needed different  ip configuration some of static other dinamic . if you don’t like in this situation netsh can help you.

you can save save netsh consol command into a batch file and just run it when you needed to change your configuration.

for change ip

Usage:
netsh interface ip set address “Local Area Connection” staticipaddr subnetmask gateway metric

Example:
netsh interface ip set address “Local Area Connection” static 192.168.0.10 255.255.255.0 192.168.0.1 1
netsh interface ip set address “Local Area Connection” dhcp

Change dns example:
netsh interface ip set dns “Local Area Connection” static 192.168.0.200

Change dns as using dhcp
netsh interface ip set dns “Local Area Connection” dhcp

That’s it…