Viewing 15 posts - 1,921 through 1,935 (of 2,917 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,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 20, 2020 at 2:43 pm
Glad to hear you got it sorted out.
Thanks for reporting back!
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 15, 2020 at 5:29 pm
Viewing 15 posts - 1,921 through 1,935 (of 2,917 total)