Server 2008 R2 & Hyper-V

From Server Knowledge Base
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Plesk log in URL

If you are redirected to an old Plesk version or alternate URL using a domain name please go into Tools > Internet Options > Browsing History > Delete and tick everything below the line.

If you are logged in via Remote Desktop and attempting to access the Plesk control panel in Internet Explorer 8 and it prompts you with the following:

"You will be redirected to the new address in 15 seconds... If you are not automatically taken to the new location, please enable javascript or click the hyperlink /login.php3"

You need to use this guide to enable Javascript on the browser.

File Permissions

On Windows, the files are not exclusively owned by one user, and can have multiple people with permissions.

To add a user to a file/folder I would recommend that you look at the instructions on this site.

Hostname

Log into Remote Desktop and go to: Start > *Right click* My Computer - Properties > Advanced System Settings > Computer Name > Change Set the hostname in there > Restart the server

Remove Plesk

Add User/Check groups

Start > Run > lusrmgr.msc

Guide 1
Guide 2

Reset password for an RDP account

Start > Control Panel > User Accounts > User Accounts > Manage another account > pick the account > Change the password

Enable remote connection on SQL Server 2008

  • Ensure you have the following DNS record for your domain:

MSSQL
A record
IP Address

  • Go into Remote Desktop, Start > search SQL Server Configuration Manager > SQL Server Network Configuration > Protocols > Right Click TCP/IP > Enable and go to Properties > IP Addresses > Scroll to the bottom > Set the TCP Port to 1433
  • Then go to IIS, Sites folder, right click sqladmin > Manage Web Site > Advanced Settings > Automatically Start set to True, Start or Restart sqladmin
  • Go to Services.msc and restart SQL Server
  • Windows Firewall > Inbound Rules > Sort by Port and ensure SQL and MSSQL over TCP Protocol can both operate on 1433.
  • Allow the port through the Plesk firewall and any hardware firewalls for remote connections.

Example 1
Example 2

If you have multiple instances of MSSQL on a server you can't connect by instance name unless you open additional ports or set specified ports in SQL Configuration Manager.

MSSQL sa user password reset

Follow the guide above first.

Next:

  • Log into MSSQL using SQL Server Management Studio with Windows Authentication and reset the SA user account by going to:

- Expand Security
- Expand Logins
- Double click sa
- Set the password and click OK

Set the password to one that is not the same as the Windows RDP Administrator password but is complicated enough. Then note this down in a safe place.

Alternatively do this in command prompt:

  • Load Command Prompt using the Run as Administrator option.

Then do:

osql -U sa
Password: <enterpassword>
1>

If the password is blank, you will be able to get past the above password prompt by just pressing enter.

1> sp_password 'oldpassword','newpassword','sa'
2> go

Ensure the new password is complicated enough with upper + lower case letters, symbols and numbers.

Mail Enable location on Plesk

C:\Program Files (x86)\Parallels\Plesk\Mail Servers\Mail Enable\Bin

Then see the MailEnable Microsoft Common Console Document with the red toolbox icon.

Enable RDP Audio

Firstly, ensure Bring to this computer is ticket/enabled in your RDP client:

  • In mRemote select Protocol RDP and then go to Redirect. In Sounds select Bring to this computer
  • In Remote Desktop Connection expand Options, select the Local Resources tab, under Remote computer sound, select Bring to this computer

Secondly, in Search/Run go to tsconfig.msc, right click RDP-Tcp, click Properties, select the Client Settings tab, untick Audio and Video playback.

Log out of the session, then log back in to the server. You should hear the Windows startup login sound.

Notes

A VPS is generally 64 bit, IIS can run in 32bit mode but will often not work and give an error.

Check server uptime, Task Manager > Performance tab.