Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Running DTS from ASP page
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Running DTS from ASP page
 Post Reply Post Reply Page  <1 3456>
Author
  Topic Search Topic Search  Topic Options Topic Options
socialanimal View Drop Down
Newbie
Newbie
Avatar

Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39 		Post Options Post Options   Thanks (0) Thanks(0)   Quote socialanimal Quote  Post ReplyReply Direct Link To This Post Posted: 05 November 2007 at 6:55pm
Ok this is getting stranger ...

A few questions that come to mind ?

  • Is your laptop using a local or roaming profile ?
  • On this other box using IIS can you connect to the same database ?
  • Are you logged on to this box directly ?
Back to Top
Gary View Drop Down
Senior Member
Senior Member
Avatar

Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gary Quote  Post ReplyReply Direct Link To This Post Posted: 05 November 2007 at 7:01pm

Sorry, I dont know whether I am using local or roaming profile?

Using the other box I can connect to the db through IIS
 
I am not logged onto the other box directly
 
I think that is all my brain can take today. I shall go home and sleep on it.
Let me know if you have any more suggestions.
 
Again, I really appreciate the effort that you are putting into this.
Back to Top
socialanimal View Drop Down
Newbie
Newbie
Avatar

Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39 		Post Options Post Options   Thanks (0) Thanks(0)   Quote socialanimal Quote  Post ReplyReply Direct Link To This Post Posted: 05 November 2007 at 7:04pm
ok no problem ... will keep looking into this for you
Back to Top
socialanimal View Drop Down
Newbie
Newbie
Avatar

Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39 		Post Options Post Options   Thanks (0) Thanks(0)   Quote socialanimal Quote  Post ReplyReply Direct Link To This Post Posted: 06 November 2007 at 1:14pm
Have you tried accessing the web page (that executes the dts) from another machine ? 
Back to Top
Gary View Drop Down
Senior Member
Senior Member
Avatar

Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gary Quote  Post ReplyReply Direct Link To This Post Posted: 06 November 2007 at 2:23pm

Yes, and I get exactly the same errors back.....

Accessing page returns the "Login failed for user 'fanle01'" error (machine accessing the page is not logged on under the fanle01 account.

 
Back to Top
socialanimal View Drop Down
Newbie
Newbie
Avatar

Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39 		Post Options Post Options   Thanks (0) Thanks(0)   Quote socialanimal Quote  Post ReplyReply Direct Link To This Post Posted: 06 November 2007 at 2:32pm
How are the permissions setup in IIS ? Do you have the default IIS account enabled or disabled for anonymous login? Do you use integrated windows authentication or another option ? In the home directory tab, which options do you have selected (ie read, write, execute etc)? 
Back to Top
Gary View Drop Down
Senior Member
Senior Member
Avatar

Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gary Quote  Post ReplyReply Direct Link To This Post Posted: 06 November 2007 at 3:01pm

IIS is configured as follows:

Integrated Windows autentication only
(not sure about the default IIS account though - how can I find this?)
 
 
Back to Top
socialanimal View Drop Down
Newbie
Newbie
Avatar

Joined: 14 October 2007
Location: Leeds, UK
Status: Offline
Points: 39 		Post Options Post Options   Thanks (0) Thanks(0)   Quote socialanimal Quote  Post ReplyReply Direct Link To This Post Posted: 06 November 2007 at 3:47pm


To view it go into the directory security and edit tab, that will bring up the above dialog screen. I'm just checking things now ... I honestly don't think it would be the cache now we've tested other things but I could be wrong.
Back to Top
 Post Reply Post Reply Page  <1 3456>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.