Please! Need help configuring my Windows 2000 Server and SQL Server
Posted on 2004-04-24
Hi All, this may seem long intro but it is impt. Info on what I am trying to accomplish.
We have a Netware network where we sign every morning. The clients PC has W2k Professional and Windows Office Professional. I would like to setup a W2k server with SQL2000 Server because I created an MS Access application that will use MS Access as a frontend and SQLServer as a backend. The computer that I use as a server is Dell PowerEdge 2400 with 5 swap discs ( I think that is what’s called – swap).
I did install the W2k Server and SQL Server to my server. When I login to Netware every morning using my own regular PC, it asks me for a second password to login as Admin to my server. I also mapped that drive so that I can see and access the files in my server using the Windows Explorer in my own computer. I am OK at this point, however,
Questions: How and what is the best way to do all of the following:
1. How do I make my users connect to my server just like I do and access the shared folder without giving them the Admin password. Not so sure about this but, I think I have to set them up in Groups and Users. Unfortunately, it won’t allow me to do the SNAP IN because I set it up as PDC during the Active Directory configuration.
2. When my users run the frontend of application in MS Access, will they be able to retrieve from and update data in SQL Server. Do they have to login again to SQLServer. I was hoping there is a way not to have login again to if they already did to W2k Server.
3. What about these multiple physical discs that I have in my server? I only used one when I install the W2k server. My boss said I should use them all. Do I have to install the W2k server to all those discs?
I greatly appreciate all your help.