Sue_H

Forum Replies Created

Viewing 15 posts - 3,691 through 3,705 (of 4,477 total)

RE: Transactional replication keeps applying snapshot

Thanks for the follow up - much appreciated. I totally hate those where a cause is never found. It's always there somewhere. And I'm foolish enough to pick...

April 20, 2017 at 1:53 pm

#1939187
RE: Ssrs 2014 migration to 2016.

Yup, messing up the naming of the account and renaming probably causes the same problems with the permissions with the SIDS as the issue that is fixed in...

April 20, 2017 at 7:52 am

#1939082
RE: Ssrs 2014 migration to 2016.

So it is an issue with the account but I think it's more likely that you might be hitting a bug with it that was fixed in SP1....

April 20, 2017 at 6:51 am

#1939054
RE: SQL Server Multi Administration Job not appearing on target server inquiry

For the first error with "not involved in a multiserver job" that sounds like it may not have a download list for that server. Check the properties for one...

April 19, 2017 at 4:14 pm

#1938986
RE: Ssrs 2014 migration to 2016.

The fairly useless "Something Went Wrong" error when using a new install of Reporting Services can often just happen from configuration issues. You'd probably want to look for earlier...

April 19, 2017 at 2:46 pm

#1938967
RE: SQL Standard 2012 and SQL Express

With that error, it's more likely that credentials aren't being passed.
This article has a pretty good explanation of Kerberos, SPNs and how they come into play across...

April 19, 2017 at 2:04 pm

#1938947
RE: Transactional replication keeps applying snapshot

You are very welcome. Please post back after the reinit if you can - I'm curious to see if that corrects things or not. Weird issue.

April 19, 2017 at 12:20 pm

#1938908
RE: Ssrs 2014 migration to 2016.

You shouldn't delete the key at all though. Just restore the key on the new server from the original backup that you took on the old server. And...

April 19, 2017 at 12:11 pm

#1938906
RE: Transactional replication keeps applying snapshot

Check the jobs I mentioned. If the snapshot has completed it would (or should) be disabled and it should list as Completed in Replication Monitor. And the Log...

April 19, 2017 at 12:01 pm

#1938901
RE: Transactional replication keeps applying snapshot

Tom Schuettke - Wednesday, April 19, 2017 10:43 AM
It is standard transactional replication. It's been running fine for about 9 months. I...

April 19, 2017 at 11:24 am

#1938892
RE: Transactional replication keeps applying snapshot

Only if the publication was setup for snapshot replication. That's really the only time that happens.
Maybe something got confused with the setup and the need for...

April 19, 2017 at 10:34 am

#1938878
RE: Ssrs 2014 migration to 2016.

If you did it previously without problems you would have managed the process with the key differently.
Backup the key on the original - your case...

April 19, 2017 at 10:17 am

#1938872
RE: tempdb - second ldf

It doesn't affect performance like the data files. Writes to the log are just sequential writes. If you are tight on space and think you may run out...

April 19, 2017 at 10:11 am

#1938870
RE: The Service Broker endpoint is in disabled or stopped state.

SQL-DBA-01 - Monday, April 17, 2017 8:31 PM
Any way to suppress the alert? Can we use any trace flag to suppress it?
Unfortunately...

April 18, 2017 at 8:07 am

#1938526
RE: Blank Output when I run the restore script

That's an old post but the error is likely not related to needed to change the script. It's only designed for Maintenance Plan backups meaning the naming and...

April 18, 2017 at 8:03 am

#1938524

Viewing 15 posts - 3,691 through 3,705 (of 4,477 total)