Moderatores Please Help

We have an old server 6.5
Try to login to sql 6.5 Enterprise manager
and try to connect get the following Error: SQL Server Error
[DB Libraray] Unable to connect: SQL server is unavailable or does not exist;
Severity level 9 MsgNo 10004 OS Error 53
ConnectionOpen(CreateFile())
The Users are able to use the Db thru the VB application...
How do I resolve this. How do I get to Open Enterprise manager and manage my
tasks and backups
Please help
Hi
Are you trying to do this from the Server? If not, try it from there.
Check how the VB application is connecting. Is it using the name or an IP.
Try "TELNET servername 1433)" and see if it gives you a blank screen without
timing out.
Regards
Mike
"G Q" wrote:

> We have an old server 6.5
> Try to login to sql 6.5 Enterprise manager
> and try to connect get the following Error: SQL Server Error
> [DB Libraray] Unable to connect: SQL server is unavailable or does not exist;
> Severity level 9 MsgNo 10004 OS Error 53
> ConnectionOpen(CreateFile())
> The Users are able to use the Db thru the VB application...
> How do I resolve this. How do I get to Open Enterprise manager and manage my
> tasks and backups
> Please help
>
|||Thank You for Your Response.
It did give a balnk screen no time out. I tried the Enterprise manager from
both the server and my machine, I could not connect.
I need to finish my tasks and projects.
Thank You in adavance
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Are you trying to do this from the Server? If not, try it from there.
> Check how the VB application is connecting. Is it using the name or an IP.
> Try "TELNET servername 1433)" and see if it gives you a blank screen without
> timing out.
> Regards
> Mike
>
> "G Q" wrote:
|||Ifinally got Connection to host lost?
Is this normal?
What should I be looking for
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Are you trying to do this from the Server? If not, try it from there.
> Check how the VB application is connecting. Is it using the name or an IP.
> Try "TELNET servername 1433)" and see if it gives you a blank screen without
> timing out.
> Regards
> Mike
>
> "G Q" wrote:

Moderatores Please Help

We have an old server 6.5
Try to login to sql 6.5 Enterprise manager
and try to connect get the following Error: SQL Server Error
[DB Libraray] Unable to connect: SQL server is unavailable or does not e
xist;
Severity level 9 MsgNo 10004 OS Error 53
ConnectionOpen(CreateFile())
The Users are able to use the Db thru the VB application...
How do I resolve this. How do I get to Open Enterprise manager and manage my
tasks and backups
Please helpHi
Are you trying to do this from the Server? If not, try it from there.
Check how the VB application is connecting. Is it using the name or an IP.
Try "TELNET servername 1433)" and see if it gives you a blank screen without
timing out.
Regards
Mike
"G Q" wrote:

> We have an old server 6.5
> Try to login to sql 6.5 Enterprise manager
> and try to connect get the following Error: SQL Server Error
> [DB Libraray] Unable to connect: SQL server is unavailable or does not
exist;
> Severity level 9 MsgNo 10004 OS Error 53
> ConnectionOpen(CreateFile())
> The Users are able to use the Db thru the VB application...
> How do I resolve this. How do I get to Open Enterprise manager and manage
my
> tasks and backups
> Please help
>|||Thank You for Your Response.
It did give a balnk screen no time out. I tried the Enterprise manager from
both the server and my machine, I could not connect.
I need to finish my tasks and projects.
Thank You in adavance
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Are you trying to do this from the Server? If not, try it from there.
> Check how the VB application is connecting. Is it using the name or an IP.
> Try "TELNET servername 1433)" and see if it gives you a blank screen witho
ut
> timing out.
> Regards
> Mike
>
> "G Q" wrote:
>|||Ifinally got Connection to host lost?
Is this normal?
What should I be looking for
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Are you trying to do this from the Server? If not, try it from there.
> Check how the VB application is connecting. Is it using the name or an IP.
> Try "TELNET servername 1433)" and see if it gives you a blank screen witho
ut
> timing out.
> Regards
> Mike
>
> "G Q" wrote:
>sql

Moderatores Please Help

We have an old server 6.5
Try to login to sql 6.5 Enterprise manager
and try to connect get the following Error: SQL Server Error
[DB Libraray] Unable to connect: SQL server is unavailable or does not exist;
Severity level 9 MsgNo 10004 OS Error 53
ConnectionOpen(CreateFile())
The Users are able to use the Db thru the VB application...
How do I resolve this. How do I get to Open Enterprise manager and manage my
tasks and backups
Please helpHi
Are you trying to do this from the Server? If not, try it from there.
Check how the VB application is connecting. Is it using the name or an IP.
Try "TELNET servername 1433)" and see if it gives you a blank screen without
timing out.
Regards
Mike
"G Q" wrote:
> We have an old server 6.5
> Try to login to sql 6.5 Enterprise manager
> and try to connect get the following Error: SQL Server Error
> [DB Libraray] Unable to connect: SQL server is unavailable or does not exist;
> Severity level 9 MsgNo 10004 OS Error 53
> ConnectionOpen(CreateFile())
> The Users are able to use the Db thru the VB application...
> How do I resolve this. How do I get to Open Enterprise manager and manage my
> tasks and backups
> Please help
>|||Ifinally got Connection to host lost?
Is this normal?
What should I be looking for
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Are you trying to do this from the Server? If not, try it from there.
> Check how the VB application is connecting. Is it using the name or an IP.
> Try "TELNET servername 1433)" and see if it gives you a blank screen without
> timing out.
> Regards
> Mike
>
> "G Q" wrote:
> > We have an old server 6.5
> > Try to login to sql 6.5 Enterprise manager
> > and try to connect get the following Error: SQL Server Error
> > [DB Libraray] Unable to connect: SQL server is unavailable or does not exist;
> > Severity level 9 MsgNo 10004 OS Error 53
> >
> > ConnectionOpen(CreateFile())
> >
> > The Users are able to use the Db thru the VB application...
> >
> > How do I resolve this. How do I get to Open Enterprise manager and manage my
> > tasks and backups
> >
> > Please help
> >|||Thank You for Your Response.
It did give a balnk screen no time out. I tried the Enterprise manager from
both the server and my machine, I could not connect.
I need to finish my tasks and projects.
Thank You in adavance
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Are you trying to do this from the Server? If not, try it from there.
> Check how the VB application is connecting. Is it using the name or an IP.
> Try "TELNET servername 1433)" and see if it gives you a blank screen without
> timing out.
> Regards
> Mike
>
> "G Q" wrote:
> > We have an old server 6.5
> > Try to login to sql 6.5 Enterprise manager
> > and try to connect get the following Error: SQL Server Error
> > [DB Libraray] Unable to connect: SQL server is unavailable or does not exist;
> > Severity level 9 MsgNo 10004 OS Error 53
> >
> > ConnectionOpen(CreateFile())
> >
> > The Users are able to use the Db thru the VB application...
> >
> > How do I resolve this. How do I get to Open Enterprise manager and manage my
> > tasks and backups
> >
> > Please help
> >

Missing tools in SSMS 2005

I am using SSMS since a few weeks, and I found it is missing a few
tools/utilities from the old Query Analyzer. One of the things which hit
me is the lack of the Debug (I know I can do it in VS 2005, but I can't
understand why I can't debug in SMSS), another is the lack of support
for Sql Server 2000 diagrams, and then there are annoying things as
forcing us to use a different shortcut to bookmark and so on.
The worst of all, anyway, is that we still can't apply a customized
format to the sql documents. In the development team I am working in
we're using a formatting code convention quite different from that
recommended by the Books Online, so every time I use the Query Designer,
I have then manually to 'beautify' the resulting T-SQL code. Even in VS
2005 there seems not to be a way to format all of a SQL document, as it
is possible to do with c# i.e..
Get me right, so far my experience with SMSS has been positive, only
these and other little defaillances are marking the difference between
an useful tool and a tool to recommend.
ale
http://www.riolo.org
Hi
Check out the SQL Server Magazine article on debugging:
http://www.windowsitpro.com/Article/...754/47754.html
For diagrams look in Books online on how to set them up and add one
http://msdn2.microsoft.com/en-us/library/ms189279.aspx
John
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Go to the Product Feedback Center and put in a request to add the features
that are missing
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Michael Hotek wrote:
> Go to the Product Feedback Center and put in a request to add the features
> that are missing
I already did it for one of the most annoying of the lack, a
customizable sql document formatter either in SSMS either in VS2005:
http://lab.msdn.microsoft.com/produc...e-43fe9c69ad8f
ale
http://www.riolo.org
|||Alessandro Riolo (alessandro.riolo@.sen.it) writes:
> The worst of all, anyway, is that we still can't apply a customized
> format to the sql documents. In the development team I am working in
> we're using a formatting code convention quite different from that
> recommended by the Books Online, so every time I use the Query Designer,
I can't say that the most serious problem with the Query Designer is
that you cannot customize how it formats the code. A much more serious
problem is that it may rewrite queries to have a different meaning.
That tool is dangerous!
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||John Bell wrote:
> For diagrams look in Books online on how to set them up and add one
> http://msdn2.microsoft.com/en-us/library/ms189279.aspx
Quoting the BOL:
"SQL Server 2005 database diagrams and SQL Server 2000 database diagrams
are created and rendered differently. Because of these differences, SQL
Server Management Studio cannot work with SQL Server 2000 diagrams. Use
SQL Server 2000 Enterprise Manager"
ale
http://www.riolo.org

missing Report Builder menu item after migration from RS2000 to 2005

I've done a clean install of RS2005 and then migrated old RS2000
database to RS2005.
After the migration the Report Builder menu item is missing.
I have system administrator level permission.
I need your advice.
TIA,
Kamelok, have solved it
there was one task unchecked in system administrator role definition -
"Execute Report Definitions"
Kamel
On 26 Sty, 16:40, "kamel" <kwic...@.gmail.com> wrote:
> I've done a clean install of RS2005and then migrated oldRS2000
> databasetoRS2005.AfterthemigrationtheReportBuildermenuitemismissing.
> I have system administrator level permission.
> I need your advice.
> TIA,
> Kamel

Missing Program group

Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt
"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" wrote:

> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:

> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas

"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
[vbcol=seagreen]
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
server).[vbcol=seagreen]
> there
happened?
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:

> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> server).
> happened?
>
>
|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas

"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:

> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows[vbcol=seagreen]
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> server).
QL
> happened?
>
>
|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT4.
Regards
Matt
"Anthony Thomas" wrote:

> Yes, but you're pushing technologies way beyond their design by doing that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> Windows
> QL
>
>
|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas

"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:

> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well[vbcol=seagreen]
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
would[vbcol=seagreen]
> Windows
S[vbcol=seagreen]
> QL
except
>
>

Missing Program group

Guys and Girls

I have a server that was running SQL Server 2000 (on Windows 2000
server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to
SQL Server and deleted all files. I have rebooted the server.

I have run an install of 6.5. It seems to have worked all right except
there is no program groups on my start menu. Any ideas what might have
happened?

Regards

Matt<john.bandettini@.rbs.co.uk> wrote in message
news:1117786641.708591.159230@.g49g2000cwa.googlegr oups.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to
> SQL Server and deleted all files. I have rebooted the server.
> I have run an install of 6.5. It seems to have worked all right except
> there is no program groups on my start menu. Any ideas what might have
> happened?
> Regards
> Matt

No idea, but presumably you can easily create your own group and add
shortcuts to the various executables? You could even copy the group from
another machine, if you have one available.

Simon

Missing Program group

Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000
server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have
happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to SQL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to S
QL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You
would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to
S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right
except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>

Missing Program group

Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" wrote:

> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:

> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:

> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
server).[vbcol=seagreen]
> there
happened?[vbcol=seagreen]
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a
.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:

> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Window
s
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
>
> server).
> happened?
>
>|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:

> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
>
> server).
QL[vbcol=seagreen]
> happened?
>
>|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT
4.
Regards
Matt
"Anthony Thomas" wrote:

> Yes, but you're pushing technologies way beyond their design by doing that
.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim th
at
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as wel
l
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
>
> Windows
> QL
>
>|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:

> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
>
would[vbcol=seagreen]
> Windows
S[vbcol=seagreen]
> QL
except[vbcol=seagreen]
>
>