View source for Server 2008 R2 & Hyper-V

From Server Knowledge Base

← Server 2008 R2 & Hyper-V

You do not have permission to edit this page, for the following reason:

---

You can view and copy the source of this page.

== 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 [http://support.microsoft.com/gp/howtoscript 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 [http://www.techotopia.com/index.php/Understanding_Windows_Server_2008_File_and_Folder_Ownership_and_Permissions 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 == [http://kb.parallels.com/en/112925 Remove Plesk] == == Add User/Check groups == Start > Run > lusrmgr.msc [http://www.techotopia.com/index.php/Configuring_Windows_Server_2008_Remote_Desktop_Administration Guide 1]<br> [http://social.technet.microsoft.com/Forums/zh/winserverTS/thread/834871a8-39b5-40ca-bbbf-f41d08caea65 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<br> A record<br> 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. [http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/ Example 1]<br> [http://blogs.msdn.com/b/bethmassi/archive/2008/09/17/enabling-remote-sql-express-2008-network-connections-on-vista.aspx 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 [[Server_2008_R2_%26_Hyper-V#Enable_remote_connection_on_SQL_Server_2008 | 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<br> - Expand Logins<br> - Double click sa<br> - 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: <pre>osql -U sa Password: <enterpassword> 1></pre> If the password is blank, you will be able to get past the above password prompt by just pressing enter. <pre>1> sp_password 'oldpassword','newpassword','sa' 2> go</pre> 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.

Return to Server 2008 R2 & Hyper-V.