SQL Server 2000 Upgrade Query

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Windows Services
- 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
    - The user does not exist or is not unique. Howdy, Here's my scenario: A admin user (not me I swear) deleted about 20 users from our WSS3 ADAC site. In adding the users back in they all have a number affixed to their user names. I'm guessing Sharepoint is doing that due to unique SIDs and whatever. Anyway, we don't want the numbered names so i created the new user directly in the SharePoint OU of AD and then used the stsad migrateuser command to migrate the user from the numberd account to the normal account. This new account without the number can login successfully! However, when they go to change their password, they get the following error: The user does not exist or is not unique. I'm guessing this is due to the fact that SharePoint now has two user names cached or stored wherever it stores it but each of the same names have different SIDs. Again, this is a huge guess. So, anyone know how I can get around this? Is there a SQL table I can just modify the numbered user account manually? I know that's a no-no but I need this to work. Thanks, -- David Lozzi Product Development Manager Delphi Technology Solutions www.delphi-ts.com - www.lozzi.net Tag: SQL Server 2000 Upgrade Query Tag: 64988
  - 2
    - Getting List Information for People and Groups Hello, i am trying to get information for People and Groups like a List URL and View Guid, becuase what i want to do is get the Account Field from People and Groups, i would like to do this using the Lists Webservice, i have the base set up i just need to know if this permissions list has a ViewGUID and ListName/URL like other Lists Please could someone help me with this? Regards Ben Tag: SQL Server 2000 Upgrade Query Tag: 64985
  - 3
    - Hiding columns from a user group.. Good day, Within my WSS v3 Intranet site I have created a Staff Listing for such information as full name, address (we have 14 offices), phone number, etc. I have also created a couple of columns within the list that I'd like to hide or filter out somehow from non-administrative accounts. Basically the Views are set up so that there is a listing of the user, phone, fax, and office location. This keeps the view nice and clean. If the staff clicks on one of the staff members listed, they get the complete details, which is what I want as there is also a digital pic of all staff, as well as off hours contact information, personal fax numbers, etc. But my problem is that I'd like to have these couple of additional columns for each user, but only want Administrative accounts to be able to see them. Is there any way to hide, filter out, or deny view permissions to these two columns? TIA - Joe Tag: SQL Server 2000 Upgrade Query Tag: 64982
  - 4
    - problem getting to sites from internet I brought up a new server with the latest WSS installed. I cannot get the site to come up from the internet. Here's what I have tried so far: To be sure IIS was working and to test connectivity I set up http://test28.leeallen.org with a simple htm page. This site serves up to any computer including my PDA and cell phone. This proved that the network is connected and that IIS seems to be working ok. Next I configured the sharepoint site to accept all port 80 requests as well as the specific url of http://moss.leeallen.org, I also enabled anonymous access for the site in both IIS and Sharepoint. This site will serve up on the server machine so WSS is working, But from any internet machine you get an "Internet Explorer cannot display the webpage." error message. I'm stumped. Is there some IIS or WSS security property that prevents the site from displaying from other machines. Any insight would be greatly appreciated. I don't know where to look next. Thanks Tag: SQL Server 2000 Upgrade Query Tag: 64978
  - 5
    - Delete large number of calendar event items Many of our schools that are using Sharepoint 2003 are using the calendar for many different topics and as a result the number of events from the last two or three years has grown to be quite large. I have been asked if there is a "easy-button" for deleting the outdated events. In short is there any scriptable methods to remove old entries? Maybe a SQL Query?? I know MS frowns on that but I can't think of any other way... Any ideas Tag: SQL Server 2000 Upgrade Query Tag: 64971
  - 6
    - Content Editor Web Part Passing Current User Hello, I am trying to deliver embedded content from an application I have written into SharePoint 2007 (MOSS). I am trying to use the Content Editor Web Part and configure it to use a URL to get the HTML from the other application (on the same server). However, I need the request to the custom app to either be in the context of the requesting user or to pass the current user name in the Querystring. I know I could just write a custom Web Part to handle this but I was hoping to make it easy on myself. Does anyone have any suggestions. Thanks Tag: SQL Server 2000 Upgrade Query Tag: 64970
  - 7
    - overlay sharepoint list with refreshed excel file I've got a two-fold issue. I'd like to take an excel sheet within a spreadsheet that gets updated/overlayed on a daily basis with the latest data and update the sharepoint list without sharepoint thinking every item in the list is new. The ultimate problem I'm trying to solve is to have alerts on each item in the list, only when data values change, but sharepoint seems to think the item changed when it really hasn't and alerts the user. What I tried to do is keep the id field and just overlay the rest of the data in the spreadsheet. Sharepoint saw that as a change and sent the alert. I need to capture new list items from that spreadsheet and data changes to existing list items. If there's a way to do this without having to write code? Tag: SQL Server 2000 Upgrade Query Tag: 64968
  - 8
    - Issue with people-picker showing as drop-down with all users I have several document libraries set-up - some of which have custom columns that reference Groups of people.. For instance - I may have a column called "Test Person" and it is set to allow selection of people from a Sharepoint Group called "Test Group" - let's say in Test Group there are three users: User 1 User 2 User 3 Now let's say that all users of the site includes those users plus two more named User 4 and User 5. For whatever reason in my Sharepoint site - when editing any of my documents or creating new ones when the document's Web File Properties page comes up - the people picker is replaced with a drop-down that contains ALL users - so in the above example it would contain Users 1 to 3 AND 4 to 5. Please help. I know this was working before and suddenly - it's not - how do I get the people-picker back? Note - the people piker works if I edit the properties of the document directly through Sharepoint - but not when saving from WORD to Sharepoint. Tag: SQL Server 2000 Upgrade Query Tag: 64967
  - 9
    - owssvr.dll will only display some lists in XML ... I have an intranet site running on Sharepoint (2003). I use owssvr.dll to save backups/archive list contents in XML format, e.g. the file 2008-01-09.xml will hold the list contents as of that date. However, I cannot display all lists this way. One particular list gives the error "Can not complete this operation. Please try again". The first one works - the second one doesn't. http://mysite/_vti_bin/owssvr.dll?Cmd=Display&List={FEB01014-77E4-4FD5-84CB-82717A723E12}&XMLDATA=TRUE http://mysite/_vti_bin/owssvr.dll?Cmd=Display&List={D339082D-0832-4012-805C-A9F48A751D16}&XMLDATA=TRUE Both GUIDs are correct (if they weren't, I'd get the "list does not exist" error). Any hints and points are greatly appreciated! Steff Tag: SQL Server 2000 Upgrade Query Tag: 64964
  - 10
    - WSS 3.0 search a file on a shared network Hi, I don't remember if it's a possible to use wss 3.0 to search files on a file server on the network. I know that this is a features of MOSS 2007 but WSS 3.0 installed as a farm has this service? Regards Tag: SQL Server 2000 Upgrade Query Tag: 64958
  - 11
    - Problem trying to install Team Foundation Server 2008 on a SharePoint Hi, I'm not even sure this is the correct newsgroup to post this in, but I'll give it a shot. I'm trying to install TFS 2008 on my local system, where I have SharePoint installed. I'm getting the following error: "setup could not determine what languages are configured for the windows sharepoint services site" I've installed the Languages Service pack, along with all Sharepoint extensions installed, so I have no clue what else I need to do. Any thoughts? Thanks, Kevin Tag: SQL Server 2000 Upgrade Query Tag: 64939
  - 12
    - Change User Profiles Hi all, I would like to know how we can modify the user profiles for out users. This is a Sharepoint Services 3 box running Server 2003 R2, that is a stand-alone box. For example, we would like to change such selections like department, Job Title, etc. Where can we change these or add additional attributes? Is this functionality even available in WSS 3? Thanks everyone, and free coffee to the winner. -- MCSE: Security, CCNA, A+, Network +, Security+ Tag: SQL Server 2000 Upgrade Query Tag: 64937
  - 13
    - Record center issues When I send a document to the record center, all the metadata does not get copied. The Title, Lookup and Person/Group fields do not get copied to record center. I can see those values in the xml file under properties but cannot see those metadata under "view properties". Any help is appreciated. Tag: SQL Server 2000 Upgrade Query Tag: 64936
  - 14
    - Document Lib Up Button Is there any way to add the Folder Up button to a 2007 document lib? I have users that are complaining when they have to use the IE back to get out of a folder when in 2003 there was an up button after you entered a folder. This really comes into play when you have multiple document libs on a page and the breadcrumb does not reflect the path for each document lib. thanks Brad Tag: SQL Server 2000 Upgrade Query Tag: 64935
  - 15
    - re-adding a sub-web to the quicklaunch of the parent on WSS 3.0: when a sub-web was created we did NOT choose the option to display a link in the quick-launch of the parent site. Now, we do want the link to appear in the quick launch of the parent - if we add the url manually, the link appears for all users even if they don't have access. How can I re-add the sub-web so that SharePoint still does it's security Trimming? I see a property "isInternal" on an SPLink object, but it is read-only - and I don't see how to programmatically create a link to the sub-web and specify that it is internal. Thanks Tag: SQL Server 2000 Upgrade Query Tag: 64934
  - 16
    - "File Not Found" error when adding new web part gallery I am currently in the process of learning how to create and deploy webparts using visual studio 5 and WSS3. I have been following the instructions on the following link on how to set up and create a web part : - " http://www.developer.com/net/asp/article.php/10917_3620316_1 " The actual creation of the webpart I believe is fine. However, the problem I am having difficulty with is the actual deployment of the web part. I get to point 8 on the guide and my WSS3 site throughs up the following error " File Not Found. " it is not an IE error, it is an actual WSS3 error, namely I get a WSS3 error page with all the borders. I am completely stumped as to why this is happening or how to rectify this. If anyone has any suggestions it would be greatly appreciated. Tag: SQL Server 2000 Upgrade Query Tag: 64931
  - 17
    - WSS3 + Win2K3 x64 Installation Woes I've been working at this for several days but am not making any progress. I've got no experience with WSS, IIS or SQL Svr 2005. WSS3 on 2K3 x64 requires the full SQL Svr to be installed. I've installed SQL Svr 2005 Std x64 with default settings opting to install only the Server package - all remaining options were unchecked. I've applied no additional changes to the Surface Area Configuration. There were no errors during the install. I installed WSS3 using the walkthrough at the Sharepoint Forum. No errors were reported. On completion of the wizard the Central Administration site did not open - I received the HTTP Error 404 text. I pressed ahead and added the URL to the Trusted Sites on the server, checked the URL from a network PC using Firefox, and also manually added /default.aspx. No joy. I was asked for a Username and Password in Firefox however the next page was HTTP Error 404. IIS reports SharePoint Central Administration v3 as Running under the Web Sites node with the default port 10806. All site files and folders appear to be fine. The Web Service Extensions node has ASP.NET v2.0.50727 Allowed and Windows SharePoint Services V3 was added during installation and is Allowed. I understand SQL Svr installs several services disabled by default, could that be the issue? I see several errors in the Event Log which I'll review tomorrow (it's 2am!). Is there anything obvious so far? Tag: SQL Server 2000 Upgrade Query Tag: 64927
  - 18
    - Make Your Site Quick To Load! The time it takes to load your site can make or break a visitor's first impression of your site. If your site takes too long to load, the visitor will click "Stop" or "Back" and leave your web site. If you are a business and offering people important information, it is critical to have a nice design, with a quick load time. You may want to check out the load time of your page, to indeed see if your site loads quick enough for the average user. A great site tool can be found at http://www.websiteoptimization.com/services/analyze/ where you are able to enter your site and it displays a report on the time it takes to load your site on different connections, in addition to tips to decrease load time. Upon doing a speed test, if your first page takes a great time to load in the visitor's browser, it is in the best interest to do some redesigning to decrease load time and increase the number of visitors that will not click back on the browser. We must remember that not everyone is running on DSL or Cable modem. Many users still dial up using a 56K connection. As web designers and site maintainers, we want to ensure our site's load quickly, as to not lose potential visitors to your site. Images, Sounds & Animations are the major menaces to download time. While these add nicely to a site, they may take up a lot of time to load. If you may avoid large sized files, please do. Many images may be optimized to look the same, however taking up less space, and download more quickly. Many image editors such as Adobe Photoshop or Paint Shop Pro can perform these tasks. Sounds & Videos should be avoided on your main page, as they take up most time to load. Keep these for inner pages if possible. Videos and sound files can be from 100 KB to 1 MB in size or larger. If the user needs to load a 500 KB video file on a 56 K modem, it will take upwards to 89 seconds to complete. This definitely could turn the user away from your site. So keep these files to a fairly small size, or avoid if possible. Text can also play a significant role in the load time. If you have a large amount of HTML code and large amount of content on your main page, it will also increase the load time. Text however is not as significant, as the entire text you have on the site may not be even the same size as a couple of pictures combined. So limit the large sized graphics on your web sites. Your visitors will appreciate the fast loading site with the information being presented that they are looking for! http://cncarrental.cn/html/Internet/20060929/31900.html Tag: SQL Server 2000 Upgrade Query Tag: 64925
  - 19
    - lost iis config had a rather unfortunate time with asp.net updates and iis metabase corrupting. Long story short, I have iis and asp.net working again but the web sites for sharepoint v3 are all gone. I don't seem to have a backup of the iis config so i am wondering if I can recreate them somehow with info from the database? I'd prefer not to remove/reinstall sharepoint(repairs fail), but if I must I must. Tag: SQL Server 2000 Upgrade Query Tag: 64906
  - 20
    - bug with RSS feed from Wiki? i just started to use the RSS feed from a Wiki i have on WSS 3.0 and i just noticed that when i get the RSS annoucnment it comes in under the creation date, not the modify date. i had just updated a wiki and i got the update ok but its dated months ago. Im using Outlook 2007, so i guess it could possibly be a bug there, but im guessing that the date and time are pushed from WSS and its not just how OL is reading the feed. Tag: SQL Server 2000 Upgrade Query Tag: 64905
  - 21
    - Change Default Web Site to https I just upgraded from SharePoint 2.0 to SharePoint 3.0. When I was running 2.0 the default webpage was https://servername. I would like to continue this in 3.0. However if I type https://servername I get redirected to http://servername/default.aspx , and a message saying â??The page must be viewed over a secure channel.â?? If I go back up to the address bar and put in https://servername/default.aspx then it will take me into SharePoint. How do I get my default web site to use ssl? How do I get my default website to stop redirecting to http instead of https? Thank You Tag: SQL Server 2000 Upgrade Query Tag: 64904
  - 22
    - *rips out hair* now central admin not working... Well we upgraded to WSS 3.0 SP1 and now our central admin site isn't working! it just gives a 404 error... all the sharepoint websites work though... just not the central admin... anyone have any clue why? and how to fix this? thanks! Tag: SQL Server 2000 Upgrade Query Tag: 64903
  - 23
    - [WSS V3] Directory services Hi, I installed a windows Sherapoint services v3 on a server located on the company domain. The WSS admin account is a local account. My pb : I would like to access to the directory services and to be able to select my users in the "select people and groups" window, and when the user is created, I would like to obtain the AD properties like the mail, the organization part .... But it doesn't work. It seems that I have a config pb ... Can you help me? What are the conditions to have the directory services ? Thanks in advance BR SDA Tag: SQL Server 2000 Upgrade Query Tag: 64901
  - 24
    - Sharepoint 2007 - reuse custom lists Hi! I've created a custom sharepoint list and a view. I use this list on more than one web-part-pages. Now I have to update the list (or view), maybe add a column. In order to get the changed list on my webpartspages I have to delete and add the list again. Very annoying. Is there a possibility for reusing a custom list on more pages without readding it, smth. like linking the list in order to get the changes automatically to the webpartpage? Any help will be greatly appreciated Tag: SQL Server 2000 Upgrade Query Tag: 64894
  - 25
    - Sharepoint (wss v3) questions. Good day, I hope you can help I am looking at purchasing a hosted sharepoint solution from 1 of the many providers available. Before I do I just wanted to make sure that WSS v3 can do what I want it to. Most providers offer X amount of "sub sites" I was wondering what a Sub site is? I have used a WSS v3 before and I when I use it properly I want a separate section of the site to be for each department/project of my company. For example we will have the main site this will contain basic company news, holidays, meetings coming up. I then require each project we work on to have its own separate space on the site for example "project 1" will have its own members and files / forum. "project 2" will have the same as project 1 and so on. Then I would also have such spaces as "sales" "support" etc etc. Do all these count as sub sites? Or would it depend how I would make them. My second question is about permissions. After inviting a user to my site as say a normal reader and then I want them to be an admin of the site how do I edit the permissions of that user? Last of all, if I do have my site set up with "project 1" "project 2" etc how do I setup users so they only have access to certain projects for example if I want contractors working from home to only have access to 1 section of my site how do I do this? J Thanks in advance for any help Tag: SQL Server 2000 Upgrade Query Tag: 64890
- Next
  - 1
    - Linked Excel Files in MOSS 2007 Hi all, Joel Oleson had a blog post last year about what not to store in SharePoint. He said that one should not store linked excel files. Has anyone out there had experience with trying to do this? What I want to do is upload a bunch of spreadsheets that reference each other to a document library and allow my users to continue working as per normal. According to what Joel said, it seems that the references in the excel files won't work. Joel's post is here: http://blogs.msdn.com/joelo/archive/2007/11/08/what-not-to-store-in-sharepoint.aspx Thanks in advance Steven Tag: SQL Server 2000 Upgrade Query Tag: 64889
  - 2
    - New Items in a custom list Hi All, Using SharePoint Server 2007. I have a 'Custom List in Datasheet View' that contains a 'Person or Group' column whose value is chosen from a SharePoint Group. The SharePoint Group in use contains several distribution lists, as well as one direct member. When entering a new row in the default Datasheet view, the column gives me a dropdown box showing all the members of all the relevant distribution lists - superb. However, when entering a new row via 'New, New Item', the column doesn't allow selection of the distlist members, only the direct member. Known bug? Tag: SQL Server 2000 Upgrade Query Tag: 64887
  - 3
    - Upload Multple Documents gone in SP1? Hey, I'm trying to use the Upload Multiple Documents feature of the list webpart, but I can't seem to find it since installing SP1. I am using Internet Explorer 7, made sure it wasn't Firefox that I was accidentally trying to use. Has this feature been removed? Regards, Wingot Tag: SQL Server 2000 Upgrade Query Tag: 64880
  - 4
    - Attaching a domain as members Hey, I have a WSS 3.0 site that I have installed on my development environment. When it was installed, this environment was not connected to the domain, and as such the authorised users list doesn't include any of the accounts on the domain (except my own which I added manually as a site administrator). Effectively, what I want is for everyone on the domain (including accounts created in the future) to be given access to the site, basically in exactly the same way as occurs if installing WSS3.0 after already being joined to a domain. Anyone know how I would set this up? Regards, Wingot Tag: SQL Server 2000 Upgrade Query Tag: 64879
  - 5
    - WindowsSharepointServices - few newbie questions Hello everyone. I have to build intranet based on Windows Sharepoint Services, but have no idea where to start, so I need few advises. Generally I'm a software developer (.NET) with ASP.NET experience, but without experience with any form of Sharepoint. I need to have fallowing modules/functionalities in intranet: - organization structure (based on data from AD), - sharing documents (for some group with possibility to edit/read depending on rights in AD) - reservation's resources(conferences rooms, cars, video equipment etc.) - news (everybody can add news, but only admin can approve it) - events calendar (global and group based) with notification on mail. - training calendar (with possibility of joining to training, uploading training materials, etc.) - some kind of reporting services (but based on external databases - db2, informix, etc.) - faq - dashboard - photo gallery - some forms/survey to collect opinions from users - some kind of statistics for admins I suppose some of the functionalities described above are available in sharepoint (maybe require little modifications), another I need to write myself. Can you point me to some places describing how to start playing with this technology (wss) ? Is the web parts development for sharepoint similar some kind to asp.net web pars development ? What should I have to start build wss solution ? best, Slawomir Tag: SQL Server 2000 Upgrade Query Tag: 64877
  - 6
    - WSS3.0 Templates Hello All Is there a way that I can restrict application templates to a specific site collection? After installing some templates on my WSS3.0 server it would appear they are available to anybody using the same web application. Thanks AJ Tag: SQL Server 2000 Upgrade Query Tag: 64876
  - 7
    - WSS 3.0 Upgrade Issue - ASP.NET (32-bit) I installed WSS V2.0 from CD through Server Roles expecting the upgrade to V3.0 to be offered from Windows Update. I'm running 2k3 x64 so during installation both IIS and ASP.NET entered 32 bit emulation modes. I've now downloaded WSS 3.0 x64 which reports that ASP.NET must be Allowed in IIS Web Service Extensions. It is but in 32 bit emulation. How is emulation returned to x64 for IIS and ASP.NET or must I reinstall those services? I've checked http://www.wssfaq.com but I couldn't find any leads. Cheers Tag: SQL Server 2000 Upgrade Query Tag: 64871
  - 8
    - WSS FAQ additions and corrections - 30th December 2007 - 5th January Note: All of the addresses of the KB / Articles - 2007 Products / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ site and to this file. I can't guarantee that they still are. Special Note: No, I've not been lazy. It's just been a very slow week. (This is also posted to my blog at http://mikewalsh.bilsimser.com) (Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.) From 30th December 2007 - 5th January 2008 I.1 2007 KB Articles (*now only one section for WSS and MOSS*) New None Modified None I.b Forefront KB Articles New None Modified None I.c InfoPath 2007 KB Articles New None Modified None II. Articles - 2007 Products (no longer with all links to articles for other Office 2007 and other 2007 Products) New A. Office 2007 Server Products http://www.sharepointblogs.com/llowevad/archive/2008/01/02/moving-to-a-new-database-server-or-instance.aspx Moving to a new database server (or instance) (Blog - Dave Wollerman) 2nd January 2008 http://projectserver201.blogspot.com/2008/01/issues-fixed-in-project-server-2007.html Issues fixed in Project Server 2007 with SP1 (Blog - Scott M. Wagner) 1st January 2008 http://blogs.technet.com/wbaer/archive/2008/01/01/microsoft-office-sharepoint-server-2007-to-windows-sharepoint-services-3-0-site-level-migration.aspx Microsoft Office SharePoint Server 2007 to Windows SharePoint Services 3.0 Site-Level Migration (Blog - William Baer) 1st January 2008 http://www.sharepointblogs.com/ssa/archive/2007/12/30/using-business-data-catalog-definition-editor.aspx Using Business Data Catalog Definition Editor (Blog - S.S.Ahmed) 30th December 2007 B. Other Office 2007 products (selected few only since 1.1.2007) None C. Other New 2006/2007 Products (selected few only since 1.1.2007) http://www.microsoft.com/downloads/details.aspx?familyid=74dd6e2d-89c6-4e1e-af00-fc7d70f15439&displaylang=en&tm Microsoft Windows Software Development Kit (SDK) for Windows Server 2008 and .NET Framework 3.5 (ver 6.1) 2nd January 2008 Modified None III WebCasts (+ PodCasts, On-Line courses) for 2007 Products New None IV WSS v3 FAQ New Note: I've moved the InfoPath 2007 books from the "Non-SP Books" section for better visibility (and to line them up with the existing Forms Services book). (For the moment I've also left them in the Non-SP Books section, but this may change) I'm always grateful for information about books - especially non-English language books - that I don't include in the list. http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1306 I.31.07 What issues are fixed in Project Server 2007 SP1? http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1303 V.83 InfoPath 2007 (in French) (Editions ENI - Jean-François Fustec) *released* http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1304 V.84 Microsoft Office InfoPath 2007 - Das Handbuch (mit Sonderteil Forms Server) (in German) (MS Press Deutschland - Egbert Jeschke, Helmut Reinke, Sven Maier) *released* http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1305 V.85 Pro InfoPath 2007 (apress - Philo Janus) *released* http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1308 V.86 MOSS for Engineers and Architects Resource Kit (MS Press - unknown) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1307 VI.96 Epok Edition for Microsoft SharePoint (Epok) Modified http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1224 III.100 Why are some top link tabs not highlighted? http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=816 V.10 Microsoft Windows SharePoint Services Version 3.0 Inside Out (MS Press - Errin O'Connor) *released* http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1240 V.68 Administrator's Guide to Microsoft Office 2007 Servers: Forms Server 2007, Groove Server 2007, Live Communications Server 2007, PerformancePoint Server, SharePoint Server 2007 for Search (Unleashed) (SAMS - J. Peter Bruzzese, Ronald Barrett) *released* --------------------------------------------------------------------------- V WSSv2 KB Articles (plus SPS 2003 Hot fixes) New None Modified http://support.microsoft.com/default.aspx?kbid=827926 Considerations That Apply When You Use Multiple Log Files for Usage Analysis Processing in Windows SharePoint Services 2.0 (ver 3.2) 2nd October 2007 VI WSSv2 FAQ New None Modified None Deleted (site no longer exists; can't find any other reference to this control) VII.10.58 Free WSS-relevant Programs - Drop-down menu control (Dan Marth) (SPS 2003 - WSS too?) Tag: SQL Server 2000 Upgrade Query Tag: 64870
  - 9
    - Cannot drop the procedure I am trying to upgrade from SharePoint 2.0 to SharePoint 3.0. In SharePoint 2.0 I was using Kerberos authentication. The SPN login is dbo on both SharePoint databases. When run the SharePoint Products and Technologies Configuration Wizard. I get this error An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Cannot drop the procedure 'user_login', because it does not exist in the system catalog. Cannot drop the procedure 'user_account_get', because it does not exist in the system catalog. Cannot drop the procedure 'user_register', because it does not exist in the system catalog. Cannot drop the procedure 'user_forgot_password', because it does not exist in the system catalog. Cannot drop the procedure 'user_change_password', because it does not exist in the system catalog. How do I fix this error? Thank You Tag: SQL Server 2000 Upgrade Query Tag: 64867
  - 10
    - Problem with MultiLine Text box displaying in an email Hello, I have a sharepoint form that has a workflow attached to it. Whenever the form is submitted it captures a couple of items from the form and send it out to a user. One of the fields it captures is a multi line text box, and when it is displayed in the email it has extra line spaces inserted into the email. Does anyone know how I can stop it from doing it? Example: How text typed into form: This is line1 <hitting enterto get down to line 2> This is line2 How text is displayed in an email This is line1 This is line 2 Tag: SQL Server 2000 Upgrade Query Tag: 64866
  - 11
    - WSS on 64bit server with 32bit IIS? How would you go about installing wss on a server that is windows 2003 x64 but configured to run in IIS 32bit mode? some of our web apps want 32bit IIS mode or they will not work... Tag: SQL Server 2000 Upgrade Query Tag: 64850
  - 12
    - Unable to Edit User Information I have added WSS site to existing Sharepoint Portal server. We don't integrate with AD, and use local Windows User (of the server) instead. So, when we add the new user to the site, there's no email address for the created user account. When we try to edit the User Information, it only shows the account name, without other fields at all. I try to edit in SSP, but there's no Email Address field there. I already use administrator account. Without email address for the account, how does the Alert Me feature work? Or Workflow email, etc? Anyone help? Regards, Gunady Ng Tag: SQL Server 2000 Upgrade Query Tag: 64845
  - 13
    - PDF Indexing Before we had to install an ifilter for adobe pdf's to be full text indexed... what do we do for a 64bit installation though? our SQL server is 64bit... our WSS server will be 64bit also.. I only ever did this on 32bit in the past... thanks! Tag: SQL Server 2000 Upgrade Query Tag: 64834
  - 14
    - Help! Moving to a new server We bought a new server we want to move share point services too... how do I go about moving this? Right now its on say Server1 and our new server is Server2... server1 will be decomissioned after this... what procedure do I need to go through? Can I just restore a backup from the sharepoint backup? the new server is also 64bit the old is 32bit... thanks! Tag: SQL Server 2000 Upgrade Query Tag: 64833
  - 15
    - Help on extending/customizing WSS 3.0 surveys Hi there, I was hoping someone you could point me to some good online resources or purchasable books that can give me some hands-on help in extending WSS 3.0 survey using features/and OR Sharepoint Designer/VS Studio. I've not found much yet online. I've only found a Kiwi Survey Plus webpart thats nice but doesn't help in extending the layout and the type of survey question you can present. If I cant find any realworld examples, then is there a 3rd party survey tool that can easily integrate with a WSS intranet site (users in active directory) Any help is appreciated! Regards, Amir Khan Tag: SQL Server 2000 Upgrade Query Tag: 64831
  - 16
    - Sharepoint and Recruitment Can anyone tell me if sharepoint has been used to search a recruitment/ staffing database? We are looking to upgrade our search capability and Sharepoint seems like a reasonable option. A link to a case study would be great. Tag: SQL Server 2000 Upgrade Query Tag: 64828
  - 17
    - Changing Ownership of a Document Hi -- This problem sounds soooo simple to overcome, but it seems to be one hard nut ... or maybe I'm just missing something. I have a fairly large number of "documents" in a set WSS 2.0 doc libraries. I need the ability to make a different person the owner (Author) of the document. I am looking for the quickest and easiest PROGRAMMATIC solution and hopefully this is something I can create a utility out of. Here is a synopsis of the solutions I've looked at: - Looked at using the SPList to extract the File into a MemoryStream, Delete the Document from the Library, then started looking into changing Security Context to Re-Add the File to SPList under this new Security Context ... This changing of Security Context looks very hairy ... - Looked at the WSSCONTENT Database and seeing if I just flip something around back here and spoof Sharepoint into the desired result. This of course is completely non-supported and disqualifies MS support down the road ... Since this didn't really prove itself to be "low hanging fruit" ... and is inherently dangerous from a support perspective ... I abandonded. Am I missing something, or is this just a nut-cracker special? Any insights on this would be greatly appreciated! Thanks in advance, --Rich Tag: SQL Server 2000 Upgrade Query Tag: 64825
  - 18
    - How to invoke a Web Service within a workflow in SharePoint Design Hello I am using SharePoint Designer 2007 and would like to know if it is possible to use a Web Service as a data source within a workflow. The following steps have been completed successfully. 1. Create a web service connection (tested successfully) 2. Create a workflow Is it possible to use the web service as a data source in a conditional? Jay Tag: SQL Server 2000 Upgrade Query Tag: 64823
  - 19
    - help with alternate access mappings hello, I'm trying to get sharepoint to work from 2 offices via VPN. the VPN works fine (vpn is used for term server and printing). I need sharepoint to work from both offices - from the office with the servers sharepoint works fine but from the other office I get error saying permission denied. I've gone to the alternate access mappings and setup the IP address of the sharepoint server as an extranet. However it still doesn't work. What else can I do to make sharepoint work from the other end of the VPN tunnel? Thanks, Oskar Tag: SQL Server 2000 Upgrade Query Tag: 64819
  - 20
    - Sharepoint for just document management I need a document management program for doing constituent services in a government office. When someone calls in with an issue, I want to create an electronic file folder for them, which I can attach documents to (including PDF's). After looking through the Sharepoint website, it looks like the program does this, but it seems that Microsoft has placed much more of an emphasis on making it a document sharing program, rather than management. Tag: SQL Server 2000 Upgrade Query Tag: 64818
  - 21
    - Lookup to Image/Picture Library Hi All, In MOSS 2007, the HTML Rich Text Editor (in creating/editing Page) is able to lookup to Picture Library. Once the user click on the Image button, it will bring look up window which user able to select picture from existing Picture Library, if the picture is not available, user can click upload to insert new image to the Picture Library, which is very useful for simple content/page editor. But, I am not sure how to use this feature in WSS 3.0? In WSS 3.0 Custom Lists, is it possible to create column that link to Picture Library which user able to enter the column by lookup to the image? The current way is by creating Lookup column to Picture Library, which only shows dropdown to show title/id (even not able to select name). This way is very difficult for user to select the Image. The other way, is to enter URL address of image, which is very difficult for the user to enter as well. Currently, I plan to add custom lists for Product Listing to displays in the Commerce Portal. The user cannot accept the default way that is provided by Sharepoint to link images. Any other way? Regards, Gunady Ng Tag: SQL Server 2000 Upgrade Query Tag: 64814
  - 22
    - How to move Configuration Database to Another Server? Hi All, Unfortunately, my Sharepoint database server is crashed, but I still can extract out all D drive data, which contains all MDF and LDF of database. Is there any guide to move configuration database to another server? I have tried some guide that explains how to move with Sharepoint Central Administrator, but the problem, the Sharepoint Central Administrator is not accessible anymore: Cannot connect to the configuration database. Is anyone able to help? Tag: SQL Server 2000 Upgrade Query Tag: 64810
  - 23
    - M`I'5.Pers ecution ` abu se in s et-up si tuations and in publ ic -=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=- -=. abuse in set-up situations and in public -= -=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=- Strangers in the street have recognized. me on sight many times, and shown awareness of the current thread of abuse. To. give you one example, in 1992 I was seriously ill, and a manager at work somewhat humorously said. that "it wasn't fair" that. people were bullying me. A few days later, I attended for. the first time a clinic in London as an outpatient, and on my way out was accosted by someone who asked if "they had paid. my fare", with emphasis on the word "fare". He repeated the word. several times in this different context; that they should have. paid my "fare", each time emphasizing the word. For two and a half years. from the time their harassment started until November 1992 I. refused to see a psychiatrist, because I reasoned that I was not ill of my own action or fault, but through the. stress caused by harassment, and that a lessening. of the illness would have to be consequent to a. removal of its immediate cause, in other words a cessation of harassment. I. also reasoned that since they were taunting me with jokes about mental illness, if I were to seek. treatment then the abusers would think that they. had "won" and been proved "right". Remember, the constant theme of any persecution is, "we must destroy you because. you're X", whether X is a racial or other attribute. In this case. the X was "we persecute you because you have brain disease".. The similarity of this logic to Nazi attitudes to the. mentally ill is striking. The same manager who'd said "it wasn't fair" asked me in winter 1992 why. I didn't seek help. from a psychiatrist; was it, he asked, because "they would think they had won". if I sought treatment? That was something I'd never said at work... again, taken separately it proves nothing, but. many such things over a period of months. proves conclusively that people in the company knew what was going on, and in quite a lot. of detail. Usually harassment in public lacks the level of. finesse of "paying your fare". Most people's imagination does. not go beyond moronic parroting of the current term of denigration. That. is not surprising given the average level of the abusers; if they do not have the intelligence. to distinguish wrong from right then neither will they. have the capacity for anything other. than mindless repetition of a monosyllabic term calculated to fit into their. minds. The first incidents of verbal. assault in public were in again in the summer of 1990, although they increased in frequency and. venom with time. In July 1990 the first public incident occurred on a tube. train on the Northern line. Two. men and their girlfriends recognised me; the women sprang to my defence, saying "He. looks perfectly normal, he doesn't look ill". Their boyfriends of course knew better, and followed the party line; one of. them made reference to an "operation", apparently to. work at the tube station but implicitly to a visit that I had made to hospital a couple of. weeks previously. In August 1990 going. home from college, soon after getting on a tube train at Gloucester Road I was followed. by a group of four youths, who started a chant of abuse. That they were targeting me was. confirmed by other people in the carriage,. one of whom asked the other "who are they going on at, is it the bloke who just. got on?" to which the second replied "yes, I think so". I. was tempted to reply, but as in every other instance the abusers are enabled. in their cowardice by physically outnumbering the abused; any confrontation would. result in my being beaten up, followed by a complaint to the police that "he attacked us", and of course he's. ill, so he must have. been imagining that we were getting at him. Shitty, aren't they? But the shittiness of the four youths on the tube train. is as nothing compared to the episode on the. National Express coach to Dover in the summer of 1992. While going on holiday to the Continent I. was verbally set upon by. a couple travelling sitting a few rows behind. The boy did the talking, his female companion contributing. only a continuous empty giggling noise. He spoke loudly to ensure other people on the. coach heard, always about "they" and "this bloke" but never naming either the abusers. or the person he was talking about. He said "they" had "found somebody from. his school, and he was always really stressed at school".. They must have dug deep to find enemies. there; perhaps someone who dropped out of school, someone who didn't. do too well later, who was jealous and keen to get their own back? The. boy also said "he was in a bed and breakfast for only one night and they got him". By a not unexpected. coincidence I had been in a B&B in Oxford a week previously,. which had been booked from work; other things lead me to the conclusion that. the company's offices were bugged for most of the 2 1/2 years that I was there, so "they" would have known a. room in the B&B had been booked. (But I'll bet "they" didn't tell the. company's managers their offices were. bugged, did they?). After a few minutes of this I went back. to where they were sitting and asked where they were travelling. The boy named. a village in France, and the girl's giggling suddenly ceased; presumably it permeated to. her brain cell what. the purpose of the boy's abuse was. This and other set-up situations are obviously calculated to. provoke a direct confrontation. which would bring in the police, with the abusers claiming that they were the ones. attacked. Again in 1992, outside the house where I was living in Oxford I. was physically attacked by someone - not punched, just. grabbed by the coat, with some verbals thrown in for good measure. That was something the people. at work shouldn't have known about... but soon. after a couple of people were talking right in front of me about, "I heard he was attacked". The UK police. have a responsibility for preventing assault. occurring, but they do not seem to take any interest in meeting that responsibility.. I suppose their attitude is that harassment does not come within their remit unless it involves physical assault,. and they will only become involved once that happens. That is. of course quite the wrong. attitude for them to take, but as I now understand, the police investigate only the crime they wish to investigate; if they do not. take your complaints seriously then there. is nothing you can do to make them take. action. 4683 Tag: SQL Server 2000 Upgrade Query Tag: 64801
  - 24
    - M`I,5`Perse cution - wh y won' t the Briti sh po lice do their job an d put a s top to it ? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -= why won't the British police do. their job and put a stop to it? -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- The British police obviously do know what is taking place. Besides. my interpretations of what individual officers have said. which forces that conclusion, it would be inconceivable for them to be. unaware of something on. this scale. If they know, then they will. know that the abusers have broken laws in the UK and abroad.. Recently the UK introduced laws against electronic spying which carry a penalty of. several years jail if caught. If the police know illegal harassment is taking place, and do nothing about it, then. they are failing in. their responsibilities. Last Easter (1995) I went into the local police station. in London and spoke to an officer about. the harassment against me. But I couldn't provide tangible. evidence; what people said, in many cases years ago, is beyond proof, and. without something to support my statements I cannot expect a police officer to. take the complaint seriously. The. current situation with regard to the police is not one which allows a breakthrough in dealing with the problem. On the one. hand, most individual officers at a local police station may not know about the ongoing. assaults, so a complaint at that level will not yield results. Yet. the police as an organisation do know of the harassment, and they must be. aware that a complaint has been made at. a police station. So it is clearly their duty to take preventative action against. the continuing molestation, but because the criminals. are operating on behalf of a state agency, the police are not carrying out their. duty. 2253 Tag: SQL Server 2000 Upgrade Query Tag: 64800
  - 25
    - Sharing Quick Launch Menu Hi All, I have a WSS 3.0 Website and have several Subsites under the parent, I need to Share the Parent Site Quick launch menu to the Subsites, Any ideas to proceed further Thanks in Advance Thomson Tag: SQL Server 2000 Upgrade Query Tag: 64799

Hi

I've got a web farm install with sharepoint 2007 and sql server sitting on
the same box; this was always temporary while we waited for a new server for
SQL.

What I wanted to check is am I best upgrading to sql 2005 first on the
current box and then migrating or migrate to the new box first and then
upgrade sql server?

If you're just upgrading from Sql server 2000 to 2005 do you need to do
anything with sharepoint 2007 - I couldn't find any definitive information.

regards Matt

Top