SharePoint BDLC Add-In OleDB Unspecified Error

I have fought with this for a week now and finally found a solution.
The error was when a user would attempt to create a new Layer2.de SharePoint Business Data List Connector in a SharePoint 2010 list they would recieve an OLEDB Unspecified Error.

Server 2008 R2 with SharePoint 2010

The problem is related to a security setting on the temp folder - but which one and where???

c:\users\temp.domain\appdata\local\temp

I added the Everyone group to the read/write/modify security on the temp folder above and it WORKS!!

This does grant all users of the server full access to the appdata temp folder so it is not a security best practice - but until I can find a better solution to this problem it works now.

SharePoint 2010 setup SSL on multiple web applications on the same WFE server

In our environment I wanted to host both the MySites and the default web application on the same server and use the same IP - at the same time I wanted to setup SSL only on both these sites using a wildcard certificate.

The goal is to get to where people could browse portal.domain.com and mysite.domain.com from SSL only and have it work both inside and outside the firewall.

I setup SharePoint with the default web application and then configured mysites to run on SSL only.
So now I could get to https://mysite.domain.com without issue.

In teh Alternate Access Mappings I changed the URL for the default web application to https://portal.domain.com and set it to also be SSL.
Then I went into IIS and configured both to bind to the wildcard certificate.

Now the websites showed stopped in IIS and they would not restart due to a conflict.
What happens is that you have to add a host header to the default web application in IIS for it to restart - except you cannot do this in the binding screen.

MAKE A BACKUP PRIOR TO THIS STEP (c:\windows\system32\inetsrv\config\applicationHost.config)

To add a host header in IIS 7:
Run NotePad as an administrator
File/Open
c:\windows\system32\inetsrv\config
applicationHost.config

Open this file and search for your default Web Application name - it will appear in the file like:
site name="SharePoint - 80"...

Look for bindings and specifically the line "binding protocol=..."
On this line you will need to add your host header (portal.domain.com) after the :443: and inside the quotations - like this
"binding protocol="https" bindinginformation="*:443:portal.domain.com" />

Now save the file and go into IIS and you can start the websites.
If you want to ensure the default website is SSL only you go into IIS and edit the bindings on that web application and remove the port 80 binding.

They will now respond to SSL only.

Windows 7 Network Shortcut location

I had a need to copy some network shortcuts from one account to another on Win7.

C:\Users\[username]\AppData\Roaming\Microsoft\Windows\Network Shortcuts

This is where Windows keeps the shortcuts for network locations.

SharePoint 2010 LoopBack and Search errors

I was having total fits with getting my search to work properly in our environment.

I have SSL enabled on our site and on our MySites, also there are AAM for each site.
What I found was an error when I tried to search these sites, even when I added the read permissions to the web applications.

There are several postings about DisableLoopBack and Server 2008 R2 - here are the two I used:
http://www.harbar.net/archive/2009/07/02/disableloopbackcheck-amp-sharepoint-what-every-admin-and-developer-should-know.aspx

http://www.cleverworkarounds.com/2011/07/22/troubleshooting-sharepoint-people-search-101/

So, for me I had to take the less attractive route to get this search working but once I disabled loopback my search started to work.

To search profiles via ssl:

• Setup your Content Source to https://
• Setup Profile Location (mysite) to sps3s://
• Don't miss the sps3s here or it will not index via SSL!

SharePoint 2010 RePost - Top Configuration Tips - Todd Klindt

I have heard Todd speak at a few SharePoint events and I highly recommend attending any of his sessions - very informative and fun too!

Checkout this article on SharePoint Pro - Top 10 SharePoint 2010 Configuration Mistakes -- and How to Fix Them

http://www.sharepointpromag.com/content1/topic/sharepoint-2010-misconfigurations-141636/catpath/sharepoint

SharePoint 2010 Name ActiveX Control

Argg - this stinks, why won't this go away on Windows 7...

It appears that you have to add your SharePoint WFE address into IE as a Local Intranet entry.
DO NOT ADD AS TRUSTED SITE!!
   - found this out the hard way that it will break passthru authentication!

Now I just need to get with our admins to edit our domain GPO to add this to all our domain machines....

Eventually when we have Lync up and running I'll have to figure out how to load this control properly so that presence information will correctly display in SharePoint.  For now that is a future project :-)

SharePoint 2010 Search Setup

Once again SharePoint George has come to my rescue.

I was having problems with search not finding everything - found this posting and I had missed a few steps in allowing the search service account access to the UPA.

http://sharepointgeorge.com/2010/configuring-enterprise-search-sharepoint-2010/