• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Accessing Computer's Shares directly...how?

Hi,

We have just had to reinstall the OS on an SQL/webserver on the network. The computer does not log onto the domain controller just is on the same workgroup. Before, we were able to access the computers shares directly from other client's computers, now we get a username/password challenge. If we provide the valid credentials it works, however loses the credentials when the client logs his computer off. I have checked the permissions on the shares and has the "Everyone" account with full access.

Any help?

Thanks

T
0
TotalIQ
Asked:
TotalIQ
  • 2
  • 2
2 Solutions
 
td_milesCommented:
you are correct, if you provide credentials to connect to a remote computer they are only cached for that logon session.

If you don't want to add the server to the domain, the easier way to provide transparent access is to create a local user account on the SQL server with the SAME username and password as the users domain account. When you try to access a remote machine windows automatically tries to use the currently logged on credentials first, then prompts if this doesn't work. If the local account on the SQL server is the same, it should work and you won't get prompted. The problem with this is obviously that if the domain password changes (eg. it expires) then you need to manually change the password for the account on the SQL server to be the same again. Strangely enough, this was why domain controllers were invented, to provide centralised store of passwords and central authentication for all devices.
0
 
simonenticottCommented:

td_miles is right saying you need to add accounts on the new server for all people that connect.

Its possible you had the guest account enabled on the old machine, though this is pretty insecure.

Simon
0
 
TotalIQAuthor Commented:
Hi,

Thanks guys, I have split the points accordingly

Regards

T
0
 
simonenticottCommented:
i didn't help much, i just wanted to confirm to you that td_miles was right in my opinion.
thanks anyway.
0
 
td_milesCommented:
Can I ask why a grade of B ?

According to the help on grading:
http://www.experts-exchange.com/help.jsp#hi73

B: The Expert(s) provided an acceptable solution, or a link to an acceptable solution, that you were able to use, although you may have needed a bit more information to complete the task.

What didn't I provide or what could I have done better ?
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now