by Gustaf Westerlund | Apr 17, 2007
SQL Reporting services is great, but it is actually quite common to mess up the installation due to the steps taken in installation. Always make sure you do not install either sharepoint or CRM on the same website as CRM. (It is possible to get it to work but not recommended).
What can happen is the following:
1. Installing SQL 2005, in the process installing SQL RS on port 80 = http://localhost/reports and http://localhost/reportmanager.
2. Installing either CRM or a SharePoint site on port 80 of the same computer.
= SQL Reporting Services doesn’t work anymore…
So, what to do.
First, if you want your CRM or SharePoint site to be located on port 80, don’t install SQL RS on port 80. Create some other webapplication using host headers or TCP-ports and install SQL RS to that website instead. Then install CRM or SharePoint to port 80. No conflict = no problems.
If you happen to mess it up anyway, or is asked to fix a messed up installation, you can do magic with the tool RSConfigTool which resides in the SQL Binn-directory (usually: C:Program FilesMicrosoft SQL Server90ToolsBinn). Start it, and reconfigure it properly.
Have fun reporting!
Gustaf Westerlund
CRM and SharePoint Consultant
Humandata AB
www.humandata.se
by Gustaf Westerlund | Apr 16, 2007
Alternate Access mapping is a new technique used in SharePoint 3 for handling url:s when you access sharepoint from different environments, for instance, maybe you both want to be able to access your sharepoint internaly using http://sharepoint and externally using https://sharepoint.humandata.se, well, by using a good firewall the redirection is possible but the problem arises when you want searching and other url:s to work properly.
To be able to handle this properly, a function called Alternate Access Mapping is used. The SharePoint Technology Team blog discusses it further and describes how to set it up.
http://blogs.msdn.com/sharepoint/archive/2007/03/06/what-every-sharepoint-administrator-needs-to-know-about-alternate-access-mappings-part-1.aspx
http://blogs.msdn.com/sharepoint/archive/2007/03/19/what-every-sharepoint-administrator-needs-to-know-about-alternate-access-mappings-part-2-of-3.aspx
Since this is quite a normal setup, and there are certain aspects of this that are a bit complicated, like only having to log on once, we at Humandata are working on a best-practice for how to set this up properly that is based on the Microsoft best-practice. When we’re done, I’ll let you know.
Gustaf Westerlund
CRM and SharePoint Consultant
Humandata AB
www.humandata.se
by Gustaf Westerlund | Mar 30, 2007
The new CRM SDK has been released, if you havn’t already heard. There are some smaller updates and some fixes. It can be downloaded here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9C178B68-3A06-4898-BC83-BD14B74308C5&displaylang=en
Talked to my collegue Michael Jansson today and he told me he met some guys down in Malmö who said they followed my blog. Thanks guys, to know that there are some really sharp CRM and SharePoint consultants that find this blog valuable is a great compliment. If there is anything concerning CRM and SharePoint you would like me to blog about, please send me a mess and I will see what I can do. Nothing is to basic, there will always be people who are new to CRM and SharePoint, and if you’re not careful, they might be way ahead of you in no time at all.
I have also seen the first screenshots from Titan (code name for the next version of CRM) and it looks really good and there seems to be some really inovative features that will boost this already great program! So, be there or be square (swe: “Var där, eller var rektangulär 😉
Gustaf Westerlund
CRM and SharePoint Consultant
Humandata AB
www.humandata.se
by Gustaf Westerlund | Mar 19, 2007
If you live close to Sweden or close to Europe for that matter, make sure not to miss SharePoint and Exchange Forum 2007 in Sweden, the 14:th and 15:th of May. It is THE place to be for all SharePoint (and Exchange) professionals, decision makers, developers, administrators and powerusers. I will be the presentor for one of the tracks and I will also be holding a seminar on SharePoint and Microsoft CRM integration.
There will be a host of very prominent speakers, some of these will be:
Patrick Tissegheim, SharePoint MVP & author, Belgium
Michael Noel, SharePoint MVP and expert on MS ISA, author, USA
Nick Swan, SharePoint MVP, USA
Göran Husman, SharePoint MVP & Author
Eric Legault, Outlook MVP and author, USA
Scott Schnoll, Exchange expert, Microsoft, USA
Micke Nyström, Windows Server MVP
Lasse Pettersson, Exchange MVP
Peter Andersson, Microsoft Sweden
Kalle Becker, Microsoft Sweden
Pontus Haglund, Microsoft Sweden
Magnus Danielsson, Microsoft Sweden
Christer Olsson, Exchange expert, Microsoft Sweden
Michael Jansson, SharePointexpert and trainer, Humandata
So invest in your social network and knowledge from the worlds most competent SharePoint and Exchange Experts! Not to be there is not an option…
There are a limited amount of seats so make sure you get one! Go to www.seforum.se for more information!
Gustaf Westerlund
CRM and SharePoint Consultant
Humandata AB
www.humandata.se
by Gustaf Westerlund | Mar 15, 2007
I was recently working with a customer and we were defining some new content types. As you probably know, you always have to inherit a content type from an existing one. This is fine, but sometime you don’t want the first column to be called Title. Well, we changed it, and guess what… all new lists created bellow this site, all had Title exchanged for our new name, in this case, “Customer Name”, not very nice, for instance in a normal Task list.
Well, not a big problem, we thought, we’ll just change it back. Well… we couldn’t… so we were stuck with a “non-Title-name”. Bad, really bad. The only way I found of resetting this, was to delete the entire sitecollection (I had changed the site column at the top site) and the creating a new one. Not a very nice workaround…
So, be ware, don’t change the “Title” site column located in the group “_hidden”.
Gustaf Westerlund
CRM and SharePoint Consultant
Humandata AB
www.humandata.se
Recent Comments