Accessing Computer's Shares

Posted on 2005-04-06
Last Modified: 2010-04-10

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?


Question by:TotalIQ
    LVL 13

    Accepted Solution

    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.
    LVL 5

    Assisted Solution


    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.


    Author Comment


    Thanks guys, I have split the points accordingly


    LVL 5

    Expert Comment

    i didn't help much, i just wanted to confirm to you that td_miles was right in my opinion.
    thanks anyway.
    LVL 13

    Expert Comment

    Can I ask why a grade of B ?

    According to the help on grading:

    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 ?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    TechValidate Research on Citrix NetScaler

    Are you looking for an ADC. See what people like you say about Citrix NetScaler. Visit this site to find TechFacts, Charts and Case Studies.

    I was recently sitting at a desk at work with one of my colleagues and needed some information on my home computer. He watched as I turned on my home computer, established a remote session into it, got the information I needed and then shut it down …
    What is IRC? IRC (Internet Relay Chat) is a form of communication between multiple users. It is available freely to anyone with inernet access. IRC is a great way to communicate with others e.g. There is an IRC channel for Ubuntu Linux, which is fo…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now