资源描述:
《sql server 导入数据时遇到的问题(problems encountered when importing data from sql server )》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、sqlserver2000导入数据时遇到的问题(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