SQL ServerÊý¾Ý¿â¾µÏñÅäÖò½Öè
Ò»¡¢Ê¹ÓÃÖ¤ÊéʵÏÖÖ÷±¸SQL ServerʵÀýµÄ»¥Í¨
1.ÔÚÖ÷»úºÍ±¸»úÉϷֱ𴴽¨Ö¤Êé
ÔÚÖ÷»úÉÏÖ´ÐÐÈçÏÂÓï¾ä:
USE master;
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'abcdefg';
CREATE CERTIFICATE CERT_HOST_A WITH SUBJECT = 'HOST_A certificate' ,
START_DATE = '01/01/2010';
GO
ÔÚ±¸»úÉÏÖ´ÐÐÈçÏÂÓï¾ä:
USE master;
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'abcdefg';
CREATE CERTIFICATE CERT_HOST_B WITH SUBJECT = 'HOST_B certificate' ,
START_DATE = '01/01/2010';
GO
2.´´½¨Á¬½ÓµÄ¶Ëµã
·Ö±ðÔÚÖ÷±¸»úÉÏÖ´ÐÐÈçÏÂÓï¾ä:
CREATE ENDPOINT Endpoint_Mirroring
STATE = STARTED
AS
TCP ( LISTENER_PORT=5022 , LISTENER_IP = ALL )
FOR
DATABASE_MIRRORING
( AUTHENTICATION = CERTIFICATE A1 , ENCRYPTION = REQUIRED ALGORITHM AES , ROLE = ALL );
GO
3.±¸·ÝÖ¤Êé
ÔÚÖ÷»úÉÏÖ´ÐÐÈçÏÂÓï¾ä,±¸·ÝÖ÷»úÉÏÒÑ´´½¨ºÃµÄÖ¤Êé
BACKUP CERTIFICATE CERT_HOST_A TO FILE = 'D:\CERT_HOST_A .cer';
ÔÚ±¸»úÉÏÖ´ÐÐÈçÏÂÓï¾ä,±¸·Ý±¸»úÉÏÒÑ´´½¨ºÃµÄÖ¤Êé
BACKUP CERTIFICATE CERT_HOST_B TO FILE = 'D:\CERT_HOST_B.cer';
4.»¥»»Ö¤Êé
½«HOST_A_cert.cer¸´ÖƵ½±¸»úµÄDÅÌ,HOST_B_cert.cer¸´ÖƵ½Ö÷»úµÄDÅÌ.
5.Ìí¼ÓµÇ½ÃûºÍÓû§
ÔÚÖ÷»úÉÏÖ´ÐÐÈçÏÂÓï¾ä,ÒÔÌí¼ÓµÇ½ÃûºÍÓû§
CREATE LOGIN HOST_B_Login WITH PASSWORD = 'abcdefg';
CREATE USER HOST_B_User FOR LOGIN HOST_B_Login;
CREATE CERTIFICATE HOST_B_CERT AUTHORIZATION HOST_B_User from FILE = 'D:\CERT_HOST_B.cer';
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [HOST_B_Login];
ÔÚ±¸»úÉÏÖ´ÐÐÈçÏÂÓï¾ä,ÒÔÌí¼ÓµÇ½ÃûºÍÓû§
CREATE LOGIN HOST_A_Login WITH PASSWORD = 'abcdefg';
CREATE USER HOST_A_User FOR LOGIN HOST_A_Login;
CREATE CERTIFICATE HOST_A_CERT AUTHORIZATION HOST_A_User from FILE = 'D:\CERT_HOST_A.cer';
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [HOST_A_Login];
¶þ¡¢½¨Á¢¾µÏñ
1.ͬ²½µÇ½ÃûºÍÃÜÂë,±ÜÃâ³öÏÖ¹ÂÁ¢Óû§
ÔÚÖ÷»úÉÏÖ´ÐÐÈçÏÂÓï¾ä,ÒÔ»ñµÃµÇ½ÃûºÍsid
USE master;
select sid,name from syslogins;
ÔÚ±¸»úÉÏÖ´ÐÐÈçÏÂÓï¾ä,ÒÔÌí¼ÓÖ÷»úÉϵĵǽÃû
USE master;
exec sp_addlogin
@loginame = '<LoginName>',
Ïà¹ØÎĵµ£º
×÷Õß:Íø·ÓÎÏÀ@youxia.org
·¢²¼Ê±¼ä:2005-9-25 11:48:18 ÎÄÕÂÀ´Ô´:youxia.org
̨ʽ»úºÍ±¾±¾·Ö±ð°²×°ÁËMS SQL Server£¬·½±ã×ö²âÊÔÓÃ
½á¹ûʱ¼ä³¤ÁË£¬
̨ʽ»úSQL ServerµÄÃÜÂëÍü¼ÇÁË……
ÄѵÀ……ûÓа취ÁËÂ𣿗—No£¡
¾¹ýÒ»Õó×ÓÓôÃÆ£¬ÓÎÏÀÔÚ°Ù¶ÈËѵ½ÁË·½·¨£º
ÏÖÔÚÄãµÄ
ÆóÒ ......
Ò»¡¢sqlÓï¾äµÄÖ´Ðв½Ö裺
1£©Óï·¨·ÖÎö£¬·ÖÎöÓï¾äµÄÓï·¨ÊÇ·ñ·ûºÏ¹æ·¶£¬ºâÁ¿Óï¾äÖи÷±í´ïʽµÄÒâÒå¡£
2£© ÓïÒå·ÖÎö£¬¼ì²éÓï¾äÖÐÉæ¼°µÄËùÓÐÊý¾Ý¿â¶ÔÏóÊÇ·ñ´æÔÚ£¬ÇÒÓû§ÓÐÏàÓ¦µÄȨÏÞ¡£
3£©ÊÓͼת»»£¬½«Éæ¼°ÊÓͼµÄ²éѯÓï¾äת»»ÎªÏàÓ¦µÄ¶Ô»ù±í²éѯÓï¾ä¡£
4£©±í´ïʽת»»£¬ ½«¸´Ô SQL ±í´ïʽת»»Îª½Ï¼òµ¥µÄµÈЧÁ¬½Ó±í´ïʽ ......
SQLÓï¾äÓÅ»¯¼¼Êõ·ÖÎö
²Ù×÷·ûÓÅ»¯
IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵ģ¬´ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
¡¡¡¡¡¡ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ ......
1. SQL Server 2000Êý¾Ý¿âÁ¬½Ó×Ö·û´®
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://Êý¾Ý¿â·þÎñÆ÷Ãû»òµØÖ·:1433; DatabaseName=Êý¾Ý¿âÃû", "Óû§Ãû", "ÃÜÂë");
Ëù ......