?
Solved

Username and Password not required - how to get

Posted on 2002-04-11
2
Medium Priority
?
128 Views
Last Modified: 2010-04-13
I have a Windows 2000 machine that functions as a server to an intranet.  It is W2K Pro - not W2K server - but it functins fine.  When I go into Users and Passwords on this machine, I get a little check box at the top "Users must enter a username and password to use this computer."
I don't have it checked, so anyone can use the machine thru HTTP services, and can access the ASP's on the intranet, even though the Access DB's those ASP's use are on another server.

I am trying to upgrade the server, and I have another, better box to replace the old intranet.  I installed IIS 5.0, loaded all the stuff from C:\inetpub\wwwroot, etc. , and tried going to the "new" intranet.  I can get there with HTTP services, but when I go to view the intranet pages that go against Access DB's on other drives, I get the following:

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data."

Now, the only differences between the boxes is that on the one that works, I don't need a login, and on the one that doesn't work, I do need a login.  I think this is the rub, but I'm not sure.  One last thing, when I power down the box that works, I don't have to log back in (It knows to reboot as Administrator), but I have to log into the other box.  Is this a W2K issue (which I think it is), and, if it is, how to I effect the change on my new box to let users use it without logging in?


0
Comment
Question by:mbenish
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 63

Accepted Solution

by:
SysExpert earned 600 total points
ID: 6934746
It could also be a file-permission or related to a SID identifier.

Double check the setups, and especially all the file permissions and IIS settings.

Also check the MS site - advanced search and see if you can find your error messages.

I hope this helps !
0
 

Author Comment

by:mbenish
ID: 6934842
It was the IIS settings.  I set the user that accesses IIS site to a user in my NT domain rather than the IUSR_nodename on domain nodename it automatically assigns when installing.

I solved this before I got this message, but, I will give somethin', you know, for the effort (a la Carl Spackler to the Dalai Lama)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question