473,659 Members | 3,117 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can't register local instance of SQL Server on local server PLUS

I have two servers running SQL Server on the same network and I am
receiving errors registering the various instances as follows:

SERVER1 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()

SERVER1 trying to register Server2's default instance (by netname, ip
address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
FROM ANYWHERE PROVIDED THAT YOU HAVE PERMISSION(S)

SERVER2 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: ssl security error -connectionopen( secdoclienthand shake)

SERVER2 trying to register Server1's default instance (by netname, ip
address and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()

Note: SERVER2's default instance was registered locally before, but I
wanted to change the alias name so I unregistered it and tried to
register it with the new alias. I only change the alias name not the
underlying information which was previously registered. That is when I
started to receive the errors. ALSO I DON'T KNOW IF THIS MATTERS, BUT
D01 WAS CLONED FROM D02 BECAUSE OF A DISK FAILURE. I DID HOWEVER RUN
THE NEWSID UTILITY.

Any Ideas?

Jul 23 '05 #1
2 2966
(wa*********@ya hoo.com) writes:
SERVER1 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()
Have you ensured that is running?
SERVER1 trying to register Server2's default instance (by netname, ip
address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
FROM ANYWHERE PROVIDED THAT YOU HAVE PERMISSION(S)

SERVER2 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: ssl security error -connectionopen( secdoclienthand shake)


Could http://support.microsoft.com/kb/322144/EN-US/ apply?

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
Erland,

Thanks for the pointer to the Microsoft article. In the future, I will
look on the Microsoft's web site more throughly.

Answer: Someone in my organization must of inadvertently enable
encryption for the client without my knowledge.

Thanks.

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
364
by: war_wheelan | last post by:
I have two servers running SQL Server on the same network and I am receiving errors registering the various instances as follows: SERVER1 tried to register the local instance (by netname, ip address and local) ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen | Connect() SERVER1 trying to register Server2's default instance (by netname, ip address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
0
4406
by: Peter | last post by:
When I issue call sqlj.install_jar('file:///f:/jars/mail.jar','MAIL'); I get the messages SQL4301N Java or .NET interpreter startup or communication failed, reason
44
16954
by: Frank Rizzo | last post by:
Any ideas?
1
7548
by: karim | last post by:
My computer (connected to a domain) is having trouble connecting to the local MSDE when using 'local' or '(local)' as server name. The only way I can connect to server through Visual Studio or DTS in Enterprise manager is when using domainname\localcomputername format. Also when I try to install the starter kits from asp.net, the installer in each kit fails to find sql server instances. I am pretty sure it's related to fact the installer is...
3
3342
by: Dan | last post by:
Hi, I have a problem using an aspx page with a Control on it. I get the following error message Compiler Error Message: CS1595: 'Test.Class2' is defined in multiple places; using definition from 'c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\root\1f575646\ad3a161b\assembly\dl2\57ca505e\044565c0_f84fc401\Test1.DLL' The problem is that the control is defined in two different assemblies
8
14369
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options
6
4868
by: scottyman | last post by:
I can't make this script work properly. I've gone as far as I can with it and the rest is out of my ability. I can do some html editing but I'm lost in the Java world. The script at the bottom of the html page controls the form fields that are required. It doesn't function like it's supposed to and I can leave all the fields blank and it still submits the form. Also I can't get it to transfer the file in the upload section. The file name...
0
1407
by: kmounkhaty | last post by:
Hi Guru, I'm tired of trouleshoot one of my sql box that the sqlagent can't started. Here is the message: SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start) · SQLSERVER runs on LocalSystem account with started up type automatic and successful · Connect to SQL Analyzer: LocalHost, . (period), (local) and blank all successful
21
2395
by: Steven T. Hatton | last post by:
I'm trying to improve my formal understanding of C++. One significant part of that effort involves clarifying my understanding of the vocabulary used to describe the language. This is from the C++ Standard: "" "...sequence of operators and operands that specifies a computation...". That means to me that an expression can be "executed". I am purposely
0
8335
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8747
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8528
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7356
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4175
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1976
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1737
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.