tag:blogger.com,1999:blog-117815382024-02-18T21:59:04.083-05:00Steve's SharePoint StuffMy virtual memory pages...who can remember all this stuff??Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.comBlogger75125tag:blogger.com,1999:blog-11781538.post-8887469625256354722021-02-22T10:13:00.002-05:002021-02-22T10:13:18.986-05:00<p>Hello 2021! Amazing that it's been this long since I shared back...</p><p>Just a quick tip for today. I've been working with the PnP Modern Search v4 web parts and really like them - mainly to help tailor a search experience similar to what my customer has today with SP2010, but without me having to write code for it. I might end up tweaking things a bit (like, changing ".aspx" in the refiner to "Pages", ".docx" to "Word Document", etc) but it's giving me the functionality required. Do check them out here:</p><p><a href="https://microsoft-search.github.io/pnp-modern-search/">Introduction - PnP Modern Search (v4) (microsoft-search.github.io)</a></p><p>One of the things my customer asked for was an ability to show results from the signed in employee's location. One thought was to create a separate Search Results web part that would include the location in the search string - so if I did a search for "cafeteria menu" I'll get the menu for my work location first, vs the one that was most recently updated from the other work locations. Still working on a way to bake in my location into search relevancy, but for now, this worked. In the Query Template of the PnP Search Results web part, I'm using this:</p><p>{searchTerms} and {User.PreferredLocation}</p><p>where in my case, PreferredLocation is a User Profile property with the value for the user's preferred location. That's the syntax to use for any of the user profile properties.</p><p>Alright world, let's hope it isn't another three years til my next post! All the best! <br /></p><p><br /></p>Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-70143240644223804202018-07-24T17:06:00.000-05:002018-07-24T17:06:44.970-05:00Microsoft Teams, Visual Studio & PowerShell: Module was not loaded because no valid module file was found in any module directory<div dir="ltr" style="text-align: left;" trbidi="on">
Hello world!<br />
<br /><br />
I've been working on a small utility to programmatically create new Microsoft Teams sites?teams?rooms?pages? whatever they're called. The idea is to accept some parameters from the user, if needed route the request for approval, then create the new site.<br />
<br /><br />
Currently, the only programmatic method to create a new Team is with PowerShell. Works great interactively, so the next step was to see if I could create the new Team using PowerShell invoked from code. Yeah, not elegant, but so far that's the only option.<br />
<br /><br />
I started off creating a new VS Windows solution with the big ol button on there to just run some code - and no dice. If I ran the same script interactively it worked great, but not from within Visual Studio. The error received was Module MicrosoftTeams was not loaded because no valid module file was found in any module directory.<br />
<br /><br />
The culprit: 32 bit instead of 64 bit.<br />
<br /><br />
When I switched VS from 32 bit to 64 bit, no more error, and my Team created as expected.</div>
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-74256634843509991902018-03-19T13:42:00.001-05:002018-03-19T13:42:14.011-05:00SP json conditional formatting<div dir="ltr" style="text-align: left;" trbidi="on">
Hi world! Yes it has been a while indeed...but finally something to give back!<br />
<br />
My customer asked to have SharePoint Online views formatted such that the font color for certain rows would be different based on the Status field value for the list item. Since we're using SPO I did not want to go the custom column formatter route, and I found a reference for using JSON for column formatting - but no great examples.<br />
<br />
The only wrinkle I found is this is done at the field level - so wherever this field is used in a list, it will include this formatting. Fortunately not an issue in my case, but you might have a case where you want the field to retain its default formatting.<br />
<br />
{<br />
"elmType": "div",<br /> "txtContent": "@currentField",<br /> "style": {<br /> "color": {<br /> "operator": "?",<br /> "operands": [<br /> {<br /> "operator": "==",<br /> "operands": [<br /> "[$processStatus]",<br /> "Inactive"<br /> ]<br /> },<br /> "#a9a9a9",<br /> ""<br /> ]<br /> }<br /> }<br /> }<br />
<br />
My status field is processStatus (case matters). And in my case I want to change the color to a dark gray, if the status is equal to 'Inactive'. <br />
<br />
The result:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFoE84jBdlik_6vPcbLT2vKRtXEncKsuI34Hw6NgiZTQ-apGrzlYJLrcjzf8vNG_4oCMiOFzD3YVnn-p-J7v5BKZyn0GNtOtG1UtykXmdKNobFf0AT81Kq68KuqK7LCh5GPfQ/s1600/colorchange.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="69" data-original-width="218" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFoE84jBdlik_6vPcbLT2vKRtXEncKsuI34Hw6NgiZTQ-apGrzlYJLrcjzf8vNG_4oCMiOFzD3YVnn-p-J7v5BKZyn0GNtOtG1UtykXmdKNobFf0AT81Kq68KuqK7LCh5GPfQ/s1600/colorchange.JPG" /></a></div>
<br />
Success!</div>
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-16560398029290357752016-09-12T07:24:00.000-05:002016-09-12T07:24:01.614-05:00SharePoint add-ins tenant permissions and appinv.aspxHaving issues deploying your tenant scoped SharePoint add-in (though I confess I still call them apps)? You've pasted the XML for your add-in on the appinv.aspx page and you get a message back that you have to be a tenant admin? But wait you are logged on as the tenant admin!<br />
<br />
Microsoft recently made a change that any apps that require tenant permissions must use the tenant admin site itself for the AppInv.aspx - so navigate to <a href="https://mytenant-admin.sharepoint.com/_layouts/15/appinv.aspx">https://mytenant-admin.sharepoint.com/_layouts/15/appinv.aspx</a> and try out the same steps - it'll work just fine!<br />
<br />
Makes sense I guess that in order to deploy a tenant scoped add-in I really should be a tenant admin... I haven't tried to verify whether I need to be a global admin or just a SharePoint admin, but I suspect both would work fine.Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-38597113126712038662016-08-16T14:43:00.004-05:002016-08-16T14:43:50.403-05:00SharePoint Designer, Workflows, local cacheHi world, been a long time! I'm still SharePointing, been having fun with client side rendering and JSOM. Post on that coming soon, promise!<br />
<br />
In the meantime, here's a quick one. Admit it, you still use Designer. It's still a handy tool especially for workflows. I had put together a workflow for one of my customers, it's been working just fine. Occasionally, though, when I went to edit it, I would get an error generating local caches. There's some recommendations on how to clear out the local cache & try again, but that didn't seem to help me. I tried on multiple PCs and VMs and finally got one working, then three months later promptly forgot which combo actually worked...so time for that root cause.<br />
<br />
What did help? Run as Administrator. Yep, the issue wasn't in pulling down the content for the caches, but getting that content into the local file system. I'm logged on with a local admin account on my dev VM, but even so that didn't help. So, with your nifty Designer program icon, hit Ctrl + Shift then click, accept the prompt to run as Admin, and edit those workflows away.<br />
<br />
See you soon! The big teaser is, re-running a workflow when an item is edited on O365. It can be done.Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-18940076382504856832015-03-18T12:38:00.002-05:002015-03-18T12:38:14.907-05:00Visual Studio, MVC and a proxy serverHello world,<br />
<br />
I'm preparing a talk for this weekend on MVC development with SharePoint Online - I'll post the deck once ready!<br />
<br />
In preparing for the demos, when I try to connect an on-premises Provider Hosted App to my SPO tenant, I'm prompted to enter in my tenant credentials, SharePoint is Working On It... then, I get an error in Visual Studio on the clientContext.ExecuteQuery(), System.Net.Exception, Unable to connect to the remote server.<br />
<br />
The issue - I'm behind a corporate proxy server. The fix - tell .Net about it! Easy enough to do, just add the following to the web.config file for the MVC app:<br />
<br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"> <</span></span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">system.net</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"> <</span></span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">defaultProxy</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"> </span></span></span><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;">useDefaultCredentials</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">=</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">"</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">true</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">"</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"> /></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></</span></span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">system.net</span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">></span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: black; font-family: Consolas; font-size: x-small;">Hit F5 and you'll be good to go!</span>Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-89494335961272560442014-10-03T13:19:00.000-05:002014-10-06T13:01:45.372-05:00Visio Services - The server failed to process the requestAnother day, another interesting SharePoint error! I finally got around to building out a Visio dashboard for my model office environment. We've got a lot of servers out there and it's about time to get a handle on overall health and performance. <br />
<br />
The dashboard worked great until I let the team try it out - two folks reported back that the page was showing an error, "the server failed to process the request". ULS showed a related error, at Microsoft.SharePoint.WebPartPages.Utility.SetThreadCulture - not totally obvious!<br />
<br />
Searching out there turned up a blog post by Robert Seso of a similar problem on SharePoint 2010 - different ULS log entries, though. I tried out the fix he suggested to solve his issue - grant a permission to the service account a used by Visio Services - not the SCOM service account or data reader account, but the service account configured for Visio Services in SP2013. Here's the PowerShell to run:<br />
<br />
$webapp = get-spwebapplication("http://mywebapp.myserver.com")<br />
$webapp.GrantAccessToProcessIdentity("mydomain\sp_visiosvc")<br />
<br />
Go back to your page, refresh, and so far so good.<br />
<br />
<a href="http://www.robertseso.com/2012/02/troubleshooting-workflow-visualization.html">http://www.robertseso.com/2012/02/troubleshooting-workflow-visualization.html</a><br />
<br />
More clarification! So far not so good. I think the real issue here was on how I had set up the data source. Initially, I had created a site collection, pointed the ODC file at that URL, then all was good. I then decided to make things nicer and go with a host named site collection, which in & of itself was not the problem, the problem was, I used the original ODC file without updating it for the new HNSC. I recreated the ODC file in the HNSC and recreated the Visio drawing to use this ODC file & it's been running fine since.Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com1tag:blogger.com,1999:blog-11781538.post-23746641671095449232014-10-02T10:36:00.000-05:002014-10-02T10:36:11.367-05:00SharePoint 5586 flood fixedHi SharePointers,<br />
<br />
Another SharePoint first today. I had set up a dev server for a colleague, went back in to take a look because she said she was having performance problems. I fixed the root certificate issue, which certainly helped, but also there were a lot of 5586 messages left. From the ULS logs:<br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">Unknown SQL Exception 53 occurred. Additional error information from SQL Server is included below. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)</span><br />
<br />
I checked the SQL Server aliases (this server uses a named instance, after all!), checked the registry keys used for the aliases & the SharePoint Config db, and checked the SQL Server's network configuration, but nowhere was it using Named Pipes.<br />
<br />
Turns out: wrong alias. I generally use SPDB as my alias name, but if I went down one more line in the ULS logs:<br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">ConnectionString: 'Data Source=<strong>ServerName_SPDB</strong>;Initial Catalog=master;Integrated Security=True'....</span><br />
<br />
So somehow, the servername value I was using was in front of the alias - sounds like a bug in my AutoSPConfig XML file! The rest of SharePoint is working fine, so there must be a service somewhere that's using this alias. I'll dig for that next, but workaround for now, I set up a second alias for this value & no more log flood.<br />
<br />
Hope this helps someone!Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com1tag:blogger.com,1999:blog-11781538.post-2580784700767227122014-09-18T15:13:00.002-05:002014-09-18T15:14:29.521-05:00Method 'Upgrade' in type 'Microsoft.SharePoint.WorkflowServices.WorkflowServiceApplicationProxy' messageThe good admin you are, you just finished deploying the Windows patches for September on your non-SP1'd SharePoint 2013 farm server...rebooted...Central Admin comes up fine...open up PowerShell and kaboom! <br />
<br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">
Method 'Upgrade' in type 'Microsoft.SharePoint.WorkflowServices.WorkflowServiceApplicationProxy' from assembly 'Microsoft.SharePoint.Wor
Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' does not have an implementation.</span>
<br />
<br />
There's an update that assumes you already have SP1 deployed - if you go back to Central Admin you'll note the UI changes for O365 & Yammer are now showing up.
The fix is to deploy one more hotfix to your server - you can download it from here: <a href="http://www.microsoft.com/en-us/download/details.aspx?id=42898">http://www.microsoft.com/en-us/download/details.aspx?id=42898
</a><br />
<br />
No reboot required - install the update, open up that PS window & you're blissfully error free.<br />
<br />
Happy SharePointing!<br />
<br />Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com21tag:blogger.com,1999:blog-11781538.post-51165850953464459652014-09-18T10:57:00.001-05:002014-09-18T11:00:15.153-05:00SharePoint 2013 Site Codes and DescriptionsBelow is a list of the out of the box site codes available for SharePoint 2013. This is for the 1033 (US English) locale:<br />
<br />
<table><tbody>
<tr><th>Site Code</th><th>Description</th></tr>
<tr><td>GLOBAL#0</td><td>Global template</td></tr>
<tr><td>STS#0</td><td>Team Site</td></tr>
<tr><td>STS#1</td><td>Blank Site</td></tr>
<tr><td>STS#2</td><td>Document Workspace</td></tr>
<tr><td>MPS#0</td><td>Basic Meeting Workspace</td></tr>
<tr><td>MPS#1</td><td>Blank Meeting Workspace</td></tr>
<tr><td>MPS#2</td><td>Decision Meeting Workspace</td></tr>
<tr><td>MPS#3</td><td>Social Meeting Workspace</td></tr>
<tr><td>MPS#4</td><td>Multipage Meeting Workspace</td></tr>
<tr><td>CENTRALADMIN#0</td><td>Central Admin Site</td></tr>
<tr><td>WIKI#0</td><td>Wiki Site</td></tr>
<tr><td>BLOG#0</td><td>Blog</td></tr>
<tr><td>SGS#0</td><td>Group Work Site</td></tr>
<tr><td>TENANTADMIN#0</td><td>Tenant Admin Site</td></tr>
<tr><td>APP#0</td><td>App Template</td></tr>
<tr><td>APPCATALOG#0</td><td>App Catalog Site</td></tr>
<tr><td>ACCSRV#0</td><td>Access Services Site</td></tr>
<tr><td>ACCSVC#0</td><td>Access Services Site Internal</td></tr>
<tr><td>ACCSVC#1</td><td>Access Services Site</td></tr>
<tr><td>BDR#0</td><td>Document Center</td></tr>
<tr><td>DEV#0</td><td>Developer Site</td></tr>
<tr><td>DOCMARKETPLACESITE#0</td><td>Academic Library</td></tr>
<tr><td>EDISC#0</td><td>eDiscovery Center</td></tr>
<tr><td>EDISC#1</td><td>eDiscovery Case</td></tr>
<tr><td>OFFILE#0</td><td>(obsolete) Records Center</td></tr>
<tr><td>OFFILE#1</td><td>Records Center</td></tr>
<tr><td>OSRV#0</td><td>Shared Services Administration Site</td></tr>
<tr><td>PPSMASite#0</td><td>PerformancePoint</td></tr>
<tr><td>BICenterSite#0</td><td>Business Intelligence Center</td></tr>
<tr><td>SPS#0</td><td>SharePoint Portal Server Site</td></tr>
<tr><td>SPSPERS#0</td><td>SharePoint Portal Server Personal Space</td></tr>
<tr><td>SPSPERS#2</td><td>Storage And Social SharePoint Portal...</td></tr>
<tr><td>SPSPERS#3</td><td>Storage Only SharePoint Portal Serve...</td></tr>
<tr><td>SPSPERS#4</td><td>Social Only SharePoint Portal Server...</td></tr>
<tr><td>SPSPERS#5</td><td>Empty SharePoint Portal Server Perso...</td></tr>
<tr><td>SPSMSITE#0</td><td>Personalization Site</td></tr>
<tr><td>SPSTOC#0</td><td>Contents area Template</td></tr>
<tr><td>SPSTOPIC#0</td><td>Topic area template</td></tr>
<tr><td>SPSNEWS#0</td><td>News Site</td></tr>
<tr><td>CMSPUBLISHING#0</td><td>Publishing Site</td></tr>
<tr><td>BLANKINTERNET#0</td><td>Publishing Site</td></tr>
<tr><td>BLANKINTERNET#1</td><td>Press Releases Site</td></tr>
<tr><td>BLANKINTERNET#2</td><td>Publishing Site with Workflow</td></tr>
<tr><td>SPSNHOME#0</td><td>News Site</td></tr>
<tr><td>SPSSITES#0</td><td>Site Directory</td></tr>
<tr><td>SPSCOMMU#0</td><td>Community area template</td></tr>
<tr><td>SPSREPORTCENTER#0</td><td>Report Center</td></tr>
<tr><td>SPSPORTAL#0</td><td>Collaboration Portal</td></tr>
<tr><td>SRCHCEN#0</td><td>Enterprise Search Center</td></tr>
<tr><td>PROFILES#0</td><td>Profiles</td></tr>
<tr><td>BLANKINTERNETCONTAINER#0</td><td>Publishing Portal</td></tr>
<tr><td>SPSMSITEHOST#0</td><td>My Site Host</td></tr>
<tr><td>ENTERWIKI#0</td><td>Enterprise Wiki</td></tr>
<tr><td>PROJECTSITE#0</td><td>Project Site</td></tr>
<tr><td>PRODUCTCATALOG#0</td><td>Product Catalog</td></tr>
<tr><td>COMMUNITY#0</td><td>Community Site</td></tr>
<tr><td>COMMUNITYPORTAL#0</td><td>Community Portal</td></tr>
<tr><td>SRCHCENTERLITE#0</td><td>Basic Search Center</td></tr>
<tr><td>SRCHCENTERLITE#1</td><td>Basic Search Center</td></tr>
<tr><td>visprus#0</td><td>Visio Process Repository</td></tr>
<tr><td>ECMWebTemplate#0</td><td>Enterprise Content Site</td></tr>
</tbody></table>
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-22389467944656354962014-09-12T10:02:00.001-05:002015-03-13T09:47:25.428-05:00Default gateway blank or 0.0.0.0Ever had your server's default gateway stuck showing either 0.0.0.0, or blank entirely? Totally ignoring the value you're assigning? Happened to me when I was bouncing between client Hyper-V on Windows 8.1 and VirtualBox. The culprit? All of those prior network connections. Once you get rid of them, network properties works like a charm.<br />
<br />
The catch? The devices and old connections are hidden. To show them, open up an administrator command prompt, and enter the command:<br />
<br />
set devmgr_show_nonpresent_devices=1<br />
<br />
then enter the command <br />
<br />
start devmgmt.msc<br />
<br />
to start up Device Manager (or launch it from Control Panel). Then, in the View menu, choose Show Hidden Devices, expand out your Network Adapters and be amazed:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzfHHHVkAHl5vhw9z1ZxOUcM9Kqx-wsUlgfaptURwpMuhhvwmzQNJ0gccOs1P80CSo9qG12NzzlQkox-6kG5E5pFsyB5FTZ8Tv-dtd-POl9uRy-FZzx1h_zXt7PcSCIKnncGs/s1600/NetworkClutter.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzfHHHVkAHl5vhw9z1ZxOUcM9Kqx-wsUlgfaptURwpMuhhvwmzQNJ0gccOs1P80CSo9qG12NzzlQkox-6kG5E5pFsyB5FTZ8Tv-dtd-POl9uRy-FZzx1h_zXt7PcSCIKnncGs/s1600/NetworkClutter.JPG" height="320" width="239" /></a></div>
<br />
See all of those hidden devices? The active one, Microsoft Hyper-V Network Adapter #19 is shown with the bold icon, but the others, including the Intel (R) PRO/1000 adapters are somewhat blurred - those are the ones to delete.<br />
<br />
Do that, reboot for good measure, set that default gateway and be productive!<br />
<br />
Update: I decided to poke around some of the other devices & there were more to remove, when making the VirtualBox to Hyper-V switch. Expand out some of the other nodes to clear out the old VirtualBox devices. Having these around wasn't causing problems, but the less clutter the better.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizwIk2O_I_s8NH6apE1USm8atUWJoXCf3xnWKropviDootShIqfQo05uKUQCxMgvUkZBwZGVY_Qq2pavQuaXlZOw5cp2KrOa0Jvuv8iYC5KHAF5zqjJnzgsOblqCUT2UWLyo8/s1600/OtherHiddenDevices.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizwIk2O_I_s8NH6apE1USm8atUWJoXCf3xnWKropviDootShIqfQo05uKUQCxMgvUkZBwZGVY_Qq2pavQuaXlZOw5cp2KrOa0Jvuv8iYC5KHAF5zqjJnzgsOblqCUT2UWLyo8/s1600/OtherHiddenDevices.JPG" height="320" width="165" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
Also, be sure you remove either the Hyper-V Integration Services or the VirtualBox Additions from Windows Control Panel Add/Remove Programs, as appropriate. And if you're switching back to VirtualBox, odds are the Additions are out of date, so go ahead & refresh.</div>
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com1tag:blogger.com,1999:blog-11781538.post-30236940614680868752014-08-19T10:59:00.000-05:002014-08-19T10:59:17.542-05:00SharePoint Designer 2013 + SharePoint 2013 Workflow - where's the workflow??Hi SharePointers,<br />
<br />
We had an interesting one today. One of my developers was having a problem creating a new SharePoint 2013 workflow with SharePoint Designer 2013. We were able to create the workflow, but when SharePoint went to fetch the workflow actions from the server, nothing else happened - the workflow was not created. SP2010 workflows worked fine.<br />
<br />
The solution: For some reason, a DLL was missing from the 15 hive on the server - in this path:<br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\WorkflowActivities</span><br />
<br />
there should be a DLL:<br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">Microsoft.SharePoint.WorkflowServices.Activities.dll</span><br />
<br />
For whatever reason, that DLL was not in the folder. It was in the GAC, oddly enough. Once we copied the DLL from another server into the above folder, IISResetted, cleared the Designer cache, the workflow was able to be created.<br />
<br />
Other things we tried that didn't help:<br />
1) Re-registerWorkflow Manager<br />
2) Removed Workflow Manager from the SharePoint server, then installed it on a separate smaller footprint server. <br />
3) Re-registered Workflow Manager with non-SSL<br />
4) Used Fiddler to see what was going on<br />
<br />
The clue was in one message in the ULS logs - several OOTB features were missing:<br />
<br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: #1f497d;"><span style="font-family: Calibri;">
Feature definition with id 00bfea71-c796-4402-9f2f-0eb9a6e71b18 not
found. [WebPageLibrary]</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: #1f497d;"><span style="font-family: Calibri;">
Feature definition with id 065c78be-5231-477e-a972-14177cc5b3c7 not
found. [BizAppsListTemplates]</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: #1f497d;"><span style="font-family: Calibri;">
Feature definition with id 00bfea71-5932-4f9c-ad71-1557e5751100 not found.
[IssuesList]</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: #1f497d;"><span style="font-family: Calibri;">
Feature definition with id 7201d6a4-a5d3-49a1-8c19-19c4bac6e668 not
found. [MetaDataNav]</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: #1f497d;"><span style="font-family: Calibri;">
Feature definition with id 0806d127-06e6-447a-980e-2e90b03101b8 not
found. [PremiumWeb]</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: #1f497d;"><span style="font-family: Calibri;">
Feature definition with id 00bfea71-4ea5-48d4-a4ad-305cf7030140 not
found. [WorkflowHistoryList]<o:p></o:p></span></span></div>
<br />
Anyway, once that DLL was copied over - didn't have to GAC it or anything - all was well once again.Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-46607827056661126162014-04-24T12:18:00.002-05:002014-04-24T12:18:42.075-05:00SharePoint 2013 and SQL Server HA optionsI put together the following table to summarize the HA options available for SQL Server 2012 and SharePoint 2013. In short - use sync AlwaysOn where possible! <br />
<br />
The difference between sync & async has to do with performance over data integrity. Sync will wait on confirmations from each end point that the transactions were successful. Async does not wait. Async will give better performance, but it's possible to have data loss. <br />
<br />
I'm building this out in a lab environment based on VirtualBox. My attempt #1 was to get FreeNAS working with Server 2012 to set up the shared disk required by Windows Clustering. I was able to get the iSCSIInitator in Server 2012 to recognize the NAS drives, but couldn't convince Windows Clustering to use it. So next up will be to see if I can get the same working with Server 2012's iSCSI built in support.
<br />
<br />
I see this as one benefit of Hyper-V over VirtualBox - Hyper-V has a virtual fiber channel feature built in. In theory, this would let me set up a virtual SAN environment. I've been trying the same with VirtualBox (yes, I know...but I did try switching over to Hyper-V on my Windows 8 laptop, but at the time networking wasn't working. I should give it another try, I know...).<br />
<br />
Anway, the table below is a summary of a TechNet article listing each of the SharePoint databases. I found the table format a bit easier to use.
<br />
<br />
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 1229px;">
<colgroup><col style="mso-width-alt: 13238; mso-width-source: userset; width: 272pt;" width="362"></col>
<col style="mso-width-alt: 10386; mso-width-source: userset; width: 213pt;" width="284"></col>
<col span="4" style="mso-width-alt: 4096; mso-width-source: userset; width: 84pt;" width="112"></col>
<col style="mso-width-alt: 4937; mso-width-source: userset; width: 101pt;" width="135"></col>
<tbody>
<tr height="49" style="height: 36.75pt; mso-height-source: userset;">
<td class="xl65" height="49" style="background-color: transparent; border: 1px black; height: 36.75pt; width: 272pt;" width="362"><strong><span style="font-family: Calibri;">Database</span></strong></td>
<td class="xl65" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><strong><span style="font-family: Calibri;">Purpose</span></strong></td>
<td class="xl66" style="background-color: transparent; border: 1px black; width: 84pt;" width="112"><strong><span style="font-family: Calibri;">Sync Mirroring</span></strong></td>
<td class="xl66" style="background-color: transparent; border: 1px black; width: 84pt;" width="112"><strong><span style="font-family: Calibri;">Sync AlwaysOn</span></strong></td>
<td class="xl66" style="background-color: transparent; border: 1px black; width: 84pt;" width="112"><strong><span style="font-family: Calibri;">Asyc Mirror/Log Shipping</span></strong></td>
<td class="xl66" style="background-color: transparent; border: 1px black; width: 84pt;" width="112"><strong><span style="font-family: Calibri;">Async AlwaysOn</span></strong></td>
<td style="background-color: transparent; border: 1px black; width: 101pt;" width="135"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">SharePoint_Config</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Configuration database</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">SharePoint_Admin_Content</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">CA content db</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">WSS_Content</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Content database</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">AppManagement</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Service database</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Search_Service_Application_DB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores Search app configuration</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Search_Service_Application_AnalyticsReportingStoreDB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores usage analysis data for
reports</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="40" style="height: 30pt;">
<td height="40" style="background-color: transparent; border: 1px black; height: 30pt;"><span style="font-family: Calibri;">Search_Service_Application_CrawlStoreDB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores the state of the crawled
content &amp; crawl history</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="40" style="height: 30pt;">
<td height="40" style="background-color: transparent; border: 1px black; height: 30pt;"><span style="font-family: Calibri;">Search_Service_Application_LinkStoreDB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores extracts of the content
processing component sna click through info</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Secure_Store_Service_DB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores Secure Store credentials</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">SharePoint_Logging</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores health monitoring &amp;
usage data</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y*</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y*</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y*</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">* not recommended</span></td>
</tr>
<tr height="40" style="height: 30pt;">
<td height="40" style="background-color: transparent; border: 1px black; height: 30pt;"><span style="font-family: Calibri;">SettingsServiceDB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores features and settings for
hosted customers</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Usage Profile Service App</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores &amp; manages users and
associated info</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Usage Profile Service App Sync DB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Used during a user profile sync</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Usage Profile Service Social DB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores social tags and notes</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="40" style="height: 30pt;">
<td height="40" style="background-color: transparent; border: 1px black; height: 30pt;"><span style="font-family: Calibri;">WordAutomationServices</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores info about pending &amp;
completed doc conversions</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Managed Metadata Service App</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores managed metadata<span style="mso-spacerun: yes;"> </span></span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="40" style="height: 30pt;">
<td height="40" style="background-color: transparent; border: 1px black; height: 30pt;"><span style="font-family: Calibri;">Translation Services DB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores info about pending &amp;
completed doc translations</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">Business Data Connectivity Service DB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores external content types</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">ProjectWebApp</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Project Web App database</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">PowerPivotServiceDB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores data refresh scheduled
&amp; usage data</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">No Guidance</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">No Guidance</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">No Guidance</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">No Guidance</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="20" style="height: 15pt;">
<td height="20" style="background-color: transparent; border: 1px black; height: 15pt;"><span style="font-family: Calibri;">PerformancePoint Service DB</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores temp objects &amp; saved
comments</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
<tr height="40" style="height: 30pt;">
<td height="40" style="background-color: transparent; border: 1px black; height: 30pt;"><span style="font-family: Calibri;">State Service db</span></td>
<td class="xl63" style="background-color: transparent; border: 1px black; width: 213pt;" width="284"><span style="font-family: Calibri;">Stores temp state info from
InfoPath, Exchange, chart web part, Visio services</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">Y</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td class="xl64" style="background-color: transparent; border: 1px black;"><span style="font-family: Calibri;">N</span></td>
<td style="background-color: transparent; border: 1px black;"></td>
</tr>
</tbody></colgroup></table>
<br />
<em>Source</em>: <a href="http://technet.microsoft.com/en-us/library/jj841106(v=office.15).aspx">Supported HA Options for SharePoint 2013</a>Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-37175255981377436902014-02-25T16:54:00.001-05:002014-02-25T16:54:18.224-05:00SPC14And, see you at the SharePoint Conference in Vegas! I'll be at the HP Booth Sunday night, and also speaking at the Partner Theatre Sunday night, then at the booth periodically throughout the event. If you're there stop by to say hello, or schedule a meeting with my on the MySPC site.<br />
<br />
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-41245406596113314302014-02-25T16:52:00.000-05:002014-02-25T16:52:41.843-05:00See you in Grand Rapids!Accepted to speak at the DevDay conference in Grand Rapids, March 22! <br />
<br />
<a href="http://grdevday.org/">http://grdevday.org/</a><br />
<br />
Hope to see you there. There's a good line up of speakers and topics, I'll be attending some of the mobile development talks.Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-32669739004100300892014-02-25T16:45:00.001-05:002014-02-25T16:45:56.285-05:00Office Web Apps 2013 - UnhealthyRan into this issue on my lab servers. I installed Office Web Apps 2013, configured it, all good! But then Windows Update showed a patch from 1/2/14 for OWA, I applied that, and afterwards, Get-OfficeWebAppsMachine showed that my server was Unhealthy.<br />
<br />
I did some Binging and found that indeed yes, there is a process to follow for patching an OWA server - first, remove the OWA server from the farm with Remove-OfficeWebAppsMachine, then apply the update, then use the New-OfficeWebAppsFarm again to rebuild the farm. <br />
<br />
Following a comment in a host here: <a href="http://michaelvh.wordpress.com/2013/04/01/the-curious-health-problems-of-the-office-web-apps-server/">http://michaelvh.wordpress.com/2013/04/01/the-curious-health-problems-of-the-office-web-apps-server/</a><br />
<br />
I enabled HTTP Activation for the WCF Services for the .Net Framework 4.5 on the OWA server. Since I'm running Server 2012, I needed to use the Features option on Server Configuration to get this working:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4XA5HKaCK17evX4USUYw6MlHDPhGnVM-oOOLGIo9tsnr0_oTye5P2IaTPZiNmwlteIxYVVnGGf_gycZ851yogVJWvSru4Q4QOKNMRfqGwFwEJgx3x8LMdMJ0wn0fq2frlsMg/s1600/HTTPActivation.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4XA5HKaCK17evX4USUYw6MlHDPhGnVM-oOOLGIo9tsnr0_oTye5P2IaTPZiNmwlteIxYVVnGGf_gycZ851yogVJWvSru4Q4QOKNMRfqGwFwEJgx3x8LMdMJ0wn0fq2frlsMg/s1600/HTTPActivation.jpg" height="227" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div align="left" class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
Did a reboot for good measure, now Get-OfficeWebAppsMachine shows Healthy!</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-44605632187517514642013-05-06T20:12:00.002-05:002014-01-26T10:43:43.855-05:00Ironing out an SP2013 installThis might save you some time...or at least it'll save me time again when I forget all the things I did to get my 2013 install done!<br />
<br />
I started with the AutoSPInstall script for 2013 - if you're unfamiliar with this do yourself the favor and get over to CodePlex and download a copy. It's a great timesaver. Apart from naming all of SP's databases with prefixes, it automates the install cycle...very helpful and repeatable!<br />
<br />
But - once the install finished, I had some issues. My logs showed a batch of errors.<br />
<br />
1) Certificate Validation Operation took 150003.361 milliseconds... error 8321. See the separate post for this. The fix was to set my company's proxy script in the registry for each of the SP Service accounts. If you get to that HKEY_USER key, you'll know which keys to update - or you can find some handy PowerShell out there to convert a SID to an account if you'd like. I just set this for everyone there, where it wasn't already set. I also set an entry in my server's Hosts file 127.0.0.1 crl.microsoft.com, followed by an ipconfig /flushdns - seemed the hosts entry did the trick.<br />
<br />
Update 1/26/14: This link really works - follow the steps to export the SharePoint root certificate & import to your trusted root certs & you'll be good to go. <a href="http://support.microsoft.com/kb/2625048">http://support.microsoft.com/kb/2625048</a><br />
<br />
2) Error 2548/2159 errors...for this, two fixes. 1) Whack the Search Service Application, delete the databases too, then redo the service. Then, add the Search Service account to the local administrators group...gets search working.<br />
<br />
3) My favorite - killed myself on this and it was a real SharePoint d'oh moment...I was getting loads of 3355 connection timeout expired errors. Do yourself a favor and skip trying to fix the timeouts - the real issue was right there on my Hyper-V Manager console. The additions were out of date...yeah, put in the Hyper-V Integration Services DVD image, ran the AMD64 setup, rebooted, and no more 3355s.<br />
<br />
I was getting these on another install - had the integration services already updated - the two changes I made were disabling named pipes on the SQL Server client configuration, and added the SP Farm account to the local admin group. I vote for the former as the fix.<br />
<br />
4) Related to all of this was a real goofy "An exception occurred" message on my publishing sites. Once I got the Search Service working again, this error also went away.<br />
<br />
Hope this helps you...Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-52654751629256475422013-04-18T16:22:00.002-05:002013-04-18T16:22:53.316-05:00We don't need no stinkin Task Outcomes!Ah, au contraire, yes you do. I had one of those SharePoint WTF challenges today. I'm building out a SharePoint Designer workflow against a custom list in a custom web template. I know what you're thinking, and I thought the same, but it wasn't the case!<br />
<br />
What was going on was, in my workflow, I have a standard approval task. Clicking on the task in Designer opens the page where I can modify the properties of the task, like its name, allow reassignment, that sort of thing. It's also the page where I can define the outcomes of the task - Approved, Rejected, or custom items like Wait Til Next Year or In Your Dreams for those vacation request denials.<br />
<br />
Problem is, when I open the page, there were no task outcomes defined...and worse, when I clicked the "New.." button or "New Outcome" on the ribbon, nothing happened, nada:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdMYqJUxkrSEzDmaRJMPAqoAbOcF806ATMe8m_nkTJtvbdJ7jbX-BlzxjB4c81IiK8oXnT1ZBLrmoCF7Dca8UKuUI0JU21ZyzXUIGHq_naVVstrGU5vD6KKGZOd1-54jHjtPs/s1600/TaskOutcomes.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdMYqJUxkrSEzDmaRJMPAqoAbOcF806ATMe8m_nkTJtvbdJ7jbX-BlzxjB4c81IiK8oXnT1ZBLrmoCF7Dca8UKuUI0JU21ZyzXUIGHq_naVVstrGU5vD6KKGZOd1-54jHjtPs/s640/TaskOutcomes.JPG" width="640" /></a></div>
<br />
Not pretty, is it? I did verify the same workflow worked fine with an OOTB site definition, so my first approach was to look at the web template definition and list definition, and yeah there were a few things wrong...but that didn't fix this issue. Redeployed the web template, IISRESETted, rebooted, still No Task Outcomes.<br />
<br />
<strong><span style="color: red;">The Solution</span></strong><br />
I've decided to make the solutions succinct and clearly findable - so you Dear Reader can skip all of the fluff above and get your workflow deployed so you can get home and relax.<br />
<br />
Go to Site Settings and in Site Collection Features, deactivate all workflow related features; then go back and re-active those feature. <br />
<br />
Worked for me twice, the third side I had really screwed up and got an error that a list "wfpub" in my web was already created so I couldn't activate the workflow features again, so it goes.<br />
<br />
Have a slice for me!Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-54290154722991704692013-03-25T12:45:00.003-05:002013-03-25T12:45:49.132-05:00CSOM in a CQWPThe post title explains it all! I've been trying to put together some dynamic web page content based on items in a SharePoint list, using JavaScript code inside a Content Query Web Part on one of my site pages. Shouldn't be so hard, right?<br />
<br />
Well, turns out it isn't. Found a nice link here with some of the steps needed: <a href="http://techtrainingnotes.blogspot.com/2012/02/sharepoint-how-to-add-javascript-to.html">http://techtrainingnotes.blogspot.com/2012/02/sharepoint-how-to-add-javascript-to.html</a> - but with that code on my linked in JavaScript source file, the code still wasn't firing.<br />
<br />
Here's what's needed. At the bottom of the code, add in the following:<br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">function myJSfunction {</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> var clientContext = new SP.ClientContext.get_current();</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"></span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">}</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"></span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">function DelayUntilMyJSLoaded()</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">{</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> ExecuteOrDelayUntilScriptLoaded(myJSfunction, 'sp.js');</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">}</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"></span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">_spBodyOnLoadFunctionNames.push('DelayUntilMyJSLoaded');</span><br />
<br />
What these lines will do is to call my function, but only when the function is ready to be called based on having the base 'sp.js' file loaded. If you do a view source on the hosting page, there toward the bottom you'll see something very similar.Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-37079738120870040342013-02-26T20:23:00.001-05:002013-02-27T06:55:06.442-05:00So that's what the Host-Only Adapter is used for! (Windows Phone SDK VM challenge)Preparing for a talk this Saturday at Grand Rapids DevDays, I wanted to demo the new capabilities for mobile development with SharePoint 2013. The Visual Studio tooling (alas, sorry MS people, but I have one of those fruit company phones and I like it!) has a good story for Windows Phone, but for the rest of us? Another story - white paper forthcoming.<br />
<br />
For Windows Phone development, here's the big kicker: can't use that Phone emulator virtualized. Nope, nada, nil, ixnay, no can do. The Windows 8 SDK requires hardware virtualization with SLAT support - great on physical iron but not virtual iron, so that's right out. With the Phone 7.1 SDK, same issue - first there's a big warning about not having a compatible GPU, then the phone emulator would continuously reboot to the OS and my app never came up.<br />
<br />
So...this gets us to the point of this post, what's a virtualization developer to do? Ever notice in VirtualBox you have a bunch of choices for networking?<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO09YyTn0NlxQyxsKX0WygXcAPDgTkF5ez_LtFYTiafagJa0Nz57lwXZjWgdl2wFIGArc3t5zBUq6bmVEr4kQ-9Bg4RhHQnbWGZ8n9VK2EB05ech-PTPlL7P8BEmYDZMoCZ-s/s1600/VirtualBox+Networking.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO09YyTn0NlxQyxsKX0WygXcAPDgTkF5ez_LtFYTiafagJa0Nz57lwXZjWgdl2wFIGArc3t5zBUq6bmVEr4kQ-9Bg4RhHQnbWGZ8n9VK2EB05ech-PTPlL7P8BEmYDZMoCZ-s/s1600/VirtualBox+Networking.jpg" /></a></div>
<br />
I've been using VirtualBox since I needed x64 support & Virtual-PC just couldn't do it...I've used NAT, Bridged, Internal Network...but Host-only adapter? What the heck is that for? Out of the box it has an IP address of 192.168.1.56, what good is that?<br />
<br />
Well, turns out this is your way in from the host to your guest internal network. I assigned an IP in the range of my guests, assigned the guest DNS and default router, changed the VM's to use Host-only Adapter instead of Internal Network, and look at that, I'm in! The host is not part of my domain but no worries, I need to use Forms Based Authentication anyway for my mobile testing, so we're good to go.<br />
<br />
The only other change is to add in entries to the Hosts file on the host for the DNS entries you'll need. I wasn't able to resolve the hosts values otherwise, and no farm in it.<br />
<br />
I'm installing the SDK 8.0 now on my Windows 8 VM with Visual Studio 2012...got a feeling this will work, I'll let you know.<br />
<br />
Update: Strike One. SDK 8.0 enables Hyper-V. Not a good thing for running VirtualBox VMs. And there can be only one hypervisor - if Hyper-V is enabled then VirtualBox can't run. Uninstalling SDK 8.0 and VS 2012, going back to VS2010 and let's hope SDK 7.1 behaves better.<br />
<br />
Update: Strike Two and probably three...the good news is I can start up Visual Studio 2010, connect to my SharePoint guest VMs, get list data, prepare my app, but then when I start up the emulator - wham! There go the VMs. Seems the VS2010 Windows Phone Emulator is also using the same virtualization VirtualBox needs, and so it knocks out my VirtualBox VMs. I guess the answer will be to go to Hyper-V with the SDK 8.0 version, but I won't get to that til next week. Oh well!Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-50839595672283344642013-02-26T17:35:00.000-05:002013-02-26T17:35:28.837-05:00SharePoint Foundation 2013 Service Applications listBelow is a screen capture of the set of service applications available with SharePoint Foundation 2013:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhs5XnoZ2ySZJG9abbcz8H2dQy-caq48lulXon0KIK0lPWKftPQVQCAAh7yAzFUgl21J05Uwi2itR0Y2ZOHkO3IexoTK2Bzzf7JcpzMYVQbfb3FYZ02RAG5OeRU8w6y0Ay7az4/s1600/ServiceApps2013.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="" border="0" height="117" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhs5XnoZ2ySZJG9abbcz8H2dQy-caq48lulXon0KIK0lPWKftPQVQCAAh7yAzFUgl21J05Uwi2itR0Y2ZOHkO3IexoTK2Bzzf7JcpzMYVQbfb3FYZ02RAG5OeRU8w6y0Ay7az4/s400/ServiceApps2013.JPG" title="" width="400" /></a></div>
<br />
Available in Foundation are:<br />
<br />
<ul>
<li>App Management Service - used for the new Apps feature set of SharePoint 2013</li>
<li>Business Data Connectivity Service - get at that external data through external list definitions</li>
<li>Secure Store Service - store credentials and other data centrally and with encryption</li>
<li>Application Discovery and Load Balancer Service App - created with the farm</li>
<li>Security Token Service Application - used for authentication.</li>
</ul>
Here's the list of services available on the server - including SharePoint Server Search:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRoVPJoQDZWq8Az6N_3H5pNmW-JfJUazIm9Rl7ikKGAl3q_ZiSGksi6xI297RgXl62iUkL3py27pxzEli8QVAoLaxZzPSdg5g3AVw4_xrqeYXNHA8ubzyfWm6TbK8FGVMmJd8/s1600/Services.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRoVPJoQDZWq8Az6N_3H5pNmW-JfJUazIm9Rl7ikKGAl3q_ZiSGksi6xI297RgXl62iUkL3py27pxzEli8QVAoLaxZzPSdg5g3AVw4_xrqeYXNHA8ubzyfWm6TbK8FGVMmJd8/s320/Services.JPG" width="287" /></a></div>
<br />
Here the list is:<br />
<ul>
<li>App Management Service</li>
<li>Business Data Connectivity Service</li>
<li>Central Administration</li>
<li>Claims to Windows Token Service</li>
<li>Distributed Cache</li>
<li>Lotus Notes Connector</li>
<li>Microsoft SharePoint Foundation Incoming E-Mail</li>
<li>Microsoft SharePoint Foundation Sandboxed Code Service</li>
<li>Microsoft SharePoint Foundation Subscription Settings Service</li>
<li>Microsoft SharePoint Foundation Web Application</li>
<li>Microsoft SharePoint Foundation Workflow Timer Service</li>
<li>Request Management</li>
<li>Search Host Controller Service</li>
<li>Search Query and Site Settings Service</li>
<li>Secure Store Service</li>
<li>SharePoint Server Search</li>
</ul>
<br />
Plenty more when you enable Standard and Enterprise features, but I was trying to find out specifically what we get with Foundation.<br />
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com1tag:blogger.com,1999:blog-11781538.post-26902898716395613492013-02-22T07:37:00.000-05:002013-02-22T07:37:11.014-05:00VirtualBox - SetHDUUID COM errorQuick tip in case you have the same issue. I use VirtualBox as my server virtualization tool - it's a bit nicer on the laptop than running Hyper-V, but that's a whole other discussion! With VirtualBox, when you set up a template VHD image, to use that image for a new virtual server, you need to assign a unique ID to the VHD image.<br />
<br />
Usually, no problem. VirtualBox has two ways to do this, either the CloneHD command or a SetHDUUID command:<br />
<br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">c:\program files\oracle\virtualbox\vboxmanage internalcommands sethduuid <path .vhd="" file="" to=""></path></span><br />
<br />
So what's the problem? I had opened up a command prompt, entered in these commands, but got an error back that the VirtualBox COM server was not running:<br />
<br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">VBoxManage.exe: error: Failed to create the VirtualBox object!<br />VBoxManage.exe: error: Code CO_E_SERVER_EXEC_FAILURE (0x80080005) - Server execu<br />tion failed (extended info not available)<br />VBoxManage.exe: error: Most likely, the VirtualBox COM server is not running or<br />failed to start.</span><br />
<br />
The solution? Since this is an admin sort of thing to do I had opened up the command prompt as administrator (Windows 8 - type in CMD, right click Command Prompt, choose Run as Administrator)...and apparently that was the wrong answer! Open up a regular ol' Command Prompt window and the command goes through just fine.<br />
<br />
I'm sure this is a permissions issue - next slow rainy day I'll crack open ProcessMonitor and see exactly what VboxManage can't grab, but for now we're good to go.<br />
Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com1tag:blogger.com,1999:blog-11781538.post-2470416132225135092013-02-18T16:15:00.001-05:002013-02-18T16:15:07.557-05:00Test Lab Guides for SP2013Looking for some help setting up your SharePoint 2013 environment? Microsoft's published a series of guides to walk you through the process of setting up a 3-tier farm, then once you have that done, you can configure Claims, Forms Based Authentication, setting up an intranet, and enabling social features:<br />
<br />
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=30386">Three-Tier Farm Configuration</a><br />
<br />
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=30385">SAML-based Claims Authentication with SharePoint 2013</a><br />
<br />
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=34684">Forms-Based Authentication</a><br />
<br />
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=30379">Intranet Collaboration with SP2013</a><br />
<br />
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=34682">Demonstrate Social Features for SP2013</a><br />
<br />
Full details on the test lab guides:<br />
<a href="http://social.technet.microsoft.com/wiki/contents/articles/12409.sharepoint-server-2013-test-lab.aspx">http://social.technet.microsoft.com/wiki/contents/articles/12409.sharepoint-server-2013-test-lab.aspx</a><br />
<br />
Setting up Forms-Based Authentication now to get my mobile development environment ready for demo!Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-80630116504672409212013-01-03T12:43:00.002-05:002013-01-03T12:43:50.574-05:00IIS Error 500 - app pool culpritI was helping a coworker today with an error trying to get a SharePoint site up and running. We were able to provision a new web app with SharePoint Central Admin, and were able to create a site collection in that web app, but when we opened up the web app we got the ol' "Internal Server Error 500" error. <br />
<br />
What was different with this one was there were no entries in the Windows event viewer or the ULS logs, so I thought it was an issue with IIS - the IIS log did show an entry with a code 500 0 0 23 and 500 0 0 22. The problem was not with security as I thought, whether an invalid app pool ID, invalid permissions for the app pool account, having anonymous enabled on the site, and so on...<br />
<br />
It turned out the problem was a setting with the app pool. If you go into Advanced Settings for the app pool, the value for Enable 32-Bit Applications was set to True, but the default and proper setting is False, as shown below.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2QLFfg9z8yQAr-llIO1smgQ6NGWJ-1JvHR643248VVTG17sMDxz9WMh8ynUXEEbFu57muMPQol15o-W5REuaUtr_nALGvoqT_imhC0cywsEFdXYwsIXQYM05wlZRK7X6l2pk/s1600/AppPool.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="199" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2QLFfg9z8yQAr-llIO1smgQ6NGWJ-1JvHR643248VVTG17sMDxz9WMh8ynUXEEbFu57muMPQol15o-W5REuaUtr_nALGvoqT_imhC0cywsEFdXYwsIXQYM05wlZRK7X6l2pk/s320/AppPool.JPG" width="320" /></a></div>
<br />
<br />
We changed the value back to False, recycled the app pool, and no more error 500!Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com0tag:blogger.com,1999:blog-11781538.post-1441800327648929172013-01-03T11:32:00.001-05:002014-01-21T10:55:47.825-05:00SharePoint Foundation Event ID 8321, solvedI have two servers running SharePoint 2013 and both were getting the same Event ID 8321 error every 15 minutes or so in the Event Viewer:<br />
<br />
<span lang="EN"><span style="font-size: x-small;">A certificate validation operation took 15004.9996 milliseconds and has exceeded the execution time threshold. If this continues to occur, it may represent a configuration issue. Please see http://go.microsoft.com/fwlink/?LinkId=246987 for more details.</span><br />
<span style="font-size: x-small;"></span><br />
I made two changes to solve this, not sure which one did the trick finally but both are worth trying. The first, my company uses a proxy server, but I didn't have this configured on either server. The second was to download the latest (December 2012) Root Certificates from Microsoft here: <a href="http://www.microsoft.com/en-us/download/details.aspx?id=35945">http://www.microsoft.com/en-us/download/details.aspx?id=35945</a><br />
<br />
<br />
So far no more 8321 errors, if they do come back I'll let you know!<br />
<br />
Happy 2013!</span><br />
<br />
Updated 5/6/2013...well, turns out it was the first trick that solved this. My company uses a proxy server to connect out to the Internet, but it's set up with a configuration script. So...the fix is:<br />
<br />
1) Regedit<br />
2) In HKEY_USERS, for each SID based ID (not with _Classes) drill in to:<br />
<br />
\Software\Microsoft\Windows\CurrentVersion\Internet Settings<br />
<br />
3) Create two keys:<br />
<br />
AutoConfigURL, string, set the value to your config script URL<br />
ProxyEnable, DWORD, set to 0<br />
<br />
Reboot for good measure. This did work for me, no more of those pesky errors.<br />
<span lang="EN"><br />
Update 1/21/14:<br />
Found this Support article describing a fix which adds the SharePoint certificate to the trusted certificates store on the server: <a href="http://support.microsoft.com/kb/2625048">http://support.microsoft.com/kb/2625048</a><br />
<br />
</span><br />Stevehttp://www.blogger.com/profile/04925496141709492938noreply@blogger.com8