Viewing 15 posts - 4,801 through 4,815 (of 6,400 total)
Well you will need to find the level of rights which securityadmin gives the user then use the DENY keywords to manually deny the permissions you dont want them to...
May 31, 2012 at 4:52 am
You dont have access to the SSRS DB or Local System doesnt? Is the report db on your local machine or is it on a remote server?
May 31, 2012 at 4:40 am
I will second that John, last selection I had was at the local beer festival http://www.beer-festival.co.uk/, had a very good range of cask, other than that not really much good...
May 31, 2012 at 4:25 am
running as local system which is a highly priviledge account, should really be running your services with a less priviledge account, that aside, check that local system has access to...
May 31, 2012 at 4:17 am
no you wont be insuring against fail over, nothing can insure against that, if it happens it happens, you will need to find the cause of what made the cluster...
May 31, 2012 at 4:14 am
why not just create a proc, which executes sp_readerrorlog as a different user, which has access to read the logs, then just grant your users the rights they need to...
May 31, 2012 at 4:12 am
I've just checked our cluster (Server 2008, SQL 2008, 4 node, 3 instance) and each instance has its own MSDTC, but I have worked in a multi instance environment before...
May 31, 2012 at 4:06 am
You can manually add in the key to the registry if you wish. It's something to do with the kernel so unsure if you have a dodgy install of...
May 31, 2012 at 4:02 am
If you have Enterprise/Standard already why not just install SSMS from the installation media and get the full functionality?
The functionality of express management studio is limited, you cant connect to...
May 31, 2012 at 3:57 am
May 31, 2012 at 3:40 am
If you failed over an LS broke, then yes when you fail over again it will break until you fix the issues.
What is the likelyhood of failing over? It...
May 31, 2012 at 3:36 am
Just register as self employed on HMRC, can setup as a sole trader, you will get a bill every 6 months to pay self employed NI contributions on top of...
May 31, 2012 at 3:31 am
You will need to redevelop the report in VS/BIDS 2005 to use it on a 2005 SSRS installation. Its the old thing of you can upgrade but you cant...
May 31, 2012 at 3:26 am
Are you self employed? If so you will need to take a recent correspondence from HMRC in or something along time lines to register for a tradecard to shop...
May 31, 2012 at 3:17 am
in sql server config manager, what is the user which is running the SSRS service?
then in SSMS, ensure that this account has access to the databases under the security tab.
May 31, 2012 at 3:02 am
Viewing 15 posts - 4,801 through 4,815 (of 6,400 total)