Can I install a Enterprise version analysis service on a Standard version of SQL 2005 server?

Hi all,

Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.

So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.

Is it possible to keep data engine as standard version and install a enterprise version of analysis service?

Thank you very much

Tony

Yes. This is supported as in SQL Server 2005, Standardard SKU and Enterprise SKU can be installed side by side successfully. Of course, their instancenames must be distinct.

Can I install a Enterprise version analysis service on a Standard version of SQL 2005 server

Hi all,

Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.

So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.

Is it possible to keep data engine as standard version and install a enterprise version of analysis service?

Thank you very much

Tony

Yes. This is supported as in SQL Server 2005, Standardard SKU and Enterprise SKU can be installed side by side successfully. Of course, their instancenames must be distinct.

Can create access form layout based on table from sql?

Hi,

Can this be done? Please advise. Thanks.Is there any template available in sql for creating forms?

YOu will have to use any coding language for this like the .NET language. If you are aware of that, which platform will you use for accessing the data (Windows Forms, Web Forms, etc.). SQL Server does ot provide such a feature beside the table editor.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can an Application be run using a Textbox Hyperlink?

I'd like to be able to run a client-side application by clicking on a text
item in a report, but none of the available Hyperlink actions on the
Navigation properties tab seem to apply. Is there any way to run something
having a filename and command line argument like
"C:\Program Files\TestApp\TestApp.exe param"?
The "param" would be the value of the TextBox.
Thanks!Hi Don,
Thank you for your post!
Based on my scope, I don't think you could run the client application
directly in the Hyperlink.
The workaround is write a html page which include some javascript to run
the client application and you could add the html page url in the Hyperlink.
Hope this will be helpful for you to resolve this issue.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
It looks like I'd have to pass the value of the textbox as a parameter for
the html page that contains the javascript. Could you point me to an example
where this technique has been used to run a client application?
Thanks,
Don
"Wei Lu" wrote
> Based on my scope, I don't think you could run the client application
> directly in the Hyperlink.
> The workaround is write a html page which include some javascript to run
> the client application and you could add the html page url in the
Hyperlink.
> Hope this will be helpful for you to resolve this issue.
> Sincerely,
> Wei Lu|||Hi Don,
Thank you for the update.
Here is the sample to run your local IIS Manager:
&

---

var WshShell = new ActiveXObject("WScript.Shell");
var oExec = WshShell.Exec("C:\\WINDOWS\\system32\\inetsrv\\inetmgr.exe");
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
Thanks for the example; works like a charm! Even permits passing a command
line argument to the local exe application.
Don
"Wei Lu" wrote in message
> &

---

>
>
>
>
>
> var WshShell = new ActiveXObject("WScript.Shell");
> var oExec = WshShell.Exec("C:\\WINDOWS\\system32\\inetsrv\\inetmgr.exe");
>
>
>
>|||Hi Don,
Glad to hear the information is helpful.
If you have any questions or concerns, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Can a report list available reports? - revisited

We all know its possible to get all our reports w/ .listchildren("/", true)
but how can get properties for that report?
parameters, security info, ect...
?
is it .Role or .Policy?
thanksStandard report properties are listed through ListChildren(). Extended
properties can be retrieved via GetProperties().
Parameter information is available through GetReportParameters()
Security info via GetPolicies().
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"mgonzales3" <mgonzales3@.discussions.microsoft.com> wrote in message
news:D8BFCEEF-ECAB-4BB6-995A-F020BCE2C9A4@.microsoft.com...
> We all know its possible to get all our reports w/ .listchildren("/",
true)
> but how can get properties for that report?
> parameters, security info, ect...
> ?
> is it .Role or .Policy?
> thanks
>

Can 2005 mirroring be temporarily 'turned of' programatically?

In 2005 there is a new'ish' kind of replication called Mirroring which
is only available in SQL 2005 sp1. When you create a mirrored database
on another server, the 'Principal Database' stays online, while the
'mirrored database' goes into a constant state of restoring. My
question is can 2005 mirroring be temporarily 'turned of'
programmatically? I have a situation where the developers do a BCP of
a large amount of data to a 'staging server' from their 'online
processor' box. For various reasons, they tell me it is to difficult
to do the bcp to both the staging and reporting server. The reporting
server is for Business Objects reporting which affords very little
control over the size and scope of the queries submitted. As a result,
Disk I/O on the reporting server during the day can be extreme. I was
considering creating a mirror between the Staging and Reporting server
database and just allow the BCP to continue on the Staging Server.
Then, after the mirror is completely synchronized, I would turn off the
'mirroring' and use the mirror for reporting. Then, near the end of
the day, I would re-create the link between the Principal and the
Mirror and let the BCP process start again.
How feasible is this?I don't think that you want to create a mirror between staging and
reporting.
As you mentioned, when you are using Mirroring the mirror is unavailable.
How are you going to report from your reporting server if Business Objects
cannot connect to the Mirror server.
You might want to look at log shipping, replication, DTS (SSIS), or a simple
backup and restore. These might be more suitable for your purposes.
--
Keith Kratochvil
"togbabe" <togbabe@.yahoo.co.uk> wrote in message
news:1154931847.145022.63740@.p79g2000cwp.googlegroups.com...
> In 2005 there is a new'ish' kind of replication called Mirroring which
> is only available in SQL 2005 sp1. When you create a mirrored database
> on another server, the 'Principal Database' stays online, while the
> 'mirrored database' goes into a constant state of restoring. My
> question is can 2005 mirroring be temporarily 'turned of'
> programmatically? I have a situation where the developers do a BCP of
> a large amount of data to a 'staging server' from their 'online
> processor' box. For various reasons, they tell me it is to difficult
> to do the bcp to both the staging and reporting server. The reporting
> server is for Business Objects reporting which affords very little
> control over the size and scope of the queries submitted. As a result,
> Disk I/O on the reporting server during the day can be extreme. I was
> considering creating a mirror between the Staging and Reporting server
> database and just allow the BCP to continue on the Staging Server.
> Then, after the mirror is completely synchronized, I would turn off the
> 'mirroring' and use the mirror for reporting. Then, near the end of
> the day, I would re-create the link between the Principal and the
> Mirror and let the BCP process start again.
> How feasible is this?
>|||Hi
There is a section on pausing and resuming database mirroring in Books
Online also see http://msdn2.microsoft.com/en-us/library/ms175539.aspx You
should also
John
"togbabe" wrote:
> In 2005 there is a new'ish' kind of replication called Mirroring which
> is only available in SQL 2005 sp1. When you create a mirrored database
> on another server, the 'Principal Database' stays online, while the
> 'mirrored database' goes into a constant state of restoring. My
> question is can 2005 mirroring be temporarily 'turned of'
> programmatically? I have a situation where the developers do a BCP of
> a large amount of data to a 'staging server' from their 'online
> processor' box. For various reasons, they tell me it is to difficult
> to do the bcp to both the staging and reporting server. The reporting
> server is for Business Objects reporting which affords very little
> control over the size and scope of the queries submitted. As a result,
> Disk I/O on the reporting server during the day can be extreme. I was
> considering creating a mirror between the Staging and Reporting server
> database and just allow the BCP to continue on the Staging Server.
> Then, after the mirror is completely synchronized, I would turn off the
> 'mirroring' and use the mirror for reporting. Then, near the end of
> the day, I would re-create the link between the Principal and the
> Mirror and let the BCP process start again.
> How feasible is this?
>|||"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uR%237WbiuGHA.4336@.TK2MSFTNGP06.phx.gbl...
> I don't think that you want to create a mirror between staging and
> reporting.
> As you mentioned, when you are using Mirroring the mirror is unavailable.
> How are you going to report from your reporting server if Business Objects
> cannot connect to the Mirror server.
> You might want to look at log shipping, replication, DTS (SSIS), or a
simple
> backup and restore. These might be more suitable for your purposes.
I second Keith's recommendation of a simple backup & restore. It works well
and it is too basic to break often.
Jonathan|||I might have found a solution to this guys. What I did was set up
'2005 mirroring' between the two servers. Then I can programmatically
take a 'snapshot' of the 'perpetually restoring mirror' and report from
the snapshot. At the end of the 'reporting day,' I can delete the
snapshot. This appears to work really well.
Jonathan Roberts wrote:
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:uR%237WbiuGHA.4336@.TK2MSFTNGP06.phx.gbl...
> > I don't think that you want to create a mirror between staging and
> > reporting.
> > As you mentioned, when you are using Mirroring the mirror is unavailable.
> > How are you going to report from your reporting server if Business Objects
> > cannot connect to the Mirror server.
> >
> > You might want to look at log shipping, replication, DTS (SSIS), or a
> simple
> > backup and restore. These might be more suitable for your purposes.
> I second Keith's recommendation of a simple backup & restore. It works well
> and it is too basic to break often.
> Jonathan

Can 2005 mirroring be temporarily 'turned of' programatically?

In 2005 there is a new'ish' kind of replication called Mirroring which
is only available in SQL 2005 sp1. When you create a mirrored database
on another server, the 'Principal Database' stays online, while the
'mirrored database' goes into a constant state of restoring. My
question is can 2005 mirroring be temporarily 'turned of'
programmatically? I have a situation where the developers do a BCP of
a large amount of data to a 'staging server' from their 'online
processor' box. For various reasons, they tell me it is to difficult
to do the bcp to both the staging and reporting server. The reporting
server is for Business Objects reporting which affords very little
control over the size and scope of the queries submitted. As a result,
Disk I/O on the reporting server during the day can be extreme. I was
considering creating a mirror between the Staging and Reporting server
database and just allow the BCP to continue on the Staging Server.
Then, after the mirror is completely synchronized, I would turn off the
'mirroring' and use the mirror for reporting. Then, near the end of
the day, I would re-create the link between the Principal and the
Mirror and let the BCP process start again.
How feasible is this?I don't think that you want to create a mirror between staging and
reporting.
As you mentioned, when you are using Mirroring the mirror is unavailable.
How are you going to report from your reporting server if Business Objects
cannot connect to the Mirror server.
You might want to look at log shipping, replication, DTS (SSIS), or a simple
backup and restore. These might be more suitable for your purposes.
Keith Kratochvil
"togbabe" <togbabe@.yahoo.co.uk> wrote in message
news:1154931847.145022.63740@.p79g2000cwp.googlegroups.com...
> In 2005 there is a new'ish' kind of replication called Mirroring which
> is only available in SQL 2005 sp1. When you create a mirrored database
> on another server, the 'Principal Database' stays online, while the
> 'mirrored database' goes into a constant state of restoring. My
> question is can 2005 mirroring be temporarily 'turned of'
> programmatically? I have a situation where the developers do a BCP of
> a large amount of data to a 'staging server' from their 'online
> processor' box. For various reasons, they tell me it is to difficult
> to do the bcp to both the staging and reporting server. The reporting
> server is for Business Objects reporting which affords very little
> control over the size and scope of the queries submitted. As a result,
> Disk I/O on the reporting server during the day can be extreme. I was
> considering creating a mirror between the Staging and Reporting server
> database and just allow the BCP to continue on the Staging Server.
> Then, after the mirror is completely synchronized, I would turn off the
> 'mirroring' and use the mirror for reporting. Then, near the end of
> the day, I would re-create the link between the Principal and the
> Mirror and let the BCP process start again.
> How feasible is this?
>|||Hi
There is a section on pausing and resuming database mirroring in Books
Online also see http://msdn2.microsoft.com/en-us/library/ms175539.aspx You
should also
John
"togbabe" wrote:

> In 2005 there is a new'ish' kind of replication called Mirroring which
> is only available in SQL 2005 sp1. When you create a mirrored database
> on another server, the 'Principal Database' stays online, while the
> 'mirrored database' goes into a constant state of restoring. My
> question is can 2005 mirroring be temporarily 'turned of'
> programmatically? I have a situation where the developers do a BCP of
> a large amount of data to a 'staging server' from their 'online
> processor' box. For various reasons, they tell me it is to difficult
> to do the bcp to both the staging and reporting server. The reporting
> server is for Business Objects reporting which affords very little
> control over the size and scope of the queries submitted. As a result,
> Disk I/O on the reporting server during the day can be extreme. I was
> considering creating a mirror between the Staging and Reporting server
> database and just allow the BCP to continue on the Staging Server.
> Then, after the mirror is completely synchronized, I would turn off the
> 'mirroring' and use the mirror for reporting. Then, near the end of
> the day, I would re-create the link between the Principal and the
> Mirror and let the BCP process start again.
> How feasible is this?
>|||"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:uR%237WbiuGHA.4336@.TK2MSFTNGP06.phx.gbl...
> I don't think that you want to create a mirror between staging and
> reporting.
> As you mentioned, when you are using Mirroring the mirror is unavailable.
> How are you going to report from your reporting server if Business Objects
> cannot connect to the Mirror server.
> You might want to look at log shipping, replication, DTS (SSIS), or a
simple
> backup and restore. These might be more suitable for your purposes.
I second Keith's recommendation of a simple backup & restore. It works well
and it is too basic to break often.
Jonathan|||I might have found a solution to this guys. What I did was set up
'2005 mirroring' between the two servers. Then I can programmatically
take a 'snapshot' of the 'perpetually restoring mirror' and report from
the snapshot. At the end of the 'reporting day,' I can delete the
snapshot. This appears to work really well.
Jonathan Roberts wrote:
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:uR%237WbiuGHA.4336@.TK2MSFTNGP06.phx.gbl...
> simple
> I second Keith's recommendation of a simple backup & restore. It works we
ll
> and it is too basic to break often.
> Jonathan