Thursday, March 27, 2003 4:55 PM HomeSkillet

TaskVision and integrated db security...

We had to re-install TaskVision today. It had been living on an R & D machine that recently bit the dust. Since it was being used quite a bit when it went down, we decided to place the db on our production db server and the web services on a .NET server so that we would have max uptime, automatic backup, etc. Didn't think it would be a probem until I tried to log it. No dice, just threw back some vague error message about contacting the network admin. However, I could login to the webservice via a web browser. Weird. Anyway, it turns out that since we didn't use integrated security like the default connection string, the db password wasn't passed beyond the first request. I don't know how long it would have taken me to figure that out had it not been for the Windows Forms Forums.

Is it just me or does it seem like there is much stronger feeling of community and a greater amount help from the community than with ASP 3.0? Whatever it is, it sure is great. 

Filed under:

Comments

# re: TaskVision and integrated db security...

Thursday, March 27, 2003 4:27 PM by julie

Mitch-
I had a problem that smelled like that one, but wasn't corrected even by ripping out AppDataBlocks entirely and replacing integrated security with uid and pw. I was having issues after the first request as well! I was not even hitting the database. Heck I was not even hitting the web service. I did blog on this a few days back:
http://dotnetweblogs.com/JLerman/posts/4283.aspx

# that's the spirit! : Julia Lerman Blog

Thursday, March 27, 2003 5:55 PM by TrackBack

that's the spirit! : Julia Lerman Blog

# TaskVision and integrated db security...

Monday, November 26, 2007 4:22 PM by TaskVision and integrated db security...

Pingback from  TaskVision and integrated db security...

Leave a Comment

(required) 
(required) 
(optional)
(required)