Report builder and custom security

We need to implement SQL Server 2005 Report Builder using our own security
model. We use application level authentication, in which a user ID and
password is verified against a record in the sql server database. So, we
don't use Windows Authentication. The problem is that we need to implement
the reporting builder as our ad-hoc reporting tool, but we need each user to
have his own private folder on the server. I've found only four articles on
http://msdn2.microsoft.com which talks about custom security extension, but
none of those is even close to what I'm looking for. I'm sure that there're
folks out there who've done this before.
Any suggestion or lead will be greatly appreciated.
Thanks,
Gilgameshhave you activated the "My Reports" option in reporting services?
this create a /My Reports folder and each user will have a private folder.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> We need to implement SQL Server 2005 Report Builder using our own security
> model. We use application level authentication, in which a user ID and
> password is verified against a record in the sql server database. So, we
> don't use Windows Authentication. The problem is that we need to implement
> the reporting builder as our ad-hoc reporting tool, but we need each user
> to have his own private folder on the server. I've found only four
> articles on http://msdn2.microsoft.com which talks about custom security
> extension, but none of those is even close to what I'm looking for. I'm
> sure that there're folks out there who've done this before.
> Any suggestion or lead will be greatly appreciated.
> Thanks,
> Gilgamesh
>|||Yes, I have. The problem is that My Reports works only if you use Windows
Autehtication. As I explained in the posting, we use database authetication.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> have you activated the "My Reports" option in reporting services?
> this create a /My Reports folder and each user will have a private folder.
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> We need to implement SQL Server 2005 Report Builder using our own
>> security model. We use application level authentication, in which a user
>> ID and password is verified against a record in the sql server database.
>> So, we don't use Windows Authentication. The problem is that we need to
>> implement the reporting builder as our ad-hoc reporting tool, but we need
>> each user to have his own private folder on the server. I've found only
>> four articles on http://msdn2.microsoft.com which talks about custom
>> security extension, but none of those is even close to what I'm looking
>> for. I'm sure that there're folks out there who've done this before.
>> Any suggestion or lead will be greatly appreciated.
>> Thanks,
>> Gilgamesh
>>|||Have you implemented custom security in Reporting Services? I don't use
Report Builder but in the end you end up with a RDL just like if it had been
designed in Report Designer.
So, my question is, do you have your custom security implemented in any way
with RS? That is the first thing you will need to do.
http://msdn2.microsoft.com/en-us/library/ms152825.aspx
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> Yes, I have. The problem is that My Reports works only if you use Windows
> Autehtication. As I explained in the posting, we use database
> authetication.
> -G
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> have you activated the "My Reports" option in reporting services?
>> this create a /My Reports folder and each user will have a private
>> folder.
>>
>> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
>> news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> We need to implement SQL Server 2005 Report Builder using our own
>> security model. We use application level authentication, in which a user
>> ID and password is verified against a record in the sql server database.
>> So, we don't use Windows Authentication. The problem is that we need to
>> implement the reporting builder as our ad-hoc reporting tool, but we
>> need each user to have his own private folder on the server. I've found
>> only four articles on http://msdn2.microsoft.com which talks about
>> custom security extension, but none of those is even close to what I'm
>> looking for. I'm sure that there're folks out there who've done this
>> before.
>> Any suggestion or lead will be greatly appreciated.
>> Thanks,
>> Gilgamesh
>>
>|||Bruce
ok, i need to do the same thing. But i am having some trouble with
configuring the secruity extension (Forms Authenication). i have an
question on the User Accounts database part.
The instructions say to replace the "LocalMachine" towards the end of
the createuserstore.sql. But i don't see any mention of that in the
script at all. Any ideas?
INSTRUCTIONS:
Locate "LocalMachine" towards the end of the script and replace it
with your own computer name. For Windows 2003 users, replace
LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
IIS 5 compatibility mode).
createuserstore SCRIPT:
exec ('sp_grantlogin [' + @.ASPUserName + ']');
-- Add a database login for the UserAccounts database for the ASPNET
account
exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
-- Grant execute permissions to the LookupUser and RegisterUser stored
procs
exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
------
Have you implemented custom security in Reporting Services? I don't
use
Report Builder but in the end you end up with a RDL just like if it
had been
designed in Report Designer.
So, my question is, do you have your custom security implemented in
any way
with RS? That is the first thing you will need to do.
http://msdn2.microsoft.com/en-us/library/ms152825.aspx
On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Have you implemented custom security in Reporting Services? I don't use
> Report Builder but in the end you end up with a RDL just like if it had been
> designed in Report Designer.
> So, my question is, do you have your custom security implemented in any way
> with RS? That is the first thing you will need to do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
>
> > Yes, I have. The problem is that My Reports works only if you use Windows
> > Autehtication. As I explained in the posting, we use database
> > authetication.
> > -G
> > "Jeje" <willg...@.hotmail.com> wrote in message
> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> >> have you activated the "My Reports" option in reporting services?
> >> this create a /My Reports folder and each user will have a private
> >> folder.
> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> >> We need to implement SQL Server 2005 Report Builder using our own
> >> security model. We use application level authentication, in which a user
> >> ID and password is verified against a record in the sql server database.
> >> So, we don't use Windows Authentication. The problem is that we need to
> >> implement the reporting builder as our ad-hoc reporting tool, but we
> >> need each user to have his own private folder on the server. I've found
> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
> >> custom security extension, but none of those is even close to what I'm
> >> looking for. I'm sure that there're folks out there who've done this
> >> before.
> >> Any suggestion or lead will be greatly appreciated.
> >> Thanks,
> >> Gilgamesh- Hide quoted text -
> - Show quoted text -|||Sorry, I have not implemented this. I suggest a separate post specifically
about that. Also, you might want to post it at the web based forums as well.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ryan Swann" <swannryan@.gmail.com> wrote in message
news:1185807504.059515.124770@.57g2000hsv.googlegroups.com...
> Bruce
> ok, i need to do the same thing. But i am having some trouble with
> configuring the secruity extension (Forms Authenication). i have an
> question on the User Accounts database part.
> The instructions say to replace the "LocalMachine" towards the end of
> the createuserstore.sql. But i don't see any mention of that in the
> script at all. Any ideas?
>
> INSTRUCTIONS:
> Locate "LocalMachine" towards the end of the script and replace it
> with your own computer name. For Windows 2003 users, replace
> LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
> IIS 5 compatibility mode).
> createuserstore SCRIPT:
>
> exec ('sp_grantlogin [' + @.ASPUserName + ']');
> -- Add a database login for the UserAccounts database for the ASPNET
> account
> exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
> -- Grant execute permissions to the LookupUser and RegisterUser stored
> procs
> exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
> exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
> ------
> Have you implemented custom security in Reporting Services? I don't
> use
> Report Builder but in the end you end up with a RDL just like if it
> had been
> designed in Report Designer.
> So, my question is, do you have your custom security implemented in
> any way
> with RS? That is the first thing you will need to do.
> http://msdn2.microsoft.com/en-us/library/ms152825.aspx
>
>
>
>
> On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Have you implemented custom security in Reporting Services? I don't use
>> Report Builder but in the end you end up with a RDL just like if it had
>> been
>> designed in Report Designer.
>> So, my question is, do you have your custom security implemented in any
>> way
>> with RS? That is the first thing you will need to
>> do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
>> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
>>
>> > Yes, I have. The problem is that My Reports works only if you use
>> > Windows
>> > Autehtication. As I explained in the posting, we use database
>> > authetication.
>> > -G
>> > "Jeje" <willg...@.hotmail.com> wrote in message
>> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> >> have you activated the "My Reports" option in reporting services?
>> >> this create a /My Reports folder and each user will have a private
>> >> folder.
>> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
>> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> >> We need to implement SQL Server 2005 Report Builder using our own
>> >> security model. We use application level authentication, in which a
>> >> user
>> >> ID and password is verified against a record in the sql server
>> >> database.
>> >> So, we don't use Windows Authentication. The problem is that we need
>> >> to
>> >> implement the reporting builder as our ad-hoc reporting tool, but we
>> >> need each user to have his own private folder on the server. I've
>> >> found
>> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
>> >> custom security extension, but none of those is even close to what
>> >> I'm
>> >> looking for. I'm sure that there're folks out there who've done this
>> >> before.
>> >> Any suggestion or lead will be greatly appreciated.
>> >> Thanks,
>> >> Gilgamesh- Hide quoted text -
>> - Show quoted text -
>|||I got evreything working, let me know if someone needs some help with it
"Bruce L-C [MVP]" wrote:
> Sorry, I have not implemented this. I suggest a separate post specifically
> about that. Also, you might want to post it at the web based forums as well.
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ryan Swann" <swannryan@.gmail.com> wrote in message
> news:1185807504.059515.124770@.57g2000hsv.googlegroups.com...
> > Bruce
> >
> > ok, i need to do the same thing. But i am having some trouble with
> > configuring the secruity extension (Forms Authenication). i have an
> > question on the User Accounts database part.
> >
> > The instructions say to replace the "LocalMachine" towards the end of
> > the createuserstore.sql. But i don't see any mention of that in the
> > script at all. Any ideas?
> >
> >
> > INSTRUCTIONS:
> >
> > Locate "LocalMachine" towards the end of the script and replace it
> > with your own computer name. For Windows 2003 users, replace
> > LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
> > IIS 5 compatibility mode).
> >
> > createuserstore SCRIPT:
> >
> >
> > exec ('sp_grantlogin [' + @.ASPUserName + ']');
> >
> > -- Add a database login for the UserAccounts database for the ASPNET
> > account
> > exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
> >
> > -- Grant execute permissions to the LookupUser and RegisterUser stored
> > procs
> > exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
> > exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
> >
> > ------
> > Have you implemented custom security in Reporting Services? I don't
> > use
> > Report Builder but in the end you end up with a RDL just like if it
> > had been
> > designed in Report Designer.
> >
> > So, my question is, do you have your custom security implemented in
> > any way
> > with RS? That is the first thing you will need to do.
> > http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> >
> >
> >
> >
> >
> >
> >
> >
> > On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Have you implemented custom security in Reporting Services? I don't use
> >> Report Builder but in the end you end up with a RDL just like if it had
> >> been
> >> designed in Report Designer.
> >>
> >> So, my question is, do you have your custom security implemented in any
> >> way
> >> with RS? That is the first thing you will need to
> >> do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >>
> >> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> >>
> >>
> >>
> >> > Yes, I have. The problem is that My Reports works only if you use
> >> > Windows
> >> > Autehtication. As I explained in the posting, we use database
> >> > authetication.
> >> > -G
> >>
> >> > "Jeje" <willg...@.hotmail.com> wrote in message
> >> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> >> >> have you activated the "My Reports" option in reporting services?
> >> >> this create a /My Reports folder and each user will have a private
> >> >> folder.
> >>
> >> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> >> >> We need to implement SQL Server 2005 Report Builder using our own
> >> >> security model. We use application level authentication, in which a
> >> >> user
> >> >> ID and password is verified against a record in the sql server
> >> >> database.
> >> >> So, we don't use Windows Authentication. The problem is that we need
> >> >> to
> >> >> implement the reporting builder as our ad-hoc reporting tool, but we
> >> >> need each user to have his own private folder on the server. I've
> >> >> found
> >> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
> >> >> custom security extension, but none of those is even close to what
> >> >> I'm
> >> >> looking for. I'm sure that there're folks out there who've done this
> >> >> before.
> >>
> >> >> Any suggestion or lead will be greatly appreciated.
> >>
> >> >> Thanks,
> >> >> Gilgamesh- Hide quoted text -
> >>
> >> - Show quoted text -
> >
> >
>
>

Report builder & designer end-user's functionality

Where can I find a comparison between the report builder and designer? I would like to implement an end-user solution and as part of the exploration process I failed to completely understand the capabilities and disadvantages in each of the modules (I’m talking about the end-users functionality for the given reports – not for the designer’s usability of any sort)

Thanks

Ron

Take a look at slide 13 of http://download.microsoft.com/download/e/2/6/e2631eea-9a8d-484c-ba43-ac2e5be86396/BIN316.ppt. This is a version of a slide that I built to explain the differences.|||

Hey Brian - any chance you have a new location for this? The link is currently invalid.

Thanks,

|||

Hello Brian,

I was just wondering if MS Report Builder is a good choice to work on SQL Database where several tables each containing '8 Million Records'? So far I have found it 'Unacceptably Slow' (even with several filter). Any suggestion will be highly appreciated.

Thanks,

Anis.

Report builder & designer end-user's functionality

Where can I find a comparison between the report builder and designer? I would like to implement an end-user solution and as part of the exploration process I failed to completely understand the capabilities and disadvantages in each of the modules (I’m talking about the end-users functionality for the given reports – not for the designer’s usability of any sort)

Thanks

Ron

Take a look at slide 13 of http://download.microsoft.com/download/e/2/6/e2631eea-9a8d-484c-ba43-ac2e5be86396/BIN316.ppt. This is a version of a slide that I built to explain the differences.|||

Hey Brian - any chance you have a new location for this? The link is currently invalid.

Thanks,

|||

Hello Brian,

I was just wondering if MS Report Builder is a good choice to work on SQL Database where several tables each containing '8 Million Records'? So far I have found it 'Unacceptably Slow' (even with several filter). Any suggestion will be highly appreciated.

Thanks,

Anis.

Reply...

Steve,
Thanks for your feedback! I will implement the code into my normal
maintenance routine as I definitely find it very useful!
I still have a problem though of shrinking the physical size of the log
or changing my maintenance plan so that the log file does not grow so
quickly. I noticed my weekend maintenance plan of REINDEX, etc makes
the log grow very large, very quickly. I desperately need a way to
control the log size when the maintenance is run on the weekend as I
need to maintain over 130 databases.
For example (values are rough estimates), on Friday I may have one log
file that throughout the weekend has maintained it's size of 5MB (mdf
size of 25MB). After running the REINDEX, etc. on a Saturday evening
(between full backups - one on Friday night/another on Sat night), the
log size is now 30MB (mdf file is still 25MB). Throughtout the week,
the trans log maintains it's physical log size of 30MB. The next
weekend, DBREINDEX, etc. kicks off again - now the log file has grown to
55MB. You can see where I'm going here I'm sure by now. I need a way
to keep this log file under control so that every week when I run db
maintenance, it does not keep growing out of control.
Is it as easy as just implementing the code that Steve provided on a
weekend basis and after the REINDEX has run, it will maintain that log
size? That is:
log size before db maintenance: 5MB
Log size after db maintenance (wk1): 30 MB
Run Steve's code
Log size after db maintenance (wk2, etc): 30 MB
Thanks again for everyone's input and if I am missing something obvious,
thanks for your patience!
Rich
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!From your description, it seems that you never empty the log. Emptying the
log is not the same as shrinking the file size of the tlog files. Either do
regular log backups or set the database in simple recovery mode. You will
then see that the log is emptied regularly and each defrag will need some 25
MB in the log, but as the log is emptied regularly, it will never grow
beyond approx 25-30 MB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich S" <myscullyfamily@.yahoo.com> wrote in message
news:OB%230byECEHA.140@.TK2MSFTNGP09.phx.gbl...
>
> Steve,
> Thanks for your feedback! I will implement the code into my normal
> maintenance routine as I definitely find it very useful!
> I still have a problem though of shrinking the physical size of the log
> or changing my maintenance plan so that the log file does not grow so
> quickly. I noticed my weekend maintenance plan of REINDEX, etc makes
> the log grow very large, very quickly. I desperately need a way to
> control the log size when the maintenance is run on the weekend as I
> need to maintain over 130 databases.
> For example (values are rough estimates), on Friday I may have one log
> file that throughout the weekend has maintained it's size of 5MB (mdf
> size of 25MB). After running the REINDEX, etc. on a Saturday evening
> (between full backups - one on Friday night/another on Sat night), the
> log size is now 30MB (mdf file is still 25MB). Throughtout the week,
> the trans log maintains it's physical log size of 30MB. The next
> weekend, DBREINDEX, etc. kicks off again - now the log file has grown to
> 55MB. You can see where I'm going here I'm sure by now. I need a way
> to keep this log file under control so that every week when I run db
> maintenance, it does not keep growing out of control.
> Is it as easy as just implementing the code that Steve provided on a
> weekend basis and after the REINDEX has run, it will maintain that log
> size? That is:
> log size before db maintenance: 5MB
> Log size after db maintenance (wk1): 30 MB
> Run Steve's code
> Log size after db maintenance (wk2, etc): 30 MB
> Thanks again for everyone's input and if I am missing something obvious,
> thanks for your patience!
> Rich
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
Rob
Standard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>
|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>
|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
Rob
Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
RobStandard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>>I have a requirement to implement replication between SQL Server and MSDE
>>on client machines. Problem is we cannot ask our customers to purchase
>>SQL Server Enterprise Edition, so we are left with the buy vs build
>>scenario.
>> Can anyone recommend any components or vendors that offer this
>> functionality? Royalty free licensing is a must.
>> Thanks in advance.
>> Rob
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
RobStandard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>