Sharepoint Connection to a Network SQL server

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
    - alert to whole sub(site) Is it possible to enable alerts for a whole sub(site)? I want that the user is notified if anything happens in any list on the site, now I always have to subscribe the users to all the lists seperately in the site. Thanks! Tag: Sharepoint Connection to a Network SQL server Tag: 38252
  - 2
    - WSS SQL 2000 Upgrade Failed I'm running WSS in SBS2003, I upgraded to SQL several month ago, when server was installed. Full text search inbox, doesn't appear. I triy to repeat SQL upgraded, But third radio buton "Upgrade istallation" is not avaliable. I belive that when i upgrade to SQL the first time, the "full-text search" check box wasnt' checked. Â¿Â¿ is it possible to arrange it?? Thanks IVan Tag: Sharepoint Connection to a Network SQL server Tag: 38249
  - 3
    - Add new user In my WSS site when I want add a new user ,before adding I must define the user (username and password)in active directory.If I do not define user before adding I get these error message " user does not exist".(Im using Domain Account Mode for WSS site) Is there any felexsible way that does not need to define users before adding.and add user in our domain without need before definition? Tag: Sharepoint Connection to a Network SQL server Tag: 38248
  - 4
    - Can't view documents I just encountered the strangest problem I've seen yet with WSS. I have a single user who has contributer rights to a site through membership with an Active Directory Group called "Corporate Engineering." All users of this group other than this particular user can use the site fine and without issue. However, when this particular user clicks on the name of the document to open it, either in the web part or the document library itself, his navigation results in a blank IE window with the "image not found" icon in the top left corner. (The white square with the red x in it). The only way the user can see the document is by going to "edit properties" and clicking the "Open in Microsoft Excel" button. This would be an acceptable workaround if it weren't for the PDF's, CAD drawings and other non-office documents that he needs access to. I'm having him try to log on to another machine to see if it is account or machine related now. I will post the results when he completes this request. Tag: Sharepoint Connection to a Network SQL server Tag: 38236
  - 5
    - try again: How to keep the Lib. doc. in the frame? I have a very basic document library but when I open the document it opens full screen. How do I restrict the doc to opening only within the web part frame? -- MarkP Tag: Sharepoint Connection to a Network SQL server Tag: 38235
  - 6
    - archiving/moving discussion board content to "inactive" discussion We're using Sharepoint Services on W2K3 as kind of a "blog" to discuss prepartion of projects, ad campaigns, and trade show booths. Our company exhibits at a couple of trade shows that are held twice a year (fall/spring, winter/summer, or east/west coast). So we'll have a discussion for Trade Show A Summer 2005, Trade Show A Winter 2005, Trade Show A Summer 2004, and similar discussions for the others. Once a trade show has passed, the marketing director wants to remove that discussion from the active discussion board, but keep it on the site in an "Archived Discussions" board so they can go back when needed to see why things were done the way they were the last time, or who handled which aspects of prep. Can someone point me to info on moving discussions between discussion boards? I've Yahoo'd and searche the MSKB and couldn't turn up anything. Thanks. Tag: Sharepoint Connection to a Network SQL server Tag: 38230
  - 7
    - Web Part drop-down menu Minimize and/or Restore problem My users are not seeing anything but a choice for Help when clicking the down arrow on the right side of the WP title bar. In WP Advanced, I have set Allow Minimize. Any ideas on how to let my users Minimize and/or Restore Web Parts? Thank You. Tag: Sharepoint Connection to a Network SQL server Tag: 38226
  - 8
    - Problem running Top-Level website I have a virtual installation of Server 2003 Web using Virtual PC 2004 with Office SharePoint Portal Server 2003 installed. I was able to setup (or extend) a local virtual server as a top level site and point at an Sql 2000 installation on another machine. However, after choosing a template (any template I have found) and browseing to the default home of the top level site, I get the following error: =========================== An unexpected error has occurred. Web Parts Maintenance Page: If you have permission, you can use this page to temporarily disable Web Parts or remove personal settings. For more information, contact your site administrator. Troubleshoot issues with Windows SharePoint Services. =========================== When I check the application event log I see the following two errors: "The safe mode service of Windows SharePoint Services has failed to initialize because of an unknown error." Followed by: "Request failed." I've tried messing with permissions, but everything more or less has domain administrator access ... So as of now I'm going to rebuild the virtual installation and see if I have any luck with that. Any ideas otherwise? TIA// Tag: Sharepoint Connection to a Network SQL server Tag: 38222
  - 9
    - Add Company Logo to companyweb Is there any way to add a company logo to the companyweb without modifying the .aspx code directly? Thanks, Rob Tag: Sharepoint Connection to a Network SQL server Tag: 38220
  - 10
    - Adding javascript to Default.aspx? Hello, I'm trying to quickly get a new WSS site up for our company. Our company has numerous websites that use the same header (which is either inherited in an asp.net app or embedded with an asp page using javascript for asp pages). I'm trying to do the same thing on a WSS page using FrontPage (I'm new to Frontpage, I'm used to VS.NET v2002). I tried just putting the javascript tag at the top but this doesn't seem to do anything. The other thing that confuses me is where the WSS pages are running from? When I look under C:\Inetpub, I don't see a corresponding site for my pages. And when I look in IIS I also don't find any corresponding sites. Any help to point me in the right direction would be appreciated. TIA. Tag: Sharepoint Connection to a Network SQL server Tag: 38214
  - 11
    - Extranet Deployment with Remote SQL Sorry, I have done this before but I got a braincramp and forgot the procedure: Im setting up an External Site for a company inside there DMZ (NO COnnection to Internal Users). AD and WSS will be in the "Blue Zone" and there is a seperate SQL Server in the DMZ that is part of a workgroup. How can i set up the authentication to allow WSS and the workgroup SQL box to communicate with each other for the WSS databases. Currently I have set this up in a test VM setting using the "Network Service" as the communication link. Thoughts..?? No im not a moron... i just play one on occasion :) Tag: Sharepoint Connection to a Network SQL server Tag: 38207
  - 12
    - Organizing site collection I would appreciate online references to information to study relative to best practices when planning the organization of site collections. I would like to understand what the issues are to take into consideration when deciding whether to make sites parallel in the hierarchy or subordinate to another site, etc. For example, we have the need to have one site be "public" in the sense our entire organization needs access to documents and information on that site developed for policy and procedure documentation. Then the department itself needs a private site for its intra-departmental procedures. Someone else set up the sites and made the public site a sub-site of the private site. My gut tells me that's a bad design since it prevents a public visiter from taking advantage of the site navigation provided by the links in the upper-right corner that traverse the hierarchy. Thanks! Tag: Sharepoint Connection to a Network SQL server Tag: 38206
  - 13
    - Host headers Hi all, Does anyone know if host header-enabled web sites in IIS supported by WSS/SPS? I know it works at first glance, but who knows... Any help will be greatly appreciated, Alex Tag: Sharepoint Connection to a Network SQL server Tag: 38202
  - 14
    - WSS and Windows Local Versions Does anyone know of any issues with accessing a sharepoint site and local versions of windows? Such as the German verison? Thanks Lee Tag: Sharepoint Connection to a Network SQL server Tag: 38199
  - 15
    - Trying to input a chart based on list numbers I am not a developer. I have been tasked, however, to create a chart that looks something like one of those thermometer type of gauges that charities use to illustrate how much money they have taken in vs. their goal. In our case, we are migrating systems to AD all over the world. Management does not want to open all the regional lists to check status. These lists keep a running total as we enter a completion date each day. I have tried to use an excel spreadsheet, but I can't get it to save the results entered by everyone and it was a second manual entry for our engineers who extra data entry. Has anyone created such an animal before? It seems like a common enouh type of request. Any advice would be graciously accepted. Let me know if I haven't been clear about the requirements. Thanks and have a great weekend. Tag: Sharepoint Connection to a Network SQL server Tag: 38198
  - 16
    - Currency in Sharepoint Lists Hi There, I need to provision for a currency field in a Sharepoint list - the problem is however, that the currency that i would like to use is not available for selection in the currency drop-down list (the currency is Uganda Shillings - UGX). Is there anyway to extend these lists, and to add extra currencies in there? I have also changed the Regional Settings on the server to reflect the correct currency but this did not have any effect on the availability of this currency in the drop-down list. Thanks! Nico Tag: Sharepoint Connection to a Network SQL server Tag: 38192
  - 17
    - new windows 2003 server hey all, i just did a clean install of windows 2003 server. i also made it an application server. i can get to the sharepoint server administration site just fine. the next thing i do is to try create a subweb. when i click on the newly created subweb it gives me a "not authorized" iis message. did i miss a step? thanks, rodchar Tag: Sharepoint Connection to a Network SQL server Tag: 38188
  - 18
    - Error accessing drop down menus I am using Microsoft Small Business Server, Microsoft Office 2003 and Windows XP on all my client computers. I created a timesheet list that uses drop down menus to â??look upâ?? information from other lists. I load this in Outlook 2003 by creating a new folder in the mail section. Then setting the homepage of the folder to the url of the employee's timesheet in Sharepoint. Some computers can access it fine. Of these there are two desktops directly connected to the server, one desktop remotely connected to the server (http connection). On certain computers (including two laptops remotely accessing the url via http or vpn, one desktop remotely connected via http and one desktop directly connected to the server). When a user tries to use a drop down there is no data in the list, it is completely blank. Then, if the user clicks the â??refresh dataâ?? option in the sharepoint window an an error message pops up saying: â??The datasheet view is attempting to retrieve data from a different domain. You will be redirected to an error page. Contact your system administrator to resolve this error.â?? When the user clicks â??OKâ?? the page changes to another sharepoint page titled â??Errorâ?? and has the following message: â??The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows Sharepoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.â?? If I then select â??Homeâ?? on the sharepoint menu, then select â??Documents and Listsâ??, then select the timesheet I was trying to use, the drop down lists now become available. Why does it take the refresh and re-opening the list for the drop down menu data to appear? How can I fix this problem? Thank you, Tracy Tag: Sharepoint Connection to a Network SQL server Tag: 38187
  - 19
    - Setup phone list on Sharepoint. Is it possible to setup a company phone list for all employees on Sharepoint and if so, how? I want the receptionist to be able to add & modify list entries. -- | +-- Julian | Tag: Sharepoint Connection to a Network SQL server Tag: 38186
  - 20
    - Booking template Hi first, sorry i am new to share point and the like.... I Have been playing with the booking template and was trying to get some error control to prevent double bookings. could someone point me in the correct direction please? Thx Tag: Sharepoint Connection to a Network SQL server Tag: 38185
  - 21
    - different departments become different sites? I am setting up Sharepoint site with Frontpage for Engineering firm. They don't have Portal, just Sharepoint Services. It seems like I am going to need to create multiple sites for different departments - Human Resources, Marketing, Technical Resources and then have a top level site. Do I have to pick one of these for the top level site, or can I create another site like Corporate? thanks. Tag: Sharepoint Connection to a Network SQL server Tag: 38183
  - 22
    - Alerts triggered by a view Hello, I have a document library setup. Within that library, I have custom colums created. For example, when a user uploads a document, they have to choose a status which includes Final, Draft, or Pending Review. I created a custom view within that library to display only those documents that are labeled Pending Review. What I would like to accomplish is have a email be sent using alerts whenever a user submits a document that its status is Pending Review. I tried creating an alert on the view that shows only the pending review docs but that is not possible. It will report on the whole library. Any Suggestions? Tag: Sharepoint Connection to a Network SQL server Tag: 38182
  - 23
    - Office Solution Accelerator for Proposals How can I get my hands on Office Solution Accelerator for Proposals. I have been looking for it on the Microsoft website but cannot find a download only articles on it. Tag: Sharepoint Connection to a Network SQL server Tag: 38181
  - 24
    - Renaming a server running Sharepoint Windows Services How do I rename a server without impacting the Sharepoint sites on it? Thanks. -- Rick Tag: Sharepoint Connection to a Network SQL server Tag: 38180
  - 25
    - Help Recurring Event I am trying to create a recurring event but it only puts the event on the original date-it doesn't reoccur. I tried also linking it to a meeting workspace even though I don't need it and that did not make any difference. I do not get any errors it just doesn't show on the calendar. Tag: Sharepoint Connection to a Network SQL server Tag: 38177
- Next
  - 1
    - The page cannot be displayed because your server's current configuration does not support it. To perform this task, use the command line operations in Stsadm.exe. Not sure how to get around this problem. Does anyone have any ideas? Tag: Sharepoint Connection to a Network SQL server Tag: 38176
  - 2
    - next in dvwp doesnt work sorry for last post. i have 2 question about dvwp. 1. when i connect to sql server even in same computer the next button doesnt work.for next records. am i missing anything?? these are my steps. 1 click data insert dataview. select database connecion. giving uname pwd table. than click on insert dataview. everything goes fine. but next doesnt work. 2 i want to filter dvwp from the form web part. also working fine.i used dvwp form connection and filter according to modify view according to input parameter. but problem is i can not remove filter once its applied to the form does anybody knows the solution?? thanx umang shah Tag: Sharepoint Connection to a Network SQL server Tag: 38175
  - 3
    - how to delete list column Hello all - I've search the newsgroup, Collutions FAQ and Google... no dice. I can edit list columns no problem. But how do I delete a list column completely? Thanks, Matt Tag: Sharepoint Connection to a Network SQL server Tag: 38173
  - 4
    - SSL & MSNBC Webparts HI! I am trying to add the MSNBC Stock Quote Webpart to the home page of my WSS site which has an SSL. Every time the page renders I get the message: "This page contains both secure and nonsecure items. Do you want to display nonsecure items?" Does anyone know how I can set this up so the message does not get generated? Many Thanks, ReneeDD Tag: Sharepoint Connection to a Network SQL server Tag: 38169
  - 5
    - Alert when Opened I have asked this before but I am still looking for an answer or direction to an authority that can answer this. First off I understand the alerts process. I know what I want is not covered by this so Im looking to see if anyone has another solution: I have been asked to provide a way to notify someone (via email) when a certain document has been opened. Not modified.. not deleted... just opened. This is due to an auditing issue they want to resolve for certain (not all) company documents. Has anyone run into this before? Thanks everyone. Tag: Sharepoint Connection to a Network SQL server Tag: 38168
  - 6
    - retriving a full row from a list is it possible to link one column from a list into the other and the second one desplay all the information contained in first list for that specific row into the second list? Tag: Sharepoint Connection to a Network SQL server Tag: 38164
  - 7
    - calculated value using Column from another list is it possible to have calculated value using Column from another list? if yes how is it done Tag: Sharepoint Connection to a Network SQL server Tag: 38163
  - 8
    - Always a dillema... Filter value for all items? Hi everybody! I know this was already discussed in the past, and I deeply apologize if I've missed it. There is more and more need for filtering by multiple parameters but not always. So is there some value that would "reset" filter in field to ALL? Something like * or % in SQL? I'd really appreciate if someone could help me with this. If we can set up that WSS is using logical parameters (and, or) in search, I believe this can also be somehow possible. Tag: Sharepoint Connection to a Network SQL server Tag: 38157
  - 9
    - Question root site I have set-up Sharepoint Team Services on our external server. THe virtual server is off the root of IIS. I create mutiple sites off that root like, marketing, engineering, intranet etc...They are all equal and each of them have sub-webs....The problems at each root site the navigation bar at top as an "up to team site" that navigates to a root site http://wwwroot . I dont want that site and wish it removed or at least teh ability to get there. Any help will be appreciated. Rich Tag: Sharepoint Connection to a Network SQL server Tag: 38153
  - 10
    - Site regional Setting to UK DD/MM/YY I have undertaken a few searches and examined the issue relating to DD/MM/YY. Although my WSS sites are set to the UK region. The Modified and Created dates still appear as MM/DD/YY. I have examined my Sharepoint Server, SQL Server and Client PC and all are set to the UK region as expected. Does anybody know how this issue can be resolved? Kind regards Andrew Tag: Sharepoint Connection to a Network SQL server Tag: 38147
  - 11
    - Enabling Active Directory User Creation Mode? Hi all, This should be pretty basic, but for the life of me, I can't figure out how to make an install using Active Directory User Creation Mode... I've made a clean install a couple of times now, but the only option I get is Typical Installation or Server Farm - is this it, or should I install using setupsts.exe with a switch of some kind, or what am I missing? Thanks in advance! /Mikael Tag: Sharepoint Connection to a Network SQL server Tag: 38146
  - 12
    - Drop Down Lists Hi there, I'm relativly new to Windows Sharepoint Services, and do not have Frontpage. Is it possible to create a drop-down list which links to other pages? Basically to act as a shortcut for other users? I would be most grateful for any assistance or code. Kindest regards, ~ Paul Tag: Sharepoint Connection to a Network SQL server Tag: 38144
  - 13
    - Document properties not updating the library metadata I thought I new the mechanism for Office document properties and the way Document library metadata is updated but this one is foxing me .. If I create a new document from the 'New Document' link in the library, i.e. use the template; save the document and populate some metadata from the dialogue box that appears; When I return to the library, none of the properties have been updated, not even mandatory ones. Now if I edit the document and look at the properties in Word - They are still there - fully populated!, and if I try again to change them they do not get updated in the library. If I use any other method to add a document to the library, everything is fine ?!? i.e. use the Upload feature to add a document then play with the properties it is as expected. Even adding the properties to the template doesn't seem to help. Help! what am I doing wrong ? Tag: Sharepoint Connection to a Network SQL server Tag: 38143
  - 14
    - Can _layouts/1033/*.aspx files be customised I have been customizing some of the files on my SharePoint sub-site using FrontPage 2000 (I don't have 2003) such as ../SharedDocuments/Forms/AllItems.aspx. However, FrontPage 2000 does not display "../_layouts/1033/.." files such as /_layouts/1033/userinfo.aspx. Can these be customized, or are they (as I suspect) shared with other sites? Tag: Sharepoint Connection to a Network SQL server Tag: 38142
  - 15
    - How to store custom Information for Document Library Hi, I want to maintain my custom information in each file and folder of Document Library. For example i want to store my OwnID for File and Folders which should not be visible to the user at the same time when i migrate the site the Values of the File and Folders shouldn't lost. Like i want to stroe many Fields. How can i achieve this. One more thing is that i need some columns for files which should not be there in Folders and vice versa. Is there any Sharepoint API is there to achieve this? Is it possible with SPField Class? If anybody knows the solution please let me know it? Regards, Vinoth Tag: Sharepoint Connection to a Network SQL server Tag: 38140
  - 16
    - wss onwindows 2003 webedition Hi All seeking major pros n cons of choosing windows 2003 web edition as web server for wss Please help , there is no article which consolidates installation configuration issues and limitations. major concerns here are 1) is it necessary to join it in doamin while installing 2) or it can take local accts in domain acct creation mode 3) i understand the Db can be only on mssql and msde is not supported. 4) how can i calculate the estimated db size growth 5) also is there is any limitaion /major feature limitaion if we use wss onweb edition? please guide cheers Deeps Tag: Sharepoint Connection to a Network SQL server Tag: 38136
  - 17
    - Documents Listing in Sharepoint Services Hi there, I would like to know if there is any way in Sharepoint to list all documents that were uploaded to all sites and export the results in a representable format (e.g Excel sheet). Thanks for your help SuresH Tag: Sharepoint Connection to a Network SQL server Tag: 38135
  - 18
    - Increase upload size Hi All, I've read Ian's solution on how to increase upload size but i get an error from windows regarding 'Delayed write failed', like a slow network connection or something like that. but we didn't experience any!!!. I increase both the timeout in the IIS and the Maximun upload size but no luck. Any toughts? Thanks in advance Tag: Sharepoint Connection to a Network SQL server Tag: 38132
  - 19
    - Migrating user listings to AD groups I currently have a WSS site structure with over 200 individual user listings. I would like to be able to create a listing of users and their applied roles, so that I could move them into the correct AD groups. Any idea how to do this? I can use STSADM with the ENUMUSERS command, but that doesn't show their roles on the site. I also took a brief look at the SQL table structure, but I couldn't seem to find anything valuable there. Thanks in advance for any help. Tag: Sharepoint Connection to a Network SQL server Tag: 38128
  - 20
    - Adding the announcements web part to a document workspace I am trying to add the announcements web part to a document web space, but am unable to get it to work so far. I am signed in as the site administrator. I select Modify This Workspace under the search window on the main page of the document workspace. This web part is not listed in the first list of web parts presented, so I select show all lists. A longer list of web parts is presented to me, this list has the announcements web part. I select the announcements web part from this list. I am then asked to enter the Name and Description, which I do, I leave the Share List Across All Meetings set to No.and then I click on Create. Then the page is presented that shows any current announcements and I can add or edit them. So I add an announcement. This page is labeled for the document workspace I am in. The new announcement appears on the list, on the page where announcements are added and edited. Now I select Home which returns me to the first page of the document webspace but the web part I just created including the announcement I just entered is not visible. What do I need to do to get the announcements webpart I just set-up to display on the first page of the document workspace? Thanks in advance for your assistance. -- Mark Steffen Winning Solutions, Inc. Ames Iowa Tag: Sharepoint Connection to a Network SQL server Tag: 38126
  - 21
    - Correct userinfo in WSS workspace I have implemented Project Server 2003, and have just rolled out to users. An administrator of a Project WSS workspace added a user through the "Manage Users" navigation, but inadvertently added the user with the wrong domain info, the admin got the e-mail address correct for the new user and the display name. In order to correct the mistake I have removed the user from the Workspace and tried re-adding him with the correct data. Problem is when the user shows up in the users list he shows as still having the worng domain (and of course the user can't access the site). I went poking around in the STS database and found the user information in a table named UserInfo. The user shows up twice in this table, once for each domain. I think this is causing the user to not be able to access even other WSS workspaces, even though in these other workspaces when the user was added, he was added the first time with the correct domain info. Maybe the double entry is confusing the system But how can I clean it up? Please help! Tag: Sharepoint Connection to a Network SQL server Tag: 38124
  - 22
    - Can I receive an email so that I know there is something to approve? I have set up an Issues List in WSS and have the "content approval" flag set to yes. When a user posts an issue is shows up properly as "pending", but unless I look every day I wouldn't know that there are pending items. In most cases an administrator enters the items in the list, so their items always show as approved... This works fine and I wouldn't want an email to go out on this since no one needs to approve. Does the Issues List provide functionality to send out an email when a pending item is submitted? Are there other ways to make this happen? Thanks for your help IAN Tag: Sharepoint Connection to a Network SQL server Tag: 38121
  - 23
    - PDF iFilter on WSS? I have installed the Adobe PDF iFilter on our WSS server. 1 - How WSS knows about the PDF iFilter installation. 2 - Is there any place on "Central Admin" to add the PDF file type? 3 - Any place to add the PDF icon? 4 - Do I have to rebuild all my Full-Text Catalogs? 5 - Any reported major problems 6 - Anything else I have to do to get things working properly? Tag: Sharepoint Connection to a Network SQL server Tag: 38115
  - 24
    - help with chm document I downloaded the new updated .chm document and want to put it in my support site. The server adm has this type blocked. I tried it in my dev box which does not have office or anything else except windows sharepoint services and it would not load properly. it there a place to get the decompiled help document so that I can upload it into the SharePoint support site I am creating? I want to have a basic page with the glossary a new users page with the basic content and a administrators page with the more advanced help features. Sometimes it is not so easy to navigate through the help files built into sharepoint thanks J Tag: Sharepoint Connection to a Network SQL server Tag: 38108
  - 25
    - need direction on .chm topic check in check out where can I go to post a comment about an admendment that needs to be made to the check in check out updated .chm I downloaded today? I downloaded thinking this section would be corrected, but it is not. I can say the process that works but to wordy for here. Judy Tag: Sharepoint Connection to a Network SQL server Tag: 38098

I know this is probably an easy fix, but I am new at SharePoint and
this is driving me crazy. I have a SharePoint webpart connecting to a
SQL dbase located on the network. The page shows great when viewed
through IE on the SharePoint machine but it will not show up on any
other machine. Error reads "An error occurred while processing the
data for this request. "

Help

Re: Sharepoint Connection to a Network SQL server by Ian

Ian
Sat Nov 12 23:56:32 CST 2005

Hi,
The SQL server must either
1. be running in mixed mode security and your web part connection string
include the sql login details
or
2. kerberos delegation enabled between the IIS and SQL server (AD
administration task)
or
3. Use Portal Server's single sign-on capability (with SQL auth rather than
windows auth for the connection)

Regards,
Ian
http://www.wssdemo.com

"cbarnhart" <cbarnhart@goelst.com> wrote in message
news:1131838013.434588.13600@g49g2000cwa.googlegroups.com...
>I know this is probably an easy fix, but I am new at SharePoint and
> this is driving me crazy. I have a SharePoint webpart connecting to a
> SQL dbase located on the network. The page shows great when viewed
> through IE on the SharePoint machine but it will not show up on any
> other machine. Error reads "An error occurred while processing the
> data for this request. "
>
> Help
>

Re: Sharepoint Connection to a Network SQL server by cbarnhart

cbarnhart
Mon Nov 14 08:28:38 CST 2005

Number 2 looks like my best option. How do I Enable the kerberos
delegation?

Re: Sharepoint Connection to a Network SQL server by Ian

Ian
Mon Nov 14 12:10:49 CST 2005

Hi,
Yes, 2 is the best (most secure) option. Works best with 2003 native mode AD
but can be done with 2000.
http://support.microsoft.com/default.aspx?kbid=832769

Regards,
Ian
http://www.wssdemo.com

"cbarnhart" <cbarnhart@goelst.com> wrote in message
news:1131978518.631701.7270@g14g2000cwa.googlegroups.com...
> Number 2 looks like my best option. How do I Enable the kerberos
> delegation?
>