Window 7 Sharing issues with XP

For a network that with different OS version might have facing this issues as the older version of Windows unable to access the share folder on Window 7. The error message as below. For this error message we can know that it related to permission issues. So you might play around with the access right.

While you already make sure your access right is correct and the folder is accessible by Windows 7. This may be the window registry issues.

Solution:

1. Go the the particular Window 7 machine that sharing the folder. Locate to the following registry key and change it's value to 1. You may refer to this link for further study.

HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache

2. Locate this next key and change it to 3, this is just that "Server" service (or part of it) setting

HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\Size

Restart the Window 7 and now the problem should be solve.

C# with MySQL Error

Recently doing a project using c# connect to MySql server. For sure the connectio is require connection driver so that I have download and install the latest version of MySql connector version (6.9.6).

This is the first time I am using c# to establish the connection with the server. Some how I hit error during the development. So now here I am to share the issues and solution. And I aware that this is MySql connector bugs.

Here the Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
 
Parser Error Message: Unable to connect to any of the specified MySQL hosts.
 
Source Error:
 

Line 283:    <siteMap>
Line 284:      <providers>
Line 285:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
Line 286:      </providers>
Line 287:    </siteMap>
 

Source File: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config    Line: 285

There is many solution say that if can resolve by commnet out the particular line of config in machine.config file. You may try this soltion since there is some people mention they albe to resolve it by this. The path of machine.config file as below:

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config 

<!--        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, 

MySql.Web.v20, Version=6.9.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" 

connectionStringName="LocalMySqlServer" applicationName="/" /> -->

Reference: http://bugs.mysql.com/bug.php?id=74080&thanks=1&notify=71

But this solution not work for me.

So the next solution is to change the installation file by go to control panel -> program -> select MySql connector and select change. un-check the web provider and next all the way. Then the issues resolve. Hope it help.

XAMPP Port Issues

When I want to start a PHP development project, I use to face port issues during setup the XAMPP. You will face this issues where the Skype, VM Ware, or team viewer installed in your PC. The port is utilize by these few software so that your Apache service is unable to start.

This problem can easily solve by changing the port number if Apache. Click on the Config button on the XAMPP Control panel that same row with the Apache service. It will show a menu and select the Apache (https.conf) and it will open the config file with notepad. Using find/search (Ctrl +F) to find port number 80 and change it to a free port and the port you prefer. In my example below i change it to 8088

Snippet for port 80.

# Change this to Listen on specific IP addresses as shown below to
# prevent Apache from glomming onto all bound IP addresses.
#
#Listen 12.34.56.78:80
Listen 8088

#
# Dynamic Shared Object (DSO) Support


And same goes to the secure port by choosing Apache (httpd-ssl.conf).


Snippet for SSL port number

# When we also provide SSL we have to listen to the
# standard HTTP port (see above) and to the HTTPS port
#
Listen 4443

##
##  SSL Global Context

After change your port number, restart the service and now you can access your site with provide the port number as below.

http://localhost:8088/testingSite/index.php

Database is Suspect Mode

There is a time the electric blackout in my place and cause the database is unable to open. There is a (Suspect) after the database name as show as screen shot below. This know as Suspect Mode.

This issues may cause by:

• There is not enough space available for the SQL Server to recover the database during startup.
• The database cannot be opened due to inaccessible files or insufficient memory or disk space.
• The database files are being held by operating system, third party backup software etc.
• There was an unexpected SQL Server Shutdown, power failure or a hardware failure.

In order to resolve this problem, recovering is needed to access again the database. So first of all you may need a database administrator account login the MS SQL Management and click on new query button. And start the script as below:

EXEC sp_resetstatus [YourDatabaseName];

ALTER DATABASE [YourDatabaseName] SET EMERGENCY

DBCC checkdb([YourDatabaseName])

ALTER DATABASE [YourDatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([YourDatabaseName], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [YourDatabaseName] SET MULTI_USER




Replace YourDatabaseName with your database name. In my example will be as follow.




EXEC sp_resetstatus [test_dr];

ALTER DATABASE [test_dr] SET EMERGENCY

DBCC checkdb([test_dr])

ALTER DATABASE [test_dr] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([test_dr], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [test_dr] SET MULTI_USER




Once you have done the script, click on execute query at the top. If for the first time is fail, double click again the make the script run. Then refresh your Object explorer and the (Suspect) will get rid and able to access the database again.

Microsoft SQL Server Error 926

In my development life, there is many issues coming up to resists you in development. Database is one of it,  as today I face this issue below. This error able me to start the MS SQL Management Studio but unable to see any one of the db on it. After some time of troubleshooting, finally get this issues resolve.

In order to resolve this issues, you may need another working database. Copy the MSDBDATA.mdf and MSDBLOG.ldf  from another environment machine.

By default, the files directory  will some where around here. (If you have custom path, please check your own database setting.)

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

In order to copy and replace both of the files, you need to stop your SQL Server Service  then only able to copy and replace both of the file.

Please make sure you make a backup before you replace the file as a safe keeping for just in-case purpose.

Once you replace the working MSDBDATA and MSDBLOG files, start the SQL Server service again.

Reset Window Server 2008 Local Admin Password

After a long run of Window server 2008 without any documentation. When the Window facing issues and need the local admin account to perform some task or installation. So is ok if you forget your administrator password. So here I going to document the way to change the administrator password of Window server 2008.

Tools that require are:

Physically access to window server 2008, a window server 2008 installation disk for sure a CD ROM

Let begin.

Insert the Window Server 2008 CD into CD ROM then restart and boot into the CD. This process similar to install a new Window Server to a new machine, but take note you are going to change the password. So there is one of screen please chose Repair your computer at the left bottom of the window screen.

Then you need to chose command prompt to give the command to move and copy a file.

So first thing going to do is rename and backup the utilman.exe file. Below is the command.

MOVE C:\Windows\System32\Utilman.exe C:\Windows\System32\Utilman.exe.bak

Your screen will like screenshot below.

Next, we going to copy again the utilman.exe file. Below is the command.

COPY C:\Windows\System32\cmd.exe C:\Windows\System32\Utilman.exe

Your screen will similar to screenshot below.

Nearly done
After assign this 2 command, eject your CD ROM disk and reboot your Window Server. After reboot, at the Window login screen left bottom you will see a icon
. Click on the ease of access icon and run the command prompt.


Once you see the command prompt, give the command below.

net user administrator *

When you press enter it will ask you to enter new password and confirm the new password. Your screen will be like screenshot below.

Once you successful login the Window Server, please do not forget to delete the Utilman.exe and then rename Utilman.exe.bak back to plain old Utilman.exe.