Post reply

Authentication problem

  • June 1, 2005 at 1:51 pm

    #86886

    Hello,

    Im using SQL Server 2005 Beta-2 on windows xp. I am not able to restore data from a remote folder. I mapped the remote folder to a local drive (say Z. I use restore to access the data on Z drive but it says operating system cannot find the file (error 3). So I use the remote folder using its network name (say \\nt2).

    The remote system has secure access and need username and password. I dont know how to supply this information to the 'restore' to work... I tried password, mediapassword, medianame ... which are of no use... I always end up with access denied error (error 5) I read from other forums that I should use the same username and password but I dont know how to synchronize.. I tried using all possible combinations .. its just not workin...

  • June 1, 2005 at 4:30 pm

    #562385

    SQL Server (2000 and 2005) runs as a service under a specific account, which can also be LocalSystem. If you are going to access remote locations you need to make sure that SQL Server is running as a domain account that has permission to access that location.

    Btw, I would definitely recommend you upgrade to the latest release of SQL Server 2005 (currently April CTP, but June CTP will be out any day now) if you are going to be doing any testing with it. A lot has changed since Beta 2 so it can be dangerous to base anything on that.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply