which country user step here?

Tag Cloud

MOSS (47) SharePoint 2007 (37) SharePoint 2013 (31) SharePoint 2010 (23) MOSS admin (17) PowerShell (17) admin (17) developer (16) List (15) WSS (14) sql query (14) MOSS SP2 (13) end user (11) scripting (11) wss V3 (11) permission (10) sql (9) Moss issue (8) search (8) database (7) RBS (6) Service Pack (6) reportadmin (6) workflow (6) CU (5) Excel (5) Patch (5) client object model (5) Client Code (4) Command (4) Cumulative Updates (4) IIS (4) SharePoint 2019 (4) SharePoint designer (4) office 365 (4) stsadm (4) user porfile (4) ASP.NET (3) Content Database (3) Groove (3) Host Named Site Collections (HNSC) (3) SharePoint 2016 (3) Tutorial (3) alert (3) authentication (3) batch file (3) codeplex (3) domain (3) error (3) incomming email (3) issue (3) restore (3) upload (3) Caching (2) DocAve 6 (2) Folder (2) Index (2) Internet (2) My Site Cleanup Job (2) My Sites (2) News (2) People Picker (2) Share Document (2) SharePoint admin (2) View (2) Web Development with ASP.NET (2) add user (2) audit (2) coding (2) column (2) deploy solution (2) download (2) enumsites (2) exam (2) export (2) june CU (2) load balance (2) mySites (2) network (2) orphan site (2) performance (2) profile (2) project server (2) query (2) security (2) server admin (2) theme (2) timer job (2) training (2) web master (2) web.config (2) wsp (2) 70-346 (1) 70-630 (1) AAM (1) Anonymous (1) Approval (1) AvePoint (1) Cerificate (1) Consultants (1) Content Deployment (1) Content Type (1) DOS (1) Document Library (1) Drive Sapce (1) Excel Services (1) Export to Excel (1) Feature (1) GAC (1) Get-SPContentDatabase (1) Get-WmiObject (1) HTML calculated column (1) ISA2006 (1) IT Knowledge (1) ITIL (1) Install (1) Link (1) MCTS (1) Macro (1) Masking (1) Migration (1) NLBS (1) Nintex (1) Office (1) Open with Explorer (1) ROIScan.vbs (1) Reporting Services (1) SPDisposeCheck.exe (1) SQL Instance name (1) SSRS (1) Sandbox (1) SharePoint Online (1) SharePoint farm (1) Shared Services Administration (1) Site Collection Owner (1) Site template (1) Skype for business (1) Steelhead (1) Teams (1) URLSCAN (1) VLOOKUP (1) WSS SP2 (1) XCOPY (1) abnormal incident (1) admi (1) app (1) application pool (1) aspx (1) availabilty (1) backup (1) binding (1) blob (1) branding sharepoint (1) cache (1) calendar (1) change password (1) connection (1) copy file (1) counter (1) crawl (1) custom list (1) domain security group (1) event (1) excel 2013 (1) facebook (1) filter (1) fun (1) group (1) iis log (1) import (1) import list (1) improment (1) interview (1) keberos (1) licensing (1) log in (1) metada (1) migrate (1) mossrap (1) notepad++ (1) onedrive for business (1) operation (1) owa (1) process (1) publishing feature (1) resource (1) send email (1) size (1) sps2003 (1) sql201 (1) sql2012 (1) sub sites (1) system (1) table (1) task list (1) today date (1) trial (1) vbs (1) video (1) web part (1) web server (1) widget (1) windows 2008 (1) windows 2012 R2 (1) windows Azura (1) windows account (1) windows2012 (1) wmi (1)

Thursday, November 22, 2018

Trial Product keys for Microsoft SharePoint

Product keys for Microsoft SharePoint 2010, 2013, 2016, 2019:
  • SharePoint 2019 Public Preview trial Enterprise product key: M692G-8N2JP-GG8B2-2W2P7-YY7J6
  • SharePoint 2019 Public Preview Project Server trial license key: R9946-QXNHR-62JPQ-3H3QC-TMWJT
  • SharePoint 2016 RTM: NQGJR-63HC8-XCRQH-MYVCH-3J3QR
  • SharePoint 2013: NQTMW-K63MQ-39G6H-B2CH9-FRDWJ
  • SharePoint 2013 Foundation: это бесплатная редакция SharePoint, для неё ключи не нужны
  • SharePoint 2010 Standard: PTTCF-PCY26-D9V8F-8JF8B-XH8JP
  • SharePoint 2010 Enterprise: VK7BD-VBKWR-6FHD9-Q3HM9-6PKMX

Monday, August 13, 2018

SharePoint 2019 Preview release

新的SharePoint版本 2019,还没正式可以用。这个是给你试验性的,不能直接换去正式版本(RTM).

很快速的看了一下,看到几个新的进步所以写下来记录一下:


  • 最大上载upload Size 增加到 15GB. ( SharePoint 2013 - 2GB , SharePoint 2016 - 10GB)
  • File names and lengths 进步了几点
    • 文件和文件夹名可以用 # 和 %了
    • URL的长度就从260 unicode code units 增加到 400 ( 方便使用者可以用长长的文件名还是可以开多几个文件夹在文件夹里面来分类)
  • Zero downtime patching : 如果你有用到customization solution那就比较难达到了
 其他关于developer的就有看没懂。。什么SharePoint Framwork的东西。。。好啦,大约是这样,到时候Install了才分享多一点。



You may view the latest post at

Sunday, August 5, 2018

How to: SharePoint 2013 permissions controlled by AD Security Group will not update

Incident :
User added to Domain security group in few hours time still cannot log in the SharePoint site which is have permission

Root cause :
User before add in to domain security group already have the SharePoint authentication token ,this will cause SharePoint will not update for at least 10 hours.


Resolution \ work around:

  • change the WindowsTokenLifetime from default 10 hours to N hours
  • second method which is wait for 10 hours and at the same time grant individual permission first.

more information from : 


https://community.spiceworks.com/how_to/86169-sharepoint-2013-permissions-controlled-by-ad-security-group-will-not-update

You have a site, list, or library with permissions assigned to an Active Directory security group instead of a SharePoint group or individual. When you add a user to or remove a user from the security group within Active Directory, their permissions on the SharePoint site are not updated right away.

3 Steps total





Get-SPSecurityTokenServiceConfig


$mysts=Get-SPSecurityTokenServiceConfig

$mysts.WindowsTokenLifetime=(New-TimeSpan -Minutes 60)

$mysts.Update()


WARNING: We've experienced some issues with this new setting. If you set the WindowsTokenLifetime to 60 minutes, please be aware that users who are editing a page must save and close that page within the 60 minute timeframe. We've had users making changes to wiki pages who spent hours working on a draft, then clicking on save and seeing all of their work lost. It turns out that when a user submits their changes by clicking the "Save" button, the request is sent back to SharePoint which sees that the user's credentials have expired. SharePoint then throws out any changes and directs the request back to the authentication page to re-authenticate. If the user is being logged in automatically (i.e. a corporate intranet), SharePoint redirects them back to the page they were editing, but without any of the changes.

This has been a HUGE problem for us. In the end, we changed the WindowsTokenLifetime back to 10 hours. Better for us to wait until the next day before the occasional Active Directory change takes effect than to risk losing hours worth of work.

Monday, April 23, 2018

Relationship Load Balance (F5) with SharePoint IIS



Due to the lacking information from the support network team to provide the information about how the LB monitoring the application health we are hardly to troubleshoot during incident happen.

For the easy way to verify the health monitoring rule set for ICMP and HTTP we can do the following test to verify.

ICMP : simply shut down all the node and leave one server node up , try to access then you will know the helath monitoring is working or not. ( this method is try to ping the server node , once detected unable to ping then the traffic will stop route to that server ~ around 1 to 2 minute to detect it)

TCP (by server name with port 443 / 80 ): this is something new i learnt which is we can stop the IIS [listener for port 443 and 80 will stop ]service at the server node then  the traffic will stop route to this server node.


Back to the incident i have faced last week , which is we have delete one of the old SSL certificate and during reboot server causing the LB unable communicate to the server node.

root cause : one of the unused web application (stop) have blank hostname with 443 port enable and the SSL cert is blank . Causing LB unable to communicate with the server node.

solution : binding the SSL cert to the blank host name with 443 port

error message can see from system log file :
Event ID 15021 Source HttpEvent
An error occurred while using SSL configuration for endpoint 0.0.0.0:443.  The error status code is contained within the returned data.

Friday, January 5, 2018

How to check the RBS folder location and name base on the content database name ?

try to run powers hell command to find out the RBS folder location and name is use by specify content database but unable to find the command.

the method i have is run SQL query on the server to get the information i needed :

SELECT
    db.name AS DBName,
    type_desc AS FileType,
    Physical_Name AS Location
FROM
    sys.master_files mf
INNER JOIN
    sys.databases db ON db.database_id = mf.database_id


check on the file type FILESTREAM under the content database you looking for then will know which RBS .