I need to Give DBA full admin rights to SQL 2005 without OS windows rights, can anyone help plea

The DBA at our location is demanding local admin (windows) right's to the box so he can function. Right now when he logs in i have given him right's to the inetpub directory, sql directory, i have set him as a sysadmin on sql2005 and gone into the http:\\localhost\reports and set him up as a system manager and under site priveledges set him as a sys admin. When he tries to login and configure the report server he gets the following error:

Title-Reporting services configuration manager

Error-There was an error refreshing the UI. bla bla bla

A WMI error has occurred and no additional error information is availiable

Title-Reporting services configuration manager

Error-There was an error while switching panels. The most likely cause is an error retrieving WMI properties. bla bla bla

A WMI error has occurred and no additional error information is availiable

then when he's in sql server 2005 surface area configuation

Title-Surface Area Configuration

Error-Access denied (system.management)

Is there any documentation or anythign anyone can tell me that i can do to give this DBA full access to configure and admin the SQL portion of his system without giving him admin rights to the OS?

Please help!!

Thanks for any time anyone has taken to review this thread!!

There's no issue in giving him/her admin rights to the box. In most cases, he'll/she'll need it. Don't confuse local admin on the box with network admin rights.

Adamus

|||

That's the problem in my environment i cant give local admin rights to any box. This is per PCI requirements which is a credit card VISA format amongst other regulations i'm under.

Do you have any other info that can provide assistance?

|||I

The DBA at our location is demanding local admin (windows) right's to the box so he can function. Right now when he logs in i have given him right's to the inetpub directory, sql directory, i have set him as a sysadmin on sql2005 and gone into the http:\\localhost\reports and set him up as a system manager and under site priveledges set him as a sys admin. When he tries to login and configure the report server he gets the following error:

Title-Reporting services configuration manager

Error-There was an error refreshing the UI. bla bla bla

A WMI error has occurred and no additional error information is availiable

Title-Reporting services configuration manager

Error-There was an error while switching panels. The most likely cause is an error retrieving WMI properties. bla bla bla

A WMI error has occurred and no additional error information is availiable

then when he's in sql server 2005 surface area configuation

Title-Surface Area Configuration

Error-Access denied (system.management)

Is there any documentation or anythign anyone can tell me that i can do to give this DBA full access to configure and admin the SQL portion of his system without giving him admin rights to the OS?

|||Moving to the SQL Server Security Forum.|||

ok i think i figured out the surface area config issue, theres a link that states : Add new administrator in which i did and i can access all pages now, but it wont obviously let a non admin restart services, since there's a handful of services i think i'll just have/set the services under the SQL admins credentials, unless someone knows of a better way, in which i can allow the sql admin to restart services?

On the other issue i still cant access the reporting service configuration page, still recieving a WMI error?//

Please anyone HELP!!

|||

These sources should help you understand and configure the appropriate account/security for your DBA.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557

|||

Ok i was looking over the attached documents. It pretty much looks from what you've given me, if i setup the services on the local machine to run under the SQL DBA's credentials that i wont need to do anything further, this will in turn give the SQL DBA access without any errors?

Personally i dont think the service items are the issues but if you're positive this will do what i dneed to do i'll try it. Please reconfirm my understanding of the situation before i attempt to run changes please.

Again thanks for your assistance.

I need to display the name of an expanded group

Hi everyone,
I want to display the name of an expanded group within a seperate text
box. The problem is that it doesn't work because my seperate text box
is "not part of the group area" which the name/field belongs to. What
should I do?
How can I access report items of a group outside that group? I though
I could temporarily copy values from a field of a group into a 'global
parameter' (if it's possible, of course) and then make my text box
display the value by referencing that parameter. But since I don't
know how to do that either, I have run out of ideas.On Mar 14, 11:01 am, "mailfo...@.googlemail.com"
<mailfo...@.googlemail.com> wrote:
> Hi everyone,
> I want to display the name of an expanded group within a seperate text
> box. The problem is that it doesn't work because my seperate text box
> is "not part of the group area" which the name/field belongs to. What
> should I do?
> How can I access report items of a group outside that group? I though
> I could temporarily copy values from a field of a group into a 'global
> parameter' (if it's possible, of course) and then make my text box
> display the value by referencing that parameter. But since I don't
> know how to do that either, I have run out of ideas.
If I'm understanding you correctly, you could use something like the
following:
To access a parameter, use an expression like: =Parameters!
ParameterName.Value
To access a dataset outside of it's normal scope, use an expression
like: =Max(Fields!FieldName.Value, "DataSetName")
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Its not possible to have a report item placed outside the group. It can be
placed only on header, footer or in the grouping. One option is that in your
grouping you can insert as many blank rows and then place the report items,
but that too static headers not the details of any rows. ie you can refer one
value and not multiple.
Amarnath,MCTS
"mailforpr@.googlemail.com" wrote:
> Hi everyone,
> I want to display the name of an expanded group within a seperate text
> box. The problem is that it doesn't work because my seperate text box
> is "not part of the group area" which the name/field belongs to. What
> should I do?
> How can I access report items of a group outside that group? I though
> I could temporarily copy values from a field of a group into a 'global
> parameter' (if it's possible, of course) and then make my text box
> display the value by referencing that parameter. But since I don't
> know how to do that either, I have run out of ideas.
>|||Thank you very much, guys.
Is there any other way to determine whether a group has been expanded
or not? I don't necessarily have to display a value of a field of a
specific group area in a seperate text box, but rather something like
"oh, you have just expanded group xyz, so I let you know that in that
text box you see over there"...?
The code might probably look like this:
textbox.Value:
=IIF(groupXYZ.Expanded,"Group XYZ is expanded","nothing or something
else is expanded")
Is that possible?

I need to create maintenance plans on SQL 2005 without using the wizard

I have several hundred SQl installations I need to change or create a maintenance plan and i don't want to touch every box. I need the step by step process to load the tables myself.

If you want to run the maintenance from a single seat, you could create a set of maintenance tasks in Integration Services, and create multiple connections for them. If you want to have the same plan on multiple servers run from each server, I'd create an Integration Services package again and ship it to the other servers. Use (local) as the connection string, assuming the same account can access each server.

Buck Woody

http://www.buckwoody.com

|||

It sounds like you're already familiar with maintenance plans in SQL 2K5, but just in case you're not:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=33&rl=1

Again, if you're a pro on this, my apologies.

Buck Woody

|||Thanks! Thought about the distribution of a services package but that doesn't initilize the maintenance folder in th SQL Enterprise tree. I know that sounds trivial but I got to follow standards.|||If this answers the question, you can mark it "answered". If you need anything else, just let us know!

Buck Woody|||Just in case you're interested in the process, you can import and export you maintenance plans. You can right click on one of your maintenance plans and then select import or export. Export from one, import to the other.

You can also "pull" your maintenance plan to another server. To do this, on the target server connect to Integration Services on the server where you created your original maintenance plan. Then go to Stored Packages - MSDB - Maintenance Plans. Right click on Maintenance Plans and then select Import.

Buck
|||Thanks

I need to connect to SQLServer 7.0 from a Linux box using php

Has anyone got experience connecting to a MS SQL Server 7.0 over the
Internet from a Linux Web Server using PHP4.3.x ?
This for a Real Estate MLS IDX feed.
I have heard I can use ADODB and another said FreeTDS (Tabular
DataStream) protocol can be used. Not sure if these people had any
experience with it.
use ODBTP (http://odbtp.sf.net).
imho it's by far the best way to get PHP and MSSQL together (on both,
Windows and Unix/Linux boxes)
"ftw" wrote:

> Has anyone got experience connecting to a MS SQL Server 7.0 over the
> Internet from a Linux Web Server using PHP4.3.x ?
> This for a Real Estate MLS IDX feed.
> I have heard I can use ADODB and another said FreeTDS (Tabular
> DataStream) protocol can be used. Not sure if these people had any
> experience with it.
>
|||Why do you like ODBTP better than ADODB?
|||Well, ADODB is a library, ODBTP a PHP extension you can't compare those two,
in fact you can use ADODB with ODBTP
The biggest plus for ODBTP compared to other extensions is it's great
Unicode support and it's easier to handle than freeTDS
"ftw" wrote:

> Why do you like ODBTP better than ADODB?
>
|||Thanks for the input Sascha!