Posted by Erland Sommarskog on 07/04/06 21:43

Lucky (tushar.n.patel@gmail.com) writes:
> Thanks for your replay. yeah i'm running the SQL server locally but it
> is added to the active directory and i've rights in active directory to
> insert,delete,update as well as i'm using the administrator("sa")
> account in SQL Server to run the query.
>
> yeah, it seems the problem is with user permission but i don't know how
> and where i need to correct them.
>
> any idea on this?

I don't know much about Active Directory, but it appears to me that you
failed to understand Stu's reply.

Right-click My Computer, select Manage, find Service. In the list,
find the SQL Server service. Double-click and go to the Log on tab.
What does it say? If it says Local System, you are out of luck, because
Local System does not have network privileges. You need to specify a
domain account that has permissions in the AD.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]