|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
11/09/2006, 22h42
|
#1 |
Messages: n/a
Hébergeur: |
Failed to import servers registered by SQL Server 2000
Hi
When I'm trying to register my SQL 2000 servers into my SQL 2005 Client, then I'l getting this error. "Failed to import servers registered by SQL Server 2000" Anyone knows about it??? Thanks in advance! Sam G |
|
|
11/09/2006, 23h52
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Failed to import servers registered by SQL Server 2000
What service pack are your SQL 2000 databases?
Have you checked all the standard things like: - am I using a trusted or standard connection? - does my SQL 2000 allow standard connections or is it NT auth only? - is my current windows account a trusted login on my SQL 2000 box? - can I ping the SQL 2000 box from here? - does DNS resolve the name to the right IP address? - is the SQL Server service currently running on my SQL 2000 box? - can I connect to my SQL 2000 box from any other machine? - can I connect to my SQL 2000 box with any other app (eg. odbcad32.exe or SQLEM or QA)? - what network protocols is my SQL 2000 box listening on? - what protocol am I trying to use when attempting a connection to it? -- /* Warren Brunk - MCITP - SQL 2005, MCDBA www.techintsolutions.com */ "Sam G" <anonyomous@discussions.microsoft.com> wrote in message news:Ou6efse1GHA.4388@TK2MSFTNGP03.phx.gbl... > Hi > > > When I'm trying to register my SQL 2000 servers into my SQL 2005 Client, > then I'l getting this error. > > "Failed to import servers registered by SQL Server 2000" > > > Anyone knows about it??? > > > Thanks in advance! > > Sam G > > |
|
|
|
12/09/2006, 16h43
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Failed to import servers registered by SQL Server 2000
Hi Warren
Thanks for the response. Actually, the connection side things are fine with all servers and see eachother. We use SP3 for SQL 2000 with build 818. And, we use both authintications. One of our work station we did import all SQL 2000 servers in SQL 2005 client by using this option. No idea, why this time I'm getting error. Regards Sam G "Warren Brunk" <wbrunk@techintsolutions.com> wrote in message news:eHcZoTf1GHA.3516@TK2MSFTNGP06.phx.gbl... > What service pack are your SQL 2000 databases? > > Have you checked all the standard things like: > - am I using a trusted or standard connection? > - does my SQL 2000 allow standard connections or is it NT auth only? > - is my current windows account a trusted login on my SQL 2000 box? > - can I ping the SQL 2000 box from here? > - does DNS resolve the name to the right IP address? > - is the SQL Server service currently running on my SQL 2000 box? > - can I connect to my SQL 2000 box from any other machine? > - can I connect to my SQL 2000 box with any other app (eg. odbcad32.exe or > SQLEM or QA)? > - what network protocols is my SQL 2000 box listening on? > - what protocol am I trying to use when attempting a connection to it? > > > -- > /* > Warren Brunk - MCITP - SQL 2005, MCDBA www.techintsolutions.com > */ > > > "Sam G" <anonyomous@discussions.microsoft.com> wrote in message > news:Ou6efse1GHA.4388@TK2MSFTNGP03.phx.gbl... >> Hi >> >> >> When I'm trying to register my SQL 2000 servers into my SQL 2005 Client, >> then I'l getting this error. >> >> "Failed to import servers registered by SQL Server 2000" >> >> >> Anyone knows about it??? >> >> >> Thanks in advance! >> >> Sam G >> >> > > |
|
|
|
12/09/2006, 18h02
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Failed to import servers registered by SQL Server 2000
It's not clear but from this post it sounds like you were
actually trying to use the Previously Registered Servers feature. Or the import servers....not sure which. You can get this error if it finds no registration file or registration information. Which steps were you actually using? The error you received isn't from a typical server registration but from using one of the other registration features. -Sue On Tue, 12 Sep 2006 09:43:12 -0600, "Sam G" <anonyomous@discussions.microsoft.com> wrote: >Hi Warren > > >Thanks for the response. >Actually, the connection side things are fine with all servers and see >eachother. > >We use SP3 for SQL 2000 with build 818. And, we use both authintications. >One of our work station we did import all SQL 2000 servers in SQL 2005 >client by using this option. No idea, why this time I'm getting error. > >Regards > >Sam G > > > > >"Warren Brunk" <wbrunk@techintsolutions.com> wrote in message >news:eHcZoTf1GHA.3516@TK2MSFTNGP06.phx.gbl... >> What service pack are your SQL 2000 databases? >> >> Have you checked all the standard things like: >> - am I using a trusted or standard connection? >> - does my SQL 2000 allow standard connections or is it NT auth only? >> - is my current windows account a trusted login on my SQL 2000 box? >> - can I ping the SQL 2000 box from here? >> - does DNS resolve the name to the right IP address? >> - is the SQL Server service currently running on my SQL 2000 box? >> - can I connect to my SQL 2000 box from any other machine? >> - can I connect to my SQL 2000 box with any other app (eg. odbcad32.exe or >> SQLEM or QA)? >> - what network protocols is my SQL 2000 box listening on? >> - what protocol am I trying to use when attempting a connection to it? >> >> >> -- >> /* >> Warren Brunk - MCITP - SQL 2005, MCDBA > www.techintsolutions.com >> */ >> >> >> "Sam G" <anonyomous@discussions.microsoft.com> wrote in message >> news:Ou6efse1GHA.4388@TK2MSFTNGP03.phx.gbl... >>> Hi >>> >>> >>> When I'm trying to register my SQL 2000 servers into my SQL 2005 Client, >>> then I'l getting this error. >>> >>> "Failed to import servers registered by SQL Server 2000" >>> >>> >>> Anyone knows about it??? >>> >>> >>> Thanks in advance! >>> >>> Sam G >>> >>> >> >> > |
|
|
|
15/09/2006, 21h00
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: Failed to import servers registered by SQL Server 2000
Thanks Sue!
Well I'm using "Previously Registered Servers" option in Registerd Servers window. There is no issue about connectivity from my machine. Even recently I used this option on another work station and it worked well. Sam G "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:7opdg21cc0d7nt9m1u03vk3brcros9g1fj@4ax.com... > It's not clear but from this post it sounds like you were > actually trying to use the Previously Registered Servers > feature. Or the import servers....not sure which. > You can get this error if it finds no registration file or > registration information. > Which steps were you actually using? The error you received > isn't from a typical server registration but from using one > of the other registration features. > > -Sue > > On Tue, 12 Sep 2006 09:43:12 -0600, "Sam G" > <anonyomous@discussions.microsoft.com> wrote: > >>Hi Warren >> >> >>Thanks for the response. >>Actually, the connection side things are fine with all servers and see >>eachother. >> >>We use SP3 for SQL 2000 with build 818. And, we use both authintications. >>One of our work station we did import all SQL 2000 servers in SQL 2005 >>client by using this option. No idea, why this time I'm getting error. >> >>Regards >> >>Sam G >> >> >> >> >>"Warren Brunk" <wbrunk@techintsolutions.com> wrote in message >>news:eHcZoTf1GHA.3516@TK2MSFTNGP06.phx.gbl... >>> What service pack are your SQL 2000 databases? >>> >>> Have you checked all the standard things like: >>> - am I using a trusted or standard connection? >>> - does my SQL 2000 allow standard connections or is it NT auth only? >>> - is my current windows account a trusted login on my SQL 2000 box? >>> - can I ping the SQL 2000 box from here? >>> - does DNS resolve the name to the right IP address? >>> - is the SQL Server service currently running on my SQL 2000 box? >>> - can I connect to my SQL 2000 box from any other machine? >>> - can I connect to my SQL 2000 box with any other app (eg. odbcad32.exe >>> or >>> SQLEM or QA)? >>> - what network protocols is my SQL 2000 box listening on? >>> - what protocol am I trying to use when attempting a connection to it? >>> >>> >>> -- >>> /* >>> Warren Brunk - MCITP - SQL 2005, MCDBA >> www.techintsolutions.com >>> */ >>> >>> >>> "Sam G" <anonyomous@discussions.microsoft.com> wrote in message >>> news:Ou6efse1GHA.4388@TK2MSFTNGP03.phx.gbl... >>>> Hi >>>> >>>> >>>> When I'm trying to register my SQL 2000 servers into my SQL 2005 >>>> Client, >>>> then I'l getting this error. >>>> >>>> "Failed to import servers registered by SQL Server 2000" >>>> >>>> >>>> Anyone knows about it??? >>>> >>>> >>>> Thanks in advance! >>>> >>>> Sam G >>>> >>>> >>> >>> >> > |
|
|
|
16/09/2006, 21h19
|
#6 |
|
Messages: n/a
Hébergeur: |
Re: Failed to import servers registered by SQL Server 2000
It found previously registered servers on the other
workstation and not on yours - that's all it means. -Sue On Fri, 15 Sep 2006 14:00:30 -0600, "Sam G" <anonyomous@discussions.microsoft.com> wrote: >Thanks Sue! > > >Well I'm using "Previously Registered Servers" option in Registerd Servers >window. >There is no issue about connectivity from my machine. Even recently I used >this option on another work station and it worked well. > > >Sam G > > > > > >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message >news:7opdg21cc0d7nt9m1u03vk3brcros9g1fj@4ax.com.. . >> It's not clear but from this post it sounds like you were >> actually trying to use the Previously Registered Servers >> feature. Or the import servers....not sure which. >> You can get this error if it finds no registration file or >> registration information. >> Which steps were you actually using? The error you received >> isn't from a typical server registration but from using one >> of the other registration features. >> >> -Sue >> >> On Tue, 12 Sep 2006 09:43:12 -0600, "Sam G" >> <anonyomous@discussions.microsoft.com> wrote: >> >>>Hi Warren >>> >>> >>>Thanks for the response. >>>Actually, the connection side things are fine with all servers and see >>>eachother. >>> >>>We use SP3 for SQL 2000 with build 818. And, we use both authintications. >>>One of our work station we did import all SQL 2000 servers in SQL 2005 >>>client by using this option. No idea, why this time I'm getting error. >>> >>>Regards >>> >>>Sam G >>> >>> >>> >>> >>>"Warren Brunk" <wbrunk@techintsolutions.com> wrote in message >>>news:eHcZoTf1GHA.3516@TK2MSFTNGP06.phx.gbl... >>>> What service pack are your SQL 2000 databases? >>>> >>>> Have you checked all the standard things like: >>>> - am I using a trusted or standard connection? >>>> - does my SQL 2000 allow standard connections or is it NT auth only? >>>> - is my current windows account a trusted login on my SQL 2000 box? >>>> - can I ping the SQL 2000 box from here? >>>> - does DNS resolve the name to the right IP address? >>>> - is the SQL Server service currently running on my SQL 2000 box? >>>> - can I connect to my SQL 2000 box from any other machine? >>>> - can I connect to my SQL 2000 box with any other app (eg. odbcad32.exe >>>> or >>>> SQLEM or QA)? >>>> - what network protocols is my SQL 2000 box listening on? >>>> - what protocol am I trying to use when attempting a connection to it? >>>> >>>> >>>> -- >>>> /* >>>> Warren Brunk - MCITP - SQL 2005, MCDBA >>> www.techintsolutions.com >>>> */ >>>> >>>> >>>> "Sam G" <anonyomous@discussions.microsoft.com> wrote in message >>>> news:Ou6efse1GHA.4388@TK2MSFTNGP03.phx.gbl... >>>>> Hi >>>>> >>>>> >>>>> When I'm trying to register my SQL 2000 servers into my SQL 2005 >>>>> Client, >>>>> then I'l getting this error. >>>>> >>>>> "Failed to import servers registered by SQL Server 2000" >>>>> >>>>> >>>>> Anyone knows about it??? >>>>> >>>>> >>>>> Thanks in advance! >>>>> >>>>> Sam G >>>>> >>>>> >>>> >>>> >>> >> > |
|
|
|
| Outils de la discussion | |
|
|
