Hello NG.
Perhaps someone can be so friendly and help me with the following
problem :
I'm running SQL Express 2005 on a public Win2003Server and want to use
SSL encryption for the data transfer between the clients and the
server.
Therefore I run selfssl on the server to create a certificate and than
I configure the network connections in the SQL management studio tu
use the ssl encryption.
But I couldn't restart the SQL service because the cn-name of the
certificate is wrong !?
The server has no DNS entry and is reached just by his ip adress and
is no domain member.
So what is the correct cn-name in this case ?
The ip ???
The computer name ???
Please be so friendly and show me the right way to solve this problem.
Re: ssl renewal questions ... Just on the server which I guess explains the clients being able to ... the certificate is invalid ... >> but connections continue to be encrypted and restarts of sql... >>> appears that I had to stop and restart the sql process to get certs ... (microsoft.public.sqlserver.security)
RE: Fulltext failure on a 2 node cluster ...Server full-text search resource online: "SQL Cluster Resource 'Full Text' ... (microsoft.public.sqlserver.clustering)
Re: ssl renewal questions ... > a year on a test server and check the certificate using the ... > certificates mmc snap-in, the certificate shows up as expired ... > but connections continue to be encrypted and restarts of sql... If a cert expires, do subsequent ... (microsoft.public.sqlserver.security)
Re: HELP PLEASE ~ ??? ... You mentioned that it went ahead and added a SQL...SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ... (microsoft.public.dotnet.framework.aspnet)
Re: Multi-Channel Raid VS SAN Storage ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ... (microsoft.public.sqlserver.setup)
