Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rob8888
Starting Member
4 Posts |
 Posted - 2007-09-30 : 17:19:50
|
| HiI'm pulling my hair out on this one..... Installed SQLServer 2005 Express and upscaled my website and intranet site that runs my photo image library.All my thumbnails and images are in a local D drive, while my site root is in C drive. I.e. <img src="file:///D|/Images-WMASTER......etcImages will now not display. I've checked folder & sharing permissions, IIS permissions, all the usual stuff, but still with no luck after 2 weeks #@%$$@!!If I change to a networked folder, such as <img src="file:///S|/Images-WMASTER...etc then they show fine.All I can think is that there is some permissions issue with SQLServer that I'm unaware of. Your erudite advice would be greatly appreciated!Thanks, Rob |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-30 : 17:28:52
|
Why would this have anything to do with the SQL Server? On your web page what path is showing in the source for the image, is it the correct path?
Future guru in the making. |
 |
|
|
Rob8888
Starting Member
4 Posts |
Posted - 2007-09-30 : 18:30:13
|
| Hi thereIt's been working fine for 5+ years. I installed SQLserver and it stopped working that day! I have tried everything I know with directories/IIS etc, to no avail.I can only sermise that SQLserver has taken over some permissions on th local machine etc. Hence a request here for help - I'm out of ideas.Any ideas?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-30 : 19:04:27
|
| Shouldn't happen if you just installed sql. How do you pull those images? Did you get any error message? |
|
|
|
Rob8888
Starting Member
4 Posts |
Posted - 2007-09-30 : 19:46:24
|
| Nope, just get the usual image missing in the browser (square with red 'x'). I've double checked the link over and over, run tests. It works fine mapping to directories on the network or the localhost directory, but not to the D drive on the local computer. All folder and IIS permissions look fine. As I said - only stopped since the SQL install? I see an app called 'SQL Server Active Directory Helper' not running....anything to so with this? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-30 : 20:28:49
|
| It shouldn't running, os uses it when you add sql into active dierctory. What kind of app do you use to display images? Does stop sql service fix the problem? |
|
|
|
Rob8888
Starting Member
4 Posts |
Posted - 2007-09-30 : 21:01:45
|
| Thanks for your help. I did bit of detective work after you said it couldn't be SQL. Well,I remember that when I did the windows update as recommended prior to SQL, it updated IExplorer also. So I've just discovered that I had to add the localhost to the trusted sites list (initially I couldn't until I unclicked the allow server verification.....). All fine now. Thanks for the help. Only 2 weeks of rummaging..... Cheers Rob |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-30 : 21:12:16
|
| Glad to hear you fixed the problem. |
|
|
|
|
|
|
|
|
SQL install - no images from other directories