Missing dll file: program

Showing posts with label program. Show all posts

Friday, March 23, 2012

MMC recovery

We recently lost our hard disk on disk c: It contained
Windows 2000 system files, but no SQL Server 7.0 files.
Our program files, data, and backups were on drive d:.
After rebuilding the W2K server, we ran regrebld.exe to
reestabish the W2K registry entries. We were able to
restart SQL Server and the Agent, but MMC (Microsoft
Management Console) will not start due to problems with
missing CLSIDs. We are able to access the database and
Agent info from remote MMCs, but not on the local server.
I don't see any option to reinstall/register MMC. Any
ideas of what to do?I found instmmc.exe on the installation disk. I'll try it
in the morning.
>--Original Message--
>We recently lost our hard disk on disk c: It contained
>Windows 2000 system files, but no SQL Server 7.0 files.
>Our program files, data, and backups were on drive d:.
>After rebuilding the W2K server, we ran regrebld.exe to
>reestabish the W2K registry entries. We were able to
>restart SQL Server and the Agent, but MMC (Microsoft
>Management Console) will not start due to problems with
>missing CLSIDs. We are able to access the database and
>Agent info from remote MMCs, but not on the local
server.
>I don't see any option to reinstall/register MMC. Any
>ideas of what to do?
>.
>

MMC Can't open SQL Server Enterprise Manager.msc

Hi All,
I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting the
error:
MMC cannot open the file c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be because
the files does not exist, is not an MMC console, or was created by a later
version of MMC. This may also be because you do not have sufficied access
rights to the file.
...when trying to run Enterprise Manager. I have tried re-installing the
server and client tools, and SP3a, but still the same error.
I have administrator access to the PC, but strangely, I can run enterprise
manager if logged on as the local administrator. I can also run SQL Server
Enterprise Manager.msc if I rename it to anything else, and it seems to work
all right.
Shall I just carry on using the new SQL Server Enterprise Manager 2? It
seems like a very odd issue.
Thanks in advance.
RyanRyan,
Can you rename it to SQLEM.msc? Does that work? Then just create a
shortcut on your desktop or Start Menu, and all should be well.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Ryan Breakspear wrote:
> Hi All,
> I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting the
> error:
> MMC cannot open the file c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be becau
se
> the files does not exist, is not an MMC console, or was created by a later
> version of MMC. This may also be because you do not have sufficied access
> rights to the file.
> ...when trying to run Enterprise Manager. I have tried re-installing the
> server and client tools, and SP3a, but still the same error.
> I have administrator access to the PC, but strangely, I can run enterprise
> manager if logged on as the local administrator. I can also run SQL Serve
r
> Enterprise Manager.msc if I rename it to anything else, and it seems to wo
rk
> all right.
> Shall I just carry on using the new SQL Server Enterprise Manager 2? It
> seems like a very odd issue.
> Thanks in advance.
> Ryan
>|||Yep, I can rename it to anything. I can run it fine renamed as something
else, I just wondered why the problem, and if there was a solution.
Thanks for your reply.
Ryan
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:edplxoLcEHA.1248@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Ryan,
> Can you rename it to SQLEM.msc? Does that work? Then just create a
> shortcut on your desktop or Start Menu, and all should be well.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Ryan Breakspear wrote:
because[vbcol=seagreen]
later[vbcol=seagreen]
access[vbcol=seagreen]
the[vbcol=seagreen]
enterprise[vbcol=seagreen]
Server[vbcol=seagreen]
work[vbcol=seagreen]|||I have the exact same settings, and the exact same problem. Wish I had
found this workaround before re-installing everything... Still would
like to know what is causing this though...
Cheers - Craig
Ryan Breakspear wrote:
> *Hi All,
> I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting
> the
> error:
> MMC cannot open the file c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be
> because
> the files does not exist, is not an MMC console, or was created by a
> later
> version of MMC. This may also be because you do not have sufficied
> access
> rights to the file.
> ....when trying to run Enterprise Manager. I have tried
> re-installing the
> server and client tools, and SP3a, but still the same error.
> I have administrator access to the PC, but strangely, I can run
> enterprise
> manager if logged on as the local administrator. I can also run SQL
> Server
> Enterprise Manager.msc if I rename it to anything else, and it seems
> to work
> all right.
> Shall I just carry on using the new SQL Server Enterprise Manager 2?
> It
> seems like a very odd issue.
> Thanks in advance.
> Ryan *
cjeff
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message888314.html|||I have been trying to fix this problem for some time. The fact that it
worked for you when you renamed it tipped me off to the source of the
problem. There is a cached version of the MMC file in the C:\Documents and
Settings\<username>\Application Data\Microsoft\MMC folder.
The problem is that on my system that cached file was corrupted.
Once I deleted the cached file, I was able to open SQL EntMgr with no proble
m.
"cjeff" wrote:

> I have the exact same settings, and the exact same problem. Wish I had
> found this workaround before re-installing everything... Still would
> like to know what is causing this though...
> Cheers - Craig
> Ryan Breakspear wrote:
>
> --
> cjeff
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message888314.html
>

Wednesday, March 21, 2012

MMC Can't open SQL Server Enterprise Manager.msc

Quote:

Originally posted by Ryan Breakspear
Hi All,
I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting the
error:
MMC cannot open the file c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be because
the files does not exist, is not an MMC console, or was created by a later
version of MMC. This may also be because you do not have sufficied access
rights to the file.
....when trying to run Enterprise Manager. I have tried re-installing the
server and client tools, and SP3a, but still the same error.
I have administrator access to the PC, but strangely, I can run enterprise
manager if logged on as the local administrator. I can also run SQL Server
Enterprise Manager.msc if I rename it to anything else, and it seems to work
all right.
Shall I just carry on using the new SQL Server Enterprise Manager 2? It
seems like a very odd issue.
Thanks in advance.
Ryan

|||I have been trying to fix this problem for some time. The fact that it
worked for you when you renamed it tipped me off to the source of the
problem. There is a cached version of the MMC file in the C:\Documents and
Settings\<username>\Application Data\Microsoft\MMC folder.
The problem is that on my system that cached file was corrupted.
Once I deleted the cached file, I was able to open SQL EntMgr with no problem.
"cjeff" wrote:

> I have the exact same settings, and the exact same problem. Wish I had
> found this workaround before re-installing everything... Still would
> like to know what is causing this though...
> Cheers - Craig
> Ryan Breakspear wrote:
>
> --
> cjeff
> Posted via http://www.mcse.ms
> View this thread: http://www.mcse.ms/message888314.html
>

MMC Can't open SQL Server Enterprise Manager.msc

Hi All,
I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting the
error:
MMC cannot open the file c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be because
the files does not exist, is not an MMC console, or was created by a later
version of MMC. This may also be because you do not have sufficied access
rights to the file.
...when trying to run Enterprise Manager. I have tried re-installing the
server and client tools, and SP3a, but still the same error.
I have administrator access to the PC, but strangely, I can run enterprise
manager if logged on as the local administrator. I can also run SQL Server
Enterprise Manager.msc if I rename it to anything else, and it seems to work
all right.
Shall I just carry on using the new SQL Server Enterprise Manager 2? It
seems like a very odd issue.
Thanks in advance.
RyanRyan,
Can you rename it to SQLEM.msc? Does that work? Then just create a
shortcut on your desktop or Start Menu, and all should be well.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Ryan Breakspear wrote:
> Hi All,
> I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting the
> error:
> MMC cannot open the file c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be because
> the files does not exist, is not an MMC console, or was created by a later
> version of MMC. This may also be because you do not have sufficied access
> rights to the file.
> ...when trying to run Enterprise Manager. I have tried re-installing the
> server and client tools, and SP3a, but still the same error.
> I have administrator access to the PC, but strangely, I can run enterprise
> manager if logged on as the local administrator. I can also run SQL Server
> Enterprise Manager.msc if I rename it to anything else, and it seems to work
> all right.
> Shall I just carry on using the new SQL Server Enterprise Manager 2? It
> seems like a very odd issue.
> Thanks in advance.
> Ryan
>|||Yep, I can rename it to anything. I can run it fine renamed as something
else, I just wondered why the problem, and if there was a solution.
Thanks for your reply.
Ryan
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:edplxoLcEHA.1248@.TK2MSFTNGP11.phx.gbl...
> Ryan,
> Can you rename it to SQLEM.msc? Does that work? Then just create a
> shortcut on your desktop or Start Menu, and all should be well.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Ryan Breakspear wrote:
> > Hi All,
> >
> > I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting the
> > error:
> >
> > MMC cannot open the file c:\Program Files\Microsoft SQL
> > Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be
because
> > the files does not exist, is not an MMC console, or was created by a
later
> > version of MMC. This may also be because you do not have sufficied
access
> > rights to the file.
> >
> > ...when trying to run Enterprise Manager. I have tried re-installing
the
> > server and client tools, and SP3a, but still the same error.
> >
> > I have administrator access to the PC, but strangely, I can run
enterprise
> > manager if logged on as the local administrator. I can also run SQL
Server
> > Enterprise Manager.msc if I rename it to anything else, and it seems to
work
> > all right.
> >
> > Shall I just carry on using the new SQL Server Enterprise Manager 2? It
> > seems like a very odd issue.
> >
> > Thanks in advance.
> >
> > Ryan
> >
> >|||I have the exact same settings, and the exact same problem. Wish I had
found this workaround before re-installing everything... Still would
like to know what is causing this though...
Cheers - Craig
Ryan Breakspear wrote:
> *Hi All,
> I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting
> the
> error:
> MMC cannot open the file c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be
> because
> the files does not exist, is not an MMC console, or was created by a
> later
> version of MMC. This may also be because you do not have sufficied
> access
> rights to the file.
> ....when trying to run Enterprise Manager. I have tried
> re-installing the
> server and client tools, and SP3a, but still the same error.
> I have administrator access to the PC, but strangely, I can run
> enterprise
> manager if logged on as the local administrator. I can also run SQL
> Server
> Enterprise Manager.msc if I rename it to anything else, and it seems
> to work
> all right.
> Shall I just carry on using the new SQL Server Enterprise Manager 2?
> It
> seems like a very odd issue.
> Thanks in advance.
> Ryan *
cjeff
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message888314.html|||I have been trying to fix this problem for some time. The fact that it
worked for you when you renamed it tipped me off to the source of the
problem. There is a cached version of the MMC file in the C:\Documents and
Settings\<username>\Application Data\Microsoft\MMC folder.
The problem is that on my system that cached file was corrupted.
Once I deleted the cached file, I was able to open SQL EntMgr with no problem.
"cjeff" wrote:
> I have the exact same settings, and the exact same problem. Wish I had
> found this workaround before re-installing everything... Still would
> like to know what is causing this though...
> Cheers - Craig
> Ryan Breakspear wrote:
> > *Hi All,
> >
> > I'm using XP Pro, and Windows SQL Server 2000 SP3a, and I'm getting
> > the
> > error:
> >
> > MMC cannot open the file c:\Program Files\Microsoft SQL
> > Server\80\Tools\Binn\SQL Server Enterprise Manager.msc. This may be
> > because
> > the files does not exist, is not an MMC console, or was created by a
> > later
> > version of MMC. This may also be because you do not have sufficied
> > access
> > rights to the file.
> >
> > ....when trying to run Enterprise Manager. I have tried
> > re-installing the
> > server and client tools, and SP3a, but still the same error.
> >
> > I have administrator access to the PC, but strangely, I can run
> > enterprise
> > manager if logged on as the local administrator. I can also run SQL
> > Server
> > Enterprise Manager.msc if I rename it to anything else, and it seems
> > to work
> > all right.
> >
> > Shall I just carry on using the new SQL Server Enterprise Manager 2?
> > It
> > seems like a very odd issue.
> >
> > Thanks in advance.
> >
> > Ryan *
>
> --
> cjeff
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message888314.html
>

MMC Cannot open

who knows how to fix this:
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
This may be because the file doesnt exist, is not an MMC console, or
was created by a later version of MMC. This may also be because
you do not have sufficient access rights to the file.
I have rebooted the server, and restarted my machine, uninstalled and reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manager. Can anyone help?
Thanks in advance
Jane
Jane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>
|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The problem is very strange. I suppose I am locked by the server. Don't know what to do now.
As I said, I am new to SQL Server, I am trying to explore it. But there isn't a senior member in our team, so your help turns to be very important for me. I am looking forward to any ideas.
Cheers
Jane
|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane
|||Thanks for your help, but it doesn't work. Any ideas?
Jane
-- Dinesh T.K wrote: --
Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane
|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps[vbcol=seagreen]
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know[vbcol=seagreen]
> what to do now.
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>
|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps[vbcol=seagreen]
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know[vbcol=seagreen]
> what to do now.
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>

MMC Cannot open

who knows how to fix this
MMC cannot open the file C:\Program Files\Microsoft SQ
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC
This may be because the file doesnt exist, is not an MMC console, o
was created by a later version of MMC. This may also be becaus
you do not have sufficient access rights to the file
I have rebooted the server, and restarted my machine, uninstalled and reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manager. Can anyone help?
Thanks in advanc
JanJane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The problem is very strange. I suppose I am locked by the server. Don't know what to do now
As I said, I am new to SQL Server, I am trying to explore it. But there isn't a senior member in our team, so your help turns to be very important for me. I am looking forward to any ideas
Cheer
Jane|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Thanks for your help, but it doesn't work. Any ideas
Jan
-- Dinesh T.K wrote: --
Jane
Refer the steps 3 to 5 given in the 'workaround' section of this article
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000
http://support.microsoft.com/default.aspx?id=27245
PS: I know that the title of the article doesnt concern you, but those step
might help
-
Dines
SQL Server MV
-
-
SQL Server FAQ a
http://www.tkdinesh.co
"Jane" <anonymous@.discussions.microsoft.com> wrote in messag
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com..
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000
The problem is very strange. I suppose I am locked by the server. Don't kno
what to do now
> As I said, I am new to SQL Server, I am trying to explore it. But ther
isn't a senior member in our team, so your help turns to be very importan
for me. I am looking forward to any ideas
> Cheer
> Jan|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>sql

MMC Cannot open

who knows how to fix this:
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
This may be because the file doesnt exist, is not an MMC console, or
was created by a later version of MMC. This may also be because
you do not have sufficient access rights to the file.
I have rebooted the server, and restarted my machine, uninstalled and reinst
alled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manag
er. Can anyone help?
Thanks in advance
JaneJane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The
problem is very strange. I suppose I am locked by the server. Don't know wh
at to do now.
As I said, I am new to SQL Server, I am trying to explore it. But there isn'
t a senior member in our team, so your help turns to be very important for m
e. I am looking forward to any ideas.
Cheers
Jane|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Thanks for your help, but it doesn't work. Any ideas?
Jane
-- Dinesh T.K wrote: --
Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.[vbcol=seagreen]
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
there[vbcol=seagreen]
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.[vbcol=seagreen]
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
there[vbcol=seagreen]
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>

Monday, March 12, 2012

Missing Tools after Setup

In the MSDE BOOKs there is a list of utilities and there directorys that i
should have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-bcp2
-console
-isql2
-sqlagent
-sqldiag
-sqlmaint
-sqlservr
-vswitch
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp2
-dtsrun
-dtswiz
-isql2
-isqlw
-itwiz
-odbccmpt
-osql
-rebuildm
-sqlftwiz
x:\Program Files\Microsoft SQL Server\80\Com
-distrib3
-logread3
-replmerg3
-snapshot3
x:\Program Files\Common Files\Microsoft Shared\Service Manager
-scm
x:\Program Files\Common Files\Microsoft Shared\?
-regxmlss
That is the list that i should have, here is the list that i do have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-cmdwrap.exe
-sqlagent.exe
-sqlmaint.exe
-sqlservr.exe
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp.exe
-cnfgsvr.exe
-dcomscm.exe
-DTSRUN.exe
-OSQL.exe
-scm.exe
-sqladhlp.exe
-sqlmangr.exe
-SVRNETCN.exe
x:\Program Files\Microsoft SQL Server\80\Com
-DISTRIB.exe
-replmerg.exe
-snapshot.exe
x:\Program Files\Common Files\Microsoft Shared\Service Manager
NO Service Manager Directory Exists
x:\Program Files\Common Files\Microsoft Shared\?
It says that this all should have been installed on the install by default
here is how installed
i moved my command prompt to the directory containing the setup folder
(C:\MSDERela)
then i ran
setup SAPWD="??"
this installed fine
what did i do wrong?
ALso i am very new to databases
the only thing that i have ever used is access which is pretty cut and dry.
I have had a lot of trouble finding simple tutorials for a beginner if any
one knows of one please let me know.
In the mean time a couple of quick questions:
1) does a database file have to be in the directory: C:\Program
Files\Microsoft SQL Server\MSSQL\Data
in order for it to work?
2) other than osql how can i access my data? The Books say that thre is a
SQL Server Query analyzer but could not find it (see beginning of post)
thanks Again for the help
WStoreyII
Hi,
I'm not sure which MSDE book you are referring to but the tools you mention
are those that are installed with SQL Server, not with the MSDE. The MSDE
ships with limited tools. The intention is that your application will do the
work. We have some tools you could try at our site. Others are at:
http://www.microsoft.com/sql/msde/pa.../default.aspx.
The data files do not have to be in a specific folder but you will find life
much easier if you have them all in a particular folder.
If you are going to be doing development for the MSDE, I'd strongly suggest
you purchase a copy of the SQL Server Developer Edition. I gather it's
currently only around $49 USD and provides a wealth of things you'll find
useful during development.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"WStoreyII" <WStoreyII@.discussions.microsoft.com> wrote in message
news:9109A07D-4093-4473-AB0A-CFDFD9611C06@.microsoft.com...
> In the MSDE BOOKs there is a list of utilities and there directorys that i
> should have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -bcp2
> -console
> -isql2
> -sqlagent
> -sqldiag
> -sqlmaint
> -sqlservr
> -vswitch
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp2
> -dtsrun
> -dtswiz
> -isql2
> -isqlw
> -itwiz
> -odbccmpt
> -osql
> -rebuildm
> -sqlftwiz
> x:\Program Files\Microsoft SQL Server\80\Com
> -distrib3
> -logread3
> -replmerg3
> -snapshot3
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> -scm
> x:\Program Files\Common Files\Microsoft Shared\?
> -regxmlss
> That is the list that i should have, here is the list that i do have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -cmdwrap.exe
> -sqlagent.exe
> -sqlmaint.exe
> -sqlservr.exe
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp.exe
> -cnfgsvr.exe
> -dcomscm.exe
> -DTSRUN.exe
> -OSQL.exe
> -scm.exe
> -sqladhlp.exe
> -sqlmangr.exe
> -SVRNETCN.exe
> x:\Program Files\Microsoft SQL Server\80\Com
> -DISTRIB.exe
> -replmerg.exe
> -snapshot.exe
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> NO Service Manager Directory Exists
> x:\Program Files\Common Files\Microsoft Shared\?
> It says that this all should have been installed on the install by default
> here is how installed
> i moved my command prompt to the directory containing the setup folder
> (C:\MSDERela)
> then i ran
> setup SAPWD="??"
> this installed fine
> what did i do wrong?
> ALso i am very new to databases
> the only thing that i have ever used is access which is pretty cut and
> dry.
> I have had a lot of trouble finding simple tutorials for a beginner if any
> one knows of one please let me know.
> In the mean time a couple of quick questions:
> 1) does a database file have to be in the directory: C:\Program
> Files\Microsoft SQL Server\MSSQL\Data
> in order for it to work?
> 2) other than osql how can i access my data? The Books say that thre is a
> SQL Server Query analyzer but could not find it (see beginning of post)
> thanks Again for the help
> WStoreyII
>
|||Greg's correct. MSDE was not intended to ship
with the full compliment of (management) tools
as SQL Server is.
If you're want to get up and running as quick as
possible then Microsoft Access (2000 and above)
is an excellent interface to MSDE for your own
internal development purposes. Micrsoft press has
a decent book on Access Data Projects also.
If you're wanting to use MSDE to develop a
distributable application, then you'll need to
be coding everything yourself.
Good luck.

Wednesday, March 7, 2012

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

Monday, February 20, 2012

Missing dll folder in SQL Server 2005

Hello, I have have some instructions to put a dll file in the folder
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
do you think I would be the dll.
ThanksHi Don,
Are these instructions from a specific application? Does it mention if it is
compatible with SQL Server 2005?
Ben Nevarez
"Don" wrote:
> Hello, I have have some instructions to put a dll file in the folder
> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
> do you think I would be the dll.
> Thanks
>|||Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
> Hi Don,
> Are these instructions from a specific application? Does it mention if it is
> compatible with SQL Server 2005?
> Ben Nevarez
>
>
> "Don" wrote:
>> Hello, I have have some instructions to put a dll file in the folder
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
>> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
>> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
>> do you think I would be the dll.
>> Thanks|||Yes, it's for a extended stored procedure called xp_calendar. And there are
notes about having it work with SQl 2005 just not about were to put the dll.
I had installed it on a SQL Server 2000 as a test and xp_calendar worked
well, but when I went to install it at the client running 2005 I saw that it
does not have the dll folder.
http://www.sqlservercentral.com/articles/Miscellaneous/2985/
http://www.logicom-inc.com/xp_sql2exchange/xp_sql2exchange.html
Thanks
Don
"Tibor Karaszi" wrote:
> Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
> instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
> >
> > Hi Don,
> >
> > Are these instructions from a specific application? Does it mention if it is
> > compatible with SQL Server 2005?
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "Don" wrote:
> >
> >> Hello, I have have some instructions to put a dll file in the folder
> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
> >> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
> >> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
> >> do you think I would be the dll.
> >>
> >> Thanks
> >>
>
>|||I would add the files to the binn folder and then adjust the paths in the file "xp_add.sql"
accordingly. You would need to find what folder (MSSQL.1 etc) corresponds to your instance name,
check the below reg key for that:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Don" <Don@.discussions.microsoft.com> wrote in message
news:0AC640AC-92C5-478F-82EA-6DD80D9BB418@.microsoft.com...
> Yes, it's for a extended stored procedure called xp_calendar. And there are
> notes about having it work with SQl 2005 just not about were to put the dll.
> I had installed it on a SQL Server 2000 as a test and xp_calendar worked
> well, but when I went to install it at the client running 2005 I saw that it
> does not have the dll folder.
> http://www.sqlservercentral.com/articles/Miscellaneous/2985/
> http://www.logicom-inc.com/xp_sql2exchange/xp_sql2exchange.html
> Thanks
> Don
> "Tibor Karaszi" wrote:
>> Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
>> instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on
>> 2005.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
>> >
>> > Hi Don,
>> >
>> > Are these instructions from a specific application? Does it mention if it is
>> > compatible with SQL Server 2005?
>> >
>> > Ben Nevarez
>> >
>> >
>> >
>> >
>> > "Don" wrote:
>> >
>> >> Hello, I have have some instructions to put a dll file in the folder
>> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
>> >> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
>> >> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
>> >> do you think I would be the dll.
>> >>
>> >> Thanks
>> >>
>>

Friday, March 23, 2012

MMC recovery

MMC Can't open SQL Server Enterprise Manager.msc

Wednesday, March 21, 2012

MMC Can't open SQL Server Enterprise Manager.msc

MMC Can't open SQL Server Enterprise Manager.msc

MMC Cannot open

MMC Cannot open

MMC Cannot open

Monday, March 12, 2012

Missing Tools after Setup

Wednesday, March 7, 2012

Missing Program group

Missing Program group

Missing Program group

Missing Program group

Monday, February 20, 2012

Missing dll folder in SQL Server 2005

Missing dll file

Blog Archive

About Me