資源描述:
《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