Tuesday, April 1, 2014

"The User Profile Service failed the logon. User profile cannot be loaded." - Resolved

"The User Profile Service failed the logon. User profile cannot be loaded." in Windows 7

Steps to resolve:

1. Log on to the Computer:

Log on to the computer using the Administrator (or an Administrator-level) account.

If the computer is not joined to a domain, reboot it and start your computer in safe mode, then log on using the Administrator (or an Administrator-level) account.

2.Using Registry

Open Start menu. In the Start Search area, type regedit and press Enter

In regedit, go to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

Expand the ProfileList key and look for the SID key (named "S-1-5"...) with a long number that ends in ".bak". Click it, and look at the ProfileImagePath value in the right pane to verify that this is the user account profile that has the error.

a) If you have two SID keys with the same number (with one ending in ".bak" and one showing the affected user account in the ProfileImagePath value), continue to Step 3;
b) If you have just one SID key with the ProfileImagePath value showing the affected user account, proceed to Step 4.

3. Two SID keys with the same number
a) Of the two SID keys that corresponds to the affected user account, right-click the SID key that does      NOT end in ".bak" and click Rename.
b) Add .bk to the end of the numbers and press Enter.
c) Right-click the other SID key that DOES end in ".bak" and click Rename.
d) Remove only .bak from the end of the numbers (so that it has the same name as the other SID key did before you renamed it) and press Enter.
e) Now go back and Rename the first one with .bk to .bak now at the end of the numbers and press Enter.

Proceed to Step 5...

4. Only one SID key ending in ".bak"
a) Right-click the SID key that corresponds to the affected user account and click Rename.
b) Remove only .bak from the end of the numbers, and press Enter.
c) In the right pane, right-click the RefCount value (if none exists, right-click the right pane and click New and DWORD (32 bit) Value, then type RefCount and press Enter), and click Modify.
d) Type 0 into the Value Data textbox and click OK.
e) In the right pane, right-click the State value and click Modify.
f) Type 0 into the Value Data textbox and click OK.

5. Close regedit and restart the computer. You should be able to logon now...

Above worked for me in step 3.

P.S. Kindly note working on Registry is own risk, take a backup of registry key before modifying.


Friday, March 14, 2014

Cannot start MSSQLSERVER service - Error 3414 - Solved

The actual problem was that the SQL server started but then stopped a few seconds later, causing the Windows Error 3414 to appear.

The 3414 error listed in the error log indicates that there are corrupt transactions that cannot be rolled back or forward.


You can find the following in Event viewer 

Application
Event ID: 9003
The log scan number (xx:xxx:x) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. 

System

Event ID: 7024
The SQL Server (MSSQLSERVER) service terminated with service-specific error 3414 (0xD56).

This is due to model.mdf corrupted you can find the same in ERRORLOG 

You can find it in Path Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

It could occur due to damaged controller, antivirus application, disk problems and other such issues. 


I tried to repair model.mdf with commercial MDF Repair products but model.mdf can't be repaired using this tool, still error occurred. I don’t find any information regarding the responsible issues,


So restoring from the last clean backup you have is the only option( Normally we won't take model, master mdf files). You can copy model.mdf and modellog.ldf from working SQL server instance from another server. (for safer you can backup a copy of model.mdf and modellog.ldf and place outside the \Data Folder.


Now try starting the SQL Service in services.msc. It worked for me :)

Friday, September 14, 2012

Monday, September 3, 2012

FindSounds - Search the Web for Sounds



Search for sample sounds and sound effects at this file search engine. Offers directory, keyword and sonic similarity search functions.

www(dot)findsounds(dot)com

Thursday, August 23, 2012

Table 'mysql.servers' doesn't exist + plesk



Usually after the upgrade there errors that arise with MySQL in Plesk while creating users, errors such as "Table 'mysql.servers' doesn't exist"



To solve do the following:

1.SSH to your server

2. mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql
 
or

mysql -u YOURUSERNAMEHERE -p

Here YOURUSERNAMEHERE=Your actual user name which you are going to use.
Hit enter, you’ll be asked for your mysql password.

3: Use the mysql database command:
        USE mysql;

4.Then RUN the following:

CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

If you don't have access to SSH, You can do this by logging into the webadmin for MySQL via Plesk, and running the above SQL command.
After that point, you will be able to add and delete as needed

And it worked for me:)

Tuesday, August 14, 2012

Hmail server with Round cube - SMTP Error (530): Failed to add recipient (SMTP authentication is required.)

I resolve this issue.
In the roundcube config file:

$rcmail_config['smtp_user'] = '%u';
$rcmail_config['smtp_pass'] = '%p';
$rcmail_config['smtp_auth_type'] = 'LOGIN';

file can be found in RoundeCube\Config\ main.inc.php