SQL Server 2005 saµÇ½ʧ°ÜµÄ½â¾ö°ì·¨
½ñÌìÔڵǼsql2005µÄʱºò£¬ÏëÓÃsaµÄÑéÖ¤·½Ê½µÇ¼£¬·¢ÏֵǼ²»ÁË£¬ÔÚÍøÉϲéÁËÏ£¬°´ÕÕÏÂÃæµÄ¾Í¿ÉÒÔ½â¾ö¡£Ö®Ç°ÔÚ×°sql2005µÄʱºò£¬ÊÇÉèÖóÉwindowsÑéÖ¤·½Ê½µÇ¼µÄ¡£
¾ßÌå½â¾ö·½°¸ÈçÏ£º
1. ¿ªÆôsql2005Ô¶³ÌÁ¬½Ó¹¦ÄÜ,¿ªÆô°ì·¨ÈçÏÂ,
ÅäÖù¤¾ß->sql serverÍâΧӦÓÃÅäÖÃÆ÷->·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷->´ò¿ªMSSQLSERVER½ÚµãϵÄ
Database Engine ½Úµã,ÏÈÔñ"Ô¶³ÌÁ¬½Ó",½ÓϽ¨ÒéÑ¡Ôñ"ͬʱʹÓÃTCP/IPºÍnamed pipes",È·¶¨ºó,ÖØÆôÊý¾Ý
¿â·þÎñ¾Í¿ÉÒÔÁË.
2.µÇ½ÉèÖøÄΪ,Sql server and windows Authentication·½Ê½Í¬Ê±Ñ¡ÖÐ,¾ßÌåÉèÖÃÈçÏÂ:
manage¹ÜÀíÆ÷->windows Authentication(µÚÒ»´ÎÓÃwindows·½Ê½½øÈ¥),->¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖÐÑ¡ÔñÄãµÄÊý
¾Ý·þÎñÆ÷--ÓÒ¼ü>ÊôÐÔ>security>Sqlserver and windows Authentication·½Ê½Í¬Ê±Ñ¡ÖÐ.
3:ÉèÖÃÒ»¸öSql server·½Ê½µÄÓû§ÃûºÍÃÜÂë,¾ßÌåÉèÖÃÈçÏÂ:
manage¹ÜÀíÆ÷->windows Authentication>new query>sp_password null,'sa123456','sa' ÕâÑù
¾ÍÉèÖÃÁËÒ»¸öÓû§ÃûΪsa ,ÃÜÂëΪ:sa123456µÄÓû§,Ï´ÎÔڵǽʱ,¿ÉÒÔÓÃSql server·½Ê½, Óû§ÃûΪ
sa ,ÃÜÂëΪ:sa123456µÄÓû§½øÊý¾Ý¿âÁË.
4: ×öÍêÉÏÃæÈý²½ºó,ÕâÑùдÁ¬½Ó×Ö·û´®¾Í¿ÉÒÔ˳Àû½øÈëÊý¾Ý¿âÁË,
(server=.\\sqlexpress;uid=sa;pwd=sa123456;database=master";
ÉÏÃæÊÇÍøÉϵÄ˵·¨:×öÁË,²»¿ÉÒÔ
ÐÂ×öÒ»±é,µÚÈý²½ÊÇÓòéѯ·ÖÎöÆ÷ÔËÐÐµÄ sp_password null,'sa123456','sa' È»ºóÖØÐÂÆô¶¯SQL
Server (SQLEXPRESS)·þÎñ Á¬½Ó Õý³£
-
Ïà¹ØÎĵµ£º
Êý¾Ý²Ù×÷Àà SQLHelper.cs
http://www.cnblogs.com/zengxiangzhan/archive/2009/12/31/1636871.html
ÎÞÏÞ¼¶·ÖÀà ´æ´¢¹ý³Ì
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/04/1639220.html
°ÙÍò¼¶·ÖÒ³´æ´¢
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/12/1565313.html
SQL¾µä¶ÌС´úÂëÊÕ¼¯
htt ......
ÎÒÔÚѧϰ¹ØÓÚjava±à³Ì£¬ÏÖÔÚÉæ¼°µ½µÄÊÇsqlµÄÎÊÌ⣬±ÈÈçÈí¼þÑ¡Ôñ¡¢»·¾³µÄÁ¬½ÓÉèÖõÈÎÊÌ⣬¶ÔÓÚÕâЩÎÊÌâÎÒÕæÊÇÊøÊÖÎ޲߰¡£¡ÇëÇóJava±à³Ì¸ßÊִͽ̣º
1¡¢ÎÒÓõÄJavaÊÇj2sdk-1_4_2_13-nb-5_0£¬ÎÒÓÃÁËsql server2000£¬ÎÒÓÃjdbc3.0ÐÐÂð£¿ËùÓÐÁ¬½ÓÉèÖøÃÔõôÑùÉèÖã¿
&nb ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦À ......
»úÆ÷Çé¿ö
p4: 2.4
ÄÚ´æ: 1 G
os: windows 2003
Êý¾Ý¿â: ms sql server 2000
Ä¿µÄ: ²éѯÐÔÄܲâÊÔ,±È½ÏÁ½ÖÖ²éѯµÄÐÔÄÜ
SQL²éѯЧÂÊ step by step
-- setp 1.
-- ½¨±í
create table t_userinfo
(
userid int identity(1,1) primary key nonclustered,
nick varchar(50) not null default '',
classid int not nul ......
SELECT DISTINCT '['+user_name(b.uid)+'].['+b.name+']' AS ¶ÔÏóÃû,b.type AS ÀàÐÍ
from sysdepends a,sysobjects b
WHERE b.id=a.depid
AND a.id=OBJECT_ID('¹ý³ÌÃû');
EXEC SP_DEPENDS '¹ý³ÌÃû'; ......