Very Computer

Hi everyboby!

Problem!
When I install Certification Authority on my W2K adv. Serv +SP1 where SQL server
already been installed something strange happend.
After issuing some sertificate and restarting hardware I can't connect to local
SQL server by Enterprise manager. Remote Connect through LAN by Enterprise
manager filed too.

Whats UP? Can anybody help?

Extremly Thanks!

ALEX

This is not strange.
You will need to install a correct certificate on the SQL Server.
To do this;
The certificate selected for SQL Server must be assigned to the name of the
server, in the form of the fully-qualified DNS server name. For example,
SQLServer.Redmond.corp.Microsoft.com. The certificate must be valid for server
authentication. Log in to SQL Server as the SQL Server service account, obtain
the certificate (from either an internal certificate authority or a trusted third-
party provider such as Verisign), and then install it on the server in the
location suggested when you import the certificate

With regards,

Tino Donderwinkel
MVP

Quote:-----Original Message-----

Hi everyboby!

Problem!
When I install Certification Authority on my W2K adv. Serv +SP1 where SQL server
already been installed something strange happend.
After issuing some sertificate and restarting hardware I can't connect to local
SQL server by Enterprise manager. Remote Connect through LAN by Enterprise
manager filed too.

Whats UP? Can anybody help?

Extremly Thanks!

ALEX
.

Hi Tino!
Thank you for reply.

But I not assigned any sertificate to SQL, and i do not want do that. It's not need! I issue sertificate to my IIS 5.0 and IE (no SQL). I can not understand why it happend!
I not need and not want install sertificate for SQL, or it necessary for computer where installed SQL server adn Certification Authority together???

Best regards!

ALEX

*** Sent via Developersdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!