MMSQL 7.0 on MMC

Hi all,

I'm facing an inconvinience with an MSSQL 7.0 installation, regarding it's accessibility in MMC. The case is as such:

When accessing the installation instance, I can navigate wihthin the tree without problems; accessing and viewing all the database, the tables, users etc within each databse. However, when highlighting a database, when it should display a summary on the right panel, it instead displays "an error occurred when trying to access the database information". Note that the puzzling thing is that accessing the database tables, users, rules etc is perfectly fine, and there is no problem with the application using the database either, in terms of accessing it.

There are also no error logged under Applications in the Event Viewer.

If you must know, an MSDE as been installed into the same machine after the MSSQL 7.0 installation.

I have not been able to find any resources on fixing this, and would appreciate if anyone can help on this matter.

Thanks.

Hi all,

Some progress report, and updates on what I've tried so far...

I've been searching and comparing this faulty MMC with a working one, and everything (setting wise) seem to be in order. I've checked registry settings, and config.ini files in the MSSQL directory, they look the same. I've even tried replacing the MSSQLServer.msc file in hopes that it was corrupted. Nothing.

I've also tried registering said MSDE into the MMC. The result? The same problem. Database, user and otherwise full access without problems. Except for the summary page when I have the database highlighted and the "Access Error" is shown. There should be none, since I can still access the database tables, users, etc by simply navigating down the explorer tree.

I would like to know though, if anyone can point me to where I might be able to see the MMC log files? Does one exist? Can I activate logging somewhere? I've been unable to find it, and am quite surmised that there is no such thing, but the programmer in me feels that something is not quite right to that. There has to be some form of logging somewhere for to troubleshoot from.

Is there a known version incompatibility between SQL7.0 and MSDE? With certain MMC/OD version? Patch levels?

Would appreciate if anyone can provide new insights.

Thanks.

Mixing 32-bit and 64-bit in MSSQL Cluster

Hi,
We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
Resource.
And these machines can only hold 6 Gb of memory which is not enough
anymore.
I was wondering if I could add 1 new 64-bit machine in this cluster or
that need to create a new cluster with 2 new 64-bit machines.
Regards,
Sven Peeters
Hi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:

> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>
|||Hi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:

> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>
|||On 10 feb, 11:26, Ben Nevarez <bneva...@.no.spam.please.sunamerica.com>
wrote:
> Hi,
> You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
> will need to create a new 64-bit Windows Cluster.
> Hope this helps,
> Ben Nevarez
>
> "Icemokka" wrote:
>
> - Tekst uit oorspronkelijk bericht weergeven -
Thank you ...

Mixing 32-bit and 64-bit in MSSQL Cluster

Hi,
We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
Resource.
And these machines can only hold 6 Gb of memory which is not enough
anymore.
I was wondering if I could add 1 new 64-bit machine in this cluster or
that need to create a new cluster with 2 new 64-bit machines.
Regards,
Sven PeetersHi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:
> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>|||Hi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:
> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>|||On 10 feb, 11:26, Ben Nevarez <bneva...@.no.spam.please.sunamerica.com>
wrote:
> Hi,
> You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
> will need to create a new 64-bit Windows Cluster.
> Hope this helps,
> Ben Nevarez
>
> "Icemokka" wrote:
> > Hi,
> > We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> > Resource.
> > And these machines can only hold 6 Gb of memory which is not enough
> > anymore.
> > I was wondering if I could add 1 new 64-bit machine in this cluster or
> > that need to create a new cluster with 2 new 64-bit machines.
> > Regards,
> > Sven Peeters- Tekst uit oorspronkelijk bericht niet weergeven -
> - Tekst uit oorspronkelijk bericht weergeven -
Thank you ...sql

Missing INFORMATION_SCHEMA.ROUTINES

Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>>I do not think that this view was added as a service pack addition. Pleasew
>>verify that you are logging in with applicable permissions. This view is
>>created by default.
>>"Madestro" wrote:
>>
>>Hi all,
>>For some reason this view is missing from my MSSQL:
>>INFORMATION_SCHEMA.ROUTINES
>>Does anyone have any idea why?... Is it a service pack maybe?
>>Please let me know. Thank you!
>>|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>> I do not think that this view was added as a service pack addition. Pleasew
>> verify that you are logging in with applicable permissions. This view is
>> created by default.
>> "Madestro" wrote:
>> > Hi all,
>> >
>> > For some reason this view is missing from my MSSQL:
>> >
>> > INFORMATION_SCHEMA.ROUTINES
>> >
>> > Does anyone have any idea why?... Is it a service pack maybe?
>> >
>> > Please let me know. Thank you!
>> >|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
> > I do not think that this view was added as a service pack addition. Pleasew
> > verify that you are logging in with applicable permissions. This view is
> > created by default.
> >
> > "Madestro" wrote:
> >
> > > Hi all,
> > >
> > > For some reason this view is missing from my MSSQL:
> > >
> > > INFORMATION_SCHEMA.ROUTINES
> > >
> > > Does anyone have any idea why?... Is it a service pack maybe?
> > >
> > > Please let me know. Thank you!
> > >

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
>> >>
>>