Viewing 15 posts - 1 through 15 (of 4,476 total)
The data and log files usually aren't deleted when you uninstall. You can manually delete them and then try the reinstall.
Sue
June 1, 2021 at 9:23 pm
Not sure what you are testing or what your errors are or what's breaking but shared features tend to be shared by instances on the server. Instance specific are specific...
May 24, 2021 at 10:31 pm
The results can be misleading when it's different group types - Universal (which xp_logininfo doesn't support), Global, Domain Local and when it involves nested groups. It can be a challenge...
May 24, 2021 at 9:59 pm
Not a direct equivalent but to access tables in other remote databases in MySQL you usually enable Federated Storage Engine and use Federated tables. I don't remember much of the...
May 18, 2021 at 5:24 pm
If the roles don't exist and things seem to mostly work, permissions are likely fairly messed up. As the documentation indicates, the role is in master and msdb and the...
January 26, 2021 at 4:24 pm
Old snapshots are deleted by the distribution cleanup agent. The distribution cleanup job will delete snapshots older than the @max_disretention value. It used to be, haven't tested so may still...
January 25, 2021 at 10:19 pm
The error can crop up, and often with subscriptions, when you have the RSExecRole not configured correctly. Review the following documentation - there is a script at the end of...
January 25, 2021 at 9:11 pm
You could look at enabling some trace flags before the restore to get more detailed information. Most of the articles on doing this mention using trace flags 3004 and 3605...
November 10, 2020 at 4:54 pm
I don't think you could have task scheduler open up SSMS and execute a job through SSMS but you really don't necessarily need to do it that way. You could...
October 15, 2020 at 3:26 pm
A couple of places to check - in the job, edit the step that executes the package and check the Package tab where the login can be specified and on...
October 12, 2020 at 6:05 pm
I've gotten the error on configuration issues before but it doesn't mean that's the issue. And you are right - there is little information on it and on some of...
October 5, 2020 at 7:18 pm
DTC is supported with Express but from the error it looks like the service isn't running or you haven't configured DTC - or both. Ensure the service is running. For...
October 1, 2020 at 11:59 pm
You don't have the error anymore so it's hard to say. I have seen it come up when statistics were out of date and that would be my first guess...
October 1, 2020 at 9:49 pm
Those connection errors could be firewall, could be proxy related...could be a lot of things. In terms of SQL Server, there were some issues with connectivity on Linux and I...
October 1, 2020 at 9:34 pm
You don't want to run them together to compare them the way you are comparing them though - it's just not accurate. And you want to be sure you really,...
October 1, 2020 at 9:31 pm
Viewing 15 posts - 1 through 15 (of 4,476 total)