Sharepoint Connection to a Network SQL server
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Sharepoint Connection to a Network SQL server

 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services
Author Message
cbarnhart
Guest
Posted: Sun Nov 13, 2005 1:50 am    Post subject: Sharepoint Connection to a Network SQL server Reply with quote
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
Back to top
Ian Morrish
Guest
Posted: Sun Nov 13, 2005 9:50 am    Post subject: Re: Sharepoint Connection to a Network SQL server Reply with quote
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...
Quote:
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
Back to top
cbarnhart
Guest
Posted: Mon Nov 14, 2005 5:50 pm    Post subject: Re: Sharepoint Connection to a Network SQL server Reply with quote
Number 2 looks like my best option. How do I Enable the kerberos
delegation?
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB