Posts

Setting up Linked Servers between SQL Servers

http://www.databasejournal.com/features/mssql/article.php/3691721/Setting-up-a-Linked-Server-for-a-Remote-SQL-Server-Instance.htm

To create a SiteCollection with a host header irrespective of the WebApplication host header

To create a SiteCollection with a host header irrespective of the WebApplication host header (even if the WebApplication did not have a host header) Solution: In PowerShell: New-SPSite http://host.header.site.url -OwnerAlias DOMAIN\username -HostHeaderWebApplication http://servername Need to add a A record in the DNS. **If you want to make this work in your dev machine then add a entry in the Hosts file of your SharePoint server. C:\Windows\System32\drivers\etc\hosts.txt for example: 127.0.0.1          intranet.triadinfotech.com Hope this will be helpful in your current and future SharePoint Implementations.

Creating a Web Application with Host Header; Cannot open the SharePoint site on server, but works on clients

I had to Create a SiteCollection with a host header irrespective of the WebApplication host header (even if the WebApplication did not have a host header) Solution: In PowerShell: New-SPSite http://host.header.site.url -OwnerAlias DOMAIN\username -HostHeaderWebApplication http://servername But this gave birth to a new issue: Cannot open the SharePoint site on server, but works on clients Solution: Suppose you run into problems with your machine that you can never open the SharePoint site on your server There might be several reasons why you may run into this First question : do you have a Host header on the site? Second: did you configure the site in a Host header mode? Third : Is the site browse able on the server with servername ? If you answer yes to all three I guess I know what to do, also even if you answer no to the third one we are still good…. Followed the KB http://support.microsoft.com/kb/896861 and disabled loopback check Steps to do th...

SharePoint 2013 Branding - Get Started!

http://blog.blksthl.com/2013/02/26/a-guide-to-quick-sharepoint-2013-branding http://blog.drisgill.com/ http://www.sharepoint2013.me/Blog/Post/129/Master-Page-and-Layout-page-styles-in-SharePoint-2013 http://sharepoint2013center.blogspot.in/p/adding-style-sheets-css-in-layout.html (Where to put CSS in Master Page and Layout / Application Pages) http://www.idubbs.com/blog/2012/sharepoint-2013-enabling-design-manager/ http://manjunath-sharepoint.blogspot.in/2013/04/branding-sharepoint-2013-creating.html http://www.slideshare.net/pixelmill/sharepoint-2013-design-manager-from-html-to-sharepoint Common Branding Tasks: ·          Hiding Site Actions for Non Administrators ·          Hiding Ribbon ·          Hiding My Site, My Profile under the User Name menu ·          Hiding Quick Launch Bar ·   ...

Adding Oracle Linked Server in SQL Server (11G and SQL Server 2008 R2)

Do ensure you install the client components in your machine (from where you would like to connect to Oracle). Choose Custom Installation of the Oracle Client and pick the following: SQL Plus Oracle Call Interface Oracle Net Oracle Connection Manager Oracle Services For Microsoft Transaction Server Oracle Administration Assistant For Windows Oracle Provider for OLE DB Oracle Data Provider for .Net Oracle Providers for ASP.Net After this you will the Oledbprovider.Oracle under the Linked Server Options in SQL Management Studio. After this,  run the below: (@Server is any name that you provide, @srvproduct has to be Oracle, @provider is the Provider name and @datasrc - is machine name/service name) exec sp_addlinkedserver @server='OrclGridDB',@srvproduct='Oracle',@provider='OraOLEDB.Oracle', @datasrc='igrid101/orcl' After this, map your SQL login to Oracle Login sp_addlinkedsrvlogin @rmtsrvname='OrclGridDB', ...

About InfoPath in SharePoint 2010

InfoPath 2010 ·          Part of Office Professional Plus 2010 ·          Tool to design electronic forms ·          These eForms can be published to SP Server ·          Two tools o    InfoPath Designer 2010 o    InfoPath Filler 2010 (Only when used outside SharePoint) ·          In SharePoint o    InfoPath Forms Services part of Enterprise Edition ·          Usage of InfoPath in SharePoint o    InfoPath Customization for a Custom List o    InfoPath Form Libraries o    DIP – Document Information Panel ·          Two Development Approaches o    InfoPath forms without code o    InfoPath...

HTTPS Site InfoPath Issue : You do not have permissions to access a web service that provides data required for this form to function correctly

Image
Also, if you look at the Event Viewer, you might find the below issue: An operation failed because the following certificate has validation errors..... It could look something like this: The solution to fix this issue is to add the root certificates of the SSL certificate to the SharePoint 2010: Open the SharePoint 2010 Central Administration Open the ‘Manage Trust’ section under the ‘Security’ Tab Add the SSL Certificate and all the Root Certificates of the certificate chain. The best way to import the certificates is to store them in base-64 files with the file extension *.cer Now check if the SharePoint 2010 Portal is working via the Https url