I am tying to buid a new BDC sample aplication in my sharepoint server with Visual Studio 2010 but when i deploy this i get the following error :
Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.
So i just read many posts and found that it is becoz of Permission issues and i tried to give owner db permission to the database Sharepoint_Config in sql server.
But the problem is i cannot set the owner db permission to sharepoint_config db.It shows the foll error :
Create failed for User 'sa'. (Microsoft.SqlServer.Smo)
Cannot use the special principal 'sa'. (Microsoft SQL Server,Error : 15405)
Am i missing somethin to get this work, if so please let me know.
View Complete Post