ASP.NET, SQL Server, WPF, C#, VB.NET

Hi all,  
  
I've an EndPoint that works fine in a server with a default instance.  
  
The problem appear when I put to work the same EndPoint in a server with a  
  
named instance. The definition code of my EndPoint is that:  
  
CREATE ENDPOINT sqlendpoint  
  
STATE = STARTED  
  
AS HTTP (  
  
PATH = '/sql',  
  
AUTHENTICATION = (INTEGRATED),  
  
PORTS = (CLEAR),  
  
SITE = 'SERVER$SQL2005')  
  
FOR SOAP (  
  
WEBMETHOD 'Get1' (Name='dbo.GetOne'),  
  
BATCHES = DISABLED,  
  
WSDL = DEFAULT,  
  
DATABASE = 'AdventureWorks',  
  
NAMESPACE = 'http://Adventure-Works/')  
  
Knows anybody what's the problem.  
  
Thanks in advance ;)

"Site" is the name of the machine to listen on using HTTP. So its orthogonal  
  
to what the SQL Server instance name is. If the name of your machine is  
  
SERVER, this will work in an endpoint in either instance. You can use the  
  
netbios name, as it sounds like you did on the other instance. You can also  
  
use the DNS qualified name, localhost, or even an IP address. It's best to  
  
set it to the default '*' which means "any of the names for the machine are  
  
acceptable".  
  
This just corresponds to what names a SOAP client can use to access your  
  
endpoint.  
  
http://localhost/sql or  
  
http://server/sql or  
  
http://server.yourdomain.com/sql  
  
....etc  
  
With site='*' the client could use any of these forms.  
  
Whatever version of the name you use has to correspond to your HTTP  
  
reservation in sp_http_reserve_namespace. So if you choose * for site, your  
  
reservation looks like:  
  
sp_http_reserve_namespace N'http://*:80/sql'  
  
Other values for site would require:  
  
sp_http_reserve_namespace N'http://localhost:80/sql'  
  
sp_http_reserve_namespace N'http://server.yourdomain.com:80/sql'  
  
...etc  
  
But it relates to the machine name for HTTP stack in the kernel and its  
  
unrelated to your SQL Server instance name.  
  
Cheers,  
  
Bob Beauchemin  
  
http://www.SQLskills.com/blogs/bobb  
  
"Siquel" <mcaddperona@hotmail.com> wrote in message  
  
news:O7XpJYGNGHA.3896@TK2MSFTNGP15.phx.gbl...

Did you enable the endpoint in "SQL Server Surface Area Configuration"? Also, try leaving out the  
  
Site, for testing purposes. I have a similar config as yours, without the SITE param which work. BOL  
  
isn't very clear on this, but it does say "name of host computer" and not service or instance name.  
  
--  
  
Tibor Karaszi, SQL Server MVP  
  
http://www.karaszi.com/sqlserver/default.asp  
  
http://www.solidqualitylearning.com/  
  
Blog: http://solidqualitylearning.com/blogs/tibor/  
  
"Siquel" <mcaddperona@hotmail.com> wrote in message news:O7XpJYGNGHA.3896@TK2MSFTNGP15.phx.gbl...

Ohh, that's right. I put my host server name in the SITE option, and  
  
"boilá". It works. Thanks to both.  
  
"Bob Beauchemin" <no_bobb_spam@sqlskills.com> escribió en el mensaje  
  
news:uVAuJbMNGHA.2828@TK2MSFTNGP12.phx.gbl...