Difference between revisions of "Windows"
Rootadminacc (talk | contribs) |
Rootadminacc (talk | contribs) |
||
Line 69: | Line 69: | ||
http://msdn.microsoft.com/en-us/library/ms186312(v=sql.90).aspx | http://msdn.microsoft.com/en-us/library/ms186312(v=sql.90).aspx | ||
== Connect to MSSQL == | |||
osql -U sa | |||
or | |||
osql -E -d psa | |||
== [http://www.microsoft.com/en-us/download/details.aspx?id=7593 Download SQL Server Management Studio] == | == [http://www.microsoft.com/en-us/download/details.aspx?id=7593 Download SQL Server Management Studio] == |
Revision as of 09:51, 29 January 2013
Log into Remote Desktop
On a Windows PC go to:
- Start > enter in "search programs and files" mstsc , or
- Start > enter in "search programs and files" run > click Run > mstsc > enter
- Start > All Programs > Accessories > Remote Desktop Connection
Enter the IP address of the server e.g. 212.90.203.19, click Connect, click Use another account
In User name put \Administrator
In Password put the default one in your hosting providers welcome email for your server.
Plesk is offline
- Ensure port 8443 is allowed through Windows Firewall
- In IIS Manager ensure the sites ISS_Default, PleskControlPanel and sqladmin are running and in Manage Web Site > Advanced Settings > set to True on Start Automatically.
- If you get an error saying the World Wide Web Publishing Service is not running, go to Services.msc, scroll to the bottom, set to Automatic and Start it.
- Restart IIS or the Sites in IIS.
Configure a Static IP Address manually
Server error in / application
Method 1) Log into Remote Desktop, go to Start - Search > iis > IIS Manager > Sites > Right click website > Manage Website ? Restart
Method 2) Log into Remote Desktop, go to Start - Search > cmd > iisreset /restart
Joomla permissions
An operation on a socket...
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.
http://www.outsystems.com/NetworkForums/ViewTopic.aspx?TopicId=8143&Topic=An-operation-on-a-socket-could-not-be-performed-because-the-system-lacked-suffic
http://www.outsystems.com/NetworkForums/ViewTopic.aspx?Topic=How-to-tune-the-TCP%2fIP-stack-for-high-volume-of-web-requests
http://blogs.msdn.com/b/sql_protocols/archive/2009/03/09/understanding-the-error-an-operation-on-a-socket-could-not-be-performed-because-the-system-lacked-sufficient-buffer-space-or-because-a-queue-was-full.aspx
http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/fd27e588-4a1d-4f3c-882a-9e95dabce794/
ASP .NET4 Framework
You can install this manually via Remote Desktop by going to Microsoft's website here, downloading it and then installing it. Then within Plesk go to:
Server Management > Tools & Settings > Server Management > Server Components > click Refresh and it will then appear when you go into:
Hosting Services > Domains> Control Panel > Websites and Domains > Click your domain name > ASP version . You should see ASP 2 and 4, if not it is likely the wrong version or it has not installed properly.
Check ASP version
Classic ASP errors
- Go into the site within IIS > Hostname > Sites > domain.co.uk > ASP > Debugging Properties > Send Errors To Browser
- IIS > the site > Error pages > right click the page - Edit Feature Settings > Detailed Error Pages
Backup the Registry
Start > "Search programs..."
or
Start > Run
regedit
Click/highlight Computer > File > Export
Create MSSQL Database
Either use this (or version 2010) or log into RDP, go to SQL Management Studio, log in as localhost (only if it has no control panel) and create new database or import.
http://msdn.microsoft.com/en-us/library/ms186312(v=sql.90).aspx
Connect to MSSQL
osql -U sa
or
osql -E -d psa
Download SQL Server Management Studio
MSSQL does come installed into Windows by default but it does not come with SQL Server Management Studio by default. You can install this yourself via Remote Desktop and on your home PC by downloading it from Microsoft here: http://www.microsoft.com/en-us/download/details.aspx?id=7593
Enable 32-bit Application Pool in IIS 7
Entering MySQL
Go into the MySQL Directory and then mysql -uroot -p
Mail Accounts
C:\Program Files (x86)\Parallels\Plesk\Mail Servers\Mail Enable\Postoffices\yourdomain.com\MAILROOT
Outlook
"Outbox cannot be saved to sent messages, server permission is not granted."
This indicates the account and it's IMAP settings are not correctly configured. There is no server setting to change.
PHP mcrypt
Uncomment the relevant extension line within C:\Program Files (x86)\Parallels\Plesk\Additional\PleskPHP5\php.ini to enable mcrypt, this should be similar to extension=php_mcrypt.dll
Remote Desktop Full Screen or non-full screen
CTRL + ALT + PAUSE|BREAK
Set/stop RDP Session timeout
- Start
- Administrative Tools> Terminal Services Configuration
- right click RDP-Tcp > properties
- Sessions tab
- Set the "End a disconnected session" to "Never" and "When session limit is reached or connection is broken" set to "Disconnect from session".
Using the URL Rewrite module
Remove IIS 6
Notes
Event Viewer in run: eventvwr.msc
Add User/Check groups in Windows 2003. Start > Run > lusrmgr.msc
If webadmin does not direct anywhere add an A record as mssql A ServerIPAddress and ensure this is enabled.
The other accounts on the server, such as IME_USER, IME_ADMIN, Plesk Administrator; these are necessary for the running of the Plesk Control Panel.
Add read permissions for IIS_USERS to C:\inetpub\vhosts\domain.com\httpdocs or C:\inetpub\vhosts\Servers\6\localuser\domainfolder\httpdocs since these are linked folders it is the same.
If a w3p process locks the home folder so it does not delete/allow you to place new files in,, use a program called Unlocker which kills it.
Stopping all the w3p processes would shut down all sites for a few moments. Unlocker finds the correct process and allows you to kill it so it doesn't affect anything else.
You can get it from CNET. The current version is around 1.9.1