customize template.ini to upgrade from msde to express edition?

I need to create the script to upgrade the current named instance of sql 2000 desktop engine to sql server 2005 express edition. I am having difficulty preparing the template.ini and would appreciate help.

[Options]
INSTANCENAME=MY_INSTANCE
SQLBROWSERACCOUNT=NT AUTHORITY\NETWORK SERVICE
SECURITYMODE=SQL
SAPWD=music
UPGRADE=SQL_Engine
SQLBROWSERAUTOSTART=1
RSCANINSTALLDEFAULT=0
RSCONFIGURATION=FilesOnly
RSSQLLOCAL=0

I get an error that this file is invalid..Any clues? I am trying to upgrade existing instance of msde 2k to sql express 2005 and uses sql authentication

http://www.microsoft.com/sql/editions/express/upgrade.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

http://msdn2.microsoft.com/en-us/ms143491.aspx

|||

When a parameter includes space characters, you need quote with " or '. For example, the browser account should be specified as SQLBROWSERACCOUNT="NT AUTHORITY\NETWORK SERVICE " or SQLBROWSERACCOUNT='NT AUTHORITY\NETWORK SERVICE'

Note, this account is localized on some localized operating system. You need to use the localized version if required. In addition, MSDE already has its SP4. So please use MSDE SP4 directly.

The following are two command lines that may be useful to you.

1. Install MSDE SP4.

start /wait setup.exe /qb INSTANCENAME=msde4instance SAPWD="<password>" SECURITYMODE=SQL

2. Upgrade to SQL 2005 SP1.

start /wait setup.exe UPGRADE=SQL_Engine INSTANCENAME=msdesp4instance SAPWD=""<password>" SECURITYMODE=SQL

Custom Semi-Additive Member using Analysis Service 2005 Standard Edition

[Edited For Clarity]

I’m using Analysis Service 2005 the standard edition:

I’m trying to create a custom semi-additive measure through MDX. My time dimension has month granularity with years on top of that. Basically, I’m trying to create an average the months while summing the averages across non time dimensions.

My best solution was using the following code:

avg(descendants([time].[hierarchy].currentmember,[time].[hierarchy].[month], self), sum(measures.[measure_to_aggregate]))

the problem with the above code is that it does not include empty months of non empty years. That is, if an attribute exists for a month in 2004, I want to see all the months of 2004 as part of the denominator. However, if an attribute does not exist for any months in 2004 I want to see Null.

I also tried the following code:

avg(descendants([time].[hierarchy].currentmember,[time].[hierarchy].[month], self), sum(measures.[measure_to_aggregate]), includeempty)

but the statement could not be parsed due to too many arguments in the avg function. Can anyone clarify what the problem is here?

Another way of doing this is using the count member. Basically I would count all the periods in the year and use that as a denominator to find the average:

sum([measures].[measure_to_aggregate]) / count (descendants ([time].[hierarchy].currentmember,[time].[hierarchy].[month], self))

The problem with this statement is that I can’t differentiate between empty years and non-empty years, so the code computes the average for all years in the dimension.I also tred using the nonempty function around descendants, but it excludes both months of empty and non-empty years.

Any ideas?

DNA,

You are saying that statement below is OK, and one problem is that it does not include empty cells.

avg(descendants([all year].[hierarchy].currentmember,[all year].[hierarchy].[period], self), sum(measures.[adjusted headcount]))

Try to use CoalesceEmpty:

avg(descendants([all year].[hierarchy].currentmember,[all year].[hierarchy].[period], self), sum(CoalesceEmpty(measures.[adjusted headcount],0)))

This will replace NULLs with 0.

Vidas Matelis

Edited: Added ,0

|||

Thanks for replying Vidas Matelis,

I have edited my post to make the previous post much more clear.

The issue with using Coalesce is that I have more years in my dimension than the cube itself.

Therefore I would not want to replace the null values of the addtional years in the dimension with zeros.

|||

Please note that includeempty is an option for Count(), but not for Avg(). How about using Count() with Filter(), like:

[measures].[measure_to_aggregate] / count(Filter(descendants(

[time].[hierarchy].currentmember, [time].[hierarchy].[month]),

Not IsEmpty(([measures].[measure_to_aggregate], [time].[hierarchy].Parent))))

|||

DNA,

I would assume that for years where you have no data, you would get result as 0. So what if you use IIF statement and replace 0 with NULL? Would that work?

IIF(avg(descendants([all year].[hierarchy].currentmember,[all year].[hierarchy].[period], self), sum(CoalesceEmpty(measures.[adjusted headcount],0))) = 0

, NULL

,avg(descendants([all year].[hierarchy].currentmember,[all year].[hierarchy].[period], self), sum(CoalesceEmpty(measures.[adjusted headcount],0)))

)

Vidas Matelis

|||

Thanks for the replies and ideas. For clarification:

To Deepak Puri,

I tried using filter but it excluded all empty values, meaning the empty values for periods for the years within the cube were exclude as well. The way I wanted to approach this is by excluding all empty values for the years that are not in the cube while including the empty periods for the years that are in the cube.

To: Vidas Matelis,

And an iif statement works very similiar to case statements and coalesceempty. When I used the coalesceempty I had to make a seperate calculated measure to use it because there was an error saying too many arguments in the avg() function. I could certainly try using the code you have provided but I would think that this code would also exclude all empty values instead of selectively excluding values for certain years.

|||

Ultimately, the code will have to know somehow that some years are considered "empty" and some are not. You are the only one who can tell what the criteria is. It could be as simple as hardcoding 2004 as the first non-empty year, or, perhaps you will have more complex criteria, i.e. year in which all months are empty for Root() of everything else, or something else. Let's assume that you created named set with all the months from the years that you consider "non-empty", i.e. something like

CREATE SET NonEmptyMonths AS Exists([Time].[Month].[Month], [Time].[Year].[2004] : NULL )

I.e. here I hardcoded 2004 as the first "non-empty" year. After that you can take any solution proposed above and use

Intersect(NonEmptyMonths, Descendants([Time].[Hierarchy].CurrentMember, [Time].[Hierarchy].Month))

Instead of using Descendants directly. You won't have to filter empty cells anymore, of course, because Intersect will take care of it.

|||

Would there be a way without hardcoding it?

The reason being is that I want it to be automated and to account for changes in the time dimension (ie. additional years and periods being added).

|||Please see my previous message - uou have to tell us the criteria - which years are considered to be "populated". Is it a member property of the Year attribute ? Is it year which has at least one non-empty month at the Root ? Is it something else ? Once we know you business logic we can translate it into MDX, but without knowing it - not much we can do.|||Mosha, sorry for the late reply, the years are considered to be populated if there is at least one non-empty months.|||

OK, then the CREATE SET statement can look like something around the following theme:

CREATE SET NonEmptyMonths AS Descendants( NonEmpty( [Time].[Hierarchy].[Year].MEMBERS ), [Time].[Hierarchy].[Month] )

|||

Something along the following lines:

CREATE SET NonEmptyMonths AS Descendants( NonEmpty([Time].[Hierarchy].[Year]), [Time].[Hierarchy].[Month] )

|||

CREATE SET NonEmptyMonths AS Descendants( NonEmpty([Time].[Hierarchy].[Year]), [Time].[Hierarchy].[Month] )

Custom Security w/ Standard Edition/

Hello...

I am trying to verify that the ability to use the security extension to use Forms based authentication is available (or not) with SQL 2005 Standard. I have read a few books and articles that state that only the Enterprise edition will allow us to use the security extensions to customize authentication and authorization. But a few recently have told me otherwise.

Does anyone know for sure? We use Standard edition...and would like to customize our security.

thanks

- will

Hello again,

Does anyone know the answer here?

Thanks for any help,

- will

|||

SQL Server 2005 Reporting Services Standard edition allows custom security :-)

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

Features/Reporting Services Enhancements

EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)

SE (32-bit) SE (64-bit)

WG (32-bit)

SSE (32-bit)

SSEA (32-bit)

Support for remote and nonrelational data sources

Yes

Yes

No

No

No

DHTML, Excel, PDF, and Image rendering extensions

Yes

Yes

Yes

No

Yes

MHTML, CSV, XML, and Null rendering extensions

Yes

Yes

No

No

No

E-mail and file share delivery extensions

Yes

Yes

No

No

No

Custom data processing, delivery, and rendering extensions

Yes

Yes

No

No

No

Custom authentication extensions

Yes

Yes

Yes

No

No

Custom Security and RS Standard Edition

My report service is Standard Edition and I implement custom security. When
I start the reporting server, the following error are shown in the log.
ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., CryptUnprotectData: Win32 error:-2146893813;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[] data, Int32 dwFlags)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[] data)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String data)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
-- End of inner exception stack trace --
ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
ERROR: Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[] data, Int32 dwFlags)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[] data)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String data)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
occured with a config file change. New config file will not be used. Error:
The encrypted value for configuration setting Dsn cannot be decrypted.
ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i INFO:
RPC Server stopped
ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31:: Service
shutting down.Custom Security extensions are not supported with RS Standard Edition. They
require Enterprise edition (or developer edition for development).
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
> My report service is Standard Edition and I implement custom security.
> When
> I start the reporting server, the following error are shown in the log.
> ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., CryptUnprotectData: Win32 error:-2146893813;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be decrypted., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be
> decrypted. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> data, Int32 dwFlags)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> data)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> data)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> -- End of inner exception stack trace --
> ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be
> decrypted. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> data, Int32 dwFlags)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> data)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> data)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
> ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
> occured with a config file change. New config file will not be used.
> Error:
> The encrypted value for configuration setting Dsn cannot be decrypted.
> ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
> INFO:
> RPC Server stopped
> ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
> Service
> shutting down.|||Actually, we don't need any features of Enterprise version but we need to
spend $20,000 US dollar to buy this product just because of Custom Security
Extensions and Data Driven Subscriptions. I don't think it is worth. How
about SQL server 2005 version ?
"Jeff A. Stucker" wrote:
> Custom Security extensions are not supported with RS Standard Edition. They
> require Enterprise edition (or developer edition for development).
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
> > My report service is Standard Edition and I implement custom security.
> > When
> > I start the reporting server, the following error are shown in the log.
> >
> > ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details., CryptUnprotectData: Win32 error:-2146893813;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
> > Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be decrypted., ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be
> > decrypted. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> > data, Int32 dwFlags)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > -- End of inner exception stack trace --
> > ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
> > ERROR: Exception caught starting RPC server:
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be
> > decrypted. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> > data, Int32 dwFlags)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
> > at
> > Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
> > ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
> > occured with a config file change. New config file will not be used.
> > Error:
> > The encrypted value for configuration setting Dsn cannot be decrypted.
> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
> > INFO:
> > RPC Server stopped
> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
> > Service
> > shutting down.
>
>|||No announcement has been made on features per version (there was a
presentation on improvements with 2005 but no mention of how things will be
packaged and what the costs would be). You say you don't need enterprise but
then you say you do, because data driven subscriptions and custom security
extensions are two major features of enterprise. There are not that many
things different. About the only other major difference other than those two
is support for web farms. I bet if you price versus Crystal that RS will
still come out ahead or at least even.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:73E4DC66-CC5D-4DB2-86BD-C0554280806B@.microsoft.com...
> Actually, we don't need any features of Enterprise version but we need to
> spend $20,000 US dollar to buy this product just because of Custom
> Security
> Extensions and Data Driven Subscriptions. I don't think it is worth. How
> about SQL server 2005 version ?
> "Jeff A. Stucker" wrote:
>> Custom Security extensions are not supported with RS Standard Edition.
>> They
>> require Enterprise edition (or developer edition for development).
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
>> news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
>> > My report service is Standard Edition and I implement custom security.
>> > When
>> > I start the reporting server, the following error are shown in the log.
>> >
>> > ERROR: Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details., CryptUnprotectData: Win32 error:-2146893813;
>> > Info:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
>> > Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be decrypted.,
>> > ;
>> > Info:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be
>> > decrypted. -->
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
>> > data, Int32 dwFlags)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > -- End of inner exception stack trace --
>> > ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
>> > ERROR: Exception caught starting RPC server:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be
>> > decrypted. -->
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
>> > data, Int32 dwFlags)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > -- End of inner exception stack trace --
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
>> > at
>> > Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
>> > ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
>> > occured with a config file change. New config file will not be used.
>> > Error:
>> > The encrypted value for configuration setting Dsn cannot be decrypted.
>> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
>> > INFO:
>> > RPC Server stopped
>> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
>> > Service
>> > shutting down.
>>

Custom Log Shipping with Standard Edition

Does anybody know if Microsoft supports "custom" log shipping at Standard
Edition.I cannot say for sure but I would doubt it. Is there a reason you do not wa
nt to use the built in Log Shipping. It works pretty well in my experience.
Jeff|||Jeff,
Built-in log shipping is not available with SQL2000 standard edition.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jeff Duncan" <jduncan@.gtefcu.org> wrote in message
news:633F0536-C1FC-43B9-8B94-191D4B502241@.microsoft.com...
> I cannot say for sure but I would doubt it. Is there a reason you do not
want to use the built in Log Shipping. It works pretty well in my
experience.
> Jeff|||I'm using the Log Shipping utility that came with the BORK - had a problem w
ith it at one point, MS came in and took a look, and did help me troubleshoo
t the problem - however, they said normally they don't support those type pr
oducts since they are typic
ally written by non-MS parties. I've had no problems since, and that was a
couple of years ago.|||Hi Nick,
R u using it still in Production systems?, if primary server fails how do
you switch to the secondary server as the new primary server and once again
how do you revert back to your old prmary server?.
thanks
gdc
"Nick" <nick.deangelo@.scigames.com> wrote in message
news:61E59B17-9B39-4B3E-8D89-24909FF8D366@.microsoft.com...
> I'm using the Log Shipping utility that came with the BORK - had a problem
with it at one point, MS came in and took a look, and did help me
troubleshoot the problem - however, they said normally they don't support
those type products since they are typically written by non-MS parties.
I've had no problems since, and that was a couple of years ago.

Custom Log Shipping with Standard Edition

Does anybody know if Microsoft supports "custom" log shipping at Standard
Edition.I cannot say for sure but I would doubt it. Is there a reason you do not want to use the built in Log Shipping. It works pretty well in my experience
Jeff|||Jeff,
Built-in log shipping is not available with SQL2000 standard edition.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jeff Duncan" <jduncan@.gtefcu.org> wrote in message
news:633F0536-C1FC-43B9-8B94-191D4B502241@.microsoft.com...
> I cannot say for sure but I would doubt it. Is there a reason you do not
want to use the built in Log Shipping. It works pretty well in my
experience.
> Jeff|||I'm using the Log Shipping utility that came with the BORK - had a problem with it at one point, MS came in and took a look, and did help me troubleshoot the problem - however, they said normally they don't support those type products since they are typically written by non-MS parties. I've had no problems since, and that was a couple of years ago.|||Hi Nick,
R u using it still in Production systems?, if primary server fails how do
you switch to the secondary server as the new primary server and once again
how do you revert back to your old prmary server?.
thanks
gdc
"Nick" <nick.deangelo@.scigames.com> wrote in message
news:61E59B17-9B39-4B3E-8D89-24909FF8D366@.microsoft.com...
> I'm using the Log Shipping utility that came with the BORK - had a problem
with it at one point, MS came in and took a look, and did help me
troubleshoot the problem - however, they said normally they don't support
those type products since they are typically written by non-MS parties.
I've had no problems since, and that was a couple of years ago.

Custom Log Shipping with Standard Edition

Does anybody know if Microsoft supports "custom" log shipping at Standard
Edition.
I cannot say for sure but I would doubt it. Is there a reason you do not want to use the built in Log Shipping. It works pretty well in my experience.
Jeff
|||Jeff,
Built-in log shipping is not available with SQL2000 standard edition.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jeff Duncan" <jduncan@.gtefcu.org> wrote in message
news:633F0536-C1FC-43B9-8B94-191D4B502241@.microsoft.com...
> I cannot say for sure but I would doubt it. Is there a reason you do not
want to use the built in Log Shipping. It works pretty well in my
experience.
> Jeff
|||I'm using the Log Shipping utility that came with the BORK - had a problem with it at one point, MS came in and took a look, and did help me troubleshoot the problem - however, they said normally they don't support those type products since they are typic
ally written by non-MS parties. I've had no problems since, and that was a couple of years ago.
|||Hi Nick,
R u using it still in Production systems?, if primary server fails how do
you switch to the secondary server as the new primary server and once again
how do you revert back to your old prmary server?.
thanks
gdc
"Nick" <nick.deangelo@.scigames.com> wrote in message
news:61E59B17-9B39-4B3E-8D89-24909FF8D366@.microsoft.com...
> I'm using the Log Shipping utility that came with the BORK - had a problem
with it at one point, MS came in and took a look, and did help me
troubleshoot the problem - however, they said normally they don't support
those type products since they are typically written by non-MS parties.
I've had no problems since, and that was a couple of years ago.

Custom Desktop Application

Hi All,

Today we are very pleased to announce the CTP release of Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. To download the product you can visit the SQL Server Mobile Edition/SQL Server Everywhere Edition product page or click on this link to Access Database Synchronizer reach the download page directly.

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

I urge you all to install and try out the solution. We look forward to you providing us feedback about this solution so that we can make it better and as close to customer’s requirements as possible.

You can provide us feedback at SQL Server Mobile Edition/SQL Server Everywhere Edition MSDN Forum or SQL Server Everywhere Edition Blog - Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) or email me directly manish.agnihotri@.microsoft.com

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Hi

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

No this cannot be modified to work with SQL Express or SQL Server Everywhere on desktop. This solution is targeted for Microsoft Access only. We had a big ask for this feature from developer community

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Currently most of my work is done on larger Mobile > SQL 2000 / 2005 merge applications, but I would like to leverage the embeddable capabilites of SQL Compact to build a desktop app that communicates to a single mobile device.

Using Access is not desireable. I don't mind that I would be limited to an ActiveSync connection, since only one device / one desktop is the core design consideration I am looking at. I'd would just rather avoid Access. Given the direction that SQL Compact is taking, it looks like the long term idea is to replace the Access engine anyway, why not throw us a bone...

Also, after reading up on the Access sync, it looks like it works very similar to merge replication anyway. Except instesad of running in IIS, it runs as its own service. Thats fine too.. But SQL > SQL is better.

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

A1ex wrote:

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

|||

Have you installed the SQL CE replication components: Either sqlce30.repl.phone.wce5.armv4i.CAB for SmartPhone (non touch screen) or sqlce30.repl.ppc.wce5.armv4i.CAB for PocketPC (touch screen). Sqlceca30.dll is included in these components (see http://www.microsoft.com/sql/editions/sqlmobile/installsdk.mspx)

|||Hi!

I have the following problem: the program runs perfectly in all cases, when my computer is connected to the LAN, without LAN connection the "A request to send data to the computer running IIS has failed" error presents. All settings are the same, IIS is running on the computer, from the computer I can see the http://(computer-name):1024 page... so the service is also running. How can I solve this problem, is there any solution for this? I'm using the program on a laptop, so it's needed....
Thanks|||

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

í can′t find the "Desktop Data Sync Wizard" either, i have installed the ADS without problems, but once done it, can′t find a way to configured it. I have installed it in a Windows XP Professional SP2 with MS Office 2003 and in the mobile device i′m running Windows CE 5.0. What i′m trying to do is to Sync an SDF database with MS Access 2003 in my PC. Is this posible? Should i installed in my PC or into the device or in both? Thank you very much for your help.

Regards,

Roberto.

Custom Data Extension

I know that SRS Enterprise Edition (EE) is needed to implement a custom
security extension. Do I need Enterprise too if I want to implement a
custom data extension?
TIA.You shouldn't as noted here:
http://www.microsoft.com/sql/reporting/productinfo/features.asp
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:uKfS3ZS3EHA.4092@.TK2MSFTNGP14.phx.gbl...
> I know that SRS Enterprise Edition (EE) is needed to implement a custom
> security extension. Do I need Enterprise too if I want to implement a
> custom data extension?
> TIA.
>

Custom Authentication in RS 2005

We are currently using RS Standard Edition (SE). With the first version of
RS, Custom Authentication was only available for the Enterprise Edition
(EE).
I was reading the new features of RS 2005, and I noticed that Custom
Authentication is now available for both SE and EE licenses. Is this
correct? I just want to confirm (before installing RS 2005) since this is
our major hurdle in creating a secure reporting system.
TIA.
MarlonYES, regarding this article
http://msdn2.microsoft.com/ms143761.aspx
Med bouchenafa
"TechnoSpyke" <technospyke@.yahoo.com> a écrit dans le message de news:
uQtAPloIGHA.1876@.TK2MSFTNGP11.phx.gbl...
> We are currently using RS Standard Edition (SE). With the first version
> of RS, Custom Authentication was only available for the Enterprise Edition
> (EE).
> I was reading the new features of RS 2005, and I noticed that Custom
> Authentication is now available for both SE and EE licenses. Is this
> correct? I just want to confirm (before installing RS 2005) since this is
> our major hurdle in creating a secure reporting system.
> TIA.
>
> Marlon
>