February 8, 2010 at 8:30 am
Other think that i have noticed is that when i changed the value of the force protcol encryptation to yes, when i restart my SQL Server Agent service it rases errors.
Can you please explain? thank you
February 8, 2010 at 10:57 am
It's this, what i have to do?
http://msdn.microsoft.com/en-us/library/ms191192.aspx
If yes, i'm having dificulties in this step:
8) In the Certificates snap-in, expand Certificates, expand Personal, and then right-click Certificates, point to All Tasks, and then click Import.
When i expand personal no certificates are displayed...
Can you please help?
February 9, 2010 at 2:31 am
It's this, what i have to do?
http://msdn.microsoft.com/en-us/library/ms191192.aspx
If yes, i'm having dificulties in this step:
8) In the Certificates snap-in, expand Certificates, expand Personal, and then right-click Certificates, point to All Tasks, and then click Import.
When i expand personal no certificates are displayed...
Can you please help?
P.s - or i don't need to create a certificate to encrypt the connection between SQL Server and my vb app?
February 9, 2010 at 3:01 am
you cannot make the conclusion "there is no encryption active" from the fact that you can connect with ssms to a sql server with "force encryption yes". as your client will adapt in this case to the requirements from the server.
for the last step you need a certificate. you can make certificates with a certificate server, make a self assigned certificate etc. i dont have a quick link atm for you.
a general starting point (win 2003) about certificates:
http://technet.microsoft.com/en-us/library/dd582586(WS.10).aspx
go for Public Key Infrastructure
February 9, 2010 at 4:52 am
In step 8
(In the Certificates snap-in, expand Certificates, expand Personal, and then right-click Certificates, point to All Tasks, and then click Import.) of the link : http://msdn.microsoft.com/en-us/library/ms191192.aspx
This what i have:
4 entrys in the MMC under the folder --> personal--> certicates:
SRV2
SRV2
SRV2.COMPANY.LOCAL
SRV2.company.local
This means that i have already installed same certifites in my machine?
If i do the same on my client computer (windows XP professional) it will not show any certificates in the "Personal", then the "certificates" of the MMC console.
Certificates are already installed in server systems (w2k3 ; w2k8;...) and not installed in clients (XP)?
thank you
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply