August 27, 2012 at 7:26 am
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.
August 27, 2012 at 3:11 pm
Looks like the SQL Server service account is not set to a domain user. Is it "Local System" or "Local Service"?
-- Gianluca Sartori
August 28, 2012 at 12:04 am
It was local system account. I have set it to windows domain account. But still the error is unchanged.
August 28, 2012 at 4:10 am
The error is resolved. I had to set "DisableLoopBackcheck" parameter value in the registry for the server.
August 28, 2012 at 7:41 am
Glad you sorted it out!
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply