• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

Help in configuration web service with SQL 2005

Hi

My problem follow :

I have Web Service (wrote Microsoft.Net 2003) ; Database name : Shipping (SQL server 2005)

Connection String :
ConnectionString="Data Source=localhost;Initial Catalog=Shipping;Integrated Security=SSPI;"  

Web Service is work but it is not connect database Shipping for Calculate .

Please , help me in configuration
0
andreni78
Asked:
andreni78
2 Solutions
 
imitchieCommented:
what is the account used for the web directory (iis configuration)? is it <iusr_machinename>?
integrated security=sspi tells it to use the currently logged in account (iusr_machinename) to authenticate with sql server
have you granted that user access, and to the database Shipping?
0
 
YveauCommented:
This is probably a delegation issue.
What is the exact error message ?

Does the user's credentails get passd to the SQL Server ? In that case you probably see an error that tells you that login failed for user ''. In that case you have to setup the connection to run under a special account doing an impersonation and connecting to the SQL Server.

Hope this helps ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now