Can I host the web service in SQL Express?

In WCF, web services can be hosted in many processes other than IIS. Can I
write my CLR extension (web service) to the SQL Express? SQL Server
Enterprise edition supports native web service, but it requires IIS.
Thanks.
HaoHello Hao,

> Can I
> write my CLR extension (web service) to the SQL Express?
If you mean, "can I write an CLR-based function or procedure and host that
in an instance of SQL Express?" then the answer is yes.
If you mean, "can I create an HTTP endpoint in an SQL Express instance?"
then the answer is no. You'll get error 7878 for your efforts.

> SQL Server
> Enterprise edition supports native web service, but it requires IIS.
Um, no, that's the point of HTTP endpoints.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||There are two challenges for deploying a full SQL edition as providing web
services.
1. Customers have to buy full SQL.
2. IIS is required.
Please correct me if the above two requirements are wrong.
Therefore it seems that the only work around is to write my own windows
service in WCF to expose web services and have this windows service talk to
SQL Express. Am I on the right track?
Thanks.
Hao
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:18f2bcb184248c93ffc0278bcf5@.news.microsoft.com...
> Hello Hao,
>
> If you mean, "can I write an CLR-based function or procedure and host that
> in an instance of SQL Express?" then the answer is yes.
> If you mean, "can I create an HTTP endpoint in an SQL Express instance?"
> then the answer is no. You'll get error 7878 for your efforts.
>
> Um, no, that's the point of HTTP endpoints.
> Thanks!
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>|||> There are two challenges for deploying a full SQL edition as providing
> web services.
> 1. Customers have to buy full SQL.
Define full SQL. HTTP endpoints are availble in the fairly cheap workgroup
SKU and higher.

> 2. IIS is required.
HTTP Endpoints DO NOT require IIS on XP, Server 2003 or higher.

> Therefore it seems that the only work around is to write my own windows
service in WCF to expose web services and have this windows service talk
to SQL Express. Am I on the right track?
If you want to use SQLExpress then the basic answer is yes.
Alternatively, you could use Mono to develop an ASMX service and deploy what
ever
HTTP stack you like.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Can I host the web service in SQL Express?

In WCF, web services can be hosted in many processes other than IIS. Can I
write my CLR extension (web service) to the SQL Express? SQL Server
Enterprise edition supports native web service, but it requires IIS.
Thanks.
Hao
Hello Hao,

> Can I
> write my CLR extension (web service) to the SQL Express?
If you mean, "can I write an CLR-based function or procedure and host that
in an instance of SQL Express?" then the answer is yes.
If you mean, "can I create an HTTP endpoint in an SQL Express instance?"
then the answer is no. You'll get error 7878 for your efforts.

> SQL Server
> Enterprise edition supports native web service, but it requires IIS.
Um, no, that's the point of HTTP endpoints.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||There are two challenges for deploying a full SQL edition as providing web
services.
1. Customers have to buy full SQL.
2. IIS is required.
Please correct me if the above two requirements are wrong.
Therefore it seems that the only work around is to write my own windows
service in WCF to expose web services and have this windows service talk to
SQL Express. Am I on the right track?
Thanks.
Hao
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:18f2bcb184248c93ffc0278bcf5@.news.microsoft.co m...
> Hello Hao,
>
> If you mean, "can I write an CLR-based function or procedure and host that
> in an instance of SQL Express?" then the answer is yes.
> If you mean, "can I create an HTTP endpoint in an SQL Express instance?"
> then the answer is no. You'll get error 7878 for your efforts.
>
> Um, no, that's the point of HTTP endpoints.
> Thanks!
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>
|||> There are two challenges for deploying a full SQL edition as providing
> web services.
> 1. Customers have to buy full SQL.
Define full SQL. HTTP endpoints are availble in the fairly cheap workgroup
SKU and higher.

> 2. IIS is required.
HTTP Endpoints DO NOT require IIS on XP, Server 2003 or higher.

> Therefore it seems that the only work around is to write my own windows
service in WCF to expose web services and have this windows service talk
to SQL Express. Am I on the right track?
If you want to use SQLExpress then the basic answer is yes.
Alternatively, you could use Mono to develop an ASMX service and deploy whatever
HTTP stack you like.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Can I handle hierarchies like Oracle ?

Hi SQL Server Experts,
Oracle has a 'Connect by prior' extension to SQL that is neat for display hierarchies.
Does SQL Server have anything simialr or would I use T-SQL or ?
I will appreciate any suggestions and advice.
B.Dimple
Junior DBANo. I faced a similar problem in the past.|||As long as you have the base of the hierarcy defined you can add levels to the table information and create your hierarchy.

This is not an elegant solution but it does work.

Assume the following Table and Field names.

tblDepartment - table of organization departments
departmentNumber - department number of the selected organization
parentDepartmentNumber - department number of preceding branch
deptLevel - hierachical level from 1

(Only the base of the hierarchy will NOT have a parent associated.

step 1--
UPDATE tblDepartment
SET tblDepartment.deptLevel = 1
WHERE (tblDepartment.parentDepartmentNumber IS NULL)

step 2--
/* L2 Levels */
UPDATE tblDepartment
SET tblDepartment.deptLevel = 2
FROM tblDepartment
INNER JOIN tblDepartment as tblParent
ON tblParent.departmentNumber = tblDepartment.parentDepartmentNumber
WHERE tblParent.deptLevel = 1

continue step 2 for all levels

referencing--
SELECT DISTINCT
level1.departmentNumber AS departmentNumber1,
Level2.departmentNumber AS departmentNumber2,
Level3.departmentNumber AS departmentNumber3,
Level4.departmentNumber AS departmentNumber4,
Level5.departmentNumber AS departmentNumber5,
Level6.departmentNumber AS departmentNumber6,
Level7.departmentNumber AS departmentNumber7
FROM tblDepartment AS level7
RIGHT
JOIN
tblDepartment AS level6 ON
level7.PARENT_departmentNumber = Level6.departmentNumber
RIGHT JOIN
tblDepartment AS level5 ON
level6.PARENT_departmentNumber = Level5.departmentNumber
RIGHT JOIN
tblDepartment AS level4 ON
level5.PARENT_departmentNumber = Level4.departmentNumber
RIGHT JOIN
tblDepartment AS level3 ON
level4.PARENT_departmentNumber = Level3.departmentNumber
RIGHT JOIN
tblDepartment AS level2 ON
level3.PARENT_departmentNumber = Level2.departmentNumber
RIGHT JOIN
tblDepartment AS level1 ON
level2.PARENT_departmentNumber = Level1.departmentNumber|||Appologies BUT the field

"PARENT_departmentNumber" in the Joins should read

"parentDepartmentNumber"

I inadvertently copied my code incorrently|||What if you have 10 levels?

You actually need a loop to go to n levels...

but if you wait awhile...Yukon will have this...

And there are many ways to denormalize this...

Check this out:

http://www.sqlteam.com/item.asp?ItemID=8866|||Brett,

I agree. My first comment was that it was not an elegant solution.

I actually use the structure defined in the artice from your link to create a lineage (a DN in my case) for populating an X500 directory.

For me it was simple because the directory has a max of 6 levels off of the root DN.

I wish I had seen this article before I spent the time devloping the logic myself. ;)

can i create database using backup file in SQl server 2005 Express edition

hi

i have a database file backup which is having no extension (eg saims) . Can i create a database using this backup in sql server expression edition.

Or else is there any way to get the .mdf file from sql server 2005 full edition??????

Thanx in advance

Hi

Is it possible you don't see the extention mdf just because your folder options in windows xp tell you to "hide extentions of known file types"?

Just create a new database and force it to backup on the file you have.

Hope this helps!

Wim

|||

no actually its a text file which is backup file taken from a sql server 2005 enterprise edition.

So now i want original file (.mdf) from DE since i don't have sql server2005 full version.

I have DE that comes with .net 2005

Can Data Extension built with VS2005 work with RS2000 ?

For various reasons our next release of our software needs to continue to support SQL 2000 and Reporting Services 2000. We are using a Data Extension written in C#.

Can we build a data extension in VS2005, using .Net 2.0 and have it work with RS2000. A quick test did not work.

Is this a valid / supported configuration ?

If it is, what steps, modification to the various configuration files would I need to make to get it to work ?

Thanks

Richard

No this won't work. RS 2000 will only work with .NET 1.1. Since data extensions will get loaded into the same app. domain, a RS 2000 data extension has to be built with .NET 1.1 / VS 2003.

-- Robert

|||What about the other way around? Will RS2005 Support extensions I built with RS2000?|||

You should update the references (e.g. RS 2005: MS.RS.Interfaces.dll) and recompile the data extension with VS 2005.

-- Robert

Can Data Extension built with VS2005 work with RS2000 ?

For various reasons our next release of our software needs to continue to support SQL 2000 and Reporting Services 2000. We are using a Data Extension written in C#.

Can we build a data extension in VS2005, using .Net 2.0 and have it work with RS2000. A quick test did not work.

Is this a valid / supported configuration ?

If it is, what steps, modification to the various configuration files would I need to make to get it to work ?

Thanks

Richard

No this won't work. RS 2000 will only work with .NET 1.1. Since data extensions will get loaded into the same app. domain, a RS 2000 data extension has to be built with .NET 1.1 / VS 2003.

-- Robert

|||What about the other way around? Will RS2005 Support extensions I built with RS2000?|||

You should update the references (e.g. RS 2005: MS.RS.Interfaces.dll) and recompile the data extension with VS 2005.

-- Robert

Can a Framework 2.0 compiled DPE run from SRS 2000?

Is it possible to run a framework 2.0 compiled data processing extension from
SRS 2000? It looks like the ReportServer script mapping is to framework 1.1.
We are not ready to upgrade to SRS2005, but would like to build our DPE with
framework 2.0.
Is this possible, and if so, what issues may there be?
Thanks, DavidI have never tried this, but my guess is that you will run into some
.NET framework versioning problems. By definition, the framework will
not let a .NET 1.1 assembly make a call to an assembly compiled with a
version higher than 1.1. However, a .NET 2.0 assembly may call a 1.1
(or prior) assembly.
In other words, .NET is backwards compatible, but not "forwards
compatible." So, since the .NET portion of SRS 2000 is running on 1.1,
you probably cannot reference a 2.0 assembly.
I hope that helps. Like I said, I've never tried, but my gut reaction
is, no, it won't work.
-Jason
David Swanson wrote:
> Is it possible to run a framework 2.0 compiled data processing extension from
> SRS 2000? It looks like the ReportServer script mapping is to framework 1.1.
> We are not ready to upgrade to SRS2005, but would like to build our DPE with
> framework 2.0.
> Is this possible, and if so, what issues may there be?
> Thanks, David|||Thanks for Jason's input,
Hi David,
As for the SSRS 2005 extension components running in SSRS 2000 question,
I'm afraid this is not supported due to the limitation of .net framework's
versioning policy. Generally, .net framework only provide backward
compatibility support. Therefore, only .net framework 1.x assemblies can
not loaded and executed in .net framework 2.0 runtime(clr). On the
contrary, .net framework 1.x can still be loaded by .net framework 2.0
runtime (for backward compaitbility), however, there is still possible
issues if the used 1.x classes have any break changes in .net 2.0 classes.
BTW, as for your DP extension, have you already developed it under .net
framework 2.0? If not, I suggest you still develop it through .net
framework 1.1 so as to make it loadable in .net framework 1.x runtime(SSRS
2000).
Please feel free to post here if you have any other concerns or ideas on
this.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi David,
How are you doing on this issue, have you got any progress or made the
decision on this issue? If there is still anything we can help, please
feel free to post here.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Can a Custom Security Extension help me here?

I am hoping someone can tell me what I am trying to do is even possible
before I waste several hours of development time. I have read all relevant
posts in this newsgroup, and the Microsoft provided Forms Authentication
example
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp).
However, I am still unsure if what I want to do will even work.
Here's the setup...
Reporting Services is being deployed on its own box, exposed to the internet.
For this discussion call it http://rs-box
Users are dropped to a "List of Reports" screen (an .aspx page) on this box
via a link clicked from an Apache server. I've handled the appropriate
security issues for this action just fine. What happens is the Apache server
sends the user's information encrypted on the query string:
ex. http://rs-box?userInfo=SomeEncryptedStringOfCharacters
My "List of Reports" .aspx page decryptes the userInfo parameter and
renders the available reports or kicks them back to the Apache server to
login. If the user information is acceptable, it gets dropped into the
HttpSession. That part is easy.
One of the reports shows the user all their account activity for a given
date range. I want them to be able to use the interactive toolbar (via their
web browser) to export to their chosen format, etc. The way the account
activity report is implemented is that one of the parameters it needs to run
is the user's account number. This is basically a parameter passed to the
report.
So here's my question. I need to check (I assume via a custom security
extension) if the account number being passed in along the URL is the same as
the account number stored in the HttpSession (I don't want users manipulating
the URL and calling up the account history for another user). It is a really
easy thing to check, but after a few hours of research I just don't know if
it is possible.
If I'm on the right track any hints as to which functions to override would
be greatly appreciated too...
ryanYes, if your account number is the UserID in your security extension, you
can simply use User!UserID as a parameter when pulling up the history.
That's very similar to what we're doing. Works like a snap -- after much
hassle setting it up. The Forms Authentication sample code is a great
start.
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"ryan" <ryan@.discussions.microsoft.com> wrote in message
news:8B7B5537-4D72-4877-AD22-D1783A932674@.microsoft.com...
>I am hoping someone can tell me what I am trying to do is even possible
> before I waste several hours of development time. I have read all
> relevant
> posts in this newsgroup, and the Microsoft provided Forms Authentication
> example
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp).
> However, I am still unsure if what I want to do will even work.
> Here's the setup...
> Reporting Services is being deployed on its own box, exposed to the
> internet.
> For this discussion call it http://rs-box
> Users are dropped to a "List of Reports" screen (an .aspx page) on this
> box
> via a link clicked from an Apache server. I've handled the appropriate
> security issues for this action just fine. What happens is the Apache
> server
> sends the user's information encrypted on the query string:
> ex. http://rs-box?userInfo=SomeEncryptedStringOfCharacters
> My "List of Reports" .aspx page decryptes the userInfo parameter and
> renders the available reports or kicks them back to the Apache server to
> login. If the user information is acceptable, it gets dropped into the
> HttpSession. That part is easy.
> One of the reports shows the user all their account activity for a given
> date range. I want them to be able to use the interactive toolbar (via
> their
> web browser) to export to their chosen format, etc. The way the account
> activity report is implemented is that one of the parameters it needs to
> run
> is the user's account number. This is basically a parameter passed to the
> report.
> So here's my question. I need to check (I assume via a custom security
> extension) if the account number being passed in along the URL is the same
> as
> the account number stored in the HttpSession (I don't want users
> manipulating
> the URL and calling up the account history for another user). It is a
> really
> easy thing to check, but after a few hours of research I just don't know
> if
> it is possible.
> If I'm on the right track any hints as to which functions to override
> would
> be greatly appreciated too...
> ryan