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 create and share snapshot folder on computer running IIS, but not computer running S

Hi all,
Usually , I will create a snapshot folder and share it on computer
running SQL Server for MR.
Now I have a question:
Can I create a snapshot folder on another computer which is running
IIS (For merge replication with SQL CE). The computer which is running
SQL Server was not installed IIS,just be installed SQL Server only.
Thanks,
The short answer is yes. Indeed, this would probably be considered the
"accepted" configuration -- one computer running IIS and one computer
running SQL Server. You are simply creating a virtual directory that your
publication is pointing toward to deposit the snapshot. However, your
publication must be able to access that virtual folder and if connectivity
is an issue then I would see you having problems. Note also that your SQLCE
server agent must be located in that virtual folder.
<pikctsach@.yahoo.com> wrote in message
news:55433649.0506201927.76979a0a@.posting.google.c om...
> Hi all,
> Usually , I will create a snapshot folder and share it on computer
> running SQL Server for MR.
> Now I have a question:
> Can I create a snapshot folder on another computer which is running
> IIS (For merge replication with SQL CE). The computer which is running
> SQL Server was not installed IIS,just be installed SQL Server only.
> Thanks,

Can "Windows Authentication" be used for SQL in distributed env.?

Hi all, we are about to move our SQL Server database onto a different machin
e from the machine that houses our web server (IIS). Currently our web appl
ication uses "windows authentication" - but once we move it to a different m
achine will we have to chan
ge the security mode? Or is there another way for our web server machine to
flow the identity to the other machine.
I tried looking this issue up online - but I saw no reference to it. I did
find this:
databasesecurity.asp" target="_blank">http://msdn.microsoft.com/library/d...asesecurity.asp
and it seems that the advice from Microsoft is that if you just create an id
entical account on both machines (including password) you can effectively co
nnect from the one machine to the other.
Or have I misunderstood?
Thanks for any advice,
NoviceYes. Either the web server could connect as the IUSR account, or if both
machines are in a domain, you could enable Security Delegation to allow the
end users credentials to pass thru and connect using Windows
Authentication. It depends on the security requirements of your
application and the environment.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Calling Webservice

Hi,
I have set the Reporting WebServices WebService Directory Security in
IIS to Windows Authentication. The authentication setting in the
config file is set to "Windows" with Impersonation set to "true".
I created an account called "RSAdminUser" with which to call the
webservice.
When calling the "ListReportsUsingDataSource" method, after setting
the credentials to this "RSAdminUser", I get the following error:
"System.Web.Services.Protocols.SoapException: The permissions granted
to user 'SERVER\RSAdminUser' are insufficient for performing this
operation. --> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
The permissions granted to user 'SERVER\RSAdminUser' are insufficient
for performing this operation. at
Microsoft.ReportingServices.Library.RSService.ListReportsUsingDataSource(String
path) at Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String
DataSource, CatalogItem[]& Reports) -- End of inner exception stack
trace -- at Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String
DataSource, CatalogItem[]& Reports)"
I have methodically given this user permissions to all of the relevant
folders and files that I can think of, but the only thing that makes
this work is making "RSAdminUser" a member of the "Administrators"
group. Is it possible that only members of the "Administrators" group
are allowed to execute this method?
Is there an alternative solution? What permissions does this account
need to execute this method?
Thanks in advance,
AmyHi Amy:
Reporting services uses roles based authorization, and the default
setup only places the local administrator into a role.
While RSAdminUser might have rights to access all the files and
folders in the reporting services installation, you still have to put
the user into a "role". Roles are how RS determines who can browse a
folder, who can view a report, who can manage a data source etc.
From your reports home page you can go to Site Settings -> Configure
site wide security (link is at the bottom). Perhaps you should define
a new role for RSAdminUser and grant just enough authorization for the
user to get the things done you need.
Hope this helps,
--
Scott
http://www.OdeToCode.com
On 3 Aug 2004 05:04:48 -0700, amydudley@.webmail.co.za (Amy) wrote:
>Hi,
>I have set the Reporting WebServices WebService Directory Security in
>IIS to Windows Authentication. The authentication setting in the
>config file is set to "Windows" with Impersonation set to "true".
>I created an account called "RSAdminUser" with which to call the
>webservice.
>When calling the "ListReportsUsingDataSource" method, after setting
>the credentials to this "RSAdminUser", I get the following error:
>"System.Web.Services.Protocols.SoapException: The permissions granted
>to user 'SERVER\RSAdminUser' are insufficient for performing this
>operation. --> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
>The permissions granted to user 'SERVER\RSAdminUser' are insufficient
>for performing this operation. at
>Microsoft.ReportingServices.Library.RSService.ListReportsUsingDataSource(String
>path) at Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String
>DataSource, CatalogItem[]& Reports) -- End of inner exception stack
>trace -- at Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String
>DataSource, CatalogItem[]& Reports)"
>I have methodically given this user permissions to all of the relevant
>folders and files that I can think of, but the only thing that makes
>this work is making "RSAdminUser" a member of the "Administrators"
>group. Is it possible that only members of the "Administrators" group
>are allowed to execute this method?
>Is there an alternative solution? What permissions does this account
>need to execute this method?
>Thanks in advance,
>Amy