Showing posts with label root. Show all posts
Showing posts with label root. Show all posts

Tuesday, March 27, 2012

Cluster Server installation other than default directory

Is anyone aware of any issues that can arise from installing MS SQL Server
2000 on the root of a drive - x:\\MSSQL\Data - instead of using the using
the default structure - x:\Program Files\Microsoft SQL Server\MSSQL\Data?
I have always installed to the root directory be it stand-alone or clustered
installs without any issues but I need to know whether there might be
issues especially regarding virtual sql servers installs.
Thanks
I have not seen any differences with clustering, you should be fine with any
path, as long as all possible owners have the same paths.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Gboyega Adepegba" <muyid@.hotmail.com> wrote in message
news:u5IVSaOZEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Is anyone aware of any issues that can arise from installing MS SQL Server
> 2000 on the root of a drive - x:\\MSSQL\Data - instead of using the using
> the default structure - x:\Program Files\Microsoft SQL Server\MSSQL\Data?
> I have always installed to the root directory be it stand-alone or
clustered
> installs without any issues but I need to know whether there might be
> issues especially regarding virtual sql servers installs.
> Thanks
>
|||No issues. I have installed clustered instances of SQL Server 2000 on non-default locations without any problems.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sqlsql

Thursday, February 16, 2012

Client must have root CA certificate?

The following get quoted from SQL book on-line.
"SSL encryption works only with instances of SQL Server 2000 running on a co
mputer that has been assigned a certificate from a public certification auth
ority. The computer on which the application is running must also have a roo
t CA certificate from the s
ame authority."
My question is that my client application run on different host from SQL ser
ver and don't have the SQL server root CA
certificated installed on client host. How my client can talk to the SQL ser
ver and packet is encryped?Install the CA's root certificate on the client.
Cheers
Ken
"Ming Cheng" <anonymous@.discussions.microsoft.com> wrote in message
news:C11E32E7-54C3-446F-9697-4361C7605812@.microsoft.com...
: The following get quoted from SQL book on-line.
: "SSL encryption works only with instances of SQL Server 2000 running on a
computer that has been assigned a certificate from a public certification
authority. The computer on which the application is running must also have a
root CA certificate from the same authority."
:
: My question is that my client application run on different host from SQL
server and don't have the SQL server root CA
: certificated installed on client host. How my client can talk to the SQL
server and packet is encryped?
:
: