Enterprise Manger CLOSES!

Hello everyone,
I have SQL server 2000 installed on Windows 2003 std
edition. The first time I opened E manager I was able to
right click on any database and go to properties to set
the location of transaction logs and so forth! The second
time I went into it I tried the same thing and now E
manager shuts down. It does the same thing to all the
databases. Does anyone know why this is happening. I have
sp3 installed...
GiacomoI don't know what happening but my be able to supply
information for you to find out.
The 2003 should contain logs of programs / services that
have started an stopped including SQL Server, so have a
chat to your 2003 Administrator to see if you can have a
look at them.
SQL Server also keeps a log, under the server - Managment -
SQL Server Logs have a look at that and see if it helps.
Run a trace and see what the server was doing before the
shut down.
J
>--Original Message--
>Hello everyone,
>I have SQL server 2000 installed on Windows 2003 std
>edition. The first time I opened E manager I was able to
>right click on any database and go to properties to set
>the location of transaction logs and so forth! The second
>time I went into it I tried the same thing and now E
>manager shuts down. It does the same thing to all the
>databases. Does anyone know why this is happening. I have
>sp3 installed...
>Giacomo
>.
>

Enterprise Manager Closes

When I right click on any of our databases and select
Properties, Enterprise Manager automatically closes. It
doesn't give me an error or anything. I tried
reinstalling it but it didn't help.
Any ideas?
Jose
I've seen this only if Yukon is installed.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jose Alfaro" <ja@.mkrs.com> wrote in message
news:d64201c410e9$25aee5e0$a001280a@.phx.gbl...
When I right click on any of our databases and select
Properties, Enterprise Manager automatically closes. It
doesn't give me an error or anything. I tried
reinstalling it but it didn't help.
Any ideas?
Jose
|||I don't really know what Yukon is. How would I know if it
is installed?
Jose

>--Original Message--
>I've seen this only if Yukon is installed.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <ja@.mkrs.com> wrote in message
>news:d64201c410e9$25aee5e0$a001280a@.phx.gbl...
>When I right click on any of our databases and select
>Properties, Enterprise Manager automatically closes. It
>doesn't give me an error or anything. I tried
>reinstalling it but it didn't help.
>Any ideas?
>Jose
>
|||It is the next release of SQL Server, currently in Beta1. If you check
Programs->SQL Server, it should have a tool called SQL Server Workbench.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote in message
news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
I don't really know what Yukon is. How would I know if it
is installed?
Jose

>--Original Message--
>I've seen this only if Yukon is installed.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <ja@.mkrs.com> wrote in message
>news:d64201c410e9$25aee5e0$a001280a@.phx.gbl...
>When I right click on any of our databases and select
>Properties, Enterprise Manager automatically closes. It
>doesn't give me an error or anything. I tried
>reinstalling it but it didn't help.
>Any ideas?
>Jose
>
|||I checked but I didn't find that tool. Do you have any
suggestions as to what else I can try?
Jose

>--Original Message--
>It is the next release of SQL Server, currently in
Beta1. If you check
>Programs->SQL Server, it should have a tool called SQL
Server Workbench.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
>I don't really know what Yukon is. How would I know if it
>is installed?
>Jose
-
>--
>
|||I'll see what I can find.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jose Alfaro" <ja@.mkrs.com> wrote in message
news:124ef01c410f6$ec18e430$a101280a@.phx.gbl...
I checked but I didn't find that tool. Do you have any
suggestions as to what else I can try?
Jose

>--Original Message--
>It is the next release of SQL Server, currently in
Beta1. If you check
>Programs->SQL Server, it should have a tool called SQL
Server Workbench.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
>I don't really know what Yukon is. How would I know if it
>is installed?
>Jose
-
>--
>
|||Two methods - use which is applicable:
Method 1
In your SQL Server bin directory, run:
regsvr32 sqldmo.dll
Method 2
You want to create a txt file for the dll's and run this at the command
prompt to *batch* register them.
for /f %i in (c:\dmo.txt) do regsvr32 %windir%\system32\%i /s
--c:\dmo.txt--
ODBC32.dll
odbc32gt.dll
odbc16gt.dll
ODBCCP32.dll
odbccr32.dll
odbccu32.dll
odbcint.dll
odbcp32r.dll
ODBCTL32.DLL
odbctrac.dll
SQLSRV32.dll
sqlunirl.dll
odbcbcp.dll
I'd like to thank fellow MVP's Anith, Greg and oj for the above tips.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
..
"Jose Alfaro" <ja@.mkrs.com> wrote in message
news:124ef01c410f6$ec18e430$a101280a@.phx.gbl...
I checked but I didn't find that tool. Do you have any
suggestions as to what else I can try?
Jose

>--Original Message--
>It is the next release of SQL Server, currently in
Beta1. If you check
>Programs->SQL Server, it should have a tool called SQL
Server Workbench.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
>I don't really know what Yukon is. How would I know if it
>is installed?
>Jose
-
>--
>

Enterprise Manager Closes

When I right click on any of our databases and select
Properties, Enterprise Manager automatically closes. It
doesn't give me an error or anything. I tried
reinstalling it but it didn't help.
Any ideas?
JoseHi Jose,
That seems like your EM encountered an AV (Access Violation). There are a
number of possibilities. The only one that I can think of is below:
http://support.microsoft.com/defaul...kb;en-us;315523
Check your SQL Server errorlog and see if there is any
EXCEPTION_ACCESS_VIOLATION when Enterprise Manager closes.
Yih-Yoon Lee
On Tue, 23 Mar 2004 08:17:12 -0800, Jose Alfaro wrote:

> When I right click on any of our databases and select
> Properties, Enterprise Manager automatically closes. It
> doesn't give me an error or anything. I tried
> reinstalling it but it didn't help.
> Any ideas?
> Jose