Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Connection Prodlem-with instance node

 
   Database Forums (Home) -> Connect RSS
Next:  failure recovery in a cluster?  
Author Message
Utf-8BUml61

External


Since: Jul 14, 2004
Posts: 2



(Msg. 1) Posted: Wed Jul 14, 2004 11:23 am
Post subject: Connection Prodlem-with instance node
Archived from groups: microsoft>public>sqlserver>connect (more info?)

Hi
I have an active/passive sql server 2000 cluster. Most of the time I remote-login into the server and use the enterprise manager to work. But now when I click on either of the node I get the following error:

Encryption not supported on SQL Server ConnectionOpen (PreLoginHandshake())

But I'm able to connect to the server from my desktop.

Any help in this regard?

Thanks,

 >> Stay informed about: Connection Prodlem-with instance node 
Back to top
Login to vote
Kevin McDonnell MS

External


Since: Dec 12, 2003
Posts: 447



(Msg. 2) Posted: Wed Jul 14, 2004 7:16 pm
Post subject: RE: Connection Prodlem-with instance node [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This means that the "Enable Protocol Encryption" option was set on the
machine you're using as a client.
Use the SQL Client Network Utility to uncheck this.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

 >> Stay informed about: Connection Prodlem-with instance node 
Back to top
Login to vote
Utf-8BUml61

External


Since: Jul 14, 2004
Posts: 2



(Msg. 3) Posted: Wed Jul 14, 2004 7:16 pm
Post subject: RE: Connection Prodlem-with instance node [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Kevin

Thank you so much it worked.

Razi

"Kevin McDonnell [MSFT]" wrote:

 > This means that the "Enable Protocol Encryption" option was set on the
 > machine you're using as a client.
 > Use the SQL Client Network Utility to uncheck this.
 >
 > Thanks,
 >
 > Kevin McDonnell
 > Microsoft Corporation
 >
 > This posting is provided AS IS with no warranties, and confers no rights.
 >
 >
 >
 >
 >> Stay informed about: Connection Prodlem-with instance node 
Back to top
Login to vote
Kevin McDonnell MS

External


Since: Dec 12, 2003
Posts: 447



(Msg. 4) Posted: Wed Jul 14, 2004 8:17 pm
Post subject: RE: Connection Prodlem-with instance node [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You're welcome!
Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.
 >> Stay informed about: Connection Prodlem-with instance node 
Back to top
Login to vote
Justine

External


Since: Mar 05, 2008
Posts: 1



(Msg. 5) Posted: Wed Mar 05, 2008 9:06 am
Post subject: RE: Connection Prodlem-with instance node [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I'm getting the same error in SQL2005 SSIS - Where is this option in 2005?

"Kevin McDonnell [MSFT]" wrote:

> This means that the "Enable Protocol Encryption" option was set on the
> machine you're using as a client.
> Use the SQL Client Network Utility to uncheck this.
>
> Thanks,
>
> Kevin McDonnell
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
>
>
 >> Stay informed about: Connection Prodlem-with instance node 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Slow connection to local instance - I have Personal Edition in my desktop for development and it's quite slow to connect. For e.g. When I'm in QA and press Ctrl-U to list the databases, it takes about 5-10 seconds to show up. For a local connection this is very slow. Also, when..

sql2000 instance connection problem - Hi All, I'm unable to make connection to my sql2000 instance, I tried to search the knowledge base on msdn and failed with their solutions (defining alias). Can you give me some advice on this ? Cheers. Gultekin KOMANLI

WMI and Instance - The following code works ... Set objWMIService = GetObject("winmgmts:\\.\root\Microsoft\SqlServer\ComputerManagement") Set colItems = objWMIService.ExecQuery("SELECT * FROM ServerNetworkProtocolProperty WHERE PropertyName = 'TcpPort'&qu...

How to specify an instance name in a SQL statement - Hello, I am trying to get info from a linked server, but the instance is not the default instance. I have tried: select *from myserver\myinstance.mydb.dbo.mytable but get a syntax error due to the backslash. How should I specify the instance I wish t...

False Instance - I have installed SQL Server 2005 standard edition onto a server. I must have typed something in wrong during the installation, because when I loaded SP2 Authentication dialog, it lists two instances. The correct instance shows up as "AppDB" -...
   Database Forums (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]