Results 1 to 12 of 12

Thread: Please help

  1. #1
    Join Date
    Oct 2012
    Posts
    7

    Unanswered: Please help

    First, I am in sales for a cheap company that is running MS SQL 2000 with windows XP. I am having trouble logging in to the server. It never starts from my workstations, other workstations, no problem. When I hover the mouse over the icon on the bottom it says "Unknown- \\ - MSSQL Server". when I right click and I enter the server is says "access denied". When I try to refresh services I get the same message. Thanks!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I am not sure, but there may be one problem, and one red herring here. When you "log into the server", do you use one of the SQL Server tools, or is it a desktop application (i.e. something that does not have "SQL Server" in the title bar)?

    If you open the services applet (control panel ->administrative tools->services), do you see an MSSQLServer service?

  3. #3
    Join Date
    Oct 2012
    Posts
    7
    MSSQL$MICROSOFTSM BIZ is started and set on automatic. I can stop and then restart with no issues.

    MSSQL ServerADHelper does not start and gives an error message when I try to start it.
    10/04/12 08:38:37 spid 0 Exception 0xc00000fd EXCEPTION_STACK_OVERFLOW at 0x004027B3
    10/08/12 08:35:46 spid 0 Exception 0x400042ac PRINTSTACK at 0x7C812AFB

    SQLAgent$MICROSOFTSMBIZ starts automatically.

    Okay, I found the error log. Take it easy on me, I am in shrimp sales not DBM.
    2012-10-10 13:15:30.83 server Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)
    Dec 16 2008 19:46:53
    Copyright (c) 1988-2003 Microsoft Corporation
    Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 3)

    2012-10-10 13:15:30.83 server Copyright (C) 1988-2002 Microsoft Corporation.
    2012-10-10 13:15:30.83 server All rights reserved.
    2012-10-10 13:15:30.83 server Server Process ID is 3120.
    2012-10-10 13:15:30.83 server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\LOG\ERRORLOG'.
    2012-10-10 13:15:30.87 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
    2012-10-10 13:15:31.67 server SQL Server configured for thread mode processing.
    2012-10-10 13:15:31.70 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
    2012-10-10 13:15:32.13 spid3 Starting up database 'master'.
    2012-10-10 13:15:33.17 server Using 'SSNETLIB.DLL' version '8.0.2039'.
    2012-10-10 13:15:33.17 spid5 Starting up database 'model'.
    2012-10-10 13:15:33.27 spid3 Server name is 'VOSTRO200-EVAN\MICROSOFTSMLBIZ'.
    2012-10-10 13:15:33.27 spid3 Skipping startup of clean database id 4
    2012-10-10 13:15:33.27 spid3 Skipping startup of clean database id 5
    2012-10-10 13:15:33.27 spid3 Starting up database 'WeeklyBLAST'.
    2012-10-10 13:15:33.97 spid5 Clearing tempdb database.
    2012-10-10 13:15:33.99 server SQL server listening on Shared Memory.
    2012-10-10 13:15:33.99 server SQL Server is ready for client connections
    2012-10-10 13:15:36.18 spid5 Starting up database 'tempdb'.
    2012-10-10 13:15:36.93 spid3 Recovery complete.
    2012-10-10 13:15:36.93 spid3 SQL global counter collection task is created.
    2012-10-10 13:15:37.44 spid51 Starting up database 'msdb'.
    2012-10-10 13:15:39.57 spid51 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Are you a SQL Server Administrator, or a user?

    Does your company use Active Directory?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Oct 2012
    Posts
    7
    Hi Pat. Thanks for your time. I am a user. I have no DB experience at all. I am sure no one here knows the answer to that using an active directory. How can I find out?

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    OK, so the local SQL Server starts up with no problems. The icon in your systray (usually bottom right of the screen along with the clock) is looking for a default instance, but SQLExpress is usually installed as a named instance (as in this case). Since there is no default instance, the icon in the systray is confused. If you right click and open it, you will likely be able to see the MICROSOFTSMBIZ instance in the dropdown list.

    No, as for the login failure, do you happen to know if the application you are using is looking for the database server local to your desktop machine (unlikely), or is it looking for a central server? Another way to look at the question is can other people see the same data you are looking at, or are all of you working off of your own personal data stores?

  7. #7
    Join Date
    Oct 2012
    Posts
    7
    Thanks for your help. We are all looking at the same data.

  8. #8
    Join Date
    Oct 2012
    Posts
    7
    When I right click on the icon on the lower left and try to connect to the server I get the error "This service control action cannot be completed as no service has been selected" but the service section does not populate. When I click on refresh services I get error "access is denied"

  9. #9
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Since you are all looking at the same data, there is likely a single server that holds all the data, and I will guess it is not one of the desktop machines.

    How long does it take from the moment you hit the login button to the time you get the error message? If it is about 20 - 30 seconds, you may have lost network connectivity to the database server. If it is really fast, then there is something going on with the username or password you are using. Here, I am also assuming that everyone else is having no trouble getting to the data.

  10. #10
    Join Date
    Oct 2012
    Posts
    7
    Thanks for your time. It is instant. There is another server that I connect with okay.

  11. #11
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    An instant error usually means that the username or password is incorrect, or you no longer have access defined on the server. If you have any IT guys, they may be able to use SQL Profiler to determine what the actual cause is.

  12. #12
    Join Date
    Oct 2012
    Posts
    7
    Bizarrely, it connected this morning with no problem after about 101 tries. So thank you for your time. No idea what happened.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •