Scenario: I backed up the vCenter SSO database and copied & restored it from an SQL2005 to an SQL2008 server. This worked fine but when I tried to add the user mapping I got the following: Create failed for User 'RSA_user'. (Microsoft.SqlServer.smo) This occurred because the user I was trying to add already existed in Read More…
Category: Windows
What version of SQL Native Client do I have ?
In preparation for moving a 2005 SQL Database from the local vCenter server to dedicated SQL 2008 server I needed to ensure I had the SQL Native Client 10.0 driver installed. First of all I checked the current drivers on the vCenter server: I knew this wasnt the correct version as I had SQL native 10.0 driver installed on Read More…
Obtaining Service Pack and Release of Windows version
In order to upgrade vCenter from 5.1 to 5.5 I wanted to check the version and release of Windows I was running. vCenter 5.5 requres Windows 2008 R2. To find this out open up a command prompt and type: winver This should display;
Password Protecting a Directory in IIS 7
To password protect a directory in IIS7 using basic authentication use the following steps. Note: In this example I will be password protecting http://www.jordanshpere.co.uk/test 1) Create a user using Computer Management 2. Open up Internet Information Services and click on the relevant website under Sites section. 3. Click the directory you want to password Read More…
Install Telnet Client via CLI on Windows 7
To install the Telnet client on a Windows 7 machine Click the Start menu -> Type cmd into the search box. Open the command prompt. Type the following: pkgmgr /iu:”TelnetClient” Alternatively if you want to install via the GUI; Go to Control Panel -> Programs & Features -> Turn Windows features on or off Read More…
Terminal Services Stopped and Grayed out in Windows 2003
One of our Windows 2003 servers became inaccessible via RDP. All other services were fine/ (eg FTP/HTTP) When we got a console into the machine I noticed that the Terminal Services service was stopped and I didn’t have the option of starting it due to the menu being greyed out. I suspect a windows update Read More…
Allowing 2 Administrators access via RDP – Windows 2008 R2
Scenario: By default Windows 2008 R2 only allows one session per user. It is often the case that more than one Administrator needs to login. To enable this go-to START -> ADMINISTRATIVE TOOLS -> REMOTE DESKTOP SERVICES -> REMOTE DESKTOP SESSION CONFIGURATION MANAGER When that page opens up right-click “Restrict each user to Read More…
Shrinking Transaction Logs in MSSQL 2005
Scenario: We host a lot of small databases on an Microsoft SQL 2005 server. Occasionally the transaction (.ldf) files will become extremely large so we will need to shrink them. As we only take nightly backups we are happy to make the recovery model “simple”. If you require a more mission critical backup solution then Read More…
Ahsay: Uploaded file size incorrect.
Scenario: One of your users suddenly starts getting an error with the message “uploaded file size incorrect” Looking at the attached logfiles we can see the file size incorrect message when trying to upload a MySQL directory (there is an argument to suggest excluding this directory and using the MySQL feature in Ahsay but the Read More…
You must be logged in to post a comment.