How to create ENDPOINT in Sql Server CTP Beta 2

I am learnig to create a endpoint in Sql Server 2005. I have create a simple SP to get a customer in Northwind.
Then create a endpoint using HTTP.

SP:
CREATE PROCEDURE [db_accessadmin].[upGetCustomer]
@.CustId nchar(5)
AS

SELECT CustomerID,CompanyName,ContactName,ContactTitle,Address,City,PostalCode,Country,Phone,Fax
FROM Customers
WHERE CustomerId=@.CustId
ORDER by CompanyName,CustomerID,Country DESC

Then, create the ENDPOINT script,
USE [Northwind]
GO

CREATE ENDPOINT customer_endpoint
STATE=STARTED
AS HTTP (
PATH='/sql',
AUTHENTICATION= (INTEGRATED),
PORTS = (CLEAR),
SITE = '*'
)
FOR SOAP (
WEBMETHOD 'http://tempUri.org','GetCustomerInfo'
(
NAME='Northwind.dbo.upGetCustomer', FORMAT=ROWSETS_ONLY,
schema=STANDARD
),
WSDL=DEFAULT,
BATCHES=ENABLED,
DATABASE='Northwind'
)
GO

I followed to .Net show - Sql Server 2005 and an article from DevX website, http://www.devx.com/dbzone/Article/28525/1954?pf=true.

Everything seems to be ok, i think but when I tried to check syntax/runs the script I gets error message,

.Net SqlClient Data Provider: Msg 102, Level 15, State 1, Line 11

Incorrect syntax near ','.

This error situated at close bracket before FOR SOAP statement.

Thanks in advance
Punpromk

WEBMETHOD 'http://tempUri.org','GetCustomerInfo'

should be:

WEBMETHOD 'http://tempUri.org'.'GetCustomerInfo'|||Thanks,
Its complied and installed but I have another problem.
The problem is the Win XP SP2 IIS 5.1 which is not "http.sys.based" as it conflict with SQL Server 2005. This problem, an article I found on the yukonxml.com, http://yukonxml.com/weblog/darshan/archive/2005/02/21.aspx.

The article stated that I can runs IIS or HTTP SOAP Web Services on the same port, and can use different ports to run both simultaneously.
Well, does not say how?, anyone can help me.

Please note, don't try to stop IIS and installed the ENDPOINT on the Win XP, almost screw my system up. (unlike me.. If you know what to do that Ok..)

Thanks in advance.
Punprom Kasemsant
|||try using this:

CREATE ENDPOINT customer_endpoint
STATE=STARTED
AS HTTP (
PATH='/sql',
AUTHENTICATION= (INTEGRATED),
PORTS = (CLEAR),
CLEAR_PORT = 8080,
SITE = '*'
)

how to create a mdf db with sql server 2005 ctp?

hi,

i have installed the sql server 2005 ctp cause i couldn't install the sql server 2005 express on my computer. when i now create a database under the sql server 2005 management studio and connect from vs 2005 beta1 everything works fine for me.

but i want to create and work with the single mdf files wich are created by sql server express edition via ADD NEW ITEM -> DATABASE -> DB.MDF .

is it possible to create such a db file for xcopy deploayment use?

thanks
Yavuz BogazciYavuz,

The functionality you speak of is only available with SQL Server Express. What problems did you encounter while installing Express?

Dan

How to create a dropdown list on report?

I would like to create a first dropdown list on my report. How can I do that?
I am using followings,
Reporting service (SQL Server 2005 June CTP release)
Steps which I am following to create a report,
1. Creating a model using BIDS and publishing it to Report Server
2. By using Report Builder, I am creating new report and storing it on
Report server. In one of my report, I would like to display dropdown list for
Project with "Project Name". At present, I am using filter criteria for
displaying parameter on each report but it is only displaying text field.
I am still searching related post here and expecting help...
Thnks
--
There is a light on the other side, Keep walking.Try these steps. Step number 3 is the key item here.
1. Open the Filter dialog
2. Add a entity or field to the filter layout area
3. Click on the entity or field name. This will open a context menu. Select
the 'Prompt' option
4. Click on the filter condition. This will open a context menu. Select the
'In a List' option
5. Click the filter value dropdown. You can pre select values to display or
leave all items unchecked.
6. Run the report. You should see dropdown that contains a list of parameter
values.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nilesh Trivedi" <NileshTrivedi@.discussions.microsoft.com> wrote in message
news:4D0A8262-1594-4A5B-B06E-2A51401307AF@.microsoft.com...
>I would like to create a first dropdown list on my report. How can I do
>that?
> I am using followings,
> Reporting service (SQL Server 2005 June CTP release)
> Steps which I am following to create a report,
> 1. Creating a model using BIDS and publishing it to Report Server
> 2. By using Report Builder, I am creating new report and storing it on
> Report server. In one of my report, I would like to display dropdown list
> for
> Project with "Project Name". At present, I am using filter criteria for
> displaying parameter on each report but it is only displaying text field.
> I am still searching related post here and expecting help...
> Thnks
> --
> There is a light on the other side, Keep walking.|||Yes, I achieved so far. But my question is still open.
Consider following scenario,
Report designer - will create a report with selected dropdown items using
filter criteria <Fieldname> <in a list> <Item selected>. This field
<fieldname> is checked as prompt which will display parameter in a report
while running a report.
N.B.: As you are saying in your previous reply.
Report user - will run this report and will see only preselected <Item
Selected> by the Report Designer.
My query is to make more flexible to Report user so that Report user can
select any dropdown items. So on Report, Report user will have dropdown list
instead of simple textbox.
--
There is a light on the other side, Keep walking.
"Bruce Johnson [MSFT]" wrote:
> Try these steps. Step number 3 is the key item here.
> 1. Open the Filter dialog
> 2. Add a entity or field to the filter layout area
> 3. Click on the entity or field name. This will open a context menu. Select
> the 'Prompt' option
> 4. Click on the filter condition. This will open a context menu. Select the
> 'In a List' option
> 5. Click the filter value dropdown. You can pre select values to display or
> leave all items unchecked.
> 6. Run the report. You should see dropdown that contains a list of parameter
> values.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Nilesh Trivedi" <NileshTrivedi@.discussions.microsoft.com> wrote in message
> news:4D0A8262-1594-4A5B-B06E-2A51401307AF@.microsoft.com...
> >I would like to create a first dropdown list on my report. How can I do
> >that?
> > I am using followings,
> > Reporting service (SQL Server 2005 June CTP release)
> > Steps which I am following to create a report,
> > 1. Creating a model using BIDS and publishing it to Report Server
> > 2. By using Report Builder, I am creating new report and storing it on
> > Report server. In one of my report, I would like to display dropdown list
> > for
> > Project with "Project Name". At present, I am using filter criteria for
> > displaying parameter on each report but it is only displaying text field.
> >
> > I am still searching related post here and expecting help...
> > Thnks
> >
> > --
> > There is a light on the other side, Keep walking.
>
>|||I achieved my query by doing followings,
1. Create a basic report using Report Builder
2. Save Report on Report Server
3. Create a new project with Report Designer
4. Go to the Report Manager and Edit Report and save RDL file to Report
Designer project path
5. Add existing report to project created in step 3.
6. Apply features like Show/hide columns/Drilldown/Header/Footer/Company
Logo/Report properties/Change report parameters/ passing parameters to sub
report/Change column headers etc.
7. Save report (PUBLISH THIS REPORT TO REPORT SERVER WILL NOT WORK AND THROW
RUNTIME ERROR)
8. Go to Report Manager and upload and overwrite report file
9. Set report parameters in report manager (If required)
10. Run report with report server (if any initial parameter, apply in IE
address bar)
This is the way i am using RS 2005 (June CTP release). I am not sure whether
this is a right way of publishing report.
There are few advantages and disadvantages by using above way to develop
report
Advantages
- Utilising most of the report features available in Report designer
- Primary goal achieved by utilising Report model concept to develop report.
(BUT STILL EXPECTING MORE FEATURES AVAILABLE IN REPORT BUILDER)
Disadvantages
- Lot of maintainace to handle reports due to once upload this report can
not be edited in Report builder. Report builder capability is minimal and may
not be used as end user tool because final report is again developed in
report designer project which is a task of development team
- Adding a new column/change a layout etc. in existing report requires to
create report again i.e. STEP-1 as mentioned above
--
There is a light on the other side, Keep walking.
"Nilesh Trivedi" wrote:
> I would like to create a first dropdown list on my report. How can I do that?
> I am using followings,
> Reporting service (SQL Server 2005 June CTP release)
> Steps which I am following to create a report,
> 1. Creating a model using BIDS and publishing it to Report Server
> 2. By using Report Builder, I am creating new report and storing it on
> Report server. In one of my report, I would like to display dropdown list for
> Project with "Project Name". At present, I am using filter criteria for
> displaying parameter on each report but it is only displaying text field.
> I am still searching related post here and expecting help...
> Thnks
> --
> There is a light on the other side, Keep walking.