Re: Cannot install Enterprise Manager

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ekrem

Thanks for the vote of confidance

I tried it again but I first had to install a upgrade to MSXML6

After I upgraded MSXML6 the install ran and now I am accessing my SQL server

Thanks again

Tom
"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:12AA1F97-6F47-4D57-B685-6C6F8F067560@xxxxxxxxxxxxxxxx
Don't take me wrong but I'm pretty sure that this tool works quite well
with SQL Server 2000 instances.

I, myself witnessed this I don't know how many times... Just give it a
try...

--
Ekrem Önsoy



"Thomas R Grassi Jr" <thomasgrassi@xxxxxxxxxxx> wrote in message
news:u3LRQ7IXJHA.5400@xxxxxxxxxxxxxxxxxxxxxxx
Ekrem

Sorry but this only works for SQL 2005

I have SQL 2000

Need something for SQL 2000

Thanks

Tom

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:21D8E6D7-0DF4-4129-86CE-21CCBA9AC056@xxxxxxxxxxxxxxxx
Download "SQL Server Management Studio Express" for free and install it
on your SQL Server server. By default, BUILTIN\Administrators is added
as a "sysadmin" Login to your MSDE instance so if you log in to that
server as a local administrator and connect to that SQL Server instance
using Windows Authentication, you'll probably succeed.

If you don't remember the "sa" s password, there's no way to find it
out. You can only change it by logging into your server using the above
method.

--
Ekrem Önsoy



"Thomas R Grassi Jr" <thomasgrassi@xxxxxxxxxxx> wrote in message
news:%23eFwt49WJHA.5364@xxxxxxxxxxxxxxxxxxxxxxx
I have a windows 2003 R2 DC standard server and I installed Microsofts
Sharepoint 2.0 which install Microoft SQL desktop engine for the
sharepoint databases.

The version of SQL Desktop engine is 8.00.2050 which is SQL 2000.

I would like to install the Enterprise Manager so I can setup backups
etc.

I have a Windows XP Pro SP3 workstation that I run SQL Developers
Edition that version is also 8.00.2050

The enterprise manager is running on my workstation so I thought I
could connect to my servers SQL Desktop engine but I am having a
problem connecting. I am not sure what the SA password is on the server
I forgot to write it down during the install.

So I am trying to install the Enterprise Manager on my server but the
option to do an upgrade is greyed out.

Any one have any ideas or suggestions on how I can install the
Enterprise manager for SQL DESKTOP ENGINE on my server.

OR any way to figure out the SA password


Thanks for your help

Tom







.

Relevant Pages

  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: Side by Side upgrade to CM2007
    ... As with any upgrade it is best to perform the upgrade within a lab thereby allow you to work through all the issues before you upgrade production. ... Created new Windows 2008 server, installed another instance of SQL on new ... > locally install SQL for SMS/CM ...
    (microsoft.public.sms.setup)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)