dbTalk Databases Forums  

Can't connect to SSL SOAP endpoint

microsoft.public.sqlserver.connect microsoft.public.sqlserver.connect


Discuss Can't connect to SSL SOAP endpoint in the microsoft.public.sqlserver.connect forum.



Reply
 
Thread Tools Display Modes
  #101  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM






Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #102  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM






Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #103  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM



Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #104  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM



Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #105  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM



Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #106  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM



Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #107  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM



Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #108  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM



Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #109  
Old   
Peter Yang[MSFT]
 
Posts: n/a

Default Re: Can't connect to SSL SOAP endpoint - 06-03-2008 , 09:23 PM



Hello Axel,

You may try telnet from a different machine. If it's blocked, please
temporiarly disable firewall on your server to test the issue. If the issue
persists, please let me know what's the exact error message you get when
you connect to the Web service from IE by using URL such as following:

https://localhost:5000/PortfolioCockpit/SQL?wsdl


Regarding your question on permission, When an endpoint is created, only
members of the sysadmin role and the owner of the endpoint can connect to
the endpoint.
You need to run "grant connect on endpoint" statement for any other users
who you want to give the permission to connect to the Web service.

Overview of Native XML Web Services for Microsoft SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345123.aspx

In order to isolate permission related issue, you just log on as a windows
user with "sysadmin" role on SQL Server, and then do the test.

If anything is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.