Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Archive
ASP .Net
ASP .Net Web Services
Problem retrieving data from SQL Server
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Knut-Olav Traa, post: 4319919"] Hello, When you run the function as a vb.net app, you are accessing the db as your own windows user (which probably have access to the database). When the web service is trying to access the database, it uses the user 'NT AUTHORITY/NETWORK SERVICE'. You should create a new user in the sql server that has access to database and specify this user in the connectionstring when creating the sqlconnection object, like specified in: ([URL]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassopentopic.asp[/URL]) Best regards, Knut-Olav Traa knut-olav.traa [AT] bekk.no [/QUOTE]
Verification
Post reply
Forums
Archive
Archive
ASP .Net
ASP .Net Web Services
Problem retrieving data from SQL Server
Top