Showing posts with label receive. Show all posts
Showing posts with label receive. Show all posts

Friday, February 24, 2012

Can't connect via HTTP remotely...

Hello-

I've just set up HTTP Access to SSAS and can connect locally, but when trying to connect remotely, as the same domain user, I receive the message:

The connection either timed out or was lost

Unable to connect to the remote server

No connection could be made because the target machine actively refused it

I can connect remotely if I connect using just the servername (rather than http://...)

Anyone else runinto this one?

Hi Tristan,

For troubleshooting connectivity problems, one great resource is Edward's blog at: http://www.sqljunkies.com/WebLog/edwardm/.

If you still have connectivity issues after following the guidelines described in this blog, please let us know and give more details.

Hope this helps,

Artur

Sunday, February 19, 2012

Can't connect to sql server 2005 - SSL

Hi,
I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
La cha?ne de certificat a été fournie par une autorité qui n'est pas
approuvée.) (.Net SqlClient Data Provider)
I don't have a SSL certificate and i don't want to use it.
Do you have any idea how I can fix it ?
Thanks in advance.
Erik
Forget it...
I found the solution. I ran REGEDIT and remove the
HKLM/SOFTWARE/MICROSOFT/MSSQLServer/CLIENT/...
... and there were a key about SSL (I already forgot the name).
After that, SQL SERVER ran without error.
;o)

Can't connect to sql server 2005 - SSL

Hi,
I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
La cha?ne de certificat a été fournie par une autorité qui n'est pas
approuvée.) (.Net SqlClient Data Provider)
I don't have a SSL certificate and i don't want to use it.
Do you have any idea how I can fix it '
Thanks in advance.
ErikForget it...
I found the solution. I ran REGEDIT and remove the
HKLM/SOFTWARE/MICROSOFT/MSSQLServer/CLIENT/...
... and there were a key about SSL (I already forgot the name).
After that, SQL SERVER ran without error.
;o)