Post reply

how to check?

  • June 21, 2005 at 8:22 am

    #88742

    Hi all,

    I tried to install MSDE it installed and asked me to restart the machine but how can i know if it is running. is there a way that on different i have SQL EM how can i check that it is working properly!

    Thanks

  • June 21, 2005 at 8:27 am

    #567056

    Can you connect to it??

  • June 21, 2005 at 8:30 am

    #567059

    If I understand your question correctly..., there are several ways to determine if SQL Server is running.

    Check the Services to see if the MSSQL service is running.

    You can register an MSDE instance in Enterprise Manager.

    You can also manage and check the service's status in SQL Server Service Manager.

    In most respects MSDE "looks and acts" just like any other SQL Server installation.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • June 21, 2005 at 9:07 am

    #567087

    Or you could try adding the odbc connection, and 'testing' it (provided you have set access correctly).

    Command-line will work too: net start, should see the instance of the db.

    Or through services in computer management directly.

  • June 21, 2005 at 2:20 pm

    #567239

    Hi,

     

    I am trying to register on different where i have SQL EM but not able to loging and it fails to register. What user name i hav to log iin as as SA or the domain user of that server?

     

    Thanks

     

  • June 22, 2005 at 7:16 am

    #567415

    The sa account is only available on MSDE if you used

    securitymode=sql

    when installing msde from the command line.

    Actually, come to think of it, you will also need to have specified

    disablenetworkprotocols=0

    on the command line to allow MSDE to be accessed from other machines!  I think one or both of these might be your problem.

    Read the readme file that comes with SQL for info on the switches.  If you did not install with securitymode=sql, then there is a registry setting you can change to enable sql authentication (can't remember where it is - look it up in google).  As for disablenetworkprotocols=0, run svrnetcn.exe and enable TCP/IP - the networking was disabled from SP3 onwards by default in response to the slammer worm.

    Cheers

  • June 22, 2005 at 8:12 am

    #567483

    You can see what instances are registered using the

    isql -L

    command (Capital L). This will tell you what instances have been installed on the machine... once you know which name you used when installing the DB!

     

  • June 22, 2005 at 2:15 pm

    #567676

    On the computer in question go to Computer Management | Services (right click My COmputer and select Manage).

     

    If you have a default instance of MSDE look for:

    MSSQLSERVER --> for the SQL Server service

    If you have a named MSDE instance look for:

    MSSQL$MASTERDBA --> for the SQL Server service, MASTERDBA is the named instance in this example.

     

    In either case check that the 'status' column reads started.

     

    As for remote connection, I've seen some MSDE packages that change the 'sa' password to some ungodly string, others do not. Some lock out Builtin/Administrators, some do not. To find out the sa password contact the vendor, however, some just will not give it out. In that event get together with a Windows Admin try the Bjuiltin/Administrators login with integrated security (if they have not turned it off !).

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • July 6, 2005 at 9:02 am

    #571292

    How do you check services from the command line?

  • July 6, 2005 at 9:25 am

    #571311

    sc queryex "servicename"

    and check column STATUS

     


    * Noel

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply