Board index MS SQL Server

SQL Enterprise Manager using SP3 not allowing access

SQL Enterprise Manager using SP3 not allowing access

Post by Jim Litchfo » Fri, 22 Feb 2002 02:20:12



I installed SP3i for SQL 7 running on Windows 2000 server and now I
cannot access the database using the Enterprise Manager. I can still
use the Query Analyzer to access the database as well as all of my web
pages can access but I cannot access the database using the Enterprise
Manager. The error that I receive is:

A connection could not be established to XXXXXXX
SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION
SQL Server is terminating this process.

Please verify SQL Server is running and check you SQL Server
registration properties and try again.

I have verified the server registration and it is ok. At this point I
am all out of ideas on what to do. I have rebooted all involved and
tried to reinstall SP3i to no avail. Any help would greatly be
appreciated.

Thanks,
Jim Litchford

 
 
 
Top

SQL Enterprise Manager using SP3 not allowing access

Post by Rishi M. Agrawal [M » Sun, 24 Feb 2002 07:31:34


James,

What you are facing is a bad install of the Enterprise Manager. As such the server and the databases are all fine and you should be able to connect to them from a
Enterprise manager on another box; but some DLL related to this particular Enterprise Manager is messed up.  As I mentioned, you could still administer the server
from another box, even using Enterprise Manager, by installing only the client utilities on another box and then connect to the SQL Server from there.

To 'fix' the bad Enterprise Manager, you could call Microsoft SQL Support, or you might have to reinstall the SQL Server components on the box which is having the
problem.

Hope that helps.

Regards,
Rishi M. Agrawal, MCDBA

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------

| Subject: SQL Enterprise Manager using SP3 not allowing access
|
| I installed SP3i for SQL 7 running on Windows 2000 server and now I
| cannot access the database using the Enterprise Manager. I can still
| use the Query Analyzer to access the database as well as all of my web
| pages can access but I cannot access the database using the Enterprise
| Manager. The error that I receive is:
|
| A connection could not be established to XXXXXXX
| SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005
| EXCEPTION_ACCESS_VIOLATION
| SQL Server is terminating this process.
|
| Please verify SQL Server is running and check you SQL Server
| registration properties and try again.
|
|
| I have verified the server registration and it is ok. At this point I
| am all out of ideas on what to do. I have rebooted all involved and
| tried to reinstall SP3i to no avail. Any help would greatly be
| appreciated.
|
| Thanks,
| Jim Litchford
|

 
 
 
Top

SQL Enterprise Manager using SP3 not allowing access

Post by Jim Litchfor » Wed, 27 Feb 2002 01:40:03


Rishi,

   Hello and thanks for responding to my situation. I am sorry that I
forgot to also mention that I couldnt access the database using the
Enterprise Manager no matter what terminal I use.  

   The good news is that I have it back up and running now. I killed
Sequel Server and reinstalled it and I can now access the database using
the Enterprise Manager.

  The bad news is that for some reason the web site attached to this
database cannot open a connection to the database. It seems that by
adding the SP3 and the new security update has kicked the IIS out. No
matter what I specify as a connection string it does not want to
recognize it. Any help would be appreciated.

Thanks once again for your help,
Jim Litchford

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

SQL Enterprise Manager using SP3 not allowing access

Post by Rishi M. Agrawal [M » Thu, 28 Feb 2002 05:54:33


Jim,

I am glad that it is working now, even though it required a reinstall of SQL Server.


the exact error that you receive while trying to open a connection.

Can you try to open a connection using a SQL client tool from the web server?
Is SQL server startup account a Local Admin with appropriate priviledges?
What account is the IIS using to connect to SQL Server? Is that account recognized by SQL?

Hope that helps.

Regards,
Rishi M. Agrawal, MCDBA

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------

| Subject: RE: SQL Enterprise Manager using SP3 not allowing access
|
| Rishi,
|
|    Hello and thanks for responding to my situation. I am sorry that I
| forgot to also mention that I couldnt access the database using the
| Enterprise Manager no matter what terminal I use.  
|
|    The good news is that I have it back up and running now. I killed
| Sequel Server and reinstalled it and I can now access the database using
| the Enterprise Manager.
|
|   The bad news is that for some reason the web site attached to this
| database cannot open a connection to the database. It seems that by
| adding the SP3 and the new security update has kicked the IIS out. No
| matter what I specify as a connection string it does not want to
| recognize it. Any help would be appreciated.
|
| Thanks once again for your help,
| Jim Litchford
|
|
|
| *** Sent via Developersdex http://www.developersdex.com ***
| Don't just participate in USENET...get rewarded for it!
|

 
 
 
Top

SQL Enterprise Manager using SP3 not allowing access

Post by Jim Litchfor » Thu, 28 Feb 2002 23:11:56


Rishi,

   Thank you once again for your help. I now have it under control. It
seems that the user account that I was using for the web could access to
the database was not functionally properly.

  The account was in the database along with the other but still would
not work. I had to drop that user account and recreate it. This allowed
access and fixed my issue.

  The funny thing is that when I went to restore the databases it
corrupted that same user again and not any of the others. Well, I fixed
it again by dropping and recreating the same user account and all is
well now.

  Now, I will attempt to reinstall the SP3 and see where it takes me.
Once again I want to thank you for all of your help.

Thank you,
Jim Litchford

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

1. SQL2K SP3 Enterprise Manager bug - row count not correct

I've ran into a situation since moving to SQL 2000 SP3
that appears to be a bug when using Enteprise Manager
(EM).  If you are looking at Properties of tables (ie;
right clicking on a table and selecting Properties) and
using the row count, the row count may differ than what
you see in Query Analyzer (QA) when using the
statement 'Select count(*) from xxtablename'.

I've had several situations recently when adding rows that
the count doesn't increment on the table using EM, but if
you look thru QA, the count has changed.  So far,  the QA
values have been the correct ones.  In one instance, the
next time I added rows to the table, the EM row count came
up correct.  I've done all sorts of refresh things in EM
and even exited EM and came back in and the count was
still not incrementing, so I don't think it's a refresh
issue.

Any solutions or fixes in the works for this would be
appreciated.

Thanks,
Doug Werner
State of Idaho Dept. of Water Resources
208-327-7938

2. Any experience with SCO OpenServer 5.0x and IDS WE

3. Allowing access via Enterprise Manager to only selected users

4. Register BTEDIT 1.10 or later

5. Correct Permissions for allowing acess to SQL from Enterprise Manager

6. Paradox for Windows Ver. 1.0

7. Microsoft SQL isapi extension - 405 Method Not Allowed - POST queries are not allowed - OpenXML

8. Column Order in Access

9. Diagram doesn't save in Enterprise Manager SQL 7.0 SP3

10. SQL Server 2000 SP3 patch for enterprise manager crash

11. Encryption works in Access not in Enterprise Manager

12. HELP: SQL Enterprise Manager not connecting to SQL Server

13. Need select permissions from Application, but not from Enterprise Manager or Access


All times are UTC
Board index