Registration Tool Problem w/ Remove SQL Server

Registration Tool Problem w/ Remove SQL Server

Post by Phillip A. Lombard » Fri, 17 Mar 2000 04:00:00



I am running Windows 2000 advanced server (with SQL Server 7.0) and Windows
2000 professional client.  FYI, the registration tool succeeds from the
server but on the client, is never able to see my SQL Server (does not show
up in the combo box and I get an error suggesting my 'sa' login is wrong if
I type in my server name).

Thanks,
Phillip

 
 
 

Registration Tool Problem w/ Remove SQL Server

Post by Frank Mante » Sat, 18 Mar 2000 04:00:00


Did you install :

a) the admin pack on that workstation  ? The registration tool needs the IIS
admin dlls installed (and by default, they are not installed on W2K
workstation)... I guess you did, otherwise the tool would not work in the
first place...

b) did you install the sql server client setup on the workstation ? We are
using currently the sql server objects to test the connection etc, and they
are installed with the sql server client setup...

Please let me know.

Regards

Frank Mantek
Microsoft


Quote:> I am running Windows 2000 advanced server (with SQL Server 7.0) and
Windows
> 2000 professional client.  FYI, the registration tool succeeds from the
> server but on the client, is never able to see my SQL Server (does not
show
> up in the combo box and I get an error suggesting my 'sa' login is wrong
if
> I type in my server name).

> Thanks,
> Phillip


 
 
 

Registration Tool Problem w/ Remove SQL Server

Post by Phillip A. Lombard » Sat, 18 Mar 2000 04:00:00


Frank,

Installing the SQL Server Client Setup did the trick.  Thanks for the help.

Is this only a requirement for the technology preview?  I'd like to have a
thin client approach and deploy client-side ASP -- only requiring IE 5.0.

Thanks,
Phillip


> Did you install :

> a) the admin pack on that workstation  ? The registration tool needs the
IIS
> admin dlls installed (and by default, they are not installed on W2K
> workstation)... I guess you did, otherwise the tool would not work in the
> first place...

> b) did you install the sql server client setup on the workstation ? We are
> using currently the sql server objects to test the connection etc, and
they
> are installed with the sql server client setup...

> Please let me know.

> Regards

> Frank Mantek
> Microsoft


> > I am running Windows 2000 advanced server (with SQL Server 7.0) and
> Windows
> > 2000 professional client.  FYI, the registration tool succeeds from the
> > server but on the client, is never able to see my SQL Server (does not
> show
> > up in the combo box and I get an error suggesting my 'sa' login is wrong
> if
> > I type in my server name).

> > Thanks,
> > Phillip

 
 
 

Registration Tool Problem w/ Remove SQL Server

Post by Frank Mante » Sat, 18 Mar 2000 04:00:00


This is only a requirement for the "user who wants to use the MMC snapin".

Now you could use the object model and specify everything there, not using
the UI at all. Then you don't need the SQL client setup.

Also, in the future, when we move away from "sql only", this requirement
will change. For now it's the "laziest" way to find all SQL servers on the
net :)

Regards

Frank Mantek
Microsoft


> Frank,

> Installing the SQL Server Client Setup did the trick.  Thanks for the
help.

> Is this only a requirement for the technology preview?  I'd like to have a
> thin client approach and deploy client-side ASP -- only requiring IE 5.0.

> Thanks,
> Phillip



> > Did you install :

> > a) the admin pack on that workstation  ? The registration tool needs the
> IIS
> > admin dlls installed (and by default, they are not installed on W2K
> > workstation)... I guess you did, otherwise the tool would not work in
the
> > first place...

> > b) did you install the sql server client setup on the workstation ? We
are
> > using currently the sql server objects to test the connection etc, and
> they
> > are installed with the sql server client setup...

> > Please let me know.

> > Regards

> > Frank Mantek
> > Microsoft


> > > I am running Windows 2000 advanced server (with SQL Server 7.0) and
> > Windows
> > > 2000 professional client.  FYI, the registration tool succeeds from
the
> > > server but on the client, is never able to see my SQL Server (does not
> > show
> > > up in the combo box and I get an error suggesting my 'sa' login is
wrong
> > if
> > > I type in my server name).

> > > Thanks,
> > > Phillip

 
 
 

1. Removing old SQL 6.5 Server Registration

  I have a SQL 7.0 sp1 server that had been migrated from 6.5 and has been
running fine.  The 6.5 portion has been removed (we can no longer switch
between versions) although the registration for the server in its 6.5
incarnation (a different name than the server has now) still exists under
the SQL 6.5 group.
    This would not be a problem except that we are now testing replication
and the distribution/publishing wizard keeps failing every time it tries to
authenticate to this missing server.  The simple thing (I think) would be
just to unregister the server but there is no way I can see to remove it.
The Delete SQL Server Registration is grayed out when you right mouse click
on it.

Any ideas?

Thanks!

-Dan Wunder

direct replys remove -nospam from email name.

2. Interesting web sites - web-related products

3. Removing SQL Server Registration from Enterprise Manager

4. DTS Shortcut on Desktop

5. SQL Server 6.5 Server registration problem

6. Valid login with NT

7. Remove Server Registration?

8. Newsgroup: Serious memory leakage while using ADO recordset

9. problems removing sql 6.5 tools

10. MMC Problem with XML Registration Tool

11. SQL 7 Server Registration Problem

12. Odd SQL Server 7 Registration Problem

13. SQL Server Registration Problem