RE: Webservice can not connect to Sql server 2000

I think it is a problem of permissions

I have added groups to IUSR_LANDON, IWAM_LANDON

I suspect it is a problem that will be resolved by the sharing wizard

Let me know if you discover a clue!

Think about it...C# code is trying to connect but instigated by a client on
the web.

Long ago I had this problem with Oracle/Windows. I had to make many many
subdirectories shareable or ???

"sameer" wrote:

Landon, i am having exactly the same problem, i can connect from a winforms
application but not from a webservice application.

thanks

"Landon Kelsey" wrote:

I can connect easily using C# & ADO.NET on standalone programs.

I am trying to connect from a web site program under .NET 1.1 VS 7 and
always get

Login failed for user 'LANDON\ASPNET'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'LANDON\ASPNET'.

Source Error:


Line 46: private void Page_Load(object sender, System.EventArgs e)
Line 47: {
Line 48: sqlConnection1.Open();
Line 49: ds = new DataSet();
Line 50: daAttendees = new SqlDataAdapter(


Source File: c:\inetpub\wwwroot\pcswebapp2\webform1.aspx.cs Line: 48

having signed in under IE6 using:
http://localhost/PCSWebApp2/WebForm1.aspx
I've tried everything to fix the problem;

MAYBE make inetpub shareableor what else?



"sameer" wrote:

Environment:
OS of sql server 2000 server: windows 2003 standard server , .NEt framework
1.1 , sql server does not have any service pack, machine has the latest
Windows service pack. Personal firewall is not enabled on this machine. All
machine are within the same network.

All i am dong is trying to open a connection from a .Net webservice (using
ADO.NET which uses a connection string) which is sitting on machine A with
IIS installed on it and connecting to the sql server which is running on
Machine B.

This used to be working all the time till the sql server that i was pointing
my webserivce was sitting on a windows 2000 box but as soon as i started
pointing to Sql; sever sittign on Windows 2003 , my application says "sql
server does not exist or access denied".

Strange part is i can register this sql server on my mahcine using
enterprise manager as well connect using query analyser and a UDL file. but
websericce can not connect to it.

what can it possibly be , please suggest.

thanks
Sameer
.

Relevant Pages

  • trusted delegation
    ... Ensure that Bob has an account on the SQL Server. ... Bob's SQL Server username/password to the Web Service ... string with Bob's credential's and open that connection. ... >WebService, the same user is used for connection to SQL ...
    (microsoft.public.sqlserver.security)
  • Not associated with trusted SQL connection.
    ... I have a WebService that opens a connection with an SQL ... The authentication setting in the SQL server is set ...
    (microsoft.public.sqlserver.security)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
Loading