What version of SQL am I using?

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
    - Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise Hi! I have set up a WSS site using SQL Server 2005 Express edition. Now I need to make an upgrade to Standard edition of SQL server 2005. How can this be implemented? Can I just detach my databases from Express and re-attach them to Enterprise? How about the instances, like now I have the following SERVERNAME\SQLEXPRESS? Is there a documented procedure on this? Thank you! Tag: What version of SQL am I using? Tag: 67051
  - 2
    - Using ASP.Net Web Parts in WSS 3.0 sites I have created a WSS 3.0 site and also created some Lists. I am creating an ASP.Net Web Part and accessing the WSS lists programmatically in this web part. I have deployed this web part to the same WSS site. When I try to edit the Web Page on WSS site and add a web part, I get an error. Tag: What version of SQL am I using? Tag: 67047
  - 3
    - Forms Authentication using AspNetSqlMembershipProvider breaks search I have tried everything and can't seem to find a way to keep search working when using Forms authentication. Both of my production servers have borken search and I have been building and tearing down numerous VM's in an attempt to find a way to make it work. There must be a way. The search service runs under a service account that also runs the app pools, etc. Can anyone point me in the right direction to get search working again? Steve Tag: What version of SQL am I using? Tag: 67044
  - 4
    - cannot uninstall Hi, I have installed WSS3.0 and MOSS2007 Now I'm unable to uninstall MOSS2007 When he ask for a final comfirmation the uninstall process never starts What can be the problem? Thanks Bart Tag: What version of SQL am I using? Tag: 67043
  - 5
    - pages not opening up in Sharepoint designer trial Hi I downloaded Sharepoint Designer trial version to work on Sharepoint site list pages. It worked fine for few days, it let me open the code, design, pages, etc, howevere,. now when I try to open any lists/pages, it doesnt do anything. It displays all the sites and lists from SHarepoint, however, when I double click open a page to edit the .aspx page, the cursor goes into hour glass for 2 seconds and then back to normal cursor, doesnt open anything. I tired to look at the bootom bar too if its opening in another window.. no help.. If I right click on the file and open with notepad O can see the code there.. however I want to view the code in designer so that I can edit it accordingly... I suspected that it might be the 'Trial' version thats causing a problem. I uninstalled and reinstalled the designer, but no change.. Please help!!! Tag: What version of SQL am I using? Tag: 67042
  - 6
    - SharePoint site not getting Active Directory information! We had wss 3.0 installed on a regular workstation with Windows server web edition everything worked fine. We have now decided to move to using SharePoint on a more regular basis so we installed wss3.0 on a enterprise server with a separate SQL server. Backed up all the information from the original site and restored it to the new server. Since then we are not able to add new users that exist in Active Directory to the site, however you can add them to Central Administration site. What did we do wrong? Tag: What version of SQL am I using? Tag: 67040
  - 7
    - Importing problem Tag: What version of SQL am I using? Tag: 67032
  - 8
    - Restore individual files in sharepoint Hi, Can someone please tell me how you restore a single file that is stored in a SharePoint database. I know about the Deleted Items folder, but I am more concerned about a corrupt file. I would like to move to Sharepoint replacing our current shared folders, but I need to know that restoring files is achievable without too much effort. TIA, Jarryd Tag: What version of SQL am I using? Tag: 67028
  - 9
    - Importing problem Tag: What version of SQL am I using? Tag: 67026
  - 10
    - How to purge all response in a survey ? I created a survey to which everyone responded. Now I would like to purge the results and ask the person to meet again in the survey. How to purge the results before. Tag: What version of SQL am I using? Tag: 67022
  - 11
    - RSS Feed being cached.. please help! This is driving me nuts. I am grabbing the daily dilbert feed on our portal site (http://feeds.feedburner.com/DilbertDailyStrip). This was working fine for a while, but now it has not updated since the June 8th (two days ago). I logged onto my sharepoint server (moss 2007), and verified i could access the site under the sharepoint account, and was not getting blocked. I then proceeded to add an RSS web part to a different sharepoint site, on the same collection (i only have one collection), and pointed it to that feed. That again, only showed feeds from before the 8th. I turned of the caching data view options for the web part, to see if that helped. I then deleted all caches and disabled caching, just to see if that would help. Nothing has! Any suggestions? Tag: What version of SQL am I using? Tag: 67015
  - 12
    - Automatically Update Document Properties from Files other than office Hi, when I update an Office file like word the document properties, e.g. Title are automatically updated in the doc lib of WSS. How ever this does not work for files other than doc, xls, ppt. For example it does not for work pdf documents. Is there a solution for this? Thanks for any comment Adrian -- Adrian Miller Tag: What version of SQL am I using? Tag: 67014
  - 13
    - Sharepoint services document libraries - replacement of shared folders? Hi, I have about 20 users on my network. They all work together in little departments and so need to share files. I have done this in the past using shared folders on network servers. Super standard stuff, its what everyone does. I do notice though that these folders have aboslutely no structure whatsoever, and they tend to just grow and grow and grow. I was wondering if I could get some feedback on whether Sharepoint Sevices Document Libraries lent itself to a better structure of folder (or site) hierarchy. I don't think at this stage that they willl use all the other features in Sharepoint Services so I am concerned that it might be a bit of an OTT project for me to undertake moving all shared folders on to Sharepoint, if all they are going to use it for is shared folders. Is that correct, or is there more to it than just being able to book document in and out, and version control? Is it easy to create and share sites. I am aslo concerned about storage and backups. What tools are there out there for this. Can I just do a SQL backup of the database and backup the website and that's it? How do I restore a single file. All help is appreciated. Bottom line, what I want to know is if it is worth moving to Sharepoint Services solely to provide shared folder capabilities. TIA, Jarryd Tag: What version of SQL am I using? Tag: 67011
  - 14
    - Links in Document Library Hi, Running WSS 3. Question is can i create links to documents in a document library rather than creating lists in the quick launch. I dont want to create an extra option in the quick launch which says LIST and create links, rather I would like to create links to douments in a document library. Is that possible? Is so how? thanks Raman Tag: What version of SQL am I using? Tag: 67003
  - 15
    - creating new sub-site with MOSS 2007 Forgive me for newbie question... Can I create hierarchies with Sharepoint? For e.g. can I create website with below URL: http://server/department/subdepartment Right now, I'm only able to create http://server/sites/website Can someone guide me through steps. TIA, MJ Tag: What version of SQL am I using? Tag: 67001
  - 16
    - How can I grant a user access to all sites in a collection? Hi I am using WSS3. How can I grant an AD group access to all sites in a site collection? Any help would be appreciated, Max Tag: What version of SQL am I using? Tag: 66999
  - 17
    - Sharepoint Lists Today I started my adventure with the Sharepoint :) At the beginning I can not add link to the list becasue this message appears: "Cannot make a cache safe URL for "SpellCheckEntirePage.js", file not found. Please verify that the file exists under the layouts directory. Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator. Troubleshoot issues with Windows SharePoint Services". To be honest I don't know what does it mean? Could you help me? Tag: What version of SQL am I using? Tag: 66998
  - 18
    - Workflow that will send Document in email I need to create a workflow that will send a document as an attachment to an email. Can I do this in Sharepoint Designer? Tag: What version of SQL am I using? Tag: 66995
  - 19
    - Amend/delete columns from within a SharePoint 2007 custom list Hello, I've just started using SharePoint and in particular the Custom Lists. I created a basic list last Friday, I've now gone in to amend 'The Type of information in this column is' part of the list and there are no options. How can I do this? In addition, how do I delete a column from within a list? Thanks. Tag: What version of SQL am I using? Tag: 66993
  - 20
    - Error When I try to open Central administration of WSS 3.0 SP1 THe WSS was working fine and today I get the following Error when I try to open the Cental Administration of WSS. Error: "HTTP/1.1 404 Connection: close Date: Mon, 09 Jun 2008 09:38:48 GMT Server: Microsoft-IIS/6.0 MicrosoftSharePointTeamServices: 12.0.0.6219 X-Powered-By: ASP.NET " Tag: What version of SQL am I using? Tag: 66990
  - 21
    - Cannot save document if the versioning is enabled I need help please. I have a document library with versioning enabled. If I save the excel spreadsheet to the document library - i'm getting "Internet Address is not valid" error. When I turn off the the versioning, it works fine. I reinstalled the sharepoint and it's still doing it. Please help... Tag: What version of SQL am I using? Tag: 66987
  - 22
    - dataviews.... help please hi all I'm new to sharepoint\sharepoint designer etc but have the job of trying to build up a project management type area from scratch. I have the basics in place but am trying to create what i think needs to be a dataview. I have a milestones list and a tasking list. When i click on and view a milestone underneath i want to be able to see all the associated tasks that have that milestone associated. The tasking list has a column which looks up a milestone and allows the user to select one. I am using sharepoint designer to edit the dispform.aspx in milestone and then try to insert new datasource i then select the datasource by chooing the tasking list and then drag and drop the milestone field across. I'm not too sure what to do next. Have played around with the filter but cannot get the associated tasking to show. I'm guessing that i am missing out a chunk of the process and some help would be greatly appreciated. Thanks Tag: What version of SQL am I using? Tag: 66983
  - 23
    - "Created By" as part of formula? In Sp 2004, is there any way to include the Created By field as part of a formula? Tag: What version of SQL am I using? Tag: 66981
  - 24
    - WSS 3.0 quick launch links are hidden from some users hi i'm running wss 3.0 sp1, i have set it for all NT users to have view access but some users do not see all the sites on the quick launch that are created. thx monica Tag: What version of SQL am I using? Tag: 66980
  - 25
    - Need help with Search I needed to migrate a WSS 3 server to new hardware. It is up and running with the exception of search. I ended up creating a new Search database as the first one created when I installed WSS gave errors and would not run. I can start a full crawl and see the CPU spike and the search service and SQLServer running hard. The event logs show the search session run, master merge complete, etc. The Search MDF file is about 18M right now and the log file 15. The mdf file on the old server was about 36M... not a lot, but I could search for everything. I have checked via stsadm and search is set on the content database so it should crawl. I set the SQL ##SSEE and Search services to run under the same account that the application pool runs under. Search gives no results. Even for new content. Wait a day, nothing. Trigger full crawls, nothing. When I stop and restart the SQL server ##SSEE I get these: Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: Database Event ID: 5586 Date: 6/7/2008 Time: 4:42:29 PM User: N/A Computer: GSP Description: Unknown SQL Exception 232 occured. Additional error information from SQL Server is included below. A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - The pipe is being closed.) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. --- Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: Database Event ID: 5586 Date: 6/7/2008 Time: 4:42:34 PM User: N/A Computer: GSP Description: Unknown SQL Exception 232 occured. Additional error information from SQL Server is included below. A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - The pipe is being closed.) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. --- Event Type: Warning Event Source: Windows SharePoint Services 3 Search Event Category: Gatherer Event ID: 2436 Date: 6/7/2008 Time: 4:42:35 PM User: N/A Computer: GSP Description: The start address <sts3://gsp:48974/contentdbid={e7194099-eea1-4fac-bb1c-bed789da4cc5}> cannot be crawled. Context: Application 'Search index file on the search server', Catalog 'Search' Details: Error in the Site Data Web Service. (0x80042616) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. --- Event Type: Error Event Source: Windows SharePoint Services 3 Search Event Category: Gatherer Event ID: 2424 Date: 6/7/2008 Time: 4:42:35 PM User: N/A Computer: GSP Description: The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again. Context: Application 'Search', Catalog 'index file on the search server Search' For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. --- Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: Database Event ID: 5586 Date: 6/7/2008 Time: 4:45:01 PM User: N/A Computer: GSP Description: Unknown SQL Exception 232 occured. Additional error information from SQL Server is included below. A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - The pipe is being closed.) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. --- Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: Timer Event ID: 6398 Date: 6/7/2008 Time: 4:45:01 PM User: N/A Computer: GSP Description: The Execute method of job definition Microsoft.SharePoint.Search.Administration.SPSearchJobDefinition (ID 5cc3d5db-a3ba-47e4-8df3-bc2c983c2763) threw an exception. More information is included below. A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - The pipe is being closed.) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Can anyone suggest where to look? Steve Tag: What version of SQL am I using? Tag: 66979
- Next
  - 1
    - WSS FAQ additions and corrections - 1st - 7th June 2008 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. (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 1st - 7th June 2008 NOTE: Amendment to KB articles: Microsoft are not not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance). This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0). Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place. I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me. I.1 2007 KB Articles (*now only one section for WSS and MOSS*) New or Modified None I.b Forefront KB Articles New http://support.microsoft.com/kb/952164/en-us The recommended backup and restore procedure for Forefront Security for SharePoint 4th June 2008 Modified None I.c InfoPath 2007 KB Articles New or 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://go.microsoft.com/fwlink/?LinkId=120119&clcid=0x409 Checklist: Deploying Service Pack 1 for Microsoft Office SharePoint Server 2007 2nd June 2008 (date added) B. Other Office 2007 products http://download.microsoft.com/download/1/e/c/1ec46e32-734f-40a2-a09b-1410a8c81f00/FSSP_datasheet_April08.pdf Microsoft Forefront Security for SharePoint datasheet 4th June 2008 (date added) C. Other relevant products None Modified None Deleted None III WebCasts (+ PodCasts, On-Line courses) for 2007 Products http://www.microsoft.com/downloads/details.aspx?familyid=8111d71e-d79b-4c7d-bc0e-e958af2e545f&displaylang=en&tm Building Simple Custom Approval Workflows with InfoPath 2007 Forms (Video) 31st May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=b54bb271-19ed-43c4-9d9f-a70f1cd6e715&displaylang=en&tm Pulling CRM Data into InfoPath 2007 Browser Forms (Video) 31st May 2008 https://msevents.microsoft.com/CUI/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=1297327790 Microsoft?s Internal Use of Rights Management Services (RMS) and Best Practices 28th May 2008 http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032380233&EventCategory=3&culture=en-US&CountryCode=US MSDN Virtual Lab: A SharePoint Developer Introduction - Web Parts - C# 22nd May 2008 IV WSS v3 FAQ New http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1389 III.68.08 Admin Basics: What do I need to do to have more than two site collection administrators? http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1390 V.121 Microsoft Sharepoint Designer 2007 Bible (Wiley UK - Vikram Kartik) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1388 VI.106 Nintex Reporting 2008 (commercial - Nintex) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1391 VI.107 Chart Plus Web Part (commercial - Bamboo Solutions) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1387 VII.30A Microsoft Office SharePoint Server 2007 Administrator?s Companion - Chapter 16 Enterprise search and indexing architecture and administration (MSPress) Modified http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=844 V.20 SharePoint Designer 2007 for Dummies (For Dummies - Dustin Miller, Heather Solomon) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1332 V.98 The SharePoint Shepherd?s Guide for End Users (privately published - Robert Bogue) *released* (Amazon links now available) --------------------------------------------------------------------------- V WSSv2 KB Articles (plus SPS 2003 Hot fixes) New or Modified None VI WSSv2 FAQ New None Modified http://wss.asaris.de/sites/walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=198 III.64.1 I am getting "#50070: Unable to connect to the database STS_Config?". What's my problem? VII. MS Articles New None Tag: What version of SQL am I using? Tag: 66978
  - 2
    - Sharepoint Services 2.0 Hi All, May I know which Sharepoint Service version is bundled in WIndow Storage Server 2003? One of the system requirements for Business Portal is Sharepoint Services but it can only support 2.0. All inputs will be appreciated. Tag: What version of SQL am I using? Tag: 66976
  - 3
    - Questions regarding installing "Application Templates for Windows SharePoint Services 3.0" I'm trying to install some application templates for my new WSS 3.0 site. I'm using the documantation below and have run up against an error message I need assistance on. I've already completed the first part "To install the Application Template Core solution" with no errors so I'm now working on the second part "To install an Application Template". In Step #6 - "Next, run "stsadm -o deploysolution -name <template_name>.wsp -allowgacdeployment". Additional attributes may be required based on your Windows SharePoint Services configuration. I get this message at the end "Please specify either '-immediate' or '-local' or 'time' parameter. Now I assume this is in relation to the end of Step #6 where it says "Additional attributes may be required based on your Windows SharePoint Services configuration." Anybody no what this means and which attribute I need to use and where in the command line I insert the attribute? Thanks in advance. APPLICATION TEMPLATES FOR WINDOWS SHAREPOINT SERVICES 3.0 ********************************************************* ========================================================= To install the Application Template Core solution: ========================================================= To deploy the Application Template Core solution on a server running Windows SharePoint Services, follow these instructions. Note: To complete the following installation, you must have Administrator rights to both the Windows SharePoint Services site and server on which it is to be installed. 1. Download the solution EXE file to your computer. 2. Run the EXE file to unpack the template file to a location on your computer. 3. Select the solution file, ApplicationTemplateCore.wsp, from the extracted distribution. This solution file will be added to the Windows SharePoint Services solution store. 4. Via command line, run "stsadm -o addsolution -filename ApplicationTemplateCore.wsp" 5. Next, run "stsadm -o deploysolution -name ApplicationTemplateCore.wsp -allowgacdeployment". Additional attributes may be required based on your Windows SharePoint Services configuration. 6. Finally, run stsadm -o copyappbincontent 7. The Application Template Core solution has now been added to the solution store, and deployed on the server. ========================================================= To install an Application Template: ========================================================= This server admin template is deployed in the Windows SharePoint Services environment as a solution. To deploy a solution on a server running Windows SharePoint Services, follow these instructions. Note: To complete the following installation, you must have Administrator rights to both the Windows SharePoint Services site and server on which it is to be installed. 1. Before installing any Application Template, you must first install the Application Template Core solution, ApplicationTemplateCore.wsp. If you have already installed this solution, proceed to Step 2. Otherwise, browse to the following URL to download the Application Template Core solution. http://go.microsoft.com/?LinkId=5922037 2. Download the application template solution EXE file to your computer. 3. Run the EXE file to unpack the template file to a location on your computer. 4. Select the solution file, <template_name>.wsp, from the extracted distribution. This solution file will be added to the Windows SharePoint Services solution store. 5. Via command line, run "stsadm -o addsolution -filename <template_name>.wsp" 6. Next, run "stsadm -o deploysolution -name <template_name>.wsp -allowgacdeployment". Additional attributes may be required based on your Windows SharePoint Services configuration. 7. The Application Template solution has now been added to the solution store, and deployed on the server. Tag: What version of SQL am I using? Tag: 66973
  - 4
    - WSS 2.0 anonymous access Hello, I have a virtual server site on my sharepoint services machine. I am trying to get just this site setup for anonymous access. I have gone to IIS Management and made the site for anonymous access. Also, I have gone to the individual site settings for manage anonymous access and made the site so anonymous users can access entire web site. However, I am still unable to view the site anonymously. I get prompted to log in and if I cancel I get the unauthorized message. I have read some posts about enabling anonymous access in sharepoint central administration but I do not see the navigation that these posts mention. Thought it may be new to WSS 3.0. Anyone have any thoughts as to why my anonymous access is not working? Thanks, Dan Tag: What version of SQL am I using? Tag: 66969
  - 5
    - how to get user name in VSTA i created a new account(solpro\z1h5503) in sharepoint service, but only return "solpro\administrator" when i use "Application.User.LoginName" in VSTA, but my login user is "solpro\z1h5503" when login in sharepoint services and infopath. i hope return "solpro\z1h5503". i am using active directory. can u help me? thanks Tag: What version of SQL am I using? Tag: 66967
  - 6
    - Could not load file or assembly 'Microsoft.SharePoint.ApplicationPages ERROR: Could not load file or assembly 'Microsoft.SharePoint.ApplicationPages, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. Access is denied. I'm leaving this here in case someone else experiences this..... I had activated a feature at the root of a new portal and after a little while I couldn't access All Site Content or Site Settings, or even use Sign In As A Different User. The change that I made hasn't taken effect because the app pool hadn't recycled itself. The easiest fix for this is to go to the affected nodes, open the web.config for that portal, add a space to the end and then save the changes. Voila, problem solved. Tag: What version of SQL am I using? Tag: 66966
  - 7
    - PDF Files not indexed after installation of PDF IFilter 6.0 Hi! I'm trying to set up my wss site to index contents of PDF files. I've installed PDF IFilter 6.0 and followed instructions in the readme file. In fact, they only thing I couldn't do is Step 6 in readme.htm: 6. [SHAREPOINT ONLY] Add PDF as a file type to be included in the content index. On the SharePoint Site Settings Page, in the Search Settings and Indexed Content section, chose Configure search and indexing. On the Configure Search and Indexing page, in the General Content Settings and Indexing Status, choose Include File Types. On the Include File Types page, choose Add File Type. On the Add File Type page, in the File Extension box, type PDF for the file type that you want to add to the list of file types for the content index. Choose OK. Maybe I did something wrong or maybe IFileter 6.0 doesn't work for WSS. Is there any way to resolve this? Tag: What version of SQL am I using? Tag: 66959
  - 8
    - email alerts How can I get an alert on my computer screen when I recive an emasil on my Gmail account? Steve G Tag: What version of SQL am I using? Tag: 66956
  - 9
    - Sharing pdf files between several sites Hi! I'm building a local intranet site for our company, where there're several sites for each department. I have many PDF files in various folders spread around several file servers. Each department has certain permissions on folders containing this data. I need to reflect that in my WSS site without uploading same pdf files in each site if possible. Let's say, the structure of the intranet site is like this: Home // Sales // Purchase // Administration // Accounting etc. Let's say that Sales has access R+W to pdf files in folder A, and Purchase department has R access to the same folder. I also need to make those pdf files be visible both under Sales shared documents and Purchase department shared documents since Sales must not have access to the Purchase department's site. How can this be accomplished? Tag: What version of SQL am I using? Tag: 66955
  - 10
    - test test Tag: What version of SQL am I using? Tag: 66951
  - 11
    - Full-text search of .sql files Hi All- I'm trying to make .sql files searchable on our Sharepoint installation. I've added the .sql file type to the list of file types to search, updated the indexes, even reset the indexes & recreated them. I've gone to the server & added the extension to the registry, in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ContentIndexCommon\Filters \Extension\ section, I've made it a duplicate of the entry for .txt files. I've restarted the MS Search Service, the Microsoft SharePointPS Search Service, even restarted IIS. Nothing works. Anyone have any ideas? Thanks, Tim Tag: What version of SQL am I using? Tag: 66950
  - 12
    - WSS 3.0 Calendar Edit "Manage Lists" permission failing I have WSS 3.0 and I have set the calendar advanced settings/Item-level permissions so people can only edit the entries they make. According to the page, so long as the user does not have the "Manage Lists" permission, they will be unable to edit any entries they do not make. To test this, I logged in as a user in the Contribute group (which does not have "Manage Lists" permission. and created an item in the calendar. I logged out and logged back in as another user in the Contribute group, and was able to successfully edit the item. I'm in a bit of a quandry because this is directly contrary to the information about permissions, I should be unable to edit an item that I didn't create. Any ideas? Tag: What version of SQL am I using? Tag: 66949
  - 13
    - Projects - Modified date Using WSS 3.0 and created a Project web part and noticed there is no tracking of when a project task is updated. its hard to figure out which parts have been updated in a project due to this. Our work around at this point is to modify the title of the task to append the modified date to it, but thats rather silly. I tried to add a new column and make it a date/time but thats clunky at best. Any suggestions? Thanks Justin Tag: What version of SQL am I using? Tag: 66948
  - 14
    - Seeking good documentation for migrating websites and data from WSS 2.0 to WSS 3.0 I have an SBS 2003 Server environment with WSS 2.0 companyweb. I've installed WSS 3.0 in a side by side installation as recommended by MS documentation. Both sites are up and running just fine. We are now ready to go production with the new WSS 3.0 companyweb site. The WSS 2.0 does contain another subsite as well as calendar, links, announcements and Docuamnts. So now I need to import or migrate from WSS 2.0 to WSS 3.0. I'm looking for feedback on the best methods and or tools as well as success and failure stories. We're not talking alot of stuff here to migrate. I can manually do it I suppose but would prefer not to if there is a tool or method that is less time consuming and easier. thanks. Tag: What version of SQL am I using? Tag: 66937
  - 15
    - Where are files stored? I'm a newbie in a Windows SharePoint Services. I'm building a document repository. I've dragged and dropped doguments through the Web interface to sharepoint portal and I can see those documents in the portal. But, where are those files I've uploaded are actually stored? How to setup folders where those files must actually be placed on a file system. Tag: What version of SQL am I using? Tag: 66935
  - 16
    - Integrating WSS with SQL Server 2005 express I need to build a web application in WSS that will do the following functions: 1) Accept user input through the form 2) Do a search against SQL Server database for a keywords based on user input 3) Output results to a webpage In general like this. Where can I get some good instructions on accomplishing that? Thank you! Tag: What version of SQL am I using? Tag: 66934
  - 17
    - Question/Feedback for MS Product Managers in SharePoint & InfoPath I would like to post a question/feedback for the Product Managers of SharePoint and InfoPath. (Alex Xie... could you pass this along to the Product Managers?) I would also appreciate feedback from the rest of the community to see if you agree with this. I really enjoy using SharePoint and InfoPath. I've been using the combination for about nine months now and find it has a lot of potential for enterprise use. I do, however, want to pass along my frustration with finding solutions to development roadblocks. I have lots of information sources, but I have still had a tough time finding solutions. Iâ??ve tried Newsgroups, Forums, Web searches, blogs, and online book systems. It seems to me that there is limited information about InfoPath with WSS/SharePoint. That makes me worry that maybe MS isnâ??t fully behind this product combination. I have both MSDN and TechNet subscriptions, but neither offers a managed newsgroup for InfoPath. I use InfoPath almost exclusively with WSS 3, so I have to try posting questions to the WSS group and hoping that the managed newsgroup team feels that the question is appropriate. When the issue is clearly WSS related, the Managed Newsgroup team has done a great job of helping me. Crosscutting issues between InfoPath and SharePoint, however, are sometimes rejected as not appropriate for the WSS newsgroup. When I've had purely InfoPath issues, however, there is little help available. The non-managed InfoPath newsgroups seem to have very low activity. Alex Xie from the managed newsgroup team recently pointed me toward the forums. I understand that these are becoming a focus for the MS teams. My recent question there, however, took several days to get a response from a community member. It's not just the forums and newsgroups that are frustrating regarding InfoPath & WSS. I have access to 24x7 Books, but nine months ago there were NO InfoPath books there. I asked 24x7 to look at that and they have slowly added six books on the topic. Safari also offered a limited selection. Web sites and blogs about InfoPath with SharePoint are also more limited than I've found for other tools. Only a handful of MVPs offer info on SharePoint/Infopath. SharePoint has a better community, so you might ask why this community should care about InfoPath? My experience is that SharePoint is limited without InfoPath's forms abilities. SharePoint can have a strong presence in our enterprise environment when it fully teams with InfoPath. MS has done a lot to make the software work together, but it can't spread out unless developers feel comfortable with the level of support. I don't want to use up my MSDN/TechNet phone call on issues but I need to resolve them without waiting days for advice. This lack of information makes it an uphill struggle to advocate SharePoint throughout the enterprise. So, my suggestion for the MS Product Managers is that there be more effort in building a community of developers around InfoPath & SharePoint. There should be a managed newsgroup (or forum) for InfoPath or InfoPath with WSS/MOSS. Not many developers would be willing to take the leap I have in trying to learn how to make the two products work. I'm excited about what I've learned, but I don't think I would recommend that other developers try this route at this time. Iâ??m posting this here hoping that the Managed Newsgroup team will pass this along to the appropriate MS people. In addition, ***I would appreciate feedback from the SharePoint community.*** Your support here could help MS pay attention. If you have integrated WSS/MOSS with InfoPath, have you found similar issues? Are there support resources I am missing? I'm hopeful that the non-managed Forums will be better than the non-managed Newsgroups. I think MS should do more to support a community of developers using WSS with InfoPath. A managed Newsgroup or Forum would be a great first step. Please share your thoughts! Tag: What version of SQL am I using? Tag: 66933
  - 18
    - Stored proc and dataview. Hey all, I have a stored procedure which i have one parameter in built username which i am passing the current users username. I'm having the following issues when i attempt to change the filter or add additional parameters after i've added the stored procedure into a data view webpart. The data view breaks and no data is available afterwards. Is it even possible to apply filter's on data from a stored proc in a dataview? Tag: What version of SQL am I using? Tag: 66931
  - 19
    - Using html forms to create new document or list item? Has anyone tried this or know how it would work? Is it even possible? I don't have InfoPath. Tag: What version of SQL am I using? Tag: 66930
  - 20
    - Calculated field total of tasks rolling up to a project I've created a "task" list and a "project" list. I'd like to get a calculated field total of all tasks rolling up to a project. Example: Project 1 Task A = 5 hrs Task B = 10 hrs Calculated field for total task hours = 15. Ideally this field would be a column in the Projects list. From what I can see the calculated field in a list can only sum from columns in it's own list. Does anybody know of any workarounds I could do with SharePoint Designer or possibly something easy within Visual Studio (newbie). Thanks, Colin Tag: What version of SQL am I using? Tag: 66928
  - 21
    - Pulling data from InfoPath form submitted as email I'm interested in having users submit InfoPath forms to a Sharepoint site via email, then take the data in the form and perform workflow tasks based on this. As of now we are unable to get the data from emailed forms to be imported into the list. If we submit directly to the library it works fine, but this is a security problem for us. We need to enable users without access to the site to submit forms. We need to do this to preserve privacy on the site-- we need to have multiple submitters but don't want them seeing other folk's data-- and multiple sites is not an option. Tag: What version of SQL am I using? Tag: 66922
  - 22
    - SharePoint Calendar View Issue Hi All, I have just found several issues with Calendar View from WSS 3.0: Unable to filter by [Start Time] and [End Time] I am not sure why these 2 columns doesn't appear in the Filtering column in the View Settings. The workaround found in the internet is to create calculated column for Start Time and and End Time. However, it doesn't work for Recurring Event, the calculated column will show only first recurring event Start Time. Unable to use "Group By" When I create new view in Calendar using format: "Standard View, with Expanding Recurring Events", there is no option to specify "Group By". Anyone knows how to show all recurring event in List view and grouped by Start Time (or any other column). Thank you and apprecate for any idea. Tag: What version of SQL am I using? Tag: 66918
  - 23
    - Workflows dont run after deploy (but I open and save ...) Ciao to everyone. I build a sharepoint site (WSS 3.0) with SP Designer. In this site there are many workflows. After testing I saved the site as template, but when I created a new site using template I got a surprise because some workflow dont run (Error: Impossible start). So I opened the workflows with Designer (on the new site) and saved it without any modify. After this action the workflows run correctly. Do you can understand why? Do you think what I can do to resolve this problem? I must deploy the site on a Sharepoint Server where I can't operate with SP Designer. Thanks Tag: What version of SQL am I using? Tag: 66914
  - 24
    - WSS FAQ additions and corrections - 25th - 31st May 2008 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. (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 25th - 31st May 2008 NOTE: Amendment to KB articles: Microsoft are not not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance). This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0). Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place. I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me. I.1 2007 KB Articles (*now only one section for WSS and MOSS*) New http://support.microsoft.com/kb/952172/en-us Event ID 2436 is logged in the Application log when you search for a URL in SharePoint Server 2007 30th May 2008 http://support.microsoft.com/kb/953127/en-us How to integrate SharePoint Server 2007 or Windows SharePoint Services 3.0 with SQL Server 2005 Reporting Services by using the Reporting Services Add-in 30th May 2008 http://support.microsoft.com/kb/951654/en-us Duplicate workflows are displayed after you create a SharePoint Server 2007 site from a site template 29th May 2008 Modified http://support.microsoft.com/kb/952167/en-us Folders may have to be excluded from antivirus scanning when you use a file-level antivirus program in Windows SharePoint Services 3.0 or in SharePoint Server 2007 (ver 4.0) 28th May 2008 http://support.microsoft.com/?kbid=950947 Support information for using Forefront Security for SharePoint on a Windows Server 2008-based computer or on a Windows Vista-based computer (ver 2.0) 22nd May 2008 I.b Forefront KB Articles New None Modified None I.c InfoPath 2007 KB Articles New or 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.microsoft.com/downloads/details.aspx?familyid=d41140ab-0ea3-47c7-be56-f42424166608&displaylang=en&tm SharePoint IT Pro and Developer Training Resources Sheet 30th May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=5474a014-0298-4c45-a8f4-f3e38abfc424&displaylang=en&tm SharePoint Products and Technologies Document: Developing Custom Applications with SharePoint Server 2007 (ver May08) 30th May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=3bfa11be-815a-414d-b69f-c2add07d8733&displaylang=en&tm SharePoint: A Platform for Enterprise Mashups 30th May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=6231f77e-a8d5-43b2-a8d8-a9bb60304505&displaylang=en&tm SharePoint Server 2007 Internal Buzz Kit 30th May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=25f9cc59-4ea3-4381-8b37-9430f664eac6&displaylang=en&tm PPTs and Demos for Introductory SharePoint Developer Modules (an msi file to install these) 29th May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=b47a2590-3f3c-42e8-b9f1-334d65a88c4a&displaylang=en&tm SharePoint Deployment Planning Services Overview Brochure 27th May 2008 http://www.microsoft.com/downloads/details.aspx?FamilyId=2BE66504-21FB-4130-844C-0F89DA54515F&displaylang=en Enterprise Search Indexing Connector 2008 for EMC Documentum (works with "Microsoft Office SharePoint Server 2007, Microsoft Search Server 2008, or Microsoft Search Server 2008 Express installed and configured") 23rd May 2008 http://www.microsoft.com/downloads/details.aspx?FamilyId=150004F9-FA15-41C6-902B-202AD2FC16D2&displaylang=en Enterprise Search Indexing Connector 2008 for IBM FileNet (works with "Microsoft Office SharePoint Server 2007, Microsoft Search Server 2008, or Microsoft Search Server 2008 Express installed and configured") 23rd May 2008 B. Other Office 2007 products (selected few only since 1.1.2007) http://www.microsoft.com/downloads/details.aspx?familyid=5c4e9dea-ab34-40f6-8c73-bd94051331b4&displaylang=en&tm Windows Small Business Server 2008 (RC0 = Release Candidate 0) (includes WSS 3.0 so included here despite being only a release candidate) 28th May 2008 C. Other New 2006/2007/2008 Products (selected few only since 1.1.2007) http://www.microsoft.com/downloads/details.aspx?familyid=82e632a7-faf9-41e0-8ec1-a2662aae9dfb&displaylang=en&tm Microsoft Dynamics CRM 4.0 Software Development Kit (ver 4.0.5) 30th May 2008 (relevant to SP and an SDK) Modified None Deleted None III WebCasts (+ PodCasts, On-Line courses) for 2007 Products http://www.microsoft.com/downloads/details.aspx?familyid=b885dce8-c93f-48aa-b798-4422febcc200&displaylang=en&tm Hands on Labs for Developing Applications on Windows SharePoint Services 3.0 30th May 2008 http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032378833&Culture=en-US MSDN Webcast: Introduction to SharePoint Products and Technologies for .NET Developers: Using Event Handlers (Level 200) (Andrew Connell, Independent Consultant) 27th May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=dd1fac2c-2d6b-449c-8d28-2e28ee96b6e1&displaylang=en&tm Windows SharePoint Services 3.0 Demo: Boost teamwork with a wiki 27th May 2008 http://www.microsoft.com/downloads/details.aspx?familyid=b300ccfd-5fb1-4e77-a6c4-2639248642b0&displaylang=en&tm Outlook 2007 Demo: Work with SharePoint calendars 27th May 2008 http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032378831&Culture=en-US MSDN Webcast: Introduction to SharePoint for .NET Developers: Silverlight and SharePoint Server (Level 200) (Andrew Connell, Independent Consultant) 27th May 2008 http://www.microsoft.com/winme/0804/32391/ConnectorTraining_EMCDocumentum/index.html Installing and Configuring Enterprise Search Indexing Connector 2008 for EMC Documentum (Video) (requires Siverlight) 25th May 2008 (date added) http://www.microsoft.com/winme/0804/32391/ConnectorTraining_IBMFilenet/index.html Installing and Configuring Enterprise Search Indexing Connector 2008 for IBM FileNet (video) (requires Siverlight) 25th May 2008 (date added) http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032378829&CountryCode=US MSDN Webcast: Introduction to SharePoint for .NET Developers: Data Lists (Level 200) (Robert L. Bogue, Thor Projects LLC) 21st May 2008 IV WSS v3 FAQ New http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1385 VI.105 blueKiwi SharePoint connector (commercial - blueKiwi) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1382 X.123 SharePoint autocomplete lookup field with AJAX (free - Stephane Eyskens, Codeplex) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1383 X.124 SharePoint Custom Field - Variation labels (free - Codeplex, Gael Duhamel) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1384 X.125 Application Pool Manager (free - Spencer Harbar) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1386 X.126 SharePoint List columns manager (free - Codeplex, StephaneEyskens) Modified http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1363 V.113 Professional Workflow Design Patterns for Microsoft Office SharePoint Server 2007 (Wrox - John Holliday) (new and much later date of issue) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1379 V.119 Inside SharePoint Administration (Charles River - Steve Caravajal, Shane Young, Todd O. Klindt) (Has suddenly acquired two new authors who actually do know a lot about SP *Administration*!) --------------------------------------------------------------------------- V WSSv2 KB Articles (plus SPS 2003 Hot fixes) New or Modified None VI WSSv2 FAQ New or Modified None VII. MS Articles New http://www.microsoft.com/downloads/details.aspx?familyid=3c6c7a37-82cb-46c4-a300-902d184c9d96&displaylang=en&tm Microsoft Windows SharePoint Services 2.0 (2003) Management Pack for OpsMgr 2007 (ver 6.0.6278.0) 27th May 2008 Tag: What version of SQL am I using? Tag: 66913
  - 25
    - wss 3.0 survey issue For some reason regardless of whether I add a user with read permissions they're able to export all survey responses to excel. Are people experiencing the same issue as well? Is there a way to fix this issue? I tried changing the advanced settings so that they can only read and edit their own responses but it seems like they're still able to export to excel. TIA, Jackson Tag: What version of SQL am I using? Tag: 66910

Hi nd please pardon my ignorance or lack of knowledge regarding SharePoint
and SQL. I have WSS 2.0 SP3 as well as WSS 3.0 SP1 running on my SBS 2003
SP1 server. Now when I look in Add/Remove Programs I can see that I have
both MS SQL Server 2000 and MS SQL Server 2005 as well as all of the MS SQL
Desktop versions that came with SBS 2003. When I use Enterprise Manager I
see

Console Root
Microsoft SQL Servers
SQL Server Group
(Local) (Windows NT)
Servername\SHAREPOINT (Windows NT)

I've got a few questions and if you could please answer them for me it sure
would help me understand a few things better.

When I look under (Local) (Windows NT) / Databases I see the default
databases I think.
Master
Model
msdb
Northwind
pubs
tempdb

When I look under Servername\SHAREPOINT (Windows NT) I can see the
STS_SERVERNAME_1 and STS_CONFIG databases which I know are the WSS 2.0
companyweb databases.

1. How do I determine which versions of SQL I am using for both WSS 2.0 and
3.0.
2. Where are the WSS 3.0 databases located.
2. Can you please provide some input as to what I am seeing above and what
they are.

Top

Re: What version of SQL am I using? by Mike

Mike
Fri Jun 13 12:07:56 CDT 2008

You almost certainly used the *SBS 2003 only* side-by-side installation
to get both WSS 2.0 and WSS 3.0 installed on your machine.

Because that is a purely SBS 2003 procedure and also because you ask
about companyweb that only SBS 2003 has, I suggest that you post this
question to the SBS 2003 newsgroup which is microsoft.windows.server.sbs

Mike Walsh
WSS FAQ http://www.wssfaq.com / http://wss.collutions.com
no questions by e-mail please

SharePoint Newbie wrote:
> Hi nd please pardon my ignorance or lack of knowledge regarding SharePoint
> and SQL. I have WSS 2.0 SP3 as well as WSS 3.0 SP1 running on my SBS 2003
> SP1 server. Now when I look in Add/Remove Programs I can see that I have
> both MS SQL Server 2000 and MS SQL Server 2005 as well as all of the MS SQL
> Desktop versions that came with SBS 2003. When I use Enterprise Manager I
> see
>
> Console Root
> Microsoft SQL Servers
> SQL Server Group
> (Local) (Windows NT)
> Servername\SHAREPOINT (Windows NT)
>
> I've got a few questions and if you could please answer them for me it sure
> would help me understand a few things better.
>
>
> When I look under (Local) (Windows NT) / Databases I see the default
> databases I think.
> Master
> Model
> msdb
> Northwind
> pubs
> tempdb
>
> When I look under Servername\SHAREPOINT (Windows NT) I can see the
> STS_SERVERNAME_1 and STS_CONFIG databases which I know are the WSS 2.0
> companyweb databases.
>
>
>
>
> 1. How do I determine which versions of SQL I am using for both WSS 2.0 and
> 3.0.
> 2. Where are the WSS 3.0 databases located.
> 2. Can you please provide some input as to what I am seeing above and what
> they are.
>
>

Top