Can I get ordinary users to create reports rather than admin...?

Can I get ordinary users to create reports rather than admin using a web browser interface?

If you mean with the Reporting Model, yes. Without Reporting Builder you will need Visual Studio.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for replying - It looks OK however the Reporting Builder program would have to be installed on the end users machines (meaning we would have to convince IT Departments to let them do this) and would have to use a DBA to set up the initial database models for each business. So I'm thinking this is probably not the best solution.

A reporting section is integrated within the current application that the user can configure. In the new application we didnt want to re-code this functionality and not to have a DBA to configure the reports and prefer not to install extra applications.

If you could think of any 3rd parties that are similar to Reporting Builder that could integrate with our application I would be really grateful? You mentioned Visual Studio - Will I be able to integrate it their?

Can all SS2000 jobs run as owner "sa"?

We have several servers, each with many jobs. Some jobs run as Owner "SA", and some jobs running as various domain admin accounts. We have been told to modify all jobs to run with Owner "SA". Now, some of the jobs read or write flat files and I am a little concerned about this. Does the domain account which starts the SS2000 services determine the rights to read and write files? If so, I guess changing all jobs owners to "SA" has no real risk?

Thanks!

Michael

With respect to accessing external resources, the service account which runs SQL Server Agent requires access rights to those resources for the job to be successful. The owner of the job has no effect on those rights.

HTH.

Can 2000 and 2005 coexist?

I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin" machine. I currently have just 2000 (server & client
tools) installed on the admin machine. Is it possible to install (not
upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
both the 2005 server and client tools) Any suggestions on how to achieve
having both versions installed on the same machine?
Thank you,
Ben
Yes. I had 2000 with two instances on my machine. I installed 2005 with one (named) instance and my
2000 tools are still there. I did get a new program group with 2005 tools.
I can now admin 7.0 and 2000 servers using EM 2000.
And I can manage 2000 and 2005 servers using Management Studio.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ben Amada" <ben@.REpoMOweVErpick.com> wrote in message news:OL2oKXd5FHA.620@.TK2MSFTNGP12.phx.gbl...
>I need to manage a couple of SQL 2000 servers and a couple of 2005 servers from a single "admin"
>machine. I currently have just 2000 (server & client tools) installed on the admin machine. Is it
>possible to install (not upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
>both the 2005 server and client tools) Any suggestions on how to achieve having both versions
>installed on the same machine?
> Thank you,
> Ben
>
|||Tibor Karaszi wrote:

> Yes. I had 2000 with two instances on my machine. I installed 2005 with
> one (named) instance and my 2000 tools are still there. I did get a new
> program group with 2005 tools. I can now admin 7.0 and 2000 servers using
> EM 2000.
> And I can manage 2000 and 2005 servers using Management Studio.
That's very good news that it is possible. As soon as I get a chance, I'll
give it a try and see what happens.
Thanks,
Ben

Can 2000 and 2005 coexist?

I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin" machine. I currently have just 2000 (server & client
tools) installed on the admin machine. Is it possible to install (not
upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
both the 2005 server and client tools) Any suggestions on how to achieve
having both versions installed on the same machine?
Thank you,
BenYes. I had 2000 with two instances on my machine. I installed 2005 with one (named) instance and my
2000 tools are still there. I did get a new program group with 2005 tools.
I can now admin 7.0 and 2000 servers using EM 2000.
And I can manage 2000 and 2005 servers using Management Studio.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ben Amada" <ben@.REpoMOweVErpick.com> wrote in message news:OL2oKXd5FHA.620@.TK2MSFTNGP12.phx.gbl...
>I need to manage a couple of SQL 2000 servers and a couple of 2005 servers from a single "admin"
>machine. I currently have just 2000 (server & client tools) installed on the admin machine. Is it
>possible to install (not upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
>both the 2005 server and client tools) Any suggestions on how to achieve having both versions
>installed on the same machine?
> Thank you,
> Ben
>|||Tibor Karaszi wrote:
> Yes. I had 2000 with two instances on my machine. I installed 2005 with
> one (named) instance and my 2000 tools are still there. I did get a new
> program group with 2005 tools. I can now admin 7.0 and 2000 servers using
> EM 2000.
> And I can manage 2000 and 2005 servers using Management Studio.
That's very good news that it is possible. As soon as I get a chance, I'll
give it a try and see what happens.
Thanks,
Ben

Can 2000 and 2005 coexist?

I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin" machine. I currently have just 2000 (server & client
tools) installed on the admin machine. Is it possible to install (not
upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
both the 2005 server and client tools) Any suggestions on how to achieve
having both versions installed on the same machine?
Thank you,
BenYes. I had 2000 with two instances on my machine. I installed 2005 with one
(named) instance and my
2000 tools are still there. I did get a new program group with 2005 tools.
I can now admin 7.0 and 2000 servers using EM 2000.
And I can manage 2000 and 2005 servers using Management Studio.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ben Amada" <ben@.REpoMOweVErpick.com> wrote in message news:OL2oKXd5FHA.620@.TK2MSFTNGP12.phx
.gbl...
>I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin"
>machine. I currently have just 2000 (server & client tools) installed on t
he admin machine. Is it
>possible to install (not upgrade) SQL 2005 on the admin machine? (Preferab
ly I'd like to install
>both the 2005 server and client tools) Any suggestions on how to achieve h
aving both versions
>installed on the same machine?
> Thank you,
> Ben
>|||Tibor Karaszi wrote:

> Yes. I had 2000 with two instances on my machine. I installed 2005 with
> one (named) instance and my 2000 tools are still there. I did get a new
> program group with 2005 tools. I can now admin 7.0 and 2000 servers using
> EM 2000.
> And I can manage 2000 and 2005 servers using Management Studio.
That's very good news that it is possible. As soon as I get a chance, I'll
give it a try and see what happens.
Thanks,
Ben