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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2011-04-20 : 12:19:12
|
| We have an issue that has recently developed with no clues as to why or how so I would appreciate any thoughts. Basically we have a Sharepoint server (2003) - which I know very little about - this server uses SQL Server 2000 for its configuration etc. and it sits on IIS. The SQL Server is on a seperate physical box to the Sharepoint one.This setup is duplicated on a live and a test setup and the issue applies to both setups.The symptoms of this issue are that if you go to for example an HTML or an ASP page on the IIS/Sharepoint box we get an error, usually a http 403 but sometimes we get a sharepoint error which suggests permissions, though I think this is probably masking a 403.So what does this have to do with SQL Server? Well I set a trace on the SQL Server in the hope of getting a clue and I think I may have one. Sharepoint uses a domain account to access the SQL Server and that works fine. However when I browse from my machine to one of the web pages I noticed that I get a failed login from the Sharepoint box. So if the Sharepoint box was called SPS I would get a failed login from MyDomain\SPS$ - note the dollar appended to the box name and the application name shows as IIS. My guess is that this is some sort of attempted anonymous access from IIS. Having said that there has been no change that I am aware of to IIS for some considerable time. There have been no patches added since well before this started. The odd thing is that it happened to both live and test at roughly the same time.Any thoughts would be greatly appreciatedsteve-----------If debugging is the process of removing software bugs, then programming must be the process of putting them in. |
|
|
|
|
|
Clutching at straws