Re: How do I find out SQL Server instance name and username?



The 'instance' name is usually the same as the computer name.

To obtain the username and password, you will most likely have to contact
the application provider. I suspect that they have the MSDE server and
databases 'locked' down to prevent customers from 'accidentally making
changes that would cause the application to fail or have problems. (It's a
normal way of doing business since they would be expected to 'fix' the
problems.)

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"achen" <achen2002@xxxxxxxxx> wrote in message
news:1155138792.537665.112290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have an application that uses MSDE 2000, I just obtained a free 3rd
party tool trying to manage the database a little bit toward what I
wish it to be.

However I do not remember the "SQL Server instance name" and "username"
when MSDE was installed with this application, is there any way to find
out?



.



Relevant Pages

  • Re: Enterprise to Standard
    ... "Arnie Rowland" wrote: ... Most good judgment comes from experience. ... All I'm doing is uninstalling EE and installing SE on my current sql ... My plans were to backup the databases, uninstall EE, install SE (with ...
    (microsoft.public.sqlserver.setup)
  • Re: Enterprise to Standard
    ... Master, model, msdb, tempdb are also installed. ... User databases 'should' not ... installation. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • Re: Hide databases in EM/QA
    ... of all databases on the server EVEN if the login does not have permissions ... Most good judgment comes from experience. ... able to see all the user databases although they can only ... In Query Analyzer, the databases will be restricted or ...
    (microsoft.public.sqlserver.security)