Can we have backend as SQL 2005 for data storage?

TheMSsForum.com: The Microsoft Software Forum

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

- Previous
  - 1
    - Smigrate.exe Exception Hi All I am trying to execute Smigarte for more then one time.. Its working fine , but for particular URL its creating more then one backup file on its own. When i am trying to restore the site , its not allowing me restore the site because after restoring first file we cannt restore second file at that URL again. Is there any limit on size of backup file ? or what ? I m not able to figure out. Anybody who has solution plz help me out.. Thanx -- Dimy Tag: Can we have backend as SQL 2005 for data storage? Tag: 78175
  - 2
    - test and production installatins Is there any tool or procedure to clone test installation over production (deployed for users) installation. In typical development enviroment we have development, testing and live installations. And the components are moved from one to the other along with development cycle. I thing I should be applied also to developing portal in SPS. What do you thing? What is your practice? Tag: Can we have backend as SQL 2005 for data storage? Tag: 78165
  - 3
    - Restore on the same network Hi there. I am trying to restore sharepoint portal server to another machine on the same network (for testing reasons). My original server is: 2 box win2k3 enterprise SpServices 2.0 SP2003 Portal server (front-end) sql2000 (back-end) I built a new server ( diff name ) installed 2 box win2k3 enterprise- SpServices 2.0 - SP2003 Portal server (front end) sql2000 ( back-end) Will it cause any problem if I restore to the test system? They will be on the same network I mean. Do I need to take any precaution? Thank You Ali Tag: Can we have backend as SQL 2005 for data storage? Tag: 78157
  - 4
    - Usega of SPS versus WSS - philosophy Hi, Could someone put more light on the purpose and limitations of SPS. I'm trying to build community portal on SPS. There is a number of different documents and buletins categorized by subject. My idea was to put everything on SPS in libraries in different areas. WSS sites would be just for sub-communities to narrrow down the audience for some contents and tasks. But after some test I a little bit dizzy. Perheps I doesn't make sens to keep libraries in Portal? In that way we come to idea of SPS with WSS. I know that MS sees SPS as glue...consolidation and some additional functionality like better search etc. But does that mean that SPS is just for keeping static contents and links to WSS contantents? hmmm Tag: Can we have backend as SQL 2005 for data storage? Tag: 78150
  - 5
    - Documentaion on WebParts I'm looking for good funtional documentation about each web part. Sometimes they behave differently than I could expect. I fact I haven't seen comprehensive description part by part. Tag: Can we have backend as SQL 2005 for data storage? Tag: 78149
  - 6
    - Custom DateFormat on Sharepoint Sites Is it possible to set a custom date format such as dd-MMM-yyyy (for ex: 08-Apr-2006) for all the dates that get displayed on Sharepoint ? I checked the Regional Settings but that only changes the locale - I am not interested in changing the locale but customizing the Date format throughout Sharepoint. Regards, Vikram Tag: Can we have backend as SQL 2005 for data storage? Tag: 78144
  - 7
    - Hierachical relations between Fields in Documentlibraries Hello Is it possible to have hiearchical relation between fields for the elements of a documentlibrary. E.g. there is a country-field and when you choose a a country the county field entries have to change according to the selected country. Thanks for your help. Mike Tag: Can we have backend as SQL 2005 for data storage? Tag: 78138
  - 8
    - Filter for null value Hi All, Is there a way to apply a null filter against a filed type of "multiples line of text". I simply want to show only those rows where this field is empty. Regards, Sumit Tag: Can we have backend as SQL 2005 for data storage? Tag: 78137
  - 9
    - access request I have 3 users who are administrators on this site...I am the person who created this site. The access - request go out to admin no3 , but they go out as me or my email address...how can I fix this ? Tag: Can we have backend as SQL 2005 for data storage? Tag: 78136
  - 10
    - Sharepoint and BAM for Biztalk 2004 I know BizTalk 2006 has an out-of-box portal for BAM in Sharepoint. Does anyone know how to do this for BizTalk 2004? Or... Any resources on making a sharepoint portal using data in an excel sheet (e.g. the BAM excel sheet)? Thanks. Tag: Can we have backend as SQL 2005 for data storage? Tag: 78135
  - 11
    - Migration Share Point sites to sharepoint farm Hi, at beggining we have installed SharePoint on one server and started to use it and test it. Now we have builded A share Point portal system with two Load balanced servers and one Index sereve and we want to mifarte some of the sites from first server. Please instruct me how to do this? I know for smigrate tool but will I have problems because I am migrating from one server to two servers which are in NLB Tag: Can we have backend as SQL 2005 for data storage? Tag: 78134
  - 12
    - One site but not the default one Hi, Is it possible to have a site portal with Sharepoint portal server 2003, on a virtual directory on TCP port 8080 (not the default web site, and not port 80) and SSL 443 + Basic authentification ? The goal is to have only one portal site for the intranet and the extranet. Thank's Tag: Can we have backend as SQL 2005 for data storage? Tag: 78127
  - 13
    - SPS backup of small farm We are trying to get spsbackup.exe to work in our small farm (1 server - SPS, 1 server - SQL). We are trying to save the backup files to the C drive on the SPS box. When I run the spsbackup GUI, I always get an error. When I check the error logs in SPS and on the SQL machine, the error is "Unknown user or bad password". The funny thing is that the _SERV seems to back up fine; but when it starts to backup the _SITE, I get the error. To me it seems that SQL does not have access to the SPS server. Has anyone seen this before? Thanks for your help. Rob Cuscaden Tag: Can we have backend as SQL 2005 for data storage? Tag: 78125
  - 14
    - Editing Data in a View via Sharepoint Web Part Office Datasheet I am able to edit data in a SQL table via the Sharepoint Web Part "Office Datasheet". BUT when I try to edit data in a SQL view via the same Sharepoint Web Part "Office Datasheet" it does not let me edit the fields. I know the view allows edits to the data because I can do an update statement to the view in SQL. I am thinking there is some constraint in the web part that if a view is chosen then the fields are not editable. Any ideas? Tag: Can we have backend as SQL 2005 for data storage? Tag: 78120
  - 15
    - Creating an ASP.NET V2 web application using WSS Hello everyone i'm new to the sharepoint world but have good experience in .Net application. I'm studying a development of a web application which will be host on a SBS server with sql server 2005 and I would like to take advantage of WSS for file sharing, web parts, site templates, etc. As i understood WSS is also possible on SQL2005. I allready have a database like let say AdventureWork which is the main store of my application. My first question is how does the merging or relation between those two databases possible ? Can i merge the two easily? how are user rights and goups related? Is it possible to create web part using ASP.NET V2 using my custom tables and integrate easily in a WSS site. What is support for multi-language, how is it handled. And finally can i use some AJAX async controls (like the telerik suite) web parts (using WSS tables and my custom tables) If someone experienced could help me a bit in understanding all the bits and pieces it will be very appreciated. And if you know some goog documentations out there let me know. Thanks mateo Tag: Can we have backend as SQL 2005 for data storage? Tag: 78116
  - 16
    - Priviliges in SPS do not work That is very strange. In my current installation it looks like any user has admin rights. I assign different groups to users (reader, contributor etc.) but there no differences. E.g. user with reader right currently can add document and e.g. reject document of other user (even with if the other has admin rights). Has I done somenthing wrong during the installation? I face that in Portal, but the same is in WSS???? help Tag: Can we have backend as SQL 2005 for data storage? Tag: 78115
  - 17
    - Search Functiopn stopped working Hi, the Serach function on our Portal Site has stopped working (doesn't return any results) and I'm getting the following error messgae repeated in my App Event log: Event Type: Error Event Source: Microsoft SharePointPS Search Service Event Category: Gatherer Event ID: 3090 Date: 11/11/2005 Time: 10:27:05 User: N/A Computer:orgportal Description: The gatherer files from the previous checkpoint cannot be restored, and this action cannot be completed. The gatherer will attempt to restore the files again. If the problem persists, restart the service, free system resources or verify that your hardware is working properly. Context: http://orgportal/ Application, Non_Portal_Content Catalog Details: The content index is not loaded. Stop and restart the search service. If the problem persists, review other errors in the event log. If necessary, delete and recreate the content index. (0x80041117) I cant seem to find any info on what this error means or how to fix it. Also I've tried clicking on "Configure Search and Indexing" on our servers Site Settings page but this just times out. I've tried restarting the server and applying the latest SP for SPPS and WSPS - nothing has worked. Any help with this would be greatly appreciated! Mike Dower Sys Admin - Ministry of Sound Tag: Can we have backend as SQL 2005 for data storage? Tag: 78114
  - 18
    - Authenticate against AD Domain Group Hi! How can I verify users, if a sharpoint site's permissions are given for seperate AD domain groups and that user belongs to one of these groups. At the moment I can only get the username of the current logged in user. But since his permission (contributor) is given on the AD domain group I would like to see which AD domains groups this user belongs to and compare that to the sites domain groups. Like this 1. UserADGroups = SPUser.GetADGroups() 2. SiteGroups = SPSite.GetSiteGroups() 3. Compare UserADGroups with SiteGroups If the UserADGroup name is equal to SiteGroup return the permission of the sitegroup. Hope you understand my situation //Filip Tag: Can we have backend as SQL 2005 for data storage? Tag: 78113
  - 19
    - sort by relevance not working Has anybody had any problems sorting by relevance? We had a portal 2001 and moved all the documents to portal 2003 - WSS sites. If we do one sort by "Audit" in the text search box and then pick a property "Author contains Tom". If we do this search in the 2001, it shows what we would expect to see. If we do this search in he 2003, we do NOT get the same results. The documents at the top (at least the first two - if not more - should be much lower down in the list). If we click 'Relevance' again it still shows things in the same order. When I hover the mouse over Relevance, I see the javascript link and one time it's 'asc' (ascending) and next time is 'desc' (descending) but it always shows items in the same order regardless of whether or not it is ascending or descending. Once I click Relevance it shows the up arrow (descending) and it never changes again no matter how many times I click 'Relevance'. Anybody have any ideas about what I can do or what is causing this problem. Do other people have the same issue? Thanks, Tom Brophy Tag: Can we have backend as SQL 2005 for data storage? Tag: 78110
  - 20
    - Backing up SPS on SBS 2003 I am just starting to use SharePoint Services and want to make sure I am getting it backed up OK. I am running Veritas Backup Exec v10 and am backing up system state, all files and the SPS database. Am I coverered? In addition I created a batch file to back up http://companyweb using stsadmin.exe. Is this necessary given the above steps? Do I need to use SharePoint Portal Server Data Backup and Restore tool? Thanks in advance, -- Kent Tag: Can we have backend as SQL 2005 for data storage? Tag: 78109
  - 21
    - how do i create a new recruitement portal ? hi Actually I want to create a recruitement portal for my company , which consists of all the details of recruitement process. So i need details to do this .. Tag: Can we have backend as SQL 2005 for data storage? Tag: 78105
  - 22
    - Running Sharepoint and Live Communications on the same server? I was wondering if it was possible to run Sharepoint and Live Communication servers on the same server. If they can not work on the same server, what is preventing them from working together? If they can work together on the same server, what are the preferred system requirements with both services running in a production environment? On a related subject to this, I was wondering several things with Sharepoint: 1. What are the maximum recommended concurrent users? 2. What is the maximum number of active users? Thank you for your time and consideration Tag: Can we have backend as SQL 2005 for data storage? Tag: 78104
  - 23
    - Community site? Is there a sharepoint community site that lists free webparts and components? regards mark Tag: Can we have backend as SQL 2005 for data storage? Tag: 78099
  - 24
    - Adding a news item We have a problem when we add a news item to the portal. On the web part it displays "by Name" The problem is the name is the name of the person publishing the item, not the author. Does anyone know how to change the name, or hide the name? Thanks, Rob. Tag: Can we have backend as SQL 2005 for data storage? Tag: 78094
  - 25
    - info sharepoint 2007 Looking for info about sharepoint 2007, who can help me? Thanks - Derreck Kelp Tag: Can we have backend as SQL 2005 for data storage? Tag: 78088
- Next
  - 1
    - Web Capture Webpart Hi there We would like to integrate Microsoft Web Capture Webpart (one of the Office Web Parts) in Sharepoint. We have two server: - Sharepoint-Server - Database-Server On Sharepoint-server we installed - SPS (english) - Frontpage 2003 (german) - Windows-Updates On Database-server: - SQL Server 2000 with all SPs Sharepoint run without any problems. But I can't install additional Office Web Parts from following page: http://www.microsoft.com/downloads/details.aspx?FamilyID=38be67a5-2056-46a1-84b1-337ffb549c5c&DisplayLang=en) Do you know, what the problem could be? Which language do I have to install? English, right? Sorry for my bad english, I hope you can understand me... :-) Thanks a lot for your help. Best regards, Michael Tag: Can we have backend as SQL 2005 for data storage? Tag: 78087
  - 2
    - SPS configuration for SSL Offload? Any pointers on how to configure SPS to work with a SSL Offload device such as F5's Big-IP? Would prefer if the offload box did not have to do any page rewriting. Thanks Tag: Can we have backend as SQL 2005 for data storage? Tag: 78079
  - 3
    - Sharepoint can't crawl Portal_Content I have this problem , Sharepoint can't crawl Portal_Content. It crawls "Non-portal content", that works fine but when trying to crawl "Portal_Content" I get this error: (the log says) 4/7/2006 4:51 Modify http://elekt1/ The address could not be found, (0x80042616 - Error in the Site Data Web Service. ) 4/7/2006 4:51 Modify sps://elekt1/site$$$people The address could not be found, (0x80042617 - Error in PortalCrawl Web Service. ) 4/7/2006 4:51 Modify sps://elekt1/site$$$site/scope=Portal content The address could not be found, (0x80042617 - Error in PortalCrawl Web Service. ) What can be wrong ??, the site is new and everything else is working fine. //ME Tag: Can we have backend as SQL 2005 for data storage? Tag: 78076
  - 4
    - SPS 2003 Install Problem We are trying to setup SPS 2003 on a Virtual Server pointed to a named instance on an active passive SQL Cluster. When we try to confirure the Single Sign-On Settings, we get an error that it cannot find the database server or permission problems when we go with a database that doesn't exist. I added a database shell, and when we try to use it, we get a warning that the Database already exists, would your like to override the configuration. If we say yes, we get a warning that the database already exists. This is confusing, if we try to have SPS create the database, it cannot find or connect to the server. If we create a shell, and all other varibles are the same, SPS can see it enough to prompt us that it exists, but we still fail. We have used the SQL Client Network Utility to point to the correct IP and Port. We can successfully connect with the credentials using ODBC. But we are hitting brick wall with this step. What can do to get SSO configured? Tag: Can we have backend as SQL 2005 for data storage? Tag: 78064
  - 5
    - Cannot connect to the database hi, im running Sharepoint Portal Server, with a couple of sites, and im having the Error Cannot connect to the database( Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com. ) when the site tries to display some images, not all images but some, i restart the iis, the sharepoint service, i even restart the server, i also add the account of the sharepoint service to domain admins, and i cant see the images, what can i do, about this ? thankx for the help Tag: Can we have backend as SQL 2005 for data storage? Tag: 78063
  - 6
    - Portal Server Uninstall I had WSS 2.0 running on a server and installed Sharepoint Portal Server 2003 on top of it. Apparently that wasn't the correct way to install the Sharepoint Server... the directions said don't install on a server with WSS already installed without following some extra instructions that I, unfortunately didn't read. Now I can't access my old WSS sites I had created before I installed the Sharepoint Server. If I just do an uninstall of the Sharepoint Server, will it revert back to my old WSS 2.0 setup? I installed the Sharepoint Server on a seperate virtual server... thanks, ~john Tag: Can we have backend as SQL 2005 for data storage? Tag: 78061
  - 7
    - SPS v1 to WSS Can I use spout.exe to extract documents from SPS v1 and import those documents to WSS using spin.exe? Thanks, Falgun Tag: Can we have backend as SQL 2005 for data storage? Tag: 78056
  - 8
    - News Archive View Is there a way to keep ALL expired news items in an archive, sorted by Date (newest first), and make that archive available to all users -- including users with only view permissions on the Portal? Tag: Can we have backend as SQL 2005 for data storage? Tag: 78053
  - 9
    - Restore SharePoint Server backup to New Server Hello everyone, I am having a problem while restoring the backup from old server to a new server (with different Names). I tried it with MDF & LDF and could able to take backup from old server and restoring it to a new server but not able to open the site. When I see the tables in the Database I am finding my old server URLs. I even tried with SPS backup and restore utility with that utility also I could able to backup but not able to restore and its throwing any error that I version is different but when I see that its one that and same only. Can you please help me how to restore SPS & WSS Backup to another Server with different name... or do we need to keep the same name by keeping old server offline and connecting the new server to the domain. Basically we are planning to change the server because my current SPS server is having hardware problem and now we have got new server so I am planning to change the server by taking the backup from the Old Server and to new server. Can you please help me out in this regards Thanks in Advance All the best Regards Andrew Tag: Can we have backend as SQL 2005 for data storage? Tag: 78051
  - 10
    - Create a book library Help! I have a general SharePoint Version and would like to create a check-in check-out library for books, audios, videos, dvds, etc... for my department to borrow from other departments learning resources --- but I don't seem to be able to get the formatting or the check-in check-out process --- any suggestions --- thanks! -- flojoe Tag: Can we have backend as SQL 2005 for data storage? Tag: 78050
  - 11
    - Move a survey Hi, Do you know how one can move a survey from one site to one other ? If you do it through windows explorer, it don't works Thanks, Tag: Can we have backend as SQL 2005 for data storage? Tag: 78048
  - 12
    - Frontpage dataviews timing out and requiring an IISRESET Hey, I have a server with WSS sites, and I am using frontpage dataview to display form libraries. recently, the dataview have started showing "The web part has timed out" when people go to the page. an IISRESET command on the server solves it, but only for a few hours. I have tested, and when the problem was active, before doing an IISRESET I added another dataview (to a different page and to the same page - made sure the problem is in all the pages) and while in frontpage everything looked ok, in the page it said "Unable to display this Web Part". again, IISRESET solves that as well. Seeing as we cant have a server that does iisreset every half an hour just to be sure that a single web part is working, and if you take into account that I changed the timeout values in the web.config files, what else can I do? Thanks, Ishai Sagi <Visit my blog! wwww.spstips.blogspot.com> Tag: Can we have backend as SQL 2005 for data storage? Tag: 78047
  - 13
    - extract documents from SPS and WSS Hi, Users have been using shared drive since years and now to make them sure they are not going to lose their documents, they need to have all documents from sps and wss sites to be extracted and backed up everyday/week. does anyone have some sample script to do this. regards -aslam Tag: Can we have backend as SQL 2005 for data storage? Tag: 78046
  - 14
    - script to list users and rights Hi, After giving / changing rights / access to users now some one needs to know who are the users for different Areas, wss sites etc.. I am trying to find a way where I can list all the users and their rights (or roles). Can someone guide me at a right place. regards -aslam Tag: Can we have backend as SQL 2005 for data storage? Tag: 78045
  - 15
    - Cannot get to Central Administration I just installed a new instance of sharepoint 2003 i did the install without the database engine, because i want to use the full version of sql for scalability. right now, i cannot get into the sharepoint central administration page, i keeps prompting me for credentials, which i enter and i get a "you are not authorized to view this page" error, for grins i turned anonymous access on and i get a "page cannot be displayed" error. i am accessing it by both "browing" the site in IIS and going to the sharepoint central administration program. i checked the application pool and i'm ok, i go ot the port and its referencing the right port from what i can tell. i am an admin on the box, the services are set to start under my credentials, as well i have the proper access in sql, though there is no instance of a sql database yet, i haven't been able to create the portal. I am stumped and any info is GREATLY appreciated. Tag: Can we have backend as SQL 2005 for data storage? Tag: 78040
  - 16
    - Setting Alerts on Dataview Parts I have master list Calendars and News sections. Based on some selections, the item will post in the master and be displayed elsewhere in the portal through dataviews created wtih frontpage. When a user set's up an alert for area changes that contain the dataview, an alert is never triggered when a new item is populated. The alerts are only working when setup on the master list. Not the sub area pulling the same data through dataview parts. The new item does come through with the dataview part, and other page changes are discovered by the Alert. But it does not recognize the dataview part. Thanks Chris Tag: Can we have backend as SQL 2005 for data storage? Tag: 78039
  - 17
    - Deploying WSS and SPS together Hi everyone. Apologies for the cross-post, but I didn't know which group to post to. I am trying to understand the licensing implications of a deployment. What I would like to do is deploy WSS+SPS on the same server and expose both to the internet. I would like to create an unauthenticated WSS site for general consumption and then have a collection of sites that require authentication and utilize SPS. I would love to avoid incurring the extra licensing costs for SPS for the unauthenticated site by *not* exposing any SPS functionality, I would like to avoid building a home-grown website for the external folks in lieu of the above, and I would like to avoid buying more hardware to ensure that the two are more segmented. The latter would actually be nice for fault tolerance/availability, but that really isn't a problem for this particular site (right now). I have read the licensing information on both microsoft.com and the MS partner site as well as in the Sharepoint Resource Kit (mspress), but there wasn't anything (in my understanding) that explicitly explained the situation. I think I understand most of the licensing implications of each of WSS and SPS in isolation. That is all very clear from the documentation. I am just wondering about this specific case. Thanks in advance. I hope you're having a nice day. Jef Newsom Improving Enterprises, LLC | http://improvingenterprises.com, http://integralpath.blogs.com Tag: Can we have backend as SQL 2005 for data storage? Tag: 78038
  - 18
    - txtlstvw.aspx Error I am getting a strange error on a portl that I cannot resolve. Any time I try to view a listing on my portal, I get an error "Object Reference not set to an instance of an object" I have tried this with multipl listings, created new listings, ensured that the listing exists in the DB, etc... Can't figure it out. i found someone wiht the exact problem but htey never found a reslution : http://www.sharepointu.com/forums/Hellllllllllllllllllp!!!_:)/m_24379/tm.htm Ideas ? -- Steve Walker Practice Manager, Application Infrastructure <a href=''''''''http://www.geniant.com''''''''>Geniant</a><br><a href=''''''''http://www.sharepointforums.com''''''''>SharePoint Forums</a> Tag: Can we have backend as SQL 2005 for data storage? Tag: 78037
  - 19
    - My Workspace Sites webpart Should this webpart show all document workspaces I have created and am a member of? Mine shows none, even though I am a member and creator of several document workspaces. My collegue has some in his (we are still at the set up stage before going live). Also, how can I show in MySite, all teamsites of which I am a member? cheers steve Tag: Can we have backend as SQL 2005 for data storage? Tag: 78032
  - 20
    - webpart error Hi All, I have installed a webpart at SPS 2003, when I tried to add it to some area, it returns the following error: A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe. How can I solve this? Thanks! Eduardo Tag: Can we have backend as SQL 2005 for data storage? Tag: 78030
  - 21
    - Installing SPS 2003 with SQL Server 2005 failed! Hi all, I tried to install SPS 2003 on my virtual machine which had SQL sequal server installed on it. When I finished all installation steps and not chose to install desktop engine, after installation and creating config. database and other initially required settings, when I wanted to create a new portal site, I got the error on the create new portal sit epage which said: "SPS has discovered that you have front page 2002 or windows sharepoint team services installed on ur virtual server. Remove that otherwise u can't extend the virtual server to create sharepoint sites." these are not the exact words from error but it was like this. I don't know why is it asking to remove sharepoint team services which was installed as part of SPS 2003 installation. If any body has some idea about this, it would be highly appreciated. Thanks in advance Kahkashan Tag: Can we have backend as SQL 2005 for data storage? Tag: 78028
  - 22
    - How to add a flash graphic Hello All, can you tell me if sharepoint support to show a flash image? And if yes can you be so nice as to tell me how to do it? I have added in a area a web-part supporting images but even if I have added the link to the flash image it doesn't show up... Thanks in advance for your help!! :) Tag: Can we have backend as SQL 2005 for data storage? Tag: 78025
  - 23
    - Access Profiles through Contact List Hello, We are currently synchronizing SharePoint PS 2003 profiles with Active Directory. To avoid maintaining double data stores we are looking at migrating our (simple) personnel database into Active Directory and then let users access subsets of the data through Contact List web parts in SharePoint. However, we are unable to find any way of performing the (presumably) simple task of linking a Contact List (or another suitable web part) with the "profile store" or "people data source". Is this seemingly no-brainer functionality simply left out of SPS, or am I just looking in the wrong places? Cheers, GM Don Tag: Can we have backend as SQL 2005 for data storage? Tag: 78024
  - 24
    - IE 6 Crashes when adding new item I am having a problem where Internet Explorer 6 crashes when adding a new item on any sharepoint site. I have installed the beta version of IE7 and it then works fine. Is there a known fix for IE6 that I can't find? Thanks, Jason Tag: Can we have backend as SQL 2005 for data storage? Tag: 78023
  - 25
    - How to recover an deleted contact list Hi, I have by mistake deleted a contact list. Can anyone tell me how i can recover it without using a backup tape? Tag: Can we have backend as SQL 2005 for data storage? Tag: 78017

SQL 2000 is used for data storage of sharepoint. Can we haved SQL 2005 for
the same?

Re: Can we have backend as SQL 2005 for data storage? by Bil

Bil
Mon Apr 10 03:42:20 CDT 2006

Yup, but there might be a few tricks to get it going. Check out the WSS
FAQ for more info:
http://wss.collutions.com/Lists/FAQ/DispForm.aspx?ID=498

I haven't tried the setup yet just because I normally run SQL on the
same box as SharePoint and don't want to do the 2.0 dance yet. In a prod
environment you would probably have SQL on a different box so it's
easier to tweak the 2.0 settings there. My recommendation is to just
wait until MOSS 2007 and full support for SQL 2005 with SharePoint as
there are no real advantages to it (some performance increase). Unless
you're installing SQL and just want to be running 2005 instead of 2000.

--
Bil Simser
SharePoint MVP, BSc., MCSD
Calgary, Alberta
http://weblogs.asp.net/bsimser

"Anj" <Anj@discussions.microsoft.com> wrote in message
news:B545ED83-63EA-4952-A95C-855D510C4EF6@microsoft.com:

> SQL 2000 is used for data storage of sharepoint. Can we haved SQL 2005 for
> the same?

Top