A bad error!

hi friends!
i have a web service in .NET 2003 that contain below error and I cant handle it...
...

Anunhandled exception of type 'System.Web.Services.Protocols.SoapException'occurred in system.web.services.dll

Additionalinformation: System.Web.Services.Protocols.SoapException: Server was unable toprocess request. --> System.Data.SqlClient.SqlException: Login failed foruser 'MICROGOD3\ASPNET'.

atSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection)

atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

atSystem.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

atSystem.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectionowningObject, SqlConnectionString connectionOptions, String newPassword,Boolean redirectedUserInstance)

atSystem.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionString connectionOptions, Object providerInfo, StringnewPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

atSystem.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnectionowning Connection)

atSystem.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionowning Connection, DbConnectionPool pool, DbConnectionOptions options)

atSystem.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

atSystem.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnectionouterConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

atSystem.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[]datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommandcommand, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSetdataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommandcommand, CommandBehavior behavior)

atSystem.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at LeitnerWebService.Service1.GetData() inc:\inetpub\wwwroot\leitnerwebservice\service1.asmx.cs:line 68

-- End of inner exception stack trace --

PLEASE HELP ME!The Windows user, the web service runs under on the server, user being MICROGOD3\ASPNET based on the error message, does not have permissions to log into the SQL Server you use. It should have a login in SQL Server and the login should be granted permissions to access the database in question.

64-bit SQL Server, Any patches needed?

Is there a specific service pack for the 64-bit version of
SQL 2000? Should I apply the SP3a or is that only for the
32-bit version? I can't find any info about SP3a with
respect to applying it to the 64-bit version.
Karl Renaut, CIO
FDN Communications.I'd like to know this as well. I just downloaded the
MSDN Version and need to know if there are any
precautions to protect SQL Server from Slammer, etc.
Thanks,
Mike
>--Original Message--
>Is there a specific service pack for the 64-bit version
of
>SQL 2000? Should I apply the SP3a or is that only for
the
>32-bit version? I can't find any info about SP3a with
>respect to applying it to the 64-bit version.
>Karl Renaut, CIO
>FDN Communications.
>.
>

64 bit

is there a service pack for 64-bit sql server? if so, please point me to
where i can find it.
thanks.
i forgot to say sql server 2000 64-bit
"Mark" <mark_kurten@.acordia.com> wrote in message
news:eJ0xsxzTFHA.3952@.TK2MSFTNGP15.phx.gbl...
> is there a service pack for 64-bit sql server? if so, please point me to
> where i can find it.
> thanks.
>

64 bit

is there a service pack for 64-bit sql server? if so, please point me to
where i can find it.
thanks.i forgot to say sql server 2000 64-bit
"Mark" <mark_kurten@.acordia.com> wrote in message
news:eJ0xsxzTFHA.3952@.TK2MSFTNGP15.phx.gbl...
> is there a service pack for 64-bit sql server? if so, please point me to
> where i can find it.
> thanks.
>

64 bit

is there a service pack for 64-bit sql server? if so, please point me to
where i can find it.
thanks.i forgot to say sql server 2000 64-bit
"Mark" <mark_kurten@.acordia.com> wrote in message
news:eJ0xsxzTFHA.3952@.TK2MSFTNGP15.phx.gbl...
> is there a service pack for 64-bit sql server? if so, please point me to
> where i can find it.
> thanks.
>

501 when connect to Endpoint

I Created SP and endpoint that exposes SP as web service :

CREATE PROCEDURE TimeServer.ResponseTime2
(
@.TimeType int,
)
AS
IF (@.TimeType = 0 )
SELECT @.Result AS CZAS
ELSE
SELECT @.Result AS CZAS
GO
CREATE ENDPOINT MyWebService
STATE = STARTED
AS HTTP
(
PATH = '/AdventureWorks/MyWebService',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'localhost'
)
FOR SOAP
(
WEBMETHOD 'GetTime' (Name = 'AdventureWorks.TimeServer.ResponseTime2', FORMAT = ROWSETS_ONLY),
DATABASE = 'AdventureWorks'
)

GO

When I try to connect to webservice (localhost/AdventureWorks/MyWebServic
I get 501 error - Not implemented or not supported.

Any ideas why ?

I don't know if this answers your question. However, we support HTTP GET requests ONLY for requesting WSDL. In this case if you submitted the following request

http://localhost/AdventureWorks/MyWebService?wsdl

it should return WSDL describing the endpoint.

The rest of the SOAP requests have to be submitted via HTTP POST.

Thanks
Srik

|||

I was also getting this at one point. Try going into IE browser->Tools->Internet Options->Advanced and enable "Use HTTP 1.1 through proxy connections" if this is not set (may be related to proxy settings associated wih IE Browser->Connections->LAN Settings)

501 when connect to Endpoint

I Created SP and endpoint that exposes SP as web service :

CREATE PROCEDURE TimeServer.ResponseTime2
(
@.TimeType int,
)
AS
IF (@.TimeType = 0 )
SELECT @.Result AS CZAS
ELSE
SELECT @.Result AS CZAS
GO
CREATE ENDPOINT MyWebService
STATE = STARTED
AS HTTP
(
PATH = '/AdventureWorks/MyWebService',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'localhost'
)
FOR SOAP
(
WEBMETHOD 'GetTime' (Name = 'AdventureWorks.TimeServer.ResponseTime2', FORMAT = ROWSETS_ONLY),
DATABASE = 'AdventureWorks'
)

GO

When I try to connect to webservice (localhost/AdventureWorks/MyWebServic
I get 501 error - Not implemented or not supported.

Any ideas why ?

I don't know if this answers your question. However, we support HTTP GET requests ONLY for requesting WSDL. In this case if you submitted the following request

http://localhost/AdventureWorks/MyWebService?wsdl

it should return WSDL describing the endpoint.

The rest of the SOAP requests have to be submitted via HTTP POST.

Thanks
Srik

|||

I was also getting this at one point. Try going into IE browser->Tools->Internet Options->Advanced and enable "Use HTTP 1.1 through proxy connections" if this is not set (may be related to proxy settings associated wih IE Browser->Connections->LAN Settings)

404 error when using Web Service

I'm building a client application that uses the SSRS Web Service. My problem
is that when I use the servername the web service works just fine. ie
http://RServer/ReportServer/reportservice.asmx
If I try to use the full DNS name of the server any call I make to the web
service returns a 404 error.
ie if I use http://RServer.sdm.dm.com/ReportServer/reportservice.asmx which
points to the same server gives me a 404 error..I've looked at the config
files for ReportServer and can't figure out what's going wrong...
Any help would be greatly appreciated..
Thanks
JasonHello Jason,
To use the FQDN name of the report server, please check the ReportServerUrl
element in the RSWebApplication.config file.
You need to specify the FQDN name for this element. Please refer this
article:
RSWebApplication Configuration File
http://msdn2.microsoft.com/en-us/library/ms155878.aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.

403 trying to access RS web service

Just installed SRS on a remote server. Tried to access the web service at
http://<IP>/reportserver/reportservice.asmx and get 403 - Forbidden.
When the system is installed, anonymous is turned off. When I turn it on I
still get 403 - Forbidden.
Thoughts?
TIA.Damned I.S. guys had IIS configured to disallow all clients except local.
Rrrrrrr..
Prob solved.
"Mark Peters" <mcpdoc@.hotmail.com> wrote in message
news:%23jGrjsJiFHA.708@.TK2MSFTNGP09.phx.gbl...
> Just installed SRS on a remote server. Tried to access the web service at
> http://<IP>/reportserver/reportservice.asmx and get 403 - Forbidden.
> When the system is installed, anonymous is turned off. When I turn it on
> I still get 403 - Forbidden.
> Thoughts?
> TIA.
>

401 Web Service Access

Hi,
We are getting a 401 unauthorized error when trying to create subscriptions
via a web service from our .Net. The server is Windows Server 2003 with SP1
and Reporting Services with SP2.
The frustration is that one of our servers is fine with this setup and the
other one is giving the 401 error! I have tried adding the DWORD registry
entry as commonly suggested, but have had no luck (the server that works
doesn't have this entry either).
Would anyone therefore be ale to offer any solutions?
Thanks
DaveUPDATE:
We have found that this problem only occurs if we have the reporting server
on a different server to the application server which is calling the web
service. If they are both hosted on the same machine, everything is fine.
I am guessing that this is because the user information isn't being passed
correctly?

401 authorization denied error for web service proxy

all-
When I have a SQLXML 3.0 virtual directory set up on the same web server as the one that my application is in on my local machine, I can run the application. When I move the web reference (and the web service) to a different server, I can access the
application on my machine with http://localhost but not http://<machinename>.
I have tried setting various properties from the System.Web.Services library in addition to credentials. Here are the the things I have tried:
proxy.UnsafeAuthenticatedConnectionSharing = true;
proxy.Credentials = CredentialCache.DefaultCredentials;
proxy.PreAuthenticate = true;
Maybe the problem is with IIS, but the username does seem to be passed in correctly when it is localhost.
to recap
SAME BOX LOCAL WEB, REMOTE SQLXML BOTH REMOTE
http://localhost YES YES NO
http://<machinename> YES NO NO
After further troubleshooting I can say with some confidence that this is a problem with server-to-server communication.
I have found KB articles on ServerXMLHTTP and how to pass default credentials from server to server, but no examples in .NET.
I also tried every syntax of proxycfg that I could think of, all the way down to
proxycfg -d
Now all requests bypass the proxy server and I still can't pass default credentials.
Any help would be greatly appreciated.