I am getting an error while creating OLEDB connection in SSIS Package as following
test connection failed because of an error in initializing provider.Cannot generate SSPI context Sql server network interfaces: the local security authority cannot be contacted.
I have SQL server 2008 R2 version running on local server. I am able to connect to the SQL server using Windows authentication. But when i try to create OLEDB connection in SSIS package i am getting above error.
SQL Browser is running.
I have even checked SQL server configuration and Named pipes are enabled. But still i am getting the same error.
Any idea where to look would be of great help?
View Complete Post