Use Single Sign on to connect to sql server
- From: "TS" <manofsteele1@xxxxxxxxxxxxx>
- Date: Tue, 14 Nov 2006 12:18:49 -0600
I'm trying to set up SSO so i can use it to authenticate an exteranal data
connection in an excel file that connects using an odc file connecting using
Sql Authentication, not windows auth.
If I create an application definition, what are the fields and in which
order do i need to supply them?
example from
http://technet2.microsoft.com/Office/en-us/library/3c78e886-5d20-44cb-b4e4-f823c4c019281033.mspx?mfr=true :
Logon account information is used for enterprise application definitions
that use individual accounts. Prompting for logon account information is
not recommended for enterprise application definitions that use group
accounts.
The logon account information that you configure here must match the logon
requirements for the enterprise application. Additionally, you must also
determine whether the system needs to mask these credentials as the user
provides them.
Typically, only a user name and password are required. Some highly secure
environments might require additional pieces of user identification.
Additionally, some systems might require additional information from users
to identify the application. For example, for access to Oracle, users might
enter the information shown in the following table.
In this fieldEnter this information
Field 1
Oracle user name
Field 2
Oracle user password (select Yes for the Mask option)
Field 3
Oracle database name
That shows a pseudo example of how to connect to an Oracle Db. I need to
know exactly for Sql Server. I came across a site that showed it like this,
but have been unsuccessful in getting to to work:
DisplayName: Northwind
ApplicationName: Northwind
e-mail address: something@xxxxxxxxxx
Field 1:
Name: SQL Server
Mask: No
Field 2:
Name: Database Name
Mask: No
Field 3:
Name: User Name
Mask: No
Field 4:
Name: Domain
Mask: No
Field 5:
Name: Password
Mask: Yes
With this definition created, you can then enter the Account Information for
the definition. This is where you specify an entry for all the fields in the
above definition. For the Northwind application, enter a group of
SAMPLE\Domain Users. And then specify the actual fields. For this solution,
the following fields were used.
SQL Server: SPSPlay
Database Name: Northwind
User Name: NorthwindSvs
Domain: SAMPLE
Password: #######
If I'm connecting using a sql username, do i need to use the domain piece
like above or what else is my problem?
*****The main reason i'm trying this is to get my excel file to be able to
refresh its data when run thru excel services, i get this in the app log:
"Excel Services can not use credential delegation when it is configured to
use a trusted subsystem with Windows SharePoint Server". So to fix it I am
trying to get SSO to work.
thanks
.
- Follow-Ups:
- RE: Use Single Sign on to connect to sql server
- From: Luke Zhang [MSFT]
- RE: Use Single Sign on to connect to sql server
- Prev by Date: Re: What is the biggest document library that you have ever had?
- Next by Date: Can't authenticate to lists.asmx web service
- Previous by thread: Sharepoint User Account Domain Migration
- Next by thread: RE: Use Single Sign on to connect to sql server
- Index(es):
Relevant Pages
|
