By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

SQL server didn't exist or access denied

P: n/a
I can't connect to our database (seperate database server) from within my
webservice. I cannot understand why.!!!

* I have configured IIS not to allow anonymous access and to use "windows
integrated authentication"
* I have configured the webService to use "windows" authentication and to
impersonate whomeever uses it.
* In the client (the one that consumes the webservice) I have specified the
network credentials (DefaultCredentials) that the webService is to use.
* The database is configured to let me (my user) access the database.
* The connection string specifies integrated security
- In the webService I get the CurrentUser and check if it is my account: It
is

This setup didn't let me access the database nor did it allow me to write
debug files so I did a explicit impersonation of my user account (uid, pass
adn domain); result: I can write files whereever I want but I still cannot
access the database.

I tried to change the ProcessModel of IIS in machine.config to run as System
instead (higher privilegies). To no avail...

What to do.???

I know that I could login to the database using SQL authentication but that
is less secure and it doesn't answer this question.
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Johan,

Have you had a chance to look at the SQL server log? The log might give
more information on what is going on.

Thanks,
Yuri

"Johan Johansson (Sweden)" <Jo******************@discussions.microsoft.com>
wrote in message news:2B**********************************@microsof t.com...
I can't connect to our database (seperate database server) from within my
webservice. I cannot understand why.!!!

* I have configured IIS not to allow anonymous access and to use "windows
integrated authentication"
* I have configured the webService to use "windows" authentication and to
impersonate whomeever uses it.
* In the client (the one that consumes the webservice) I have specified
the
network credentials (DefaultCredentials) that the webService is to use.
* The database is configured to let me (my user) access the database.
* The connection string specifies integrated security
- In the webService I get the CurrentUser and check if it is my account:
It
is

This setup didn't let me access the database nor did it allow me to write
debug files so I did a explicit impersonation of my user account (uid,
pass
adn domain); result: I can write files whereever I want but I still cannot
access the database.

I tried to change the ProcessModel of IIS in machine.config to run as
System
instead (higher privilegies). To no avail...

What to do.???

I know that I could login to the database using SQL authentication but
that
is less secure and it doesn't answer this question.

Nov 21 '05 #2

P: n/a
Hi,

Without some information on the specific error you are getting, it's hard
to fathom a guess. Does the connect to SQL step return an error? What
does it say?

Regards

Dan Rogers
Microsoft Corporation
--------------------
Thread-Topic: SQL server didn't exist or access denied
thread-index: AcTNWgAAq5OnvEeJSkGEecQA0ZhaKQ==
X-WBNR-Posting-Host: 139.58.232.1
From: =?Utf-8?B?Sm9oYW4gSm9oYW5zc29uIChTd2VkZW4p?=
<Jo******************@discussions.microsoft.com>
Subject: SQL server didn't exist or access denied
Date: Thu, 18 Nov 2004 02:33:10 -0800
Lines: 26
Message-ID: <2B**********************************@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!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl
microsoft.public.dotnet.framework.webservices:7523
X-Tomcat-NG: microsoft.public.dotnet.framework.webservices

I can't connect to our database (seperate database server) from within my
webservice. I cannot understand why.!!!

* I have configured IIS not to allow anonymous access and to use "windows
integrated authentication"
* I have configured the webService to use "windows" authentication and to
impersonate whomeever uses it.
* In the client (the one that consumes the webservice) I have specified
the
network credentials (DefaultCredentials) that the webService is to use.
* The database is configured to let me (my user) access the database.
* The connection string specifies integrated security
- In the webService I get the CurrentUser and check if it is my account:
It
is

This setup didn't let me access the database nor did it allow me to write
debug files so I did a explicit impersonation of my user account (uid, pass
adn domain); result: I can write files whereever I want but I still cannot
access the database.

I tried to change the ProcessModel of IIS in machine.config to run as
System
instead (higher privilegies). To no avail...

What to do.???

I know that I could login to the database using SQL authentication but that
is less secure and it doesn't answer this question.

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.