Can I deploy a runtime version

Is is possible to deploy MSDE with a database in such a way that an end user
can only access that database via a custom application? In other words, I
don't want the end user to be able to use osql (or any other tool) to get
into the database, and I don't want them to be able to detach that database
and attach it to a full blown SQL Server.
Thanks.
No, it is not possible. If the user has full right (Admin right) to his
computer, he can do anything to SQL Server/MSDE on this computer:
attaching/detaching it, peeking into the database structure. The most you
can do is to encrypt the data content, if you can find a reliable tool to do
that.
"Tom Iarusso" <TomIarusso@.discussions.microsoft.com> wrote in message
news:E2A8F5F9-A707-4985-8E00-C419353C82D9@.microsoft.com...
> Is is possible to deploy MSDE with a database in such a way that an end
> user
> can only access that database via a custom application? In other words, I
> don't want the end user to be able to use osql (or any other tool) to get
> into the database, and I don't want them to be able to detach that
> database
> and attach it to a full blown SQL Server.
> Thanks.

Can I Deploy a report to a client who doesn't have SQL server license.

How can I Deploy a report with my visual Studio.Net application to a company
who doesn't have SQL server license?
I plan to use SQL Server 2005 Express.SQL Server Express does not yet have support for this. Supposedly Q1. Then
the data needs to reside locally as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||VS2005 provide a report viewer control which allow you to render reports.
does your application is web or windows based?
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||Hi Roberto,
As Bruce mentioned, the SQL Server reporting service is not available for
EXPRESS edition so far. Also, what's your application's detailed structure,
does it require a local SQL Server instance? If it is just a client
application which can consume reporting service reports through those
remote accessible programming interfaces, we can consider separate the
application from the backend SQL Server database... Thus, there need a
certain DataBase server which have SQL Server 2005 instance installed
already...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Jéj? <willgart@.BBBhotmailAAA.com>
| References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Can I Deploy a report to a client who doesn't have SQL
server license.
| Date: Thu, 26 Jan 2006 21:35:45 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67651
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| VS2005 provide a report viewer control which allow you to render reports.
| does your application is web or windows based?
|
| "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
| news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
| > How can I Deploy a report with my visual Studio.Net application to a
| > company who doesn't have SQL server license?
| >
| > I plan to use SQL Server 2005 Express.
| >
|
|
||||RDLC reports doesn't required any server.
its standalone reports generated on the client side, not the server side.
Also, I think that the report control can render RDL reports without using a
reportserver.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:TUqDfawIGHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Roberto,
> As Bruce mentioned, the SQL Server reporting service is not available for
> EXPRESS edition so far. Also, what's your application's detailed
> structure,
> does it require a local SQL Server instance? If it is just a client
> application which can consume reporting service reports through those
> remote accessible programming interfaces, we can consider separate the
> application from the backend SQL Server database... Thus, there need a
> certain DataBase server which have SQL Server 2005 instance installed
> already...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --
> | From: "Jéj? <willgart@.BBBhotmailAAA.com>
> | References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
> | Subject: Re: Can I Deploy a report to a client who doesn't have SQL
> server license.
> | Date: Thu, 26 Jan 2006 21:35:45 -0500
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Response
> | Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67651
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | VS2005 provide a report viewer control which allow you to render
> reports.
> | does your application is web or windows based?
> |
> | "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
> | news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> | > How can I Deploy a report with my visual Studio.Net application to a
> | > company who doesn't have SQL server license?
> | >
> | > I plan to use SQL Server 2005 Express.
> | >
> |
> |
> |
>

can i create a cube by VB.net

can i create a cube by VB.net?

I wanna a dynamic Cube, so I can not define it in the Analysis Services Project.

So the problems come.

I must deploy and process and compile the cube.

That can be done?

thank you.

Yes. This can be done using AMO (AnalysisServices Management Objects). In your project, add a reference to the AMO DLL and you can see lots of classes exposed.

|||

Can you clarify what you mean by "dynamic cube"? Just making sure that indeed you do need to create the cube programmatically using AMO.

By the way, there's a good sample in C# (which you'll probably be able to work from and translate to VB) at the following path after you install the SQL Server Samples:

C:\Program Files\Microsoft SQL Server\90\samples\Analysis Services\Programmability\AMO\AMOAdventureWorks\CS\AmoAdventureWorks

|||

Thank you for your replies.

AMO can do the work exactly.

END.

Can I add user and passw to my OLAP ConnectionString?

Hi all,
I have written a custom assembly that works fine in preview mode, but when I deploy the report I get the '#Error' message instead of the output.
I have copied the assembly to the bin folder of Reportserver, placed it in the GAC and even edited the policyfiles.

Any help would be very appriciated,

Thanks in advance

public static class SimCardBuyer
{
public static string ReturnBuyer(string Seller, string PeriodeCode, string ComDevice)
{
string connstring = "PROVIDER=MSOLAP;DATA SOURCE=srv03-gc-10;INITIAL CATALOG=Invoicing";
AdomdConnection conn = new Microsoft.AnalysisServices.AdomdClient.AdomdConnection(connstring);
//Create a new string builder to store the results
System.Text.StringBuilder result = new System.Text.StringBuilder();
//Connect to the local server
using (conn)
{
conn.Open();
//Create a command, using this connection
AdomdCommand cmd = conn.CreateCommand();
cmd.CommandText = @."SELECT NON EMPTY { [Measures].[InvoiceAmount] } ON COLUMNS, NON EMPTY { ([Buyer].[Company].[Company].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
( SELECT ( { [Com Device].[Com Device].[" + ComDevice + @."] } ) ON COLUMNS FROM
( SELECT ( { [Invoice].[Period Code].[" + PeriodeCode + @."] } ) ON COLUMNS FROM
( SELECT ( { [Seller].[Company].[" + Seller + @."] } ) ON COLUMNS FROM [Invoicing])))
WHERE ( [Seller].[Company].[" + Seller + @."], [Invoice].[Period Code].[" + PeriodeCode + @."], [Com Device].[Com Device].[" + ComDevice + @."] )";

//Execute the query, returning a cellset
CellSet cs = cmd.ExecuteCellSet();
//Output the column captions from the first axis
//Note that this procedure assumes a single member exists per column.
TupleCollection tuplesOnRows = cs.Axes[1].Set.Tuples;
if (tuplesOnRows.Count > 1)
{
for (int row = 0; row < tuplesOnRows.Count - 1; row++)
{
result.Append(tuplesOnRows[row].Members[0].Caption);
result.Append(" / ");
}
result.Append(tuplesOnRows[tuplesOnRows.Count - 1].Members[0].Caption);
}
else if (tuplesOnRows.Count == 1)
{result.Append(tuplesOnRows[0].Members[0].Caption);}
else{result.Append(Seller);}
conn.Close();
return result.ToString();
}
}

Dear readers,

I have solved the problem above, but now I get an error with the Connectionstring.
I'm getting the next error now:

Either the user, NL01\SRV03-GC-10$, does not have access to the Invoicing database, or the database does not exist.
NL01\SRV03-GC-10$ is not a user in my system, so I'm stunned with this strange error.

I would appriciate any reply on this.

regards.

Calling Subscription screen inside Report viewer

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

Assuming a clickable link is an appropriate solution here, and assuming that these are RDLs rather than RDLCs (which it seems they are), and if you really want to do it inside the report definition itself, realize that the subscription page is just like any other URL.

You should be able to have a textbox that says "click here to go to the subscriptions page for this report" that navigates to a URL using something similar to this expression for the navigation link:

Code Snippet

="http://YourServer/Reports/Pages/Report.aspx?ItemPath=" &
Globals!ReportFolder & "/" & Globals!ReportName
& "&SelectedTabId=SubscriptionsTab"

... but there is no real advantage to putting this inside the report, IMHO. Why not just something like this expression as a hyperlink in the header of your ReportViewer ASPX page?

>L<

|||

Hello Lisa,

thanks for looking at my problem. you solution works but still have a problem. when i use a link as you suggested in my report viewer the user gets the subscription page but after he completes he is redirected again to show Report manager with all reports.

I have a.rdl file which i show in my web page. but i use this http://<servername>/reportserver?folder name/reportname

this gives me control to show only report with out showing the report manager's header and other details.

eg http://gloss.asp.net/ReportServer?%2fDMS_Reports%2fHB107_Dashboard&rcocMap=false

/Soni

|||

Chandresh, if you don't want them to see the report manager, you shouldn't be sending them to the report manager <s>.

You can interrogate current subscriptions, using the RS SOAP interfaces. You then display whatever limited interface to your users you want, and provide any updates back to RS with SOAP interfaces. Doesn't this make more sense?

>L<

|||

hi again,

many thanks, do you know where can i find more documentation on using RS SOAP API

/Chandresh soni

|||You could start here... http://msdn2.microsoft.com/de-de/library/ms155376.aspx

Or here http://msdn2.microsoft.com/de-de/library/ms155376.aspx

>L<

Calling Subscription screen inside Report viewer

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

Assuming a clickable link is an appropriate solution here, and assuming that these are RDLs rather than RDLCs (which it seems they are), and if you really want to do it inside the report definition itself, realize that the subscription page is just like any other URL.

You should be able to have a textbox that says "click here to go to the subscriptions page for this report" that navigates to a URL using something similar to this expression for the navigation link:

Code Snippet

="http://YourServer/Reports/Pages/Report.aspx?ItemPath=" &
Globals!ReportFolder & "/" & Globals!ReportName
& "&SelectedTabId=SubscriptionsTab"

... but there is no real advantage to putting this inside the report, IMHO. Why not just something like this expression as a hyperlink in the header of your ReportViewer ASPX page?

>L<

|||

Hello Lisa,

thanks for looking at my problem. you solution works but still have a problem. when i use a link as you suggested in my report viewer the user gets the subscription page but after he completes he is redirected again to show Report manager with all reports.

I have a.rdl file which i show in my web page. but i use this http://<servername>/reportserver?folder name/reportname

this gives me control to show only report with out showing the report manager's header and other details.

eg http://gloss.asp.net/ReportServer?%2fDMS_Reports%2fHB107_Dashboard&rcocMap=false

/Soni

|||

Chandresh, if you don't want them to see the report manager, you shouldn't be sending them to the report manager <s>.

You can interrogate current subscriptions, using the RS SOAP interfaces. You then display whatever limited interface to your users you want, and provide any updates back to RS with SOAP interfaces. Doesn't this make more sense?

>L<

|||

hi again,

many thanks, do you know where can i find more documentation on using RS SOAP API

/Chandresh soni

|||You could start here... http://msdn2.microsoft.com/de-de/library/ms155376.aspx

Or here http://msdn2.microsoft.com/de-de/library/ms155376.aspx

>L<