August 27, 2014 at 2:32 am
Hi all,
I've just started a new job and the role I have taken on is completely new within the organisation. As such, as role of MI Manager I will be starting an MI Team off from scratch. What this obviously means is that I will need to install the software and get everything moving.
Although I have numerous years experience actually using SQL Server, I have (believe it or not!) never had to install it or physically set it up.
Unfortunately it seems there is quite a bit of red tape here (quite normal in fairness) and despite SQL Server already being used elsewhere in the business (by IT) they've got their own server and databases set up but seem a bit cautious about giving me access.
Therefore, my question was as follows; in the interim, would it be possible for me to create my database(s) locally (i.e. not on any main server but on my local machine), create SSRS reports off the back of that data, but then deploy them to an online ReportServer that could still be accessed by people throughout the business (i.e. other than those using my local machine).
In my head it sounds like a silly question and I assume the answer is "no", but just in case it is possible, I wondered how simple it would be to do this? If it can be done it will certainly be a weight off my mind as that will mean that I can start developing in the interim whilst I attempt to negotiate my way around the red tape!
Thank you in advance for any help or guidance that you are able to provide.
August 27, 2014 at 2:45 am
You can install SQL Server locally and create reports locally. But once you deploy the SSRS reports to another machine, the data source of this reports needs to be accessible. The data has to come from somewhere...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 27, 2014 at 3:03 am
Thank you for the response Koen; that's what I thought.
Another noob question; would a way around it just be to have IT set me up a completely seperate server? I.e. I could create my own databases completely seperate from theirs? If so, is there any reason they might turn this request down; i.e. will it cost extra money etc etc?
Apologies for the daft questions; as I say, I've not had to set up SQL from scratch before - historically all I've done is write queries from within it!
August 27, 2014 at 3:20 am
there will undoubtedly be a cost which your dept may be expected to fund
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 3:22 am
ben_manns 49753 (8/27/2014)
Thank you for the response Koen; that's what I thought.Another noob question; would a way around it just be to have IT set me up a completely seperate server? I.e. I could create my own databases completely seperate from theirs? If so, is there any reason they might turn this request down; i.e. will it cost extra money etc etc?
Maybe they can provision you with a virtual server. It may come with a licensing cost, but they already have the hardware...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 27, 2014 at 4:00 am
Koen Verbeeck (8/27/2014)
but they already have the hardware...
There would still usually be a nominal cost to cover hardware, maintenance and OS licensing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 6:24 am
Development license should do the trick along with signing up for Microsoft Action Pack that gives you access to Microsoft Software for development purposes?
August 27, 2014 at 12:22 pm
If you have database and SSRS running off your machine so that others can access it, you cannot do your day to day activity. You need your computer ON all the time, pretty much your computer needs to be treated as a server. Is that what you want?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply