2015年1月19日 星期一

How to setup Linux/ABC e-mail account to your iPhone's

1. Click "Setting" on your iPhone's

2. Click "Mail, Contacts, Calendars"

3. Click "Add Account" and click "Other"














<<<<<<<<<<<<<<





4. Click "Add Mail Account"



 <<<<<<<<<<<

















5. Enter the following information :

Name :   << This is sender name >>
E-Mail :   << Enter your e-mail address >>
Password :   << Enter your password >>
Description :    << This is name for display your mail account >>, check the right side picture!






















6. You need to choice which mode do you want to connect with e-mail account

Please enquire your administrator which mode is better for you, but I will suggest using POP.

The following screen you only need to care the Incoming & Outgoing Mail Server :
Incoming Mail Server Host Name is : mail.abchk.com or mail.asa.com.hk or mail.yourdomain.com
Outgoing Mail Server Host Name is : smtp.abchk.com or smtp.asa.com.hk or smtp.yourdomain.com
















P.S. Some time when you click "SAVE" it will wait a long time to validation of your account setting, just wait it.



7. After add the account, you should click to the mail account for checking SMTP setting.









<<<<<















8. Click "SMTP"


















<<<<<<<<<<<






9. Click the Primary Server "smtp.abchk.com"




<<<<<<<<<<



















10. Make sure your outgoing mail server setting have username and password, and server port must using 465, if server port is 25, sometime you can sent out e-mail, but i guess will always fail, depend on your existing internet connection, because most ISP will block the Port 25 for outgoing mail services.














<<<< 465







How to setup Exchange Online / Office 365 e-mail account to your iPhone's

Remark : If you are using Andriod Phone and it can't automatically discovery the setting, please click here to follow the instruction complete your setting.

1. Click "Setting" on your iPhone's

2. Click "Mail, Contacts, Calendars"

3. Click "Add Account"



4. Click "Exchange"





















5. Enter your e-mail address, password and description.
Description is what name you want to display on Mailboxes list, check right side picture, such as "iCloud" & "MYS"






















6. You can enable what function you need.




















7. Check this picture, you will see "MYS" seperate on upper and down side, the difference is upper only show inbox and latest e-mail only, down side will connect to Exchange Online/Office 365 server and show all e-mail and folder


2015年1月7日 星期三

SQL Error 1814 / Change tempdb path / How to start SQL Server if you lost TEMPDB Data files?

Source from : http://blogs.xtivia.com/home/-/blogs/how-to-start-sql-server-if-you-lost-tempdb-data-files-

Following are the steps needed to add a new file to TEMPDB and then restart SQL Server.
1)   Open command prompt window #1 as ADMIN and go to the BINN directory where SQL Server is installed. This is typically in
 
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn
OR
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
 
2) Then execute command like
       Sqlservr.exe /f /c  

3)   Then open one more command window #2 and if this is a default instance then open SQLCMD  using the following command
SQLCMD –S localhost –E

4)   This will open a SQL command prompt there where you can type the following commands
      
1> USE MASTER
2> GO
3> ALTER DATABASE tempdb MODIFY FILE
4> (NAME = tempdev, FILENAME = 'd:\tempdb\tempdb.mdf')
5> GO 
6> ALTER DATABASE tempdb MODIFY FILE
7> (NAME = templog, FILENAME = 'd:\tempdb\templog.ldf')
8> GO 
9> quit

5)   Now go back to Command window #1 and hit CTRL C.
It will ask if you want to stop the instance. Y/N.
Enter Y, Please close all Command Prompt before start the services
6)   Now start the SQL Server instance from configuration manager. You should see the new data file created and SQL Server started.