Results 1 to 6 of 6
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Error signing on to SQL Server (Access 2003 SP2)

    I now have a problem signing to SQL Server using SQL Servr Management Studio Express.
    I have deleted a database and created one a few times, then removed SQL Servr Management Studio Express then reinstalled it.

    I still get the error.
    Attached Images Attached Images

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error signing on to SQL Server (Access 2003 SP

    Hi Pat

    Have a look here, it appears to have quite a comprehensive answer to Error 26

    http://www.aquesthosting.com/HowTo/S...QLError26.aspx
    Jerry

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error signing on to SQL Server (Access 2003 SP2)

    Hi Pat,
    Is your SQL Browser service running? You can check it the same way you checked if SQL Server itself was running <post:=699,432>post 699,432</post:>
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Error signing on to SQL Server (Access 2003 SP2)

    When i go into the SQL Server Configuration manager i see that:
    SQLServer (SQLExpress) is running
    SQLServer Browser is stopped

    After a lot of mucking around, igot the SQServer Browser started, and that fixed it.

    Thank youfor your help again.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Error signing on to SQL Server (Access 2003 SP

    Hi Jezza, thank you for the info, I have included their fix for sql 2005 which is:
    SQL Server 2005 Open SQL Server Configuration Manager. Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols you need.
    I have started the TCP/IP protocol.

    Check my reply to Gary, it turned out to be the SQL Server rowser that was stopped.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error signing on to SQL Server (Access 2003 SP

    Great result

    Just as a secondary reference for others with similar problems. This is a good reference

    http://technet.microsoft.com/en-us/l.../ms181087.aspx
    Jerry

Posting Permissions

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