How distribute report to external subscribes?

We need to invoke every evening report for all our customers, and send
to him by email and fax according customer profile.
I read about scheduling and ability to send email but in our situation
it seem more complicated.
I not sure how deal with:
+Invoke report for each subscribe according his profile
+even if i send for all customer the same report, how I make schedule
that invoke the same report for each customer by his ID?
+how make schedule that send to each subcribe by his mail address?
+How I can make schedule to send by Fax (this is can be resolve by
Emailing to some Mail to Fax system, So for now we can ignore this Q)
I'm familiar with .NET and I have some experience to build Window
Services so if SQL Reporting not fit to our goal, I can write some
Service, but I not sure how I can Call to Reporting service to Invoke
for me Report and svae it to some format, withoute dealing with GUI.
In short, i need to invoke report and save it programmatically?I find somthing:
Tutorial: Creating a Data-Driven Subscription
at:
MSDN Library > Enterprise Servers and Development > SQL Server > SQL
Server 2005 Documentation > SQL Server 2005 Tutorials > Reporting
Services Tutorials > Creating a Data-Driven Subscription
from: SQL Server 2005 Books Online
hear the excec link:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx

How can you tell who SQL 2005 components are installed?

I have a new customer who I am trying to document his SQL 2005 server only I am haveing a hard time telling what components are installed such as:

Replication, Full-Text Search, Analysis Services, Reporting Services, Notification Services, Integration Services, Ect.

Anyone know an easy way to check what was installed?

Shaun

There are several ways to accomplish this, but my suggestion would be to go to Add/Remove Programs, click on the SQL Server 2005 entry, and click on the Change button. This will bring up a new window, showing the instances and common components. For version information, you can click on the "Report" button.

Thanks,
Sam Lester (MSFT)

How can we administrate SQL remotely?

Hi,
customer has a W2k SBS with SQL installed. We recently
installed McAfee Protection Pilot, which uses SQL as data
storage for the client configurations. All works well.
Our problem is, that we can logon as local admin and open
this database OK. But when we connect via terminal server,
log in as admin and try to open the database we get the
error: "You can not log on as database administrator. Make
sure that your are logged in as local administrator".
Is there a way to overcome this "logon as local admin"
requirement? How else could one administrate the SQL
database remotely?
Thanks
Wolf
Make sure you have TCP/IP setup in sql client config.
Make sure you have Authentication mode setup to "Windows and SQLServer"
"w.haunzwickl" <anonymous@.discussions.microsoft.com> wrote in message
news:afd501c49991$d00bd300$a601280a@.phx.gbl...
> Hi,
> customer has a W2k SBS with SQL installed. We recently
> installed McAfee Protection Pilot, which uses SQL as data
> storage for the client configurations. All works well.
> Our problem is, that we can logon as local admin and open
> this database OK. But when we connect via terminal server,
> log in as admin and try to open the database we get the
> error: "You can not log on as database administrator. Make
> sure that your are logged in as local administrator".
> Is there a way to overcome this "logon as local admin"
> requirement? How else could one administrate the SQL
> database remotely?
> Thanks
> Wolf

How can we administrate SQL remotely?

Hi,
customer has a W2k SBS with SQL installed. We recently
installed McAfee Protection Pilot, which uses SQL as data
storage for the client configurations. All works well.
Our problem is, that we can logon as local admin and open
this database OK. But when we connect via terminal server,
log in as admin and try to open the database we get the
error: "You can not log on as database administrator. Make
sure that your are logged in as local administrator".
Is there a way to overcome this "logon as local admin"
requirement? How else could one administrate the SQL
database remotely?
Thanks
WolfMake sure you have TCP/IP setup in sql client config.
Make sure you have Authentication mode setup to "Windows and SQLServer"
"w.haunzwickl" <anonymous@.discussions.microsoft.com> wrote in message
news:afd501c49991$d00bd300$a601280a@.phx.gbl...
> Hi,
> customer has a W2k SBS with SQL installed. We recently
> installed McAfee Protection Pilot, which uses SQL as data
> storage for the client configurations. All works well.
> Our problem is, that we can logon as local admin and open
> this database OK. But when we connect via terminal server,
> log in as admin and try to open the database we get the
> error: "You can not log on as database administrator. Make
> sure that your are logged in as local administrator".
> Is there a way to overcome this "logon as local admin"
> requirement? How else could one administrate the SQL
> database remotely?
> Thanks
> Wolf

How can take Back-Up and restore database from a web form wsing asp.net(vb.net)

I want to give a facility to backup database restore database to the customer in my project.
Database is stored in sql server 2000.
From the website the browser can take backup by clicking BACKUP button and
restore database by clicking RESTORE button.
is it possiable in asp.net programatically ?

In SQL Server you backup a database using the "backup database" command. You restore a database using the "restore database" commands. You can lookup the complete syntax to these commands.

You issue these SQL commands from asp.net just like you would any other SQL command. The backup command will work even if others are using the database at the moment you do the backup. The biggest problem would be the restore. If you are going to restore a database over an existing database (overwrite it) then that database must not be in use or you will get an error.

Brian

|||i do not really recommend this approach whether you can or not !!!!
this is an admin job and it is better not to have a wide access to do this kind of operation..... i am not sure about if you can do it or not ... !!|||Its definitely possible, take a look at this page on MSDNhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_35ww.asp This details the TSQL commands that are necessary to perform the backup/restore. Once you create the commands just execute them with SqlClient.
Hope This Helps