2015年4月10日 星期五

Mouse problem on VMWare Player

When your laptop connect to an extend moniter, and when you move your VMware guest to the second display then your mouse "fly away". Try this:
Step 1: Right click vmplayer.exe --> Properties


Step 2: Compatibility --> check "Disable display scaling on high DPI setting" --> OK

2015年1月17日 星期六

Can not connect to SQL Server?

After install SQL Server, using following commands to open Firewall ports on SQL Server and client:

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer" 
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection" 
@echo Enabling conventional SQL Server Service Broker port 4022  
netsh firewall set portopening TCP 4022 "SQL Service Broker" 
@echo Enabling Transact-SQL Debugger/RPC port 135 
netsh firewall set portopening TCP 135 "SQL Debugger/RPC" 
@echo =========  Analysis Services Ports  ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services" 
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser" 
@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80 
netsh firewall set portopening TCP 80 "HTTP" 
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL" 
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser" 
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE 

2014年2月24日 星期一

OpenCart PHP Fatal Error: Allowed memory size of

The Export/Import Tool is a very useful tool when you need to manage tons of products in OpenCart. However, you may see this message when you try to export your file:
PHP Fatal Error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 48 bytes)

Then you can set "memory_limit = 512M;" in your php.ini file.

2014年2月14日 星期五

Use WDS (Windows Deployment Services) to deploy Windows 8.1 (2/2)

Use WDS (Windows Deployment Services) to deploy Windows 8.1 (1/2)

3. Add Windows 8.1 Image
3.1 Right click "Install Images" and select [Add Install Image...].

3.2 You can give it an image group name. Click [Next >].

3.3 Click [Browse...].

3.4 Find your Windows 8.1 disk and the folder "sources". Select "install.wim".

3.5 Click [Next >].

3.6 Click [Next >].

3.7 Click [Next >].

3.8 Click [Finish].

3.9 Right click "Boot Images" and select [Add Boot Image...].

3.10 Click [Browse...].

3.11 Find your Windows 8.1 disk and the folder "sources". Select "boot.wim".

3.12 Click [Next >].

3.13 Click [Next >].

3.14 Click [Next >].

3.15 Click [Finish].

3.16 Right click your deploy server and select [All Tasks] and select [Start].

3.17 Click [OK].

4. Boot from client PC.
4.1 Change BIOS first boot order to Network boot.

4.2 Restart PC. When show "Press F12 for network serice boot", press keyboard [F12].

4.3 Wait...

4.4 Click [Next >]. You can install Windows 8.1 now.

Use WDS (Windows Deployment Services) to deploy Windows 8.1 (1/2)

0. Prerequisites for installing Windows Deployment Services
0.1 Server: Windows Server 2012 R2 - ADDS, DNS, DHCP
0.2 Client PC: PXE boot

1. Add Windows Deployment Services Role
1.1 Click "Add roles and features".

1.2 Click [Next >].

1.3 Check "Role-based or feature-base installation". 

1.4 Select your deploy server. Click [Next >].

1.5 Check "Windows Deployment Services".

1.6 Click [Add Features].

1.7 Click [Next >].

1.8 Click [Next >].

1.9 Click [Next >].

1.10 Click [Next >].

1.11 Click [Install].

1.12 Click [Close].


2. Configure Windows Deployment Services
2.1 Click [Tools] --> [Windows Deployment Services].

2.2 Right click your deploy server and select [Configure Server].

2.3 Click [Next >].

2.4 Click [Next >].

2.5 Click [Next >]. For production you can change to another hard drive.

2.6 Click [Yes].

2.7 Click [Next >].

2.8 Check "Respond to all client computers (known and unknown)". Click [Next >].

2.9 Click [Finish].


Use WDS (Windows Deployment Services) to deploy Windows 8.1 (2/2)

2014年2月12日 星期三

How to share SkyDrive documents with a browser

1. Sign in to SkyDrive
1.1 Go https://skydrive.live.com . Sign in with a Microsoft account. (If you don't have one, click "Sign up now")

1.2 After you sign in. You can see your home folder.


2. Share your folder
2.1. Click [Create] --> [Folder].

2.2 Type the folder name which you'd want to share to others. Then click [Create].

2.3 Check the folder you want to share. Then click [Share] on the top.

2.4 Enter the email who you want to share. Click "Recipients can only view" to change the permissions.

2.5 You can change to "Recipients can edit". When you finish, click [Share]. (For detail: Share files and folders and change permissions)


3. Find shared folder
3.1 Click [Shared] on the left sidebar, you will find shared folders which someone share with you.

3.2 After click one shared folder. You will see the files which shared with you.

3.3 After click the shared file. You can see the file's content. If you have edit permission, you can click [EDIT DOCUMENT] to select [Edit in Word] (You need MS Word) or [Edit in Word Web App]. When you edit it, it saves automatically. Others who can read the file can see it has been changed.