Solved

SharePoint 2010 as extranet host and VS2010 unable to connect remote Data Source

Posted on 2011-02-20
12
2,308 Views
Last Modified: 2012-05-11
A recent attempt to use Visual Studio and LightSwitch to connect to a SharePoint data source hosted on a SharePoint 2010 server configured as a public extranet has given much headache.

Attempts to connect to a SharePoint data source request server url. When given the http://server.mysite.com i am returned with the following message: "There was a problem accessing the web resource. Server returned error code: 302."

when i get a bit more specific: http://server.mysite/subsite/lists i get the following: "http://server.mysite.com/subsite/lists/_vti_bin/listdata.svc/$metadata does not appear to be a valid site. SharePoint 2010 (or later) with an installation of WCF Data Services is required."

so i check the server and find that i'm running the following:
MS Server 2008
SharePoint 2010 server

Server Manager Features Summary:
.NET Framework 3.0
WCF Activation

i checked the C:\inetpub\wwwroot\wss\VirtualDirectories\80\_vti_pvt and no listdata.svc file exists

i checked the system logs and obtained the following:

System.ServiceModel.ServiceHostingEnvironment+HostingManager/36040709 
   System.ServiceModel.ServiceActivationException: The service '/_vti_bin/listdata.svc' cannot be activated due to an exception during compilation. The exception message is: Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.. ---> System.TypeLoadException: Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throwOnError) at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses) at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath) at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath) at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath) --- End of inner exception stack trace --- at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath) at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath) 
   w3wp 
   6084 

Open in new window


naturally the documentation is quite slim on this matter.

The goal is to create an application using Visual Studio to edit data contained in a SharePoint 2010 list for purpose of opening list data in Excel and exporting to csv but i can't seem to get off the ground here. Any thoughts?

thanks.
0
Comment
Question by:synetron
  • 8
  • 4
12 Comments
 
LVL 14

Accepted Solution

by:
KoenVosters earned 500 total points
ID: 34941087
0
 
LVL 2

Author Comment

by:synetron
ID: 34941106
I wish it were so simple, however i'd already tried this exact "solution."

thank you for the post, in fact had a good laugh at some of the comments left on his pages

When attempting to install the suggested patches it returns "The update does not apply to your system" and does not load. The system is current on all updates. Have rebooted and done IIS reset after previous updates
0
 
LVL 2

Author Comment

by:synetron
ID: 34941127
checked system - KB976126 has already been installed.

still receive error message "There was a problem accessing the web resource. Server returned error code: 302." within Microsoft Visual Studio
0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34941159
Did you install .net 3.5? As it is looking for the 3.5 version of System.Data and you state that you have .net Framework 3.0 installed.
0
 
LVL 2

Author Comment

by:synetron
ID: 34941185
Here's the FULL picture

[System Summary]
Item Value
OS Name Windows Server 2008 Server Standard Edition (full installation)
OS Version 6.0 Service Pack 2 (Build 6002)
System Name ******
System Model System Product Name
System Manufacturer System manufacturer
Processor Intel(R) Core(TM) i5 CPU         650  @ 3.20GHz
BIOS Version 092410 - 20100924
IP 192.168.250.3
Windows Directory C:\Windows
System Directory C:\Windows\system32
Locale United States
User Name ************
Time Zone Eastern Standard Time
Total Physical Memory 8183 MB
Available Physical Memory 6417 MB
Serial number System Serial Number
MAC address ***************

[Applications]
Window Title Module Name
Programs and Features System
wss System
Initial Configuration Tasks System
GoToAssist C:\Program Files (x86)\Citrix\GoToAssist Express Customer\258\g2ax_user_customer.exe
Program Manager System

[Processes]
Image Name PID Memory Usage (K) Path
g2ax_user_customer.exe 4820 12880 C:\Program Files (x86)\Citrix\GoToAssist Express Customer\258\g2ax_user_customer.exe
System 2088 10008 Unknown
System 4696 4868 Unknown
System 1032 52812 Unknown
System 5156 13644 Unknown
System 5188 11476 Unknown
System 5208 39268 Unknown
IAStorIcon.exe 5248 20772 C:\Program Files (x86)\Intel\Intel(R) Rapid Storage Technology\IAStorIcon.exe
System 5312 87136 Unknown
System 4228 16540 Unknown
g2ax_user_medium_customer.exe 4596 12624 C:\Program Files (x86)\Citrix\GoToAssist Express Customer\258\g2ax_user_medium_customer.exe

[Startup Programs]
Program Path
IAStorIcon "C:\Program Files (x86)\Intel\Intel(R) Rapid Storage Technology\IAStorIcon.exe"
OfficeSyncProcess "C:\Program Files\Microsoft Office\Office14\MSOSYNC.EXE"

[Logical Drives]
Drive Name Type Free Space Total Space
C:\ Fixed Drive 689.89 GB 732.42 GB
D:\ Fixed Drive 198.29 GB 199.09 GB
E:\ CD-ROM


[Devices]
Device Name Device Type
ACPI Fixed Feature Button System
Intel Processor Processor
Intel Processor Processor
Intel Processor Processor
Intel Processor Processor
Intel(R) 82802 Firmware Hub Device System
Programmable interrupt controller System
System timer System
High precision event timer System
Direct memory access controller System
Standard PS/2 Keyboard Keyboard
Communications Port Ports
Communications Port Ports
System speaker System
PCI bus System
System CMOS/real time clock System
System board System
System board System
Motherboard resources System
Motherboard resources System
Motherboard resources System
Motherboard resources System
Motherboard resources System
Numeric data processor System
ACPI Power Button System
Microsoft PS/2 Mouse Mouse
Microsoft ACPI-Compliant System System
Generic PnP Monitor Monitor
CD-ROM Drive CDROM
Disk drive DiskDrive
ASPEED Graphics Family Display
Intel(R) processor DRAM Controller - 0048 System
Intel(R) 82574L Gigabit Network Connection Net
Intel(R) 82574L Gigabit Network Connection Net
Intel(R) 82801 PCI Bridge - 244E System
Intel(R) ICH8R/ICH9R/ICH10R/DO/5 Series/3400 Series SATA RAID Controller SCSIAdapter
Intel(R) 3420 Chipset LPC Interface Controller - 3B14 System
Intel(R) 5 Series/3400 Series Chipset Family SMBus Controller - 3B30 System
Intel(R) 5 Series/3400 Series Chipset Family USB Enhanced Host Controller - 3B34 USB
Intel(R) 5 Series/3400 Series Chipset Family USB Enhanced Host Controller - 3B3C USB
Intel(R) 5 Series/3400 Series Chipset Family PCI Express Root Port 1 - 3B42 System
Intel(R) 5 Series/3400 Series Chipset Family PCI Express Root Port 5 - 3B4A System
Intel(R) 5 Series/3400 Series Chipset Family PCI Express Root Port 6 - 3B4C System
Intel(R) 5 Series/3400 Series Chipset Family PCI Express Root Port 7 - 3B4E System
Intel(R) 5 Series/3400 Series Chipset Family PCI Express Root Port 8 - 3B50 System
Microsoft ISATAP Adapter Net
Microsoft ISATAP Adapter Net
Microsoft Tun Miniport Adapter Net
ACPI x64-based PC Computer
Microsoft iSCSI Initiator SCSIAdapter
Ancilliary Function Driver for Winsock LegacyDriver
Common Log (CLFS) LegacyDriver
Crcdisk Filter Driver LegacyDriver
HTTP LegacyDriver
Intel RAID Controller Vista LegacyDriver
ISOParser LegacyDriver
KSecDD LegacyDriver
Link-Layer Topology Discovery Mapper I/O Driver LegacyDriver
Mount Point Manager LegacyDriver
Windows Firewall Authorization Driver LegacyDriver
Message Queuing Access Control LegacyDriver
ISA/EISA Class Driver LegacyDriver
Nal Service  LegacyDriver
NDIS System Driver LegacyDriver
NDProxy LegacyDriver
NETBT LegacyDriver
NSI proxy service LegacyDriver
Null LegacyDriver
PassthroughParser LegacyDriver
PEAUTH LegacyDriver
QoS Packet Scheduler LegacyDriver
Remote Access Auto Connection Driver LegacyDriver
RDPCDD LegacyDriver
RDP Encoder Mirror Driver LegacyDriver
RDP Winstation Driver LegacyDriver
Link-Layer Topology Discovery Responder LegacyDriver
Security Driver LegacyDriver
Message-oriented TCP/IP and TCP/IPv6 Protocol (SMB session) LegacyDriver
Security Processor Loader Driver LegacyDriver
Disk VMBUS Acceleration Filter Driver LegacyDriver
TCP/IP Protocol Driver LegacyDriver
TCP/IP Registry Compatibility LegacyDriver
TDTCP LegacyDriver
NetIO Legacy TDI Support Driver LegacyDriver
Terminal Services Security Filter Driver LegacyDriver
VgaSave LegacyDriver
VHDParser LegacyDriver
Dynamic Volume Manager LegacyDriver
Storage volumes LegacyDriver
Remote Access IPv6 ARP Driver LegacyDriver
Kernel Mode Driver Frameworks service LegacyDriver
WAN Miniport (L2TP) Net
WAN Miniport (Network Monitor) Net
WAN Miniport (IP) Net
WAN Miniport (IPv6) Net
WAN Miniport (PPPOE) Net
WAN Miniport (PPTP) Net
WAN Miniport (SSTP) Net
Terminal Server Device Redirector System
Terminal Server Keyboard Driver System
Terminal Server Mouse Driver System
Microsoft Virtual Disk Server(no Class Installer) System
Plug and Play Software Device Enumerator System
Microsoft System Management BIOS Driver System
UMBus Root Bus Enumerator System
Virtualization Infrastructure Driver System
Virtual Machine Bus System
Microsoft Virtual Network Switch Adapter Net
Microsoft Virtual Network Switch Adapter Net
Volume Manager System
Generic volume Volume
Generic volume Volume
RAS Async Adapter Net
UMBus Enumerator System
UMBus Enumerator System
USB Root Hub USB
USB Root Hub USB
Generic USB Hub USB
Generic USB Hub USB

[Default Browser]
Item Value
Name Internet Explorer
Version 7.00.6000.16386
Application Path C:\Program Files (x86)\Internet Explorer\iexplore.EXE
Cipher Strength 128

[Services]
Service Name State
Application Experience Running
Application Layer Gateway Service Stopped
Application Host Helper Service Running
Application Information Running
Application Management Running
ASP.NET State Service Stopped
Windows Audio Endpoint Builder Stopped
Windows Audio Stopped
Base Filtering Engine Running
Background Intelligent Transfer Service Stopped
Computer Browser Stopped
Claims to Windows Token Service Running
Certificate Propagation Running
Microsoft .NET Framework NGEN v2.0.50727_X86 Stopped
Microsoft .NET Framework NGEN v2.0.50727_X64 Stopped
Microsoft .NET Framework NGEN v4.0.30319_X86 Running
Microsoft .NET Framework NGEN v4.0.30319_X64 Running
COM+ System Application Stopped
Cryptographic Services Running
Offline Files Stopped
Document Conversions Launcher for Microsoft SharePoint Server 2010 Stopped
Document Conversions Load Balancer for Microsoft SharePoint Server 2010 Stopped
DCOM Server Process Launcher Running
DHCP Client Running
DNS Client Running
Wired AutoConfig Stopped
Diagnostic Policy Service Running
Extensible Authentication Protocol Stopped
Windows Event Log Running
COM+ Event System Running
Microsoft Fibre Channel Platform Registration Service Stopped
Function Discovery Provider Host Stopped
Function Discovery Resource Publication Stopped
Forefront Identity Manager Service Stopped
Forefront Identity Manager Synchronization Service Stopped
Windows Font Cache Service Running
Windows Presentation Foundation Font Cache 3.0.0.0 Stopped
GoToAssist Express Customer Running
Group Policy Client Running
Human Interface Device Access Stopped
Health Key and Certificate Management Stopped
Intel(R) Rapid Storage Technology Running
Windows CardSpace Stopped
IIS Admin Service Running
IKE and AuthIP IPsec Keying Modules Running
PnP-X IP Bus Enumerator Stopped
IP Helper Running
CNG Key Isolation Running
KtmRm for Distributed Transaction Coordinator Running
Server Running
Workstation Running
Link-Layer Topology Discovery Mapper Stopped
TCP/IP NetBIOS Helper Running
Microsoft SharePoint Workspace Audit Service Stopped
Multimedia Class Scheduler Stopped
Windows Firewall Running
Distributed Transaction Coordinator Running
Microsoft iSCSI Initiator Service Stopped
Windows Installer Stopped
Message Queuing Running
Windows Internal Database (MICROSOFT##SSEE) Stopped
SQL Server (SHAREPOINT) Running
SQL Server (SQLEXPRESS) Running
SQL Active Directory Helper Service Stopped
Network Access Protection Agent Stopped
Netlogon Running
Network Connections Running
Net.Msmq Listener Adapter Running
Net.Pipe Listener Adapter Running
Network List Service Running
Net.Tcp Listener Adapter Running
Net.Tcp Port Sharing Service Running
Network Location Awareness Running
Network Store Interface Service Running
Hyper-V Networking Management Service Running
Office 64 Source Engine Stopped
SharePoint Server Search 14 Stopped
Office Software Protection Platform Running
BranchCache Stopped
Performance Counter DLL Host Stopped
Performance Logs & Alerts Stopped
Plug and Play Running
IPsec Policy Agent Running
User Profile Service Running
Protected Storage Stopped
Remote Access Auto Connection Manager Stopped
Remote Access Connection Manager Running
Routing and Remote Access Stopped
Remote Registry Running
Replication Engine Stopped
Remote Procedure Call (RPC) Locator Stopped
Remote Procedure Call (RPC) Running
Resultant Set of Policy Provider Stopped
Special Administration Console Helper Stopped
Security Accounts Manager Running
Smart Card Stopped
Task Scheduler Running
Smart Card Removal Policy Stopped
Secondary Logon Running
System Event Notification Service Running
Terminal Services Configuration Running
Internet Connection Sharing (ICS) Stopped
Shell Hardware Detection Running
SAN/LAN Transfer Virtualization Accelerator Stopped
Software Licensing Running
SL UI Notification Service Stopped
Simple Mail Transfer Protocol (SMTP) Stopped
SNMP Trap Stopped
SharePoint 2010 Administration Stopped
Print Spooler Running
SharePoint Foundation Search V4 Stopped
SharePoint 2010 Timer Stopped
SharePoint 2010 Tracing Running
SharePoint 2010 User Code Host Stopped
SharePoint 2010 VSS Writer Stopped
SQL Server Agent (SHAREPOINT) Stopped
SQL Server Agent (SQLEXPRESS) Stopped
SQL Server Browser Stopped
SQL Server VSS Writer Running
SSDP Discovery Stopped
Secure Socket Tunneling Protocol Service Running
Windows Image Acquisition (WIA) Running
Microsoft Software Shadow Copy Provider Stopped
Superfetch Stopped
Tablet PC Input Service Running
Telephony Running
TPM Base Services Stopped
Terminal Services Running
Themes Stopped
Thread Ordering Server Stopped
Distributed Link Tracking Client Running
Windows Modules Installer Running
Interactive Services Detection Stopped
Terminal Services UserMode Port Redirector Running
UPnP Device Host Stopped
Desktop Window Manager Session Manager Running
Virtual Disk Stopped
Hyper-V Image Management Service Running
Hyper-V Virtual Machine Management Running
Volume Shadow Copy Stopped
Windows Time Running
World Wide Web Publishing Service Stopped
Windows Process Activation Service Running
Windows Color System Stopped
Diagnostic Service Host Stopped
Diagnostic System Host Running
Web Analytics Service Stopped
WebClient Running
Windows Event Collector Stopped
Problem Reports and Solutions Control Panel Support Stopped
Windows Error Reporting Service Running
Windows Defender Running
WinHTTP Web Proxy Auto-Discovery Service Stopped
Windows Management Instrumentation Running
Windows Remote Management (WS-Management) Running
WMI Performance Adapter Stopped
Web Management Service Stopped
Portable Device Enumerator Service Running
Windows Presentation Foundation Font Cache 4.0.0.0 Stopped
Windows System Resource Manager Running
Windows Update Running
Windows Driver Foundation - User-mode Driver Framework Stopped

[Installed Applications]
Program
GoToAssist Customer 1.5.0.258
PowerISO
Microsoft Silverlight 3 SDK
Intel(R) Rapid Storage Technology
Microsoft Chart Controls for Microsoft .NET Framework 3.5
Microsoft Server Speech Recognition Language - TELE (en-US)
Microsoft Silverlight
ASPEED Graphics WinS08_x64 v.0.90
Security Update for Microsoft .NET Framework 4 Extended (KB2416472)
Microsoft SharePoint 2010 SDK
Microsoft SQL Server 2008 Browser
Security Update for Microsoft .NET Framework 3.5 SP1 (KB2416473)
Hotfix for Microsoft .NET Framework 3.5 SP1 (KB953595)
Hotfix for Microsoft .NET Framework 3.5 SP1 (KB958484)
Update for Microsoft .NET Framework 3.5 SP1 (KB963707)
Hotfix for Microsoft .NET Framework 3.5 SP1 (KB976126)

Security Update for Microsoft .NET Framework 4 Client Profile (KB2160841)
Update for Microsoft .NET Framework 4 Client Profile (KB2473228)
Intel(R) Control Center

[Microsoft Office]
Application Version Build
Microsoft OneNote 14.0.5128 5000
Microsoft Outlook 14.0.4760 1000
Microsoft Publisher 14.0.5126 5000
0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34941194
Just check with the Features of your server if you have .net Framework 3.5 installed. As I see the hotfixes, but I don't see the framework itself.
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 2

Author Comment

by:synetron
ID: 34941297
.NET Framework 3.5 SP1 is installed, however the server features lists only .net Framework 3.0

downloaded .NET Framework 3.5 SP1 and ran, selected option to repair (only other option was remove)

restarted IIS

no change.

server features still only lists 3.0
0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34941500
The only thing that I can still think of is that you uninstall and reinstall KB976126. It really seems to be the solution for this issue. I hope any other experts can shed a different light on this as I am stuck for the moment.
0
 
LVL 2

Author Comment

by:synetron
ID: 34941507
thank you for the time and effort. i'll give that a shot and see.
0
 
LVL 2

Author Comment

by:synetron
ID: 34941557
nope, nada. no change.

all this new fancy stuff and it's new fancy problems...
0
 
LVL 2

Author Comment

by:synetron
ID: 34957445
uninstalled and re-installed. no change. still receiving error 302 and no connection.
0
 
LVL 2

Author Closing Comment

by:synetron
ID: 37175151
Apologies for leaving this open so long. Though the matter was never quite resolved, the sever was scrapped and the issue a null point now. Points assigned for assistance given as there seems to be no documented options outside of the solutions offered.

Thanks again and again, sorry for the lengthy delay.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now