MOSS 2007 and Office 2007 Integration

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Portal Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Content Query WP - MOSS Hi, I have some announcement lists on some subsites. On the start-page I have a Content Query WP showing the newest announcements on subsites. How do I change the CQWP tho show title, description, and if exists, a picture from the announcement? Tag: MOSS 2007 and Office 2007 Integration Tag: 99729
  - 2
    - Web clipping webpart Hi! Is there any web clipping webpart (free one) ? Thanks in advance Tag: MOSS 2007 and Office 2007 Integration Tag: 99728
  - 3
    - Site Usage Report Hi any ideas to generate report on site usage (sites, sub sites, sub sub sites, whole intranet) for a few months instead of 30 days (current feature in SharePoint)? Thanks a lot. -- Hakuna Matata Tag: MOSS 2007 and Office 2007 Integration Tag: 99726
  - 4
    - SharePoint Training All: Aivea, Microsoft Gold Partner and a premier SharePoint Consulting Services provider for Microsoft is conducting an excellent SharePoint 2007 Architecture and Administration class in beautiful Portland, Oregon on 05/19 â?? 05/20, The training fees include Hotel and Meals. If you are interested, please call 1-800-779-7506 or e-mail consulting@aivea.com Please find the course details at http://www.aivea.com/sharepoint/aivea_sharepoint_arch_admin_training.pdf Thanks -Pradeep Tag: MOSS 2007 and Office 2007 Integration Tag: 99724
  - 5
    - MOSS 2007 & Exchange 2007 OWA webpart I tried to setup Exchange 2007 OWA Webpart (Calendar, Inbox) on mySite. Since Exchange 2007 OWA is SSL, I used https://mailserver/owa for the URL. What I got is the form-based login screen. I assume that there's a way to bypass the login part but do not know how. Your help is greatly appreciated. Thanks Tag: MOSS 2007 and Office 2007 Integration Tag: 99722
  - 6
    - MOSS 2007 & Reporting Services I have configured reporting services to run in sharepoint integrated mode. When accessing any valid report through sharepoint the report viewer shows Root element is missing. The reports work outside of sharepoint just not inside it. Any suggestions? Thanks, Keith Tag: MOSS 2007 and Office 2007 Integration Tag: 99716
  - 7
    - Registry key value {SearchThrottled} I'm getting the following error in my SharePoint logs: <?xml version="1.0" encoding="utf-16"?><entries><entry source="ULSLog"><Area>Office Server</Area><Category>Setup and Upgrade</Category><EventID>8u3j</EventID><Level>High</Level><machineName>MOSS</machineName><Process>OWSTIMER.EXE (0x060C)</Process><TID>0x0D2C</TID><Timestamp>05/06/2008 01:09:04.69</Timestamp><Correlation /><Message>Registry key value {SearchThrottled} was not found under registry hive {Software\Microsoft\Office Server\12.0}. Assuming search sku is not throttled.</Message></entry></entries> Is this an issue that needs to be resolved or standard behaviour? Cheers Damon Tag: MOSS 2007 and Office 2007 Integration Tag: 99713
  - 8
    - Sharepoint Search Can anyone tell me in which SQL Server table does MOSS 2007 store the craw rules? Thanks in advance. Tag: MOSS 2007 and Office 2007 Integration Tag: 99711
  - 9
    - Is this even possible Hey All, Looking at doing the following for some client solutions. Basically to limit the data set available to a logged in user we are planning to use a stored procedure grabbing parameters from the user's group memberships or parameters stored in the user's account details Tag: MOSS 2007 and Office 2007 Integration Tag: 99710
  - 10
    - ¹ØÓÚWSS3.0ËÑË÷ADÕÊ»§ ÄãºÃ! ÎÒÏëÎÊÒ»ÏÂ,ÒÔÇ°ÔÚADÖÐ½¨µÄÓÃ»§»ò×é±»É¾µôºó,ÎªÊ²Ã´ÔÚWSS3.0Ìí¼ÓÓÃ»§µÄÊ±ºò»¹ÄÜËÑË÷µ½. Tag: MOSS 2007 and Office 2007 Integration Tag: 99708
  - 11
    - SPS2003 Cross Domain Authentication Hi all, I have a current SPS2003 installation in Domain A. If I introduce a new Domain B with a two way trust between domains can I have users from Domain B access the SharePoint installation/portal on the servers residing in Domain A? Any guidance or advice much appreciated. Thanks in advance, Simon Tag: MOSS 2007 and Office 2007 Integration Tag: 99702
  - 12
    - The machine key problem while using FBA How to modify a sharepoint web application's machine key? While using FBA,I use the SQL membership provider ,and while adding users I need to make suer that the web-application's machine key must be matched to the sharepoint site ,which I want to use FBA in. However ,if another sharepoint web application want to share the user I have added,how to enable the target application's machine key to matched the original application's machinekey? In other words,how to modify a sharepoint web application's machine key? I have try to modify the web.config file ,but it's unuseful. Tag: MOSS 2007 and Office 2007 Integration Tag: 99701
  - 13
    - Incoming E-mail configuration - what permissions are required for Hello all, I have a MOSS 2007 SP1 (x64) server running on Windows 2008 Enterprise (x64). The system is configured using the Microsoft best practices for MOSS, which use the concept of "least privilege," creating several domain accounts that have only standard user rights plus whatever MOSS auto- assigns to them. I have been fighting with the incoming e-mail stuff for a week. I'm aware of the whitepaper from "CombinedKnowledge" - I followed it closely, but continued to have problems. Here's a layout of the environment. SQL 2000 SP4 on a two node Cluster (has to be SQL 2000 due to other app requirements) SHGMOSS1 - single MOSS 2007 Enterprise server, all services are currently running here. Domain is SHG and all accounts listed below are in that domain as normal users. Accounts used for MOSS: svcMOSS - Main farm account, Central Admin app pool and DB access svcMOSS_SSP - Shared Service Provider (SharedServices1) account svcMOSS_Index - DB index / search account svcMOSS_ca - content access account for indexer svcMOSS_ap1 - App Pool 1 account (app pool for SharedServices1) svcMOSS_ap2 - App pool 2 account (app pool for MySites) While trying to mail-enable a collection, I kept getting "Access denied" and "Error in application" type errors when it was trying to create the contact in Active Directory. My DirMan config looks like so: OU=SharePoint,DC=ourcompany,DC=local The OU "SharePoint" exists in the root of the domain, and "ourcompany.local" (obviously changed) is the FQDN for the domain. The documentation is NOT clear on what accounts need access to the OU. The CombinedKnowledge whitepaper implies that only the Central Admin account has to be able to modify the OU but I have eventually found this to be FALSE. Out of frustration, I eventually gave *all* of the accounts listed above Full Access to the OU (and all child objects). I was still getting Access Denied and/or generic Errors. I haven't even bothered to setup the SMTP portion of things because the process is failing before it gets that far - the contact isn't being created in Active Directory. Note that all accounts are in the appropriate WSS_WPG and WSS_Admin_WPG groups on the local machine - I followed the normal setup procedure and allowed the system to do what it wanted when I chose the accounts. What finally "fixed" the problem - I had to make the App Pool account for any App Pool that I want to e-mail enable a LOCAL Administrator on the MOSS server. This makes NO sense to me - why would I need local Admin for a domain operation? Also, I had the exact same problem when using "least privilege" accounts on Windows 2003 R2 SP2, so this is not anything Server 2008 specific. I have been using Process Monitor to figure out what is failing for a normal user account but i'm not getting any access denied or failure messages, so I'm not sure why the App Pool accounts have to be Local Administrators for the contact creation to work. So, I have things "working" but in a sub-optimal way due to the lack of security. Microsoft's documented practices don't work here, and there's no explanation as to why. Event Logs and the MOSS logs haven't helped me yet. Can someone point out what security options I might need to get this to work without Administrator rights? Tag: MOSS 2007 and Office 2007 Integration Tag: 99699
  - 14
    - cyptic email getting sent from Approval Workflow Hey, I am using the Approval workflow on a document library. Each time I start the workflow I get a cryptic email. All emails from the workflow after this one look fine. It's only this one email. Other things, like alerts, work fine. I am using Lotus Notes. The email (I've replaced sensitive text with ********** ): : Content-Transfer-Encoding: 8bit Content-Type: text/html; charset=utf-8 Subject: RSDFlow started on testdoc1. MIME-Version: 1.0 X-Mailer: Windows SharePoint Services (version 3) <style> TABLE.mail { border-style:none; border-collapse:collapse; font:8pt Tahoma; width:100%; }TD.header { background:#F8F8F9; border:1px solid #E8EAEC; padding:12pt 10px 4pt 10px; }TD.body { padding:12pt 10px 24pt 10px; }TD.footer { border-width:1px; border-style:solid none none none; border-color:#9CA3AD; padding:4pt 10px 4pt 10px; }A { text- decoration:none; }DIV.title { font:16pt Verdana; }DIV.headertext { margin:5px 0px 0px 0px; }DIV.error { font-weight:bold; }DIV.comment { color:#9CA3AD; }SPAN.wfname { font:bold italic; } </style><table cellpadding="2" cellspacing="0" class="mail" DIR="none"> <tr class="header"> <td class="header"><div class="title"> <span class='wfname'>RSDFlow</span> has started on <a href='http:// *************/testdoc1.doc'>testdoc1</a>. </div><div class="headertext"> Participants are ************** </div><div class="headertext"> Each person will get 2 days </div></td> </tr><tr class="body"> <td class="body" valign="top"><div> Each person will receive a task to approve <a href='http:// ****************/testdoc1.doc'>testdoc1</a>. The tasks will be assigned one at a time in the order shown above. </div></td> </tr><tr class="footer"> <td class="footer"><div> <a href="http://********************/_layouts/WrkStat.aspx? List={97e94481-4cf8-4d12-998c- b71046b2df54}&WorkflowInstanceID={6c6f8de7-f5c8-421e- a618-594433ee89c4}">View the status of this workflow.</a> </div></td> </tr> </table> Tag: MOSS 2007 and Office 2007 Integration Tag: 99698
  - 15
    - Excel Services refresh failure I have a Excel workbook stored in a MOSS trusted report library using an odc connection from a trusted data connections library that pulls data into a pivot table from an Analysis Services cube. The connection to the cube has to be made through the http olap pump because our internal network is such a patchwork that our users do not authenticate to any microsoft network, much less the one the SSAS server authenticates to. There are also firewalls between some segments of our network and the server that make it even more necessary to use http authentication. The data is not particularly sensitive, so anonymous users just authenticate as IUSER_Servername and that local account has been given the appropriate rights to access the cube. In the web part I need to have a default value sent to the date parameter to get today's data on opening. When the workbook is opened through Excel locally or through the Sharepoint library using the "Edit in Excel" command it works fine. When it is displayed in a Excel Services web part the refresh fails, and when it is accessed using the "View in Web Browser" command the refresh fails. The failure message returns very quickly and says: Data Refresh Failed Unable to retrieve external data for the following connections: MyconnectionFileName The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set. I have a KPI list based on that same connection that works fine, although it takes several seconds to populate the data so I do not believe the problem is related to security, firewalls, or anything else except something unique to Excel Services. I am not a SharePoint Admin- that is outsourced to a contractor so when I want a configuration change I have to submit a request stating exactly the settings I want, then wait for them to make the change- it can easily take a week or more to get the changes made. I believe I am the only one that has started using Excel Services on our SharePoint site as it was not configured until I requested that it be done, and the settings I requested were these: Please insure that the following configuration is set for the trusted file location "my stuff address" 1. Trust Children = yes 2. Under the External Data section set Allow External Data to Trusted data connection libraries only, or Trusted data connection libraries and embedded (embedded is preferred- but would live with tdc library.) 3. Warn on refresh = no 4. User defined functions = yes I have found no similar issues on my searches of the internet, and I am out of ideas. Can you suggest other settings that may need to be made to get the functionality to work as desired? Tag: MOSS 2007 and Office 2007 Integration Tag: 99695
  - 16
    - Content Database Migration Error: Cannot insert NULL into RoleID hi, i'm trying to migrate a wss 2.0 content database to 2007.prescan gave no erros on the db. i run stsadm -o addcontetndb but it tells me that some errors happened and to look into upgrade log. in log file it says [SPManager] [ERROR] [5/2/2008 3:26:48 PM]: Upgrade [SPContentDatabase Name=IstWeb01 Parent=SPDatabaseServiceInstance Name=OfficeServers] failed. [SPManager] [ERROR] [5/2/2008 3:26:48 PM]: Cannot insert the value NULL into column 'RoleId', table 'IstWeb01.dbo.RoleAssignmentT'; column does not allow nulls. INSERT fails. The statement has been terminated. [SPManager] [ERROR] [5/2/2008 3:26:48 PM]: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) does anybody know how to solve this problem? thanks in advance. Tag: MOSS 2007 and Office 2007 Integration Tag: 99694
  - 17
    - SPS Portal restore to new Farm.. Hello - i'm hoping someone can help with this problem. We are replicating our sharepoint infrastructure onto 2 new farms (the company is demergin so we need to create 2 new environments for everything we have!). Currently we have 2 farms that either host sharepoint sites for internal users (e.g. company intranet) or external users (e.g. collaboration sites). The Farms are setup as: 2 x Web Servers (WSS 2.0 & SPS 2003) 1 x Job & Index Server (WSS 2.0 & SPS 2003) 1 x SQL Server (SQL Server 2000). The 2 new companies will have 1 Farm with all the sites consolidated into it. Don't ask why there are 2 farms currently - it was inherited! Anyway, i am using the SPS Backup and Restore Utility to backup portals and restore. Everything works as expected for Portals backed up from the internal farm but not for the external farm. On restoring a portal we receive the following errors: In SPS Backup & Restore Utility following message is displayed, usually about 35% through the restore: "Error: The site database specified is already in use by another component of the farm". The popup box also says to consult the database servers event log. The SQL Server eventlog has the following entry: "Recovery is checkpointing database 'Projects1_SITE'." The SQL Activity logs has an entry that says: "Bypassing recovery for database 'Projects1_SITE' because it is marked IN LOAD." Followed by: "Recovery is checkpointing database 'Projects_SITE' (18)" I have seen posts that say to do the restore with the NORECOVERY switch but i don't see where to specify that using the SPS Backup & Restore Utility. Any advice would be greatly appreciated. Thanks, Oli. Tag: MOSS 2007 and Office 2007 Integration Tag: 99693
  - 18
    - Moss 2007 Active Directory/LDAP with SSL Configuration Issue Hi all, I tried to setup moss 2007 form based authentication against Active Directory with AD/LDAP Membership Provider. However, I tried for the last 5 days to figure out what's wrong with the setup but no luck. Could anyone tell me what could be wrong with the setup? Here is what I did 1. Create web application to host https://extranet.acme.com with "default zone" and use form with either AD/LDAP Membership Provider so external users login with their internal NT Account or Email (BTW I used SSL 128 bit) 2. Extend the above web application to host intranet http://intranet with "Intranet zone" 3. Modify web.config of both Central Administration and extranet 4.Here is partial of web.config file that show connection and membership //AD Membership Provider <connectionStrings> <add name="ADConnection" connectionString="LDAP://server1.acme.com/ CN=Users,DC=acme,DC=com" /> </connectionStrings> <membership defaultProvider="ADProviderService"> <providers> <add name="ADProviderService" type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="ADConnection" connectionUsername="acme\app_account" connectionPassword="abc123"/> </providers> </membership> //LDAP Membership Provider <membership> <providers> <add name="ADProviderService" type="Microsoft.Office.Server.Security.LDAPMembershipProvider, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" server="server1.acme.com" port="389" useSSL="true" userDNAttribute="distinguishedName" userNameAttribute="sAMAccountName" userContainer="OU=Users,OU=Dener,DC=acme,DC=com" userObjectClass="person" userFilter="(|(ObjectCategory=group) (ObjectClass=person))" scope="Subtree" otherRequiredUserAttributes="sn,givenname,cn" /> </providers> </membership> When I try AD Membership Provider and login to the form with either email or nt account, I got the following sign in form error "The server could not sign you in. Make sure your user name and password are correct, and then try again." Then I take a look at the server event viewer, I got the following error Event Type: Information Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1315 Date: 5/1/2008 Time: 12:40:27 AM User: N/A Computer: MYSERVER Description: Event code: 4006 Event message: Membership credential verification failed. Event time: 5/1/2008 12:40:27 AM Event time (UTC): 5/1/2008 7:40:27 AM Event ID: 5ed5b12b0e7c491fb4962f07827ac9f3 Event sequence: 4 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/918023365/ Root-1-128541012094024926 Trust level: WSS_Minimal Application Virtual Path: / Application Path: C:\Inetpub\wwwroot \wss\VirtualDirectories\extranet.acme.com80\ Machine name: MYSERVER Process information: Process ID: 3824 Process name: w3wp.exe Account name: acme\app_account Request information: Request URL: https://extreanet.acme.com:443/_layouts/login.aspx?ReturnUrl=Membership credential verification failed.f_layoutsMembership credential verification failed.fAuthenticate.aspx5/1/2008 12:40:27 AMfSource5/1/2008 12:40:27 AMd%252f&Source=Membership credential verification failed.f Request path: /_layouts/login.aspx User host address: 10.247.229.41 User: Is authenticated: False Authentication Type: Thread account name: MYSERVER \IUSR_FLATFILE Name to authenticate: john.doen@acme.com Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. After the above AD membership provider failed, I then try to use LDAP Membership Provider and I still get the same sign in form error above. There was no server error in the event viewer. For both provider, I try to look up user in people picker Ex: ADProviderService:jonh.doe@acme.com, but I could not find any of them I checked membership/connection string syntax many times and could not find anything wrong. I search on the internet and found several threads about above issues and followed those instructions, but no luck. Here is some of the threads that I found http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2337663&SiteID=1 http://www.setfocus.com/technicalarticles/nickkellett/MOSS2007-and-Novell-LDAP-Authentication_pg1.aspx http://blogs.msdn.com/harsh/archive/2007/01/10/forms-based-authentication-in-moss.aspx http://blogs.infosupport.com/porint/archive/2007/05/07/Step_2D00_by_2D00_Step-guide_2C00_-installing-AD-Provider-on-WSS-v3.aspx http://jasonflowers2k.spaces.live.com/blog/cns!1889117EF017B979!118.entry Thanks all Tag: MOSS 2007 and Office 2007 Integration Tag: 99690
  - 19
    - Creating users I would like to create some new SharePoint users. My sys admin told me that he cannot create them in the AD. The goal is to test the audience with some fake users and to give a demo to someone logging in from a VPN. Optimally, our client will will log in as himself (SP Site Collection admin) through a VPN and connect to SharePoin to see some functionality (always as himself), and then log in as different users (IndiaUser, MexicoUser) throught the menu option "Sign me in as a differnt user" to view the audience functionality. How can I arrange this from SharePoint? It seems it will only accept domain users. I'm relatively new to SharePoint and cannot find info on this topic anywhere. Tag: MOSS 2007 and Office 2007 Integration Tag: 99686
  - 20
    - Problem with sharepoint intermittently not saving changes. We are experiencing a problem with Sharepoint intermittently not saving changes made to word documents & excel spreadsheets in document libraries and also when opening a document or spreadsheet it will intermittently open read-only (The file is always opened for editing in the native application.) Sharepoint allows you to edit a file, make changes and then save, but when it is reopened the changes have disappeared. This happens from multiple workstations running XP (SP2) & Office 2003 (SP2 & SP3) and on multiple documents and spreadsheets and is occuring on the Portal and within WSS. We have 2 sharepoint servers one Live and one Development and we are experiencing the same problem on both server, here are the configuration details: Devsharepoint01 - Development server Windows server 2003 Std + SP2 Sharepoint 2003 + SP3 Using local MSDE ( 8.00.2039 ) Sharepoint01 - Live server Windows server 2003 Std + SP1 Sharepoint 2003 + SP2 Using SQL Server 2005 x64 SP2 on a separate server ( Windows 2003 Std x64 Edition + SP1) Tag: MOSS 2007 and Office 2007 Integration Tag: 99684
  - 21
    - Boxed View Style Hi When I create a new view on the contacts list using the Boxed Style, SharePoint 2007 includes the column headings horizontally at the top of the view. This doesn't make sense as the Boxed View pivots the data row to display it vertically and column headings can be included as labels. I've checked the behaviour on SP 2003 and it does not include the column heading, in other words this works as you would expect it to in 2003 but not in 2007. Any ideas? Is there a way to suppress the display of column headings when displaying lists via a web part? Cheers Doug Tag: MOSS 2007 and Office 2007 Integration Tag: 99682
  - 22
    - MOSS 2007-Search Crawl Errrors: Error in Site Data Web Service. (Invalide High Surrogate Character...) I have a MOSS 2007 Sharepoint site setup with several document libraries with several thousand documents. Running Windows Server 2003, WSS3 SP1, and OfficeServers SP1. One of my document libraires, and several folders in another document library thrown errors in the crawler like the following: (and subsequently none of the files in the library, or the folders beneath are returned in search results): --Error Text--------------------------------------------------- http://internalsite/library..ms/simpleview.aspx Error in the Site Data Web Service. (Invalid high surrogate character (0xDE94). A high surrogate character must have a value from range (0xD800 - 0xDBFF).) ---------------------------------------------------------------- The Hex code in the error seems to vary - also get: 0xDD00 0xDED0 0XDE50 on and on The ASPX page of the view in question shows up in search results, but none of the documents inside the library or folder show up in search results. Any advice is appreciated. Tag: MOSS 2007 and Office 2007 Integration Tag: 99677
  - 23
    - how to get top 10 search results! Hi, Im working with MOSS 2007. Im finding some problem with search feature. Actually I need to get the top 10 searched documents from the portal I am working for. Can u suggestion me any solution and send me the dot net code it will require. And also information like how to implement the scope feature into it. Tag: MOSS 2007 and Office 2007 Integration Tag: 99671
  - 24
    - List Search Result Incorrect Hi Folks, In regards to MOSS search: For some reason when I search for a list item, the returned URL is incorrect. Instead of returning a url with the appropriate http://site.com/Lists/ListName/DispForm.aspx?ID=2, I get the following type of URL: http://site.com/Lists/ListName/3_.000 I have checked the crawl account and recreated the search indexes. I have also setup the query and indexes on the same server and rather than on two different servers. It just seems to be the lists, all other types are searched correctly. Am I missing a setting somewhere? Thanks, -Alan L Tag: MOSS 2007 and Office 2007 Integration Tag: 99665
  - 25
    - SharePoint Upgrade Help Needed Hi all, I amhaving a single server implementation of SPS 2003 SP3, Sql 2000....everything in one box. I am moving to new hardware, which will be a full fledge server farm with web servers, application servers and sql servers all separated. I do not want to use database migration technique, since ultimately it would be an in place upgrade, and if some sites are not properly upgraded, there is no going back...yea I understand that I will have the original environment intact as a back up....but how would I deal with a site which is not properly upgraded in the new environment, given there is no going back option. (Am I right, wrong, there is a work around, anything). So, currently, I plan to run the gradual upgrade on my current single server implementation. Once upgraded, I intend to move everything from it to the new full fledge farm implementation. (Later, we will retire this server). (Is this approach correct, incorrect, your suggestions) Now can I do anything of the following and which is correct, best, or anything that you suggest: Backup the whole portal (on my single server implementation) and restore it to the new farm. And Im done. New farm will have two web servers, two app servers and sql cluster. The new farm is configured independently of the old single server implementation. (I wonder if this is even possible?) OR, I should use attach/detach to move the sql server components to new Sql cluster. And then move the web server components to new web servers. And then configure the app servers. And all that is done manually. (Am I actually talking about database migration technique but doing it after the upgrade?) Portal currently in use is not highly customized, may be a few frontpage customizations. 500 to 800 users. No custom webparts. One main level portal. 150 to 200 sites. 50+- subsites. Please note that doing the gradual upgrade on the current server is what I HAVE to do, officially. Anything totally different that you wanna suggest is most welcome. Best regards, Rehman Tag: MOSS 2007 and Office 2007 Integration Tag: 99655
- Next
  - 1
    - (MOSS 2007/WSS3) Question about AUTHOR Property: Why can't I edit it? Ok here's a strange one. I've got a vanilla Document library in a MOSS 2007 site. I add the AUTHOR site column to it and upload several WORD documents (both 2003 adn 2007). The Author comes into the field as expected; however I cannot EDIT it using the Edit Properties option int he doc library. In Word 2007 I can go into the (Office Icon)-->Preapre-->Properties window and I see 3 optoins: -Document Properites -Document Properites - Server -Advanced Properties If I EDIT the "_Author" property under Advanced Properties, I can change the Author that shows up in sharepoint. Editing either of the other 2 doesn't change it. And I just noticed that editing the Author on the site in Edit-Properties actually edits the Documents properties, but the site still only shows the _Author property. Driving me nuts...any advice is greatly appreciated. regards, -h.liles Tag: MOSS 2007 and Office 2007 Integration Tag: 99654
  - 2
    - Organization Hierarchy in my site dose not update hi... i have a problem when i change user properties in Active Ditectory for example in organization tab ( tile, manager and ...) , in my site at sharepoint portal dose not update . wha is solution? or how can i synchronize my site with AD? please help me? Tag: MOSS 2007 and Office 2007 Integration Tag: 99651
  - 3
    - Alerts and timezone When alerts are created, is the timezone included in the definition? Is it possible to exclude this? Users who created an alert during the winterperiod (CET), is now getting the alert an hour too late.. (CEST).. If possible, then how? Thanks, SL. Tag: MOSS 2007 and Office 2007 Integration Tag: 99650
  - 4
    - Sharepoint search issue after SP1 We have 2 WFE (with WNLB) and 1 indexquery server Once we upgraded to SP1 the Office SharePoint Server Search cannot be started from the index server anymore, it gives the error message "An unhandled exception occurred in the user interface.Exception Information: Unable to connect to the remote server ". Try to do enumservices on the server nad it gives the following: <Services> <Service> <Type>Microsoft.SharePoint.Administration.SPWebService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Windows SharePoint Services Web Application</ DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPWebService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>WSS_Administration</Name> <DisplayName>Central Administration</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.OfficeServerService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>SSP Job Control Service</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPAdministrationService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPAdmin</Name> <DisplayName>Windows SharePoint Services Administration</ DisplayName> <Status /> </Service> <Service> <Type>Microsoft.Office.Server.Administration.AnalyticsService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Office SharePoint Usage Analytics Service</ DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.SharePoint.Portal.Administration.PortalService, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Portal Service</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.ApplicationRegistryService, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>ApplicationRegistryService</Name> <DisplayName>Business Data Catalog</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.JobSchedulerService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Shared Services Timer</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Search.Administration.SearchService, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>OSearch</Name> <DisplayName>Office SharePoint Server Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Search.Administration.SearchService, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>OSearch</Name> <DisplayName>Office SharePoint Server Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPTimerService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPTimerV3</Name> <DisplayName>Windows SharePoint Services Timer</DisplayName> <Status /> </Service> <Service> <Type>Microsoft.Office.Excel.Server.ExcelServerSharedWebService, Microsoft.Office.Excel.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Excel Calculation Services</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.SharePoint.Portal.Administration.SsoService, Microsoft.SharePoint.Portal.SingleSignon, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SSOSRV</Name> <DisplayName>Single Sign-on Service</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Search.Administration.SearchAdminSharedWebService, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SearchAdminSharedWebService</Name> <DisplayName>Office SharePoint Server Search Admin Web Service</ DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Search.Administration.SPSearchService, Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPSearch</Name> <DisplayName>Windows SharePoint Services Help Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Search.Administration.SPSearchService, Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPSearch</Name> <DisplayName>Windows SharePoint Services Help Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Conversions.LauncherService, Microsoft.Office.Server.Conversions, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>DCLauncher</Name> <DisplayName>Document Conversions Launcher Service</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.Office.Server.Conversions.LoadBalancerService, Microsoft.Office.Server.Conversions, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>DCLoadBalancer</Name> <DisplayName>Document Conversions Load Balancer Service</ DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.Office.RecordsManagement.Internal.PolicyConfigService, Microsoft.Office.Policy, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>PolicyConfigService</Name> <DisplayName>Microsoft.Office.RecordsManagement.Internal.PolicyConfigService</ DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.SessionStateService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Session State Service</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPIncomingEmailService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Windows SharePoint Services Incoming E-Mail</ DisplayName> <Status>Online</Status> </Service> </Services> Not sure why there is teo osearch there. Does anyone have any idea to resolve this search problem? Tag: MOSS 2007 and Office 2007 Integration Tag: 99649
  - 5
    - Is there a way let anonymous users add attachemnts Hi guys, Is there a way let anonymous users add attachemnts while they adding items into a list? Br, Alan Tag: MOSS 2007 and Office 2007 Integration Tag: 99648
  - 6
    - How to accomplish this goal? Hi guys, We would like to add a custom list in Sharepoint site. And only let a specific group users add item, but can not view those items. I've tried the approach below. Create 2 lists(list a and list b) with same columns. give the specific group users contribute permission on list a, but no access on list b. And develop an event handler on list a's itemadded event. When one item was added in list a, copy it to list b then delete it from list a. Unfortunately, I found the event handler did NOT work for the specific group users. Only work for the group users who have access on list b. Do you have any good ideas? Br, Alan Tag: MOSS 2007 and Office 2007 Integration Tag: 99645
  - 7
    - How to create new WSS sites in newly upgraded MOSS 2007 installati I recently upgraded my SPS 2003 to MOSS 2007 and all is running well. Back in the SPS 2003 world, I had some WSS sites that I had created under a special, separate url, http://wss/sites This helped me stay organized. After the upgrade, there's an app called WSS and it's for the http://wss. I can't figure out how to create new WSS sites user the http://wss/sites path. Does anyone have any idea? -- Sandy Wood Orange County District Attorney Tag: MOSS 2007 and Office 2007 Integration Tag: 99640
  - 8
    - Configure top nav to display sub folders in drop down? Hi, I'd like to configure my top nav bar to show drop downs for each sub folder created in the document libraries linked to the tabs. I know we can configure the drop downs to display sub sites and pages, but can they be configured to dynamically show sub folders under document libraries? Thank You Tag: MOSS 2007 and Office 2007 Integration Tag: 99639
  - 9
    - Sharepoint not a valid user error hello, I have the following problem with MOSS Enterprise, this problem ocurrs every minute and I don't know how I can resolve it, please help me. Event Type: Error Event Source: Office SharePoint Server Event Category: General de Office Server Event ID: 7888 Date: 4/24/2008 Time: 12:59:51 PM User: N/A Computer: SHRPOINTSRV Description: Se ha detectado una excepciÃ³n en tiempo de ejecuciÃ³n. Detalles. Mensaje: 'sharepointuser' is not a valid Windows NT name. Give the complete name: <domain\username>. Detalles tÃ©cnicos: System.Data.SqlClient.SqlException: 'sharepointuser' is not a valid Windows NT name. Give the complete name: <domain\username>. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.Data.SqlServerManager.GrantLogin(String user) at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeConfigurationDatabaseAccess(SharedComponentSecurity security) at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeAccessControl(SharedComponentSecurity sharedApplicationSecurity) at Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedComponent.Synchronize() Tag: MOSS 2007 and Office 2007 Integration Tag: 99635
  - 10
    - Forefront Databases on Server with MOSS 2007 I am trying to setup my forefront databases with the reporting on the same SQL server that our MOSS installation is on. I keep running into problems with the reporting website on my Forefront installation. Are there special conciderations I need to take when installing Forefront Client Security on the same server with MOSS or is it even supported? Tag: MOSS 2007 and Office 2007 Integration Tag: 99634
  - 11
    - SharePoint Connectors (Protocol Handlers) I'm giving away my SharePoint connector framework (Protocol Handler.NET) for free. You can develop protocol handlers and ifilters with .NET to connect to any system to index data and documents and make available through search. Sample code and documentation included. Just go to http://www.fastsharepoint.com/products.aspx to download. Chris www.fastsharepoint.com Tag: MOSS 2007 and Office 2007 Integration Tag: 99633
  - 12
    - MOSS 2007 Excel Web Access Web Part Hello, Can you anyone advise if the MOSS 2007 Excel Web Access Web Part is compatible with MS Office Excel 2003. When we add the Excel Webpart and attempt to display a workbook we are presented with the following error message. "An error has occurred, Please contact your system administrator if this problem persists" Can anyone suggest where we should look to troubleshoot the problem. Thank you. Samir Tag: MOSS 2007 and Office 2007 Integration Tag: 99632
  - 13
    - companyweb intranet site savings doc isssue Windows 2003 SBS have a companyweb intranet site users set up word documents... other users edit the documents using word XP. Changes are often not saves unless the user chooses save as and even then they sometimes have to save the document twice to get the changes to appear... anyone have any ideas... the save fucntionality works perfectly fine with Excel XP. Tag: MOSS 2007 and Office 2007 Integration Tag: 99631
  - 14
    - Get SharePoint Email Enabled Doc Library to Store Messages as MSG We have a large (20 GB +) set of Public Folders on Exchange 2000. We migrate all the closed PF to MOSS 2K7 using Quest's Public Folder Migrator. We were all ready to go live and move production data, when we saw the behavior of new email messages sent to them. Has anyone else seen this problem and found a solution? I'd be willing to look at another 3rd Party tool of it could get us over this hump quickly. It really seems like it should be a no-brainer given that the tool is meant to integrate with Exchange and Outlook. Sincerely, Bill Teeple System Administrator Minnetronix Tag: MOSS 2007 and Office 2007 Integration Tag: 99630
  - 15
    - Is it possible Single Sign-on between two sharepoint sites I have 2 sharepoint applications in my web server ( First application is called A and the second application is called B). Both applications (A+B) are working absolutely fine without any issues. When we browse the web site A it asks for authentication and once the credentials are provided, I get access to the web site. This is the same case with Application B. There is a link in sharepoint application A to sharepoint application B. When we follow the link, the authentication popup appears again=85.Is there any way with which we can avoid the second authentication popup. Any possible help/links in this will be greatly appreciated. Thanks and Regards Sreejesh Tag: MOSS 2007 and Office 2007 Integration Tag: 99624
  - 16
    - Exam Module in SharePoint?? Hi All, I need to display a page which shows questions and answers(radio button/dropdown). When the user clicks done, I want the score to be calculated based on a predefined weightages for each answer. How can this be done without coding? I can utmost use SharePoint Designer. Please provide your inputs... Thanks and Regards, Mahesh. Tag: MOSS 2007 and Office 2007 Integration Tag: 99621
  - 17
    - MOSS 2007 Site Content not appearing After adding a SP Portal 2003 db to a MOSS 2007 application via sts (see below) I am unable to see any content from the db. The problem is when I am looking at the db I see in dbo.alldocs there are some 27000 items both the site version (12.0.0.6219) and BitFlags (262144) are correct but no data. STSADM Command: stsadm -o addcontentdb -url http://blah-web:24146 -databasename dbblahSITE -datbaseserver There was no customization in the templates, no web parts... this was just a straight forward SPS 2003 site that was pre=scan based on the version number. I'm at a loss and spent some time on the phone with Microsoft... One tech asked me what WSS stood for, not feeling too confident in them.... Any ideas would be appreciated Just to summarize... I connected a prescanned SPS2003 to a MOSS 2007 site / web application not being used by anything else. I am unable to see any of the content that should be there with the exception of the site structure, links, sub sites. This was out of the box with no parts or customization. I can see the content in the db... How do I now get his content viewable in the site again. Bad part... There are no backups before the site was upgraded to the MOSS / WSS 30 schema. Tag: MOSS 2007 and Office 2007 Integration Tag: 99619
  - 18
    - Re: lock file error I'm having the same issue, and I'm running Office 2007/Vista. I tried disabling IPv6 as well and that seemed to help a little, but I'm still getting the same "unable to lock file" error. Tag: MOSS 2007 and Office 2007 Integration Tag: 99618
  - 19
    - Login Issue We just deployed MOSS 2007, and we have the following issue: Sally logs in to her computer at startup as Sally. Sally enters her SharePoint portal home URL and is automatically logged in as Administrator (Sally has access to both accounts as she is also the SP Admin.) Sally clicks on "Sign in as Different User" and signs in as Sally. Sally clicks on "My Site" and is taken to the Administrator's My Site instead of Sally's My Site. How can we make it so that Sally logs in automatically as Sally, not the administrator? Any help would be greatly appreciated. Tag: MOSS 2007 and Office 2007 Integration Tag: 99615
  - 20
    - Is this even possible Hi All, Got a question i am planning to create a AD SharePoint install to our production domain my main issue is that i will be using stored procedures based on AD information. I am wondering if it's possible to use data view webparts with a stored procedure passing the Office and say the department fields to the stored procedure??? Tag: MOSS 2007 and Office 2007 Integration Tag: 99608
  - 21
    - Great Indian Developer Awards 2008 Vote for your favorite trailblazing individuals & products in the IT Developer ecosystem and win exciting prizes! Prizes include: Apple Mac Air Book, 26" PLASMA TV, NOKIA95 8 GB, APPLE iPOD 80Gb, ZEST HOLIDAYS, GIDS GOODIES. The Great Indian Developer Awards is a first-of-its-kind initiative that honors individual & organisational excellence in the IT Developer ecosystem. Just click and cast your vote. With over 15 categories & a distinguished independent jury, who knows... it could be your colleague, company or product that will emerge triumphant. And you get to go home with cool goodies as well! Hurry! Click here to vote for the Great Indian Developer Awards: http://www.developersummit.com/awards.html#vote Tag: MOSS 2007 and Office 2007 Integration Tag: 99606
  - 22
    - Corrupted PDF files when dragging and dropping to a mapped drive I have a user who maps drives to his document libraries. Occasionally after dragging and dropping a PDF file into a doc library mapped drive, the file will become corrupted. When users download the file Adobe fails to open the file and says the file is corrupted. However, when the user uploads the same problem files via the SharePoint site upload feature, the file goes up there clean. Mapped drive funcionality is a must for this user as he enjoys the convenience of working from his file explorer and not have to browse through the SharePoint site interface. Does anyone have any idea why dragging and dropping in this manner causes certain PDF files to corrupt? He is currently trying to pinpoint a common factor between the problem PDF's. I will post again if he comes up with anything. Thanks, Alex Tag: MOSS 2007 and Office 2007 Integration Tag: 99599
  - 23
    - list item access Hi. I have a Document Library with list item access (permissions set to each item on the DL). If a user sees a Document Library View or a Web Part not filtered by anything (with all items), then that user only sees the documents that he has permission to read =96 this a correct behavior, as I think. If the view has any kind of filter, like items added today, for example, the user sees a list with all documents added today even if he does not have access to read them (if he clicks on a document a message saying that he has no permission shows up). If the user sets an =93alert=94 on that list, he will be informed on any change in any document, even if he doesn=92t access to it (again, if he clicks on the document link, inside the email, a message saying that he doesn=92t have access to the document shows up). Is this the default behavior? Is there anything I can do to change these 2 behaviors? i.e. users only sees in any situation, and is only alerted on documents he has access? Thanks. Tag: MOSS 2007 and Office 2007 Integration Tag: 99598
  - 24
    - How to combine tasks lists into a single tasks list? I have a list of projects and for each of them an attached workspace. In these workspaces, tasks lists. How can I have a single tasks list showing all current tasks from all these workspaces? Thanks. Tag: MOSS 2007 and Office 2007 Integration Tag: 99587
  - 25
    - "Error Access denied" to site We have the weirdest thing just happen with our install of MOSS and it has stumped us all. Under our Ops department site, we have 3 sub sites for Admin, Frontline and 3rd Line. Admin and 3rd Line are fine, but no-one other than the 2 SharePoint admin accounts can access Frontline. The error is the standard "Access Denied" message that you would get if you didn't have permissions to the site, but the site is using inherited permissions, so exactly the same as the parent Ops site and the 2 sibling sites, but nothing. We have done everything that we can think of bar recreating the site, so hoping that someone might be able to save us before we have to resort to this ... Tag: MOSS 2007 and Office 2007 Integration Tag: 99581

I am looking for detailed documentation outlining the capabilities and
procedures for integrating MOSS 2007 and Office 2007. We are using
content types, check in/out, versioning and would appreciate any
assistance in this request.

Top