Viewing 15 posts - 46 through 60 (of 966 total)
Yep, you cannot use EXCEPT on a 2005 instance. The feature wasn't introduced until SQL Server 2008.
September 10, 2017 at 3:05 am
Do the errors always happen during the same times/days? You mentioned earlier in the thread restarting all SQL services, does that mean that SSRS and the database engine are on...
September 8, 2017 at 3:42 pm
How long do the datasets in the query take to run if you execute them outside of the report, like from SSMS or SQLCMD?
September 8, 2017 at 3:12 pm
Just to clarify what Sue mentioned the trust for delegation setting needs to be set on the account running the SQL Server service on the instance with the linked server....
September 8, 2017 at 3:01 pm
Do ping requests from the laptop on the parent network respond to the IP to the SQL Server on the parent network? That would help verify that layer 3 networking...
September 8, 2017 at 2:51 pm
Is anything posted in the SSRS logs during the times when you get the error?
You can find them here:
%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles
September 8, 2017 at 2:33 pm
What do you mean by SSRS 2010 report? Is this a report made in Visual Studio 2010?
Are the production and test SSRS instances the same version and build...
September 8, 2017 at 2:28 pm
Are you able to post a screenshot of the error and the rdl for review?
September 8, 2017 at 2:23 pm
Is that the same error you get when accessing the report directly using the reportserver web service and navigate to the report? Is this native SSRS or SSRS in SharePoint...
September 8, 2017 at 2:21 pm
You might be able to do it modifying the start properties of the SSRS service in the registry specifying the affinity you want in the imagepath value of the service...
September 8, 2017 at 2:17 pm
Quick Google search turned up looking for event id 7035 in the system log.
August 27, 2017 at 2:50 pm
If you installed SQL Server 2016 on the VM then you can find out what the instance info is. Go to Start > All Programs > SQL Server 2016 and...
August 27, 2017 at 4:16 am
When you installed SQL Server 2008 on your Windows 7 machine did you select BIDS? Can you see Business Intelligence project types when you go to create a new project?...
August 27, 2017 at 3:34 am
It's a little hard from that screenshot to tell if that is the virtual name/IP of the Availability Group or the WSFC itself. Are there any error in the cluster...
August 17, 2017 at 12:42 pm
Viewing 15 posts - 46 through 60 (of 966 total)