Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > Permissions problem accessing SQL Server from Web Service on Windows 2003

Reply
Thread Tools

Permissions problem accessing SQL Server from Web Service on Windows 2003

 
 
RichardF
Guest
Posts: n/a
 
      05-25-2005
I have a Web Service that accesses a SQL Server database.

IIS, SQL Server and the Web Service are all running on the same
machine.

As I have done on other machines, I gave the appropriate permissions
to the IIS_WPG user group.

However, on this machine, when my web service tries to open a
connection to the database I get the following message...

..Net SqlClient Data Provider: System.Data.SqlClient.SqlException:
Login failed for user <DOMAINNAME>\<MACHINENAME>$'. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at
MyWebService.OpenTheDBConnection()

Where <DOMAINNAME> and <MACHINENAME> are the domain name and machine
name of the machine where I am running everything.

Any ideas why it is using <DOMAINNAME>\<MACHINENAME>$ instead of the
IIS_WPG group?

Thanks for any help.

RichardF
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Faulting application error occured while installing SQL Server service pack 3a(sp3a) on Windows Server 2003 Ent 64bit Edition Joshua Son Windows 64bit 0 03-16-2007 01:09 AM
401 Error on Windows 2003 Server Accessing Web Service Stephen ASP .Net Web Services 1 11-10-2004 10:44 PM
access permissions in asp.net web service in windows 2003 server Ollie ASP .Net Web Services 2 05-28-2004 09:28 AM
access permissions in asp.net web service in windows 2003 server Ollie ASP .Net Security 0 05-25-2004 01:13 PM
Elevating permissions for Web service running on IIS6/Windows Server 2003 Peter Bernhardt ASP .Net Security 1 01-14-2004 01:05 PM



Advertisments