Authentication Error with HTTP EndPoints

I keep getting these errors when I try to access an
endpoint I created. I have double checked and it is setup
for integrated authentication, grant connect has been
done on the account I am trying to access as and I still
get this error.
Any ideas or suggestions are welcome and appreciated.
Walt
Event Type:Error
Event Source:MSSQLSERVER
Event Category:Logon
Event ID:26026
Date:6/4/2005
Time:7:36:37 PM
User:N/A
Computer:HWCVS17
Description:
HTTP authentication failed. [CLIENT: X.X.X.X]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: aa 65 00 00 0e 00 00 00 e.....
0008: 08 00 00 00 48 00 57 00 ...H.W.
0010: 43 00 56 00 53 00 31 00 C.V.S.1.
0018: 37 00 00 00 00 00 00 00 7......
Hi Jim,
Could you please post the exact steps you performed to create the HTTP
EndPoints and the URL you used to connect to the SQL Server? This will help
us get a clear picture of the problem.
You may want to refer to the SQLXML chapter and sub-chapters in MSDN for
more information:
http://msdn.microsoft.com/library/en...nch_SQLXML.asp
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.

Authentication Error with HTTP EndPoints

I keep getting these errors when I try to access an
endpoint I created. I have double checked and it is setup
for integrated authentication, grant connect has been
done on the account I am trying to access as and I still
get this error.
Any ideas or suggestions are welcome and appreciated.
Walt
Event Type: Error
Event Source: MSSQLSERVER
Event Category: Logon
Event ID: 26026
Date: 6/4/2005
Time: 7:36:37 PM
User: N/A
Computer: HWCVS17
Description:
HTTP authentication failed. [CLIENT: X.X.X.X]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: aa 65 00 00 0e 00 00 00 e.....
0008: 08 00 00 00 48 00 57 00 ...H.W.
0010: 43 00 56 00 53 00 31 00 C.V.S.1.
0018: 37 00 00 00 00 00 00 00 7......Hi Jim,
Could you please post the exact steps you performed to create the HTTP
EndPoints and the URL you used to connect to the SQL Server? This will help
us get a clear picture of the problem.
You may want to refer to the SQLXML chapter and sub-chapters in MSDN for
more information:
http://msdn.microsoft.com/library/e...anch_SQLXML.asp
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.

Authentication Error with HTTP EndPoints

Hello!
I'm unable to use a webservice exposed on a Sql Server 2005 by using
the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
is to write a function for a Excel Sheet wich resolves some
identifiers to strings by using a SQL Server 2005. I thougt to use web
services but end up with errors, as you can read furthre down.
If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
wrong, I would be very happy if some one could advise me.
The exception in VBA is about '... access denied...'. The SQL Server
logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
The Endpoint I want to use is as follows:
CREATE ENDPOINT SQLEP_gmd
STATE = STARTED
AS HTTP
(
PATH = '/gmd',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = '2003dellp285002'
)
FOR SOAP
(
WEBMETHOD 'getNextReferenceSubstanceIdentifier'
(NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'metabolomics',
NAMESPACE = 'http://2003dellp285002'
)
The stored procedure is very simple, has no input parameters and
returns a string to simplify matters.
Any commnt is apreciated very much!
With kind regardsHi,
If I remember correctly, you will need to specify the user and password as
part of the URL you used to initialize the MSSoap.SoapClient object. If that
isn't possible, I recommend creating the data connection using the normal SQL
database method.
Please also make sure that you have granted access to the Endpoint and the
Stored Procedure for the user you wish to connect with.
Jimmy
"jahu" wrote:
> Hello!
> I'm unable to use a webservice exposed on a Sql Server 2005 by using
> the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
> is to write a function for a Excel Sheet wich resolves some
> identifiers to strings by using a SQL Server 2005. I thougt to use web
> services but end up with errors, as you can read furthre down.
> If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
> wrong, I would be very happy if some one could advise me.
> The exception in VBA is about '... access denied...'. The SQL Server
> logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
> The Endpoint I want to use is as follows:
> CREATE ENDPOINT SQLEP_gmd
> STATE = STARTED
> AS HTTP
> (
> PATH = '/gmd',
> AUTHENTICATION = (INTEGRATED),
> PORTS = (CLEAR),
> SITE = '2003dellp285002'
> )
> FOR SOAP
> (
> WEBMETHOD 'getNextReferenceSubstanceIdentifier'
> (NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
> BATCHES = DISABLED,
> WSDL = DEFAULT,
> DATABASE = 'metabolomics',
> NAMESPACE = 'http://2003dellp285002'
> )
>
> The stored procedure is very simple, has no input parameters and
> returns a string to simplify matters.
> Any commnt is apreciated very much!
> With kind regards
>|||Dig up some more details. You can specify the user credentials on the
SoapClient object. The following is a sample:
SoapClient.connectorProperty("AuthUser") = "userName"
SoapClient.connectorProperty("AuthPassword") = "PASSWORD"
// Set Auth scheme
// digest 0x8
// negotiate 0x10
// ntlm 0x2
// basic 0x1
SoapClient.connectorProperty("WinHTTPAuthScheme") = 0x2
Jimmy
"Jimmy Wu [MSFT]" wrote:
> Hi,
> If I remember correctly, you will need to specify the user and password as
> part of the URL you used to initialize the MSSoap.SoapClient object. If that
> isn't possible, I recommend creating the data connection using the normal SQL
> database method.
> Please also make sure that you have granted access to the Endpoint and the
> Stored Procedure for the user you wish to connect with.
> Jimmy
> "jahu" wrote:
> > Hello!
> >
> > I'm unable to use a webservice exposed on a Sql Server 2005 by using
> > the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
> > is to write a function for a Excel Sheet wich resolves some
> > identifiers to strings by using a SQL Server 2005. I thougt to use web
> > services but end up with errors, as you can read furthre down.
> >
> > If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
> > wrong, I would be very happy if some one could advise me.
> >
> > The exception in VBA is about '... access denied...'. The SQL Server
> > logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
> >
> > The Endpoint I want to use is as follows:
> > CREATE ENDPOINT SQLEP_gmd
> > STATE = STARTED
> > AS HTTP
> > (
> > PATH = '/gmd',
> > AUTHENTICATION = (INTEGRATED),
> > PORTS = (CLEAR),
> > SITE = '2003dellp285002'
> > )
> > FOR SOAP
> > (
> > WEBMETHOD 'getNextReferenceSubstanceIdentifier'
> > (NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
> > BATCHES = DISABLED,
> > WSDL = DEFAULT,
> > DATABASE = 'metabolomics',
> > NAMESPACE = 'http://2003dellp285002'
> > )
> >
> >
> > The stored procedure is very simple, has no input parameters and
> > returns a string to simplify matters.
> >
> > Any commnt is apreciated very much!
> >
> > With kind regards
> >
> >

Authenctication to Report Builder

I m really new to reporting service. I dnt know what I did but once I try to access "http://localhost/reports" it will prompt me for username & password. And whatever I typed in is incorrect...

Help Please~

Thank you,

Elton

By default, the reporting services will use NT authentication. You should be able to use the NT administrator account to login.

|||

Thankumcsenow,

I thought I tried that before but it does not seem work...Acturally, I m currently open Report server directly from IIS and also I applied the integrated auth.

Cheers,

Elton

attaching a link to an email subscription

Our report manager and reports are accessed over a secure conection but the link uses http:// by default. where can i change that to https://?

You can change default report serwer url address in configuration files of your report server (rsreportserver.config or something like that)