Search This Blog

Loading...

Friday, July 26, 2013

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 that are as follows:

Disable the loopback check

Follow these steps:
1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor, and then restart your computer.

Now it is okay if you do not restart the machine, sometimes it just takes it and the site should be then browseable on the server

Hope this will be helpful in your current and future SharePoint Implementations.

Saturday, July 20, 2013

SharePoint 2013 Branding - Get Started!

http://sharepoint2013center.blogspot.in/p/adding-style-sheets-css-in-layout.html (Where to put CSS in Master Page and Layout / Application Pages)

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
·         Approaches:
o   Overriding CSS and Master Page – Simple Approach
o   Importing HTML Proto into SP using Design Manager
o   Adding Composed Looks
o   Custom Themes

o   Packaging as WSP and Deploying  

Monday, May 27, 2013

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',
@useself='false',@locallogin='sa',@rmtuser='grid',@rmtpassword='grid'

Now you can access the table's data as below:
  Select * FROM [OrclGridDB]..[GRID].[PO_LINE_CLEARANCE_HEAD_TAB]
Here grid being the schema name.

Monday, November 19, 2012

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 forms with code (Written using C# or VB.Net – this is called as VSTA – Visual Studio Tools for Applications)

·         InfoPath Form Templates

o   XSN : XML Schema Notation

Friday, October 19, 2012

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

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:
  1. Open the SharePoint 2010 Central Administration
  2. Open the ‘Manage Trust’ section under the ‘Security’ Tab
    SharePoint 2010 - Manage Trusts
  3. 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
  4. Now check if the SharePoint 2010 Portal is working via the Https url