New answers tagged sql-server
I think this is the correct way of doing it. Copying the data from Old List to new List using datasheet view would have made copying data easy, but datasheet view is not available in External list. You can create a console application or PowerShell script which will read data from old list and insert it into new External list.
So this is how I solved this problem. I simply installed SQL Server 2008 on my VM so I was able to create a database which I then could connect to on the very same VM.
Are you Backup on shared folder, if yes then check SQL Server permission there on Shared folder. For me it looks like permission issue. Yes it will do SharePoint part properly but when it will try to do the backup of SQL Database, that time it will use SQL Server Service account may be that account will not have permission to Shared folder. Another thing ...
PowerShell is the best "Tool" for this job. Are there any other specific requirements you have?
Frank, I would start by reviewing the ULS logs. Generally there will be some events that point you in the direction of the issue (if not the actual issue itself.) The error says "...or the Service". If you can pull a correlation ID it may guide you to the group of transactions that are failing. There are MANY reasons that it would fail that do not require ...
I feel your pain. All I can think of is to re-create the User Profile (if nothing has changed in terms of service accounts). If you want to troubleshoot the issue, I would start with this great article: http://www.harbar.net/articles/sp2010ups.aspx
Here is a post that explains how to do this via code in the report: "Sum Result of SSRS LookupSet Function" http://salvoz.com/blog/2013/05/27/sum-result-of-ssrs-lookupset-function/
Top 50 recent answers are included