Viewing 15 posts - 1,906 through 1,920 (of 2,902 total)
I am thinking you are using the -o parameter and not the -i one (or possibly both), right? -i is for an input file, -o is for output file. Well,...
May 20, 2020 at 8:04 pm
When you say multi-subnet, I am thinking that is a multi-VLAN setup, correct?
Communication across VLANs may require additional configuration to allow the communication.
If it is really multi-subnet, I am assuming...
May 20, 2020 at 5:59 pm
My advice - try it and find out.
Having the site not secure when accessing it locally is likely because you are connecting to "https://localhost/reports_ssrs", right? Connecting by server name should...
May 20, 2020 at 5:51 pm
You can use a SSL certificate and HTTPS (ie port 443) with SSRS no problem. SSC actually has a good tutorial on this:
https://www.sqlservercentral.com/articles/configure-ssrs-with-an-ssl-certificate
In that tutorial it explains how to use...
May 20, 2020 at 2:43 pm
Glad to hear you got it sorted out.
Thanks for reporting back!
May 19, 2020 at 7:34 pm
Thanks scdecate! That is a bit more elegant of a solution than what I was proposing.
Seems to have a bug though - it returns the week of the 27th through...
May 19, 2020 at 7:25 pm
if you haven't configured anything special, then port 80 is used for HTTP traffic.
If you want a SHORT TERM test, you can turn off the firewall on the server and...
May 19, 2020 at 5:03 pm
Then it is likely a firewall issue. Do you have port 80 open on the server to allow for HTTP traffic (or port 443 for https, or whatever port you...
May 19, 2020 at 4:23 pm
Just to get a bit more info with this - you want to give a date range, and you want SQL to figure out how to break that up into...
May 19, 2020 at 4:21 pm
Quick guess (as I don't have SSRS open in front of me), could you do something like add the Commission column to be calculated on the SQL side and then...
May 19, 2020 at 4:10 pm
Could be DNS or could be firewall.
From your machine, can you PING the remote server by name? If not, can you ping it by IP?
May 19, 2020 at 3:55 pm
Yep. That will work. When you add encryption by service master key, it will overwrite the previous one.
I've had to do this when doing some restores from live to test...
May 15, 2020 at 9:44 pm
My opinion, if it is a sequence or an identity really depends on a lot more than we can accurately guess from what was posted. It might be that each...
May 15, 2020 at 9:04 pm
Yep. That was what I meant - the database master key in every case of the "master key" except when I had said "service master key".
But basically, if you NEED...
May 15, 2020 at 7:43 pm
My advice is to back up the master key no matter what. Hypothetically, the server dies and needs to be rebuilt from scratch. You install the SQL instance, restore the...
May 15, 2020 at 5:29 pm
Viewing 15 posts - 1,906 through 1,920 (of 2,902 total)