How to control security to parameter level in Report server?

I am developing a web application which need control security to parameter level. For example, salesman just only view report which belong to himself, but manager need to view all sales reports.
what should I do? thanks

newmanYou can achieve this in several ways:

Solution 1) use the User!UserID global in your report definition. This allows you to scope query results, parameter values, etc based on who the user actually is. This provides a single report that lists all the data for

Solution 2) use linked reports. If, for example, you have 2 groups, one which needs to see North region and the other South region, you can create a single report that takes the region parameter. Then create 2 linked reports that submit only the parameter value that each group is supposed to see. You can then ACL each linked report to be visible only to the appropriate group.

Solution 3) use database security with integrated security. You can just always access the underlying data source as the current users. If you underlying data source supports row level security, then the user will automatically get only those values to which they have permission.

-Lukaszsql

how to control it's right of a sysadmin roles menbers

i have a sql 2005 server, I caeat i login accout & give it db_owner roles
for a application. but the application still can't work well unless i
give the account sysadmin server roles.
so ,i give the accout sysadmin roles. but i don't the user to view other
database.
I have refuse some right like " view any database " for the account on
the server property-- right.
but i don't know why the accout staill have all the sysadmin right , to
view any database.
. how can i control it's right of a sysadmin roles menbers
i donn'n know how to do?
Ryan.You can't restrict permissions of sysadmin role members. The purpose of the
sysadmin role is to provide administrators with full access to SQL Server.
It is not intended for routine application use.

> but the application still can't work well unless i
> give the account sysadmin server roles.
Can you elaborate on why the application won't work as a non-sysadmin role
member? I would think you could create your own role(s), grant the role the
permissions needed to execute your application and then add the application
users to the role.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ryan" <Ryan@.discussions.microsoft.com> wrote in message
news:48867756-671D-4CCB-8E26-C7581999EEA5@.microsoft.com...
>i have a sql 2005 server, I caeat i login accout & give it db_owner roles
> for a application. but the application still can't work well unless i
> give the account sysadmin server roles.
> so ,i give the accout sysadmin roles. but i don't the user to view other
> database.
> I have refuse some right like " view any database " for the account on
> the server property-- right.
> but i don't know why the accout staill have all the sysadmin right , to
> view any database.
> . how can i control it's right of a sysadmin roles menbers
> i donn'n know how to do?
> --
> Ryan.sql

How to connect to SQL server database from Oracle 9ias Application Server (9.0.3

How to connect to SQL server database from Oracle 9ias Application Server (9.0.3) & Test & Verify the Connection. Is it posible.I've never done it...only worked with 8i...

didn't see too much connectivity stuff though...

You might try the Oracle (http://www.dbforums.com/f4) Forum though...

How to connect to sql server 2000 (asp.net)

hi everybody, i got this error in my code.

Server Error in '/' Application.

---

SQL Server does not exist or access denied.

Source Error:

Line 12:       Dim SQLConn As SqlConnection = New SqlConnection()

Line 13:                SQLConn.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")

Line 14:                SQLConn.Open()

Line 15:       

Line 16:       cmdLath = New SqlCommand ( _

my web.config

<configuration>

<appSettings>

<addkey="ConnectionString" value="DataSource=xxx;UID=xxx;pwd=xxx" />

<addkey="ConnectionString" value="Server=xxx.xxx.x.x;database=xxx;UID=xxx;pwd=xxx;Trusted_Connection=True"/>

</appSettings>

<system.web>

<sessionState cookieless="false" timeout="20"/>

<customErrorsmode="Off"/>

</system.web>

</configuration>

what seems to be a problem, please help me??Is your connection string correct (server address, username, password, etc.)? Does the user your authenticating as have the correct permissions on the database?

Ryan|||i ran into this problem a few weeks ago as well, like the previous poster stated, you have to make sure they have an account in the sql server itself, not just a windows account. So the problem isn't with your code (assuming no spelling errors or the such) but with the sql server authenticating the user name and password. Hope that helps.|||Besides the suggestions given above, make sure you have SQL Server Authentication configured to be Mixed mode. Checkthis for the configuration.|||To Strongtypes,

Yes, I write the correct server, database, username and password. basically i use sa account with password but it didn't work. I used sql server authentication mixed mode.|||To Darkempire and Alvin,

Thanks for the reply, You know I've done a lot of codes in my asp.net but unfortunately it appears errors in my webpage. This is my setup, my sql server 2000 is installed on other machine with the domain controller running windows server 2003. I have this local pc with my asp.net with web server(iis). I think that my web server does not locate my sql server database or my connection string is wrong but if I'm going to used my dreamweavermx to fetch data to my sql server database it will show up perfectly but when i code an asp.net and run in my localhost, bang errorrs.. please help me|||

Let's do a connection testing on teh .NET client machine: new a '.udl' file e.g. test.udl, then double click to edit it->switch to Provider tab and choose 'SQL Native Client' (which is the default provider when you add connectionstring element in your web.config)->click next to switch to Connection tab->entering connection information including login and pasword (the same as you connect to the SQL Server in DreamWeaver)->click Test Connection. If this succeeds, then the SQL Native Client provider is OK; otherwise there's something wrong with the SQL Native Client provider, so you need to change another provider.

To learn more about connection strings using different providers, you can visit:

www.connectionstrings.com

sql

How to connect to remote MSDE database using VB.NET

Greetings
I have a VB.NET application that works great with a local MSDE database. But, when I try to revise my connection string to point to a remote MSDE server and database, it fails. The MSDE Server Manager can pick up the remote server and tell me its runni
ng, but when I try to register it using SQL Server, or use a DSN to connect to it, I get a "SQL Server does not exist or access denied. ConnectionOpen(Connect())" My connection string is:
Provider=SQLOLEDB.1;Server=DSS\VSDOTNET;Database=d atabase;User ID=sa;Password = xxxxx;Integrated Security=SSPI
Any help will be appreciated. Thanks...
- Tim B.
hi Tim
"Tim Balderramos" <pacmantab@.hotmail.com> ha scritto nel messaggio
news:28F08CF8-86CF-4C04-9E5A-900296EC78A7@.microsoft.com...
> Greetings
> I have a VB.NET application that works great with a local MSDE database.
But, when I try
>to revise my connection string to point to a remote MSDE server and
database, it fails. The
>MSDE Server Manager can pick up the remote server and tell me its running,
but when I try
>to register it using SQL Server, or use a DSN to connect to it, I get a
"SQL Server does not
>exist or access denied. ConnectionOpen(Connect())" My connection string
is:
> Provider=SQLOLEDB.1;Server=DSS\VSDOTNET;Database=d atabase;User
>ID=sa;Password = xxxxx;Integrated Security=SSPI
the most frequent causes of that kind of error are reported in
http://support.microsoft.com/default...06&Product=sql
KB article...
please verify the remote MSDE instance has enabled networkprotocols too,
using the remote Server Network Utilityes (svrnecn.exe)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I think that does it. Here is what my co-worker did:
During MSDE setup, use SECURITYMODE=SQL
Then use SVRNETCN.exe and enable TCP/IP as a network library. I did this on
both machines, but you may not need to do it for both (wasn't sure, but didn't
think it mattered).
Here's the connection string that was working -
Provider=SQLOLEDB;Data Source=wrctest;user id=sa;password=wrctest;Initial
Catalog=winthrop;Net=dbmssocn;Auto Translate=True;Persist Security
Info=False;Use Encryption for Data=False

How to connect to ODBC data source through C#. net

Hi experts,
I am doing an application which takes the DSN name from user in text
box and then open the ODBC data source dialog box. i.e. I want the
(ODBC data source administrator) form which comes after clicking on
ODBC data source icon in administrative tools.
Now my problem is that is it possible to call that system form
(utility) through my program or I have to design the same form (ODBC
data source administrator).
If I can call that form then please tell me how....i can do that?
Any help will be appreciated.
Thanks
DineshYou would be better off posting this in a C# newsgroup. This is for
Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dinesh" <dinesht15@.gmail.com> wrote in message
news:1166091132.509799.4510@.f1g2000cwa.googlegroups.com...
> Hi experts,
> I am doing an application which takes the DSN name from user in text
> box and then open the ODBC data source dialog box. i.e. I want the
> (ODBC data source administrator) form which comes after clicking on
> ODBC data source icon in administrative tools.
> Now my problem is that is it possible to call that system form
> (utility) through my program or I have to design the same form (ODBC
> data source administrator).
> If I can call that form then please tell me how....i can do that?
> Any help will be appreciated.
> Thanks
> Dinesh
>

How to connect SQL Server 2005 in WAS 5.1

Hi All,

One of our database server has upgraded from SQL Server 2000 to 2005 version some days ago, but I found the application which could run before cannot work fine now. I have followed some intructions got from other guys, such as replace the old driver with a new version, but it still did not work. Now I have two questions

1. What is the driver implementation class name? I found there were several answers. (I don't use XA connections)

2. What is the data source helper class name?

I suspect that the above questions are the causes. However, please give me some other hints if any.

Thank you very much!

The driver implementation class name is com.microsoft.sqlserver.jdbc.SQLServerDriver.

The datasource name of the com.microsoft.sqlserver.jdbc.SQLServerDataSource. You can use com.ibm.websphere.rsadapter.DerbyDataStoreHelper to setup our datasource.

Here is some info that may be of use:

Setting up our driver as the JDBC Provider

You should first set up our driver as the JDBC provider. Expand Resources menu on the left of the Administrative Console and choose JDBC Providers. Select New to create a new provider.

1) General Properties: Select the following.

Step 1: User-defined

Step 2: User-defined JDBC Provider

Step 3: User-defined

2) Next Screen

A) General Properties

You can leave scope and name as they are. You can choose your own description. My configuration is as follows

Name: SQLJDBC2005

Class path: path to the sqljdbc.jar file

Implementation class name: com.microsoft.sqlserver.jdbc.SQLServerDataSource

You have to click on save at the top of the screen so that your changes will be saved. You will also be prompted to save incase you forget.

3) Choosing a Datasource

Once you’ve saved and the provider is in place click on the provider name from the providers list. Click on the data sources below Additional Properties. Click on new. You can leave the scope as it is. My configuration is as follows. Unlisted options are left the way they are.

JNDI Name: SQLJDBC2005

Data store helper class name: Generic data store helper

(com.ibm.websphere.rsadapter.GenericDataStoreHelper)

4) Setting up authentication properties for the data source

There are different ways to set up authentication properties for the data source. The following is for the configuration options listed above.

A) Click on the saved data source and go to Custom Properties under Additional Properties

B) Enter serverName, password and user as additional properties. You only need to enter the connection string keyword as the name and the corresponding value.

Once you save all your changes go back to data sources under this provider and click on test connection. You should see the message that your connection succeeded at the top of the screen. You will be given an error message if the connection does not succeed.

|||

Your Step 1 didn't make any sense.

I'm using WAS 5.1.1.3, I'm having a problem trying to get to SQL Server 2005 data and I get errors when I Test Connection. error says:

Test Connection failed for datasource SQL2005 on server server1 at node localhost with the following exception: java.lang.Exception: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.microsoft.sqlserver.jdbc.SQLServerDataSource

Aside from the vague step 1 instructions which don't follow the provider prompts, aren't there some custom properties that need to be created?sql

How to connect SQL Server 2005 in WAS 5.1

Hi All,

One of our database server has upgraded from SQL Server 2000 to 2005 version some days ago, but I found the application which could run before cannot work fine now. I have followed some intructions got from other guys, such as replace the old driver with a new version, but it still did not work. Now I have two questions

1. What is the driver implementation class name? I found there were several answers. (I don't use XA connections)

2. What is the data source helper class name?

I suspect that the above questions are the causes. However, please give me some other hints if any.

Thank you very much!

The driver implementation class name is com.microsoft.sqlserver.jdbc.SQLServerDriver.

The datasource name of the com.microsoft.sqlserver.jdbc.SQLServerDataSource. You can use com.ibm.websphere.rsadapter.DerbyDataStoreHelper to setup our datasource.

Here is some info that may be of use:

Setting up our driver as the JDBC Provider

You should first set up our driver as the JDBC provider. Expand Resources menu on the left of the Administrative Console and choose JDBC Providers. Select New to create a new provider.

1) General Properties: Select the following.

Step 1: User-defined

Step 2: User-defined JDBC Provider

Step 3: User-defined

2) Next Screen

A) General Properties

You can leave scope and name as they are. You can choose your own description. My configuration is as follows

Name: SQLJDBC2005

Class path: path to the sqljdbc.jar file

Implementation class name: com.microsoft.sqlserver.jdbc.SQLServerDataSource

You have to click on save at the top of the screen so that your changes will be saved. You will also be prompted to save incase you forget.

3) Choosing a Datasource

Once you’ve saved and the provider is in place click on the provider name from the providers list. Click on the data sources below Additional Properties. Click on new. You can leave the scope as it is. My configuration is as follows. Unlisted options are left the way they are.

JNDI Name: SQLJDBC2005

Data store helper class name: Generic data store helper

(com.ibm.websphere.rsadapter.GenericDataStoreHelper)

4) Setting up authentication properties for the data source

There are different ways to set up authentication properties for the data source. The following is for the configuration options listed above.

A) Click on the saved data source and go to Custom Properties under Additional Properties

B) Enter serverName, password and user as additional properties. You only need to enter the connection string keyword as the name and the corresponding value.

Once you save all your changes go back to data sources under this provider and click on test connection. You should see the message that your connection succeeded at the top of the screen. You will be given an error message if the connection does not succeed.

|||

Your Step 1 didn't make any sense.

I'm using WAS 5.1.1.3, I'm having a problem trying to get to SQL Server 2005 data and I get errors when I Test Connection. error says:

Test Connection failed for datasource SQL2005 on server server1 at node localhost with the following exception: java.lang.Exception: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.microsoft.sqlserver.jdbc.SQLServerDataSource

Aside from the vague step 1 instructions which don't follow the provider prompts, aren't there some custom properties that need to be created?

how to connect MySQL?

A naive question on how to connect MySQL DB from my C# application.
Kindly explain the steps to be taken to communicate with this DB.

Hi,

There're probably multiple ways of doing this, but one could be:

== Get an ODBC driver for MySQL, for instance here: http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32

== Use System.Data.Odbc namespace functions withC#

The latter is nicely explained in MSDN with samples, you shouldn't have any problems getting into it easily. Have you considered using SQL Express instead of MySQL? You might get richer functionality out of the SqlClient.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||hey!
Thanx for help. I successfully established connection through first method.
The second one I dont have an idea about what namespace is so didn't try to go that way.It would be helpful if you can shed some light on that method or provide some tutorial link.

Also, I have never heard of SQL express. MySQL is available free and being a student thats the best thing for me. Is SQL express free too? I guess it may be since other express editions are free for students. And is there any extra functionality that would entice me to use SQL express?

regarsd
Sumit Dagar.

how to connect asp.net to sql server 2k

i have this error in my asp.net

>Server Error in '/' Application.
>------------------------
>SQL Server does not exist or access denied.
>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
>Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
>Source Error:
>
>Line 23: Dim sText As String = "SELECT employeeid, firstname, lastname FROM Employees"
>Line 24: Dim cmd As SqlDataAdapter= New SqlDataAdapter(sText, sConn)
>Line 25: cmd.Fill(ds, "EmpTable")
>Line 26:
>Line 27: Session("MyData") = ds
>
>Source File: c:\inetpub\wwwroot\FormViewer.aspx Line: 25

and my connection string is :

>"server=localhost;uid=sa;Initial Catalog=Northwind;"

i tried a lot of codes but it doesn't work in sql server 2k but in mysql server it perfectly run. i installed my web server in my local machine with .net framework but my sql server 2k is installed in other machine with the domain controller setup. how im going to connect to my sql server 2k using asp.net codes. i learn some ideas that it better to code the connection string in web.config. is it ok? please please help me. im really out of mind.hi everybody, im a newbie in asp.net. my current language is vb/sqlserver2k. i have a problem in connecting asp.net to sql server2k because my sql server2k is installed in other machine and my web server is installed in my local machine together with my .net framework. i tried a lot of examples but none of this is working with application, it shows with an error "SQL Server does not exist or access denied."
can you give me a complete source step by step. i would really appreciate if anybody can help. thanks in advance|||Tryhttp://www.connectionstrings.com for connection string help. If you still can't get it working, is your SQL Server using SQL authentication or Windows authentication? What does your connection string look like (be sure not to post actual user names and passwords if you are using SQL authentication)?

Edit: I found your duplicate post on the same topic and joined it to this thread. Please do not post the same question multiple times. It only frustrates those who are trying to help you and dilutes the effort.|||how can i know what authentication am i using, sql authentication or windows authentication?
all i know that in my vb application i was using this connection string to connect to my sql server "provider=sqloledb;database=xxxx;server=xxxx;uid=xxx;pwd=xxxx" is that so simple in my vb but in asp.net i really don't know what is the correct connection. thanks anyway tmorton for your reply|||Use the connection string example under SQL Server, SqlConnection, Standard Security at connectionstrings.com.

You are using SQL authentication since you are using a user name and password to connect. If you were using Windows authentication there would be no user name or password; the credentials of the current user would be used.

How to Configure PSP

HI,
Anyone know how to configure the pl/sql server page application. iam new to this area, can you help me regarding PSP.
Thank youLast time I created a PSP page was about 2 years ago. I created a HTML file with embedded PL/SQL and the used the PSP converter/uploaded to load it into the database. The upload then creates a PL/SQL procedure/package (not quite sure) in the database which can be executed via the PL/SQL mod on the IAS server. PSP was in a way their version of JSP (Java Server Pages HTML pages with Java embedded into them which when executed were converted)

I personally used designer to design generate Web PL/SQL forms as I found it more benificial at the time.

Maybe PSP has moved on since then have a look at this thread and see what other people think.

http://groups.google.ie/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=1e2f54c1.0106290422.5029eb80%40posting.goo gle.com&rnum=1&prev=/groups%3Fq%3Doracle%2Bpsp%2Bvs%2Bweb%2Bpl/sql%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D1e2f54c1.0106290422.5029eb80%2540postin g.google.com%26rnum%3D1

I hope I have been of some help.

Regards

Edwin|||this page may also help you

http://www.orafaq.com/faqmodpl.htm#CONFIG|||Hi,

To Develop and Deploy PL/SQL Server Pages, you need the Oracle Server 8.1.6 or later and either Oracle Application Server PL/SQL Cartridge or Oracle WebDB PL/SQL Gateway.|||Hi,

1. Install the PL/SQL Toolkit
2. Create the Listener
3. Create a Database Access Descriptor
4. Create an Application called pspApp
5. Add a Cartridge to your Application
6. Create the PL/SQL Server Pages Script
7. Load the PL/SQL Server Page
8. Verify Procedure creation
9. Reload OAS
10. Execute the PSP script from OAS|||Originally posted by satish_ct
Hi,

To Develop and Deploy PL/SQL Server Pages, you need the Oracle Server 8.1.6 or later and either Oracle Application Server PL/SQL Cartridge or Oracle WebDB PL/SQL Gateway.

As far as I am aware none of these products are supported.

Can I recommend that you use version 9i or higher of the database and IAS as OAS is not as reliable and also may not be supported. IAS come with PL/SQL module in replace of the PL/SQL cartridge.

Regards

Edwin|||U Better check & make sure that these products are supported.

Originally posted by edwinjames
As far as I am aware non of these products are supported.

Can I recommend that you use version 9i or higher of the database and IAS as OAS is not as reliable and also may not be supported. IAS come with PL/SQL module in replace of the PL/SQL cartridge.

Regards

Edwin

How to configure Email Delivery to send out message in Plain/Text format?

Hi, guys,
I have an application which only accept Plain/Text format email, but the
email sent out by Reporting Services Email Delivery was wrap in HTML format.
Is it possible to configure Email Delivery to send out Plain/Text format
message?
Many thanks!
David ZengThe reports server should populate both the plain text and html parts of the
message. Are you saying that you can not have the html portion present? If
so then RS does not support this. You could have RS drop the files to a
local share and then have an app which stripped out the html part before
sending the message on.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Zeng" <dzeng@.pembrooke.com> wrote in message
news:#K9xIQqpEHA.3424@.TK2MSFTNGP12.phx.gbl...
> Hi, guys,
> I have an application which only accept Plain/Text format email, but the
> email sent out by Reporting Services Email Delivery was wrap in HTML
format.
> Is it possible to configure Email Delivery to send out Plain/Text format
> message?
> Many thanks!
> David Zeng
>|||Daniel,
That's right! I do not want the HTML portion present.
Are there any ways to configure Reporting Services to export report into CSV
format without header?
I am in the middle of one urgent project. I very much appreciate your help!
Thanks,
David Zeng
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uBIS04vpEHA.3716@.TK2MSFTNGP10.phx.gbl...
> The reports server should populate both the plain text and html parts of
the
> message. Are you saying that you can not have the html portion present?
If
> so then RS does not support this. You could have RS drop the files to a
> local share and then have an app which stripped out the html part before
> sending the message on.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "David Zeng" <dzeng@.pembrooke.com> wrote in message
> news:#K9xIQqpEHA.3424@.TK2MSFTNGP12.phx.gbl...
> > Hi, guys,
> >
> > I have an application which only accept Plain/Text format email, but the
> > email sent out by Reporting Services Email Delivery was wrap in HTML
> format.
> > Is it possible to configure Email Delivery to send out Plain/Text format
> > message?
> >
> > Many thanks!
> > David Zeng
> >
> >
>|||Daniel,
That's right! I do not want the HTML portion present.
Are there any ways to configure Reporting Services to export report into CSV
format without header?
I am in the middle of one urgent project. I very much appreciate your help!
Thanks,
David Zeng
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uBIS04vpEHA.3716@.TK2MSFTNGP10.phx.gbl...
> The reports server should populate both the plain text and html parts of
the
> message. Are you saying that you can not have the html portion present?
If
> so then RS does not support this. You could have RS drop the files to a
> local share and then have an app which stripped out the html part before
> sending the message on.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "David Zeng" <dzeng@.pembrooke.com> wrote in message
> news:#K9xIQqpEHA.3424@.TK2MSFTNGP12.phx.gbl...
> > Hi, guys,
> >
> > I have an application which only accept Plain/Text format email, but the
> > email sent out by Reporting Services Email Delivery was wrap in HTML
> format.
> > Is it possible to configure Email Delivery to send out Plain/Text format
> > message?
> >
> > Many thanks!
> > David Zeng
> >
> >
>|||No, you can not change the way the Viewer renders the report on export, nor
set any device info for subscriptions. You could write a Delivery extension
fairly quickly that would call the renderer with what ever device info you
want. Then just have it drop it to a file share. Would this solve your
problem?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Zeng" <dzeng@.pembrooke.com> wrote in message
news:#nukQ2wpEHA.3244@.tk2msftngp13.phx.gbl...
> Daniel,
> That's right! I do not want the HTML portion present.
> Are there any ways to configure Reporting Services to export report into
CSV
> format without header?
> I am in the middle of one urgent project. I very much appreciate your
help!
> Thanks,
> David Zeng
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:uBIS04vpEHA.3716@.TK2MSFTNGP10.phx.gbl...
> > The reports server should populate both the plain text and html parts of
> the
> > message. Are you saying that you can not have the html portion present?
> If
> > so then RS does not support this. You could have RS drop the files to a
> > local share and then have an app which stripped out the html part before
> > sending the message on.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "David Zeng" <dzeng@.pembrooke.com> wrote in message
> > news:#K9xIQqpEHA.3424@.TK2MSFTNGP12.phx.gbl...
> > > Hi, guys,
> > >
> > > I have an application which only accept Plain/Text format email, but
the
> > > email sent out by Reporting Services Email Delivery was wrap in HTML
> > format.
> > > Is it possible to configure Email Delivery to send out Plain/Text
format
> > > message?
> > >
> > > Many thanks!
> > > David Zeng
> > >
> > >
> >
> >
>

How to configure a JBOD disk array (PowerVault) for Performance

We have an application that is experiencing I/O contention,
particularly in tempdb but also in two other databases. The data is
stored on mirrored PowerVault 220's, each with 10 of 14 possible disks.
The PowerVaults are JBOD devices, not true SANs. The current config has
four separate groups of physical drives assigned to distinct logical
drives for log files, tempdb, and the two app dbs. This means, for
example, that tempdb resides on one mirrored drive. The standard advice
when faced with disk contention is to add spindles if possible. With 4
empty slots, we would presumably assign the new physical disks to the
most stressed db, e.g. tempdb.

An alternative arrangement would be to combine all the physical drives
into one logical drive, and put all the files, log and data, onto the
single logical drive. The hope for this configuration is that the
PowerVault would automagically distribute the data among the drives
such that all drives were in use, all spindles reading and writing at
maximum capacity when necessary. It is my understanding that
full-featured SANs, like NetApps and EMC models, do this. My question
is whether this configuration is best for the PowerVault, as well. Or
is this the essential difference between JBOD and a true SAN?

Has anyone tried both arrangements?

Advice is much appreciated.Hi

I can't say I know anything about the internals of JBOD.. but I would expect
combining the drives into a single logical drive to not be benificial even
though they are distributing the data over more spindles the type of access
between log file and data files will probably be counter productive.

If you are having contention on tempdb you may want to consider splitting
tempdb into multiple files (preferrably on separate sets of spindles) as
described in http://support.microsoft.com/defaul...kb;en-us;328551

John

"JRoughgarden" <jroughgarden@.stanfordalumni.org> wrote in message
news:1139511253.211524.40670@.o13g2000cwo.googlegro ups.com...
> We have an application that is experiencing I/O contention,
> particularly in tempdb but also in two other databases. The data is
> stored on mirrored PowerVault 220's, each with 10 of 14 possible disks.
> The PowerVaults are JBOD devices, not true SANs. The current config has
> four separate groups of physical drives assigned to distinct logical
> drives for log files, tempdb, and the two app dbs. This means, for
> example, that tempdb resides on one mirrored drive. The standard advice
> when faced with disk contention is to add spindles if possible. With 4
> empty slots, we would presumably assign the new physical disks to the
> most stressed db, e.g. tempdb.
> An alternative arrangement would be to combine all the physical drives
> into one logical drive, and put all the files, log and data, onto the
> single logical drive. The hope for this configuration is that the
> PowerVault would automagically distribute the data among the drives
> such that all drives were in use, all spindles reading and writing at
> maximum capacity when necessary. It is my understanding that
> full-featured SANs, like NetApps and EMC models, do this. My question
> is whether this configuration is best for the PowerVault, as well. Or
> is this the essential difference between JBOD and a true SAN?
> Has anyone tried both arrangements?
> Advice is much appreciated.|||Yes, we have split tempdb in accordance with this article. No obvious
improvement yet. Looking at the -T1118 flag in a replicated
environment.

I am gathering that a JBOD is just a holder for physical disks that is
capable of splitting them up into logical disks, with or without RAID.
No real optimization.

Still, it would be an interesting experiment to put everything on one
logical disk comprising 14-physical disks vs. splitting the 14 into
separate logical drives for log files, tempdb mdf, and app data file
mdfs.

How to close all open "handles" to a SQL Server 2005 express DB?

Hello all!
I'm trying to create an application which makes a copy of the database file it is using on application start and can restore it at any time, if needed (little project about SQL injection, so I need the copy ;-) ). This works fine, but as soon as I make my first connection to the db (connection_object.open()) and close it again I can not access the file anymore, because it is "in use by another process". How can I release all handles from the database, so that I can replace the DB file with it's backup copy?

Thank you

KoljaYou have to kill connection instead of just closing.

Shot two bulets in his head and call GC to finish him.

|||Ahm...
cal me a noob, but I disposed it and set the variable to null... doesn't work
What do you mean : Call GC?