Posts

Showing posts from 2013

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

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',