Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem While accessing Network Drive - Trusted Connection Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 7:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 8:03 AM
Points: 135, Visits: 216
Hello,
We have SQL Server 2008 installed on Windows 7 (32 bit). I am trying to execute a stored procedure which in turn accesses network drives. I have logged in through windows authentication. While executing the stored procedure I get an error

Proc. :<SPROC name>
Error :-2147467259
Source:Microsoft OLE DB Provider for SQL Server
Desc. :Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.


I am not sure where to start the trouble shooting from?Can anyone assist?

Thanks in advance.


Post #1350375
Posted Monday, August 27, 2012 3:11 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 5,018, Visits: 10,536
Looks like the SQL Server service account is not set to a domain user. Is it "Local System" or "Local Service"?

--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1350614
Posted Tuesday, August 28, 2012 12:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 8:03 AM
Points: 135, Visits: 216
It was local system account. I have set it to windows domain account. But still the error is unchanged.
Post #1350698
Posted Tuesday, August 28, 2012 4:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 8:03 AM
Points: 135, Visits: 216
The error is resolved. I had to set "DisableLoopBackcheck" parameter value in the registry for the server.

Post #1350781
Posted Tuesday, August 28, 2012 7:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 5,018, Visits: 10,536
Glad you sorted it out!

--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1350933
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse