Viewing 15 posts - 16 through 30 (of 6,344 total)
Verify both the share permissions and the NTFS permissions, just because it has access to the share doesn't mean it has access to the actual disk.
Also then map the UNC...
September 12, 2024 at 9:18 am
Have you checked and/or configured MSDTC to allow "remote/network transactions".
What do your MSDTC setting look like on the component services snapin on the linked host.
September 11, 2024 at 7:42 am
Just verify in SQL Server Configuration manager that SQL has actually got TCP/IP enabled in all the right areas, as there's the part for the engine and for the client...
September 5, 2024 at 8:30 am
That's the same problem then, all your connection managers / data sources are having the same issue, so will need to force the connection property NP:
Looks like whatever you done...
September 5, 2024 at 8:27 am
Add TCP: to the beginning of the servername, or NP: if wanting to force named pipes etc.
September 4, 2024 at 3:57 pm
OH, sorry with you saying TCP/IP thought it was going over the network.
Probably try forcing a protocol in the SSRS config manager, like TCP:MySQLServer or NP:MySQLServer in the SSRS connection...
September 4, 2024 at 3:14 pm
Something is in the way of your machine and the SQLServer.
Best thing would be to work with your Network Admins & DBA's to ensure your workstation can connect over the...
September 4, 2024 at 2:56 pm
Not you're local firewall, could be the firewall on the SQL Server, could be a network level firewall too, there's multiple places a firewall could be.
I missed the -Port keyword,...
September 4, 2024 at 2:47 pm
Log shipping would be your friend here, use the previous full and log backups to make your new copy on the new server then setup LS to do the usual...
September 4, 2024 at 1:57 pm
Have you verified that there is no firewall issue in the way?
Is SSMS installed on the SSRS server where you tested it successfully or is it on another machine?
Can the...
September 4, 2024 at 1:50 pm
The error message is saying otherwise.
Please provide screenshots of your SSMS window so we can actually see what is happening, as in my SQL2022 setups, I only get the error...
September 2, 2024 at 10:33 am
That error is pretty self explanatory.
You may have disabled the audit, but you haven't disabled the audit specification.
Ensure you disable the right thing, and then it will let you modify...
September 2, 2024 at 8:17 am
When you installed SQL there would have been an option to set the auth mode, did you select Mixed or Windows only?
If it was mixed, what password did you give...
August 29, 2024 at 7:59 am
No there’s no differences between the patches
August 21, 2024 at 6:28 pm
2016 is a dead product now, only time it will get an update is if there is a CVE that needs fixing.
You’ve got less than 2 years to get off...
August 20, 2024 at 6:33 pm
Viewing 15 posts - 16 through 30 (of 6,344 total)