資源描述：
《sql server 導(dǎo)入數(shù)據(jù)時(shí)遇到的問題（problems encountered when importing data from sql server ）》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、sqlserver2000導(dǎo)入數(shù)據(jù)時(shí)遇到的問題（ProblemsencounteredwhenimportingdatafromSQLServer2000）Question1:unabletoconnecttoeachother'sdatabaseSolutionsteps:Onthismachine,opentheCMDwindowandusethepingcommandPingtheotherIP,andtheresultisnormal;Pingnameoftheothermachine,theresultisnormal;Enterthecommand"Tel
2、net,IP1433".Theerroristhatitcannotconnecttothehost.Checktheservernetworkutilitysettings,namedpipesandTCP/IPareenabled,andtheTCP/IPportis1433;Checkeachother'sSQLrelatedservicesandfindthatithasstartedTurnonthetelnetserviceonyourcomputer,turnofftheWindows,andbringyourownfirewall.Tryagainte
3、lnettoconnectthe1433portofthecomputeroftheotherparty,stillreportwrong.OpentheCMDwindowontheothercomputerandviewtheactiveportwiththe"netstat-an"command.No1433portsarefound;VerifythattheSQLServer2000SP4patchisnotinstalledandthatthe1433porthasbeensuccessfullyopenedafterinstallingthepatchan
4、drestartingtheSQLservice.Onthismachine,onceagain,telnetconnectstotheothercomputeranddisplaysblinkingcursorintheupperleftcornerofthescreentoindicatetheconnectionissuccessful.NewSQLServerregistrationhasbeensuccessfullycompletedonthismachine.Atthispoint,theproblemresolved,toremindyoutoinst
5、allSQLServer,mustnotforgettoputrelevantpatches.Question2:unabletocompleteimportAfterthedatabaseconnectionissuccessful,importdataoperationsareperformed.Novicenotethatinthe"DTS"import/ExportWizardtospecifytablecopyorquerywindow,ifyouwanttoputthesourcedatabase,primarykeyindexStoredprocedur
6、elikeobjecttocopyoverhere,notbydefault,toselectthirditems:copyobjectsanddatabetweenSQLServerdatabase,otherwisecanonlyimporttablestructureanddata.Thefirsttimeafterthecompletionoftheoperationshowsthattheimportfailedatthattimeasasourceserver,applicationserver,inspectionfoundthatmanyownerso
7、fthetablesandstoredproceduresisnotdbosourcedatabaseontheserverwewanttoimport,butbeforetheotherdeveloperstobuildtheusernamed"ABC".Thecolleague'sSQLserverdoesnothaveacorrespondingloginanduser,soitwillbereportedattheendoftheimportoperation.SoweinthewindowoftheDTSimport/ExportWizar
