How is your network connection managed? The calls to SQL server can go
over either TCP/IP or over named pipes. If your SQL client is configured
for TCP/IP, then you need a valid network connection to talk to SQL Server.
I hope this helps
Dan Rogers
Microsoft Corporation
--------------------
Thread-Topic: Error connecting to SQL Server through a Web Service???
thread-index: AcTX3tYEVMW3Zl0ETZOgKNJRjwF+vw==
X-WBNR-Posting-Host: 4.158.243.47
From: "=?Utf-8?B?R1REcml2ZXI=?=" <GT******@discussions.microsoft.com>
References: <C5**********************************@microsoft.co m>
<85*********************@msnews.microsoft.com>
Subject: Re: Error connecting to SQL Server through a Web Service???
Date: Wed, 1 Dec 2004 11:49:14 -0800
Lines: 44
Message-ID: <01**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl
microsoft.public.dotnet.framework.webservices:7727
X-Tomcat-NG: microsoft.public.dotnet.framework.webservices
Drew - Thanks , I added ASPNET user to the database and it worked fine.
However, I noticed when I try to use this webservice, I have to be
connected
to the internet. This webservice is on my local machine( the webserver on
my
Win2K profesional pc). I'm not trying to get any ohter info other than
connect to SQL Server database and return the query.
Why do I have to be connected to the Internet for this to work?
Thanks,
Keith
"Drew Marsh" wrote:
GTDriver wrote:
What is causing this error?
Login failed for user '......
Where is the 'ASPNET' comming from in the login failed for user
'myserver\ASPNET'?
Looks like your SqlConnection string is setup to use Windows
authentication. The ASP.NET worker process runs as that account that you're seeing.
Therefore if you need your web service application to login to the database using
Windows authentication you need to permit yourdomain\ASPNET to the database (I
suggest with very low permissions) or you need to change your web service
application to run as a different Windows user (all kinds of security considerations
to make there). I usually use the latter, but you just need to be very
careful what rights you grant that account.
As another option, you can change your connection string to use SQL
authentication (which has it's own considerations).
HTH,
Drew
___________________________________
Drew Marsh
Chief Software Architect
Mimeo, Inc. - http://www.mimeo.com
Weblog - http://blog.hackedbrain.com/