Promoting a SQL Server 2000 to a DC

I manage a small Win 2k domain with 3 servers and about 20 users (IIS for ou
r
website on one server, DC & Exchange on one, SQL 2000/file/print on one). W
e
currently have a single DC in our domain and I want to promote one of the
other servers to a DC for backup purposes. The IIS box is out because it
hosts our public web page, which leaves me with the SQL box. I read that
DCPromo removes any local user accounts and am not sure of how this will
affect our SQL Server. It is currently using mixed authentication and start
s
as a system account. Any constructive feedback is appreciated.>
> I manage a small Win 2k domain with 3 servers and about 20 users (IIS for
our
> website on one server, DC & Exchange on one, SQL 2000/file/print on one).
We
> currently have a single DC in our domain and I want to promote one of the
> other servers to a DC for backup purposes. The IIS box is out because it
> hosts our public web page, which leaves me with the SQL box. I read that
> DCPromo removes any local user accounts and am not sure of how this will
> affect our SQL Server. It is currently using mixed authentication and
starts
> as a system account. Any constructive feedback is appreciated.
--
For performance reasons, we generally do not recommend running SQL Server
on a domain controller.
Regards,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.sql

Promoting a SQL Server 2000 to a DC

I manage a small Win 2k domain with 3 servers and about 20 users (IIS for our
website on one server, DC & Exchange on one, SQL 2000/file/print on one). We
currently have a single DC in our domain and I want to promote one of the
other servers to a DC for backup purposes. The IIS box is out because it
hosts our public web page, which leaves me with the SQL box. I read that
DCPromo removes any local user accounts and am not sure of how this will
affect our SQL Server. It is currently using mixed authentication and starts
as a system account. Any constructive feedback is appreciated.>
> I manage a small Win 2k domain with 3 servers and about 20 users (IIS for
our
> website on one server, DC & Exchange on one, SQL 2000/file/print on one).
We
> currently have a single DC in our domain and I want to promote one of the
> other servers to a DC for backup purposes. The IIS box is out because it
> hosts our public web page, which leaves me with the SQL box. I read that
> DCPromo removes any local user accounts and am not sure of how this will
> affect our SQL Server. It is currently using mixed authentication and
starts
> as a system account. Any constructive feedback is appreciated.
--
For performance reasons, we generally do not recommend running SQL Server
on a domain controller.
Regards,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Promoting a SQL Server 2000 to a DC

I manage a small Win 2k domain with 3 servers and about 20 users (IIS for our
website on one server, DC & Exchange on one, SQL 2000/file/print on one). We
currently have a single DC in our domain and I want to promote one of the
other servers to a DC for backup purposes. The IIS box is out because it
hosts our public web page, which leaves me with the SQL box. I read that
DCPromo removes any local user accounts and am not sure of how this will
affect our SQL Server. It is currently using mixed authentication and starts
as a system account. Any constructive feedback is appreciated.
>
> I manage a small Win 2k domain with 3 servers and about 20 users (IIS for
our
> website on one server, DC & Exchange on one, SQL 2000/file/print on one).
We
> currently have a single DC in our domain and I want to promote one of the
> other servers to a DC for backup purposes. The IIS box is out because it
> hosts our public web page, which leaves me with the SQL box. I read that
> DCPromo removes any local user accounts and am not sure of how this will
> affect our SQL Server. It is currently using mixed authentication and
starts
> as a system account. Any constructive feedback is appreciated.
For performance reasons, we generally do not recommend running SQL Server
on a domain controller.
Regards,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

programmaticly print a report

hi all.

how can i print a report from c# code?

the report is stored on the reporting server.

Hi.

Here's an article for printing based on RS 2000, but it should be very similar for RS 2005:

http://www.csharphelp.com/archives3/archive545.html

Good luck!

Jessica

|||there is a vb.net program that will do it. look for a thread called : How to print a report to a printer by me.