Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    2

    Unanswered: SQL 2005 EXPRESS Remote Connectio Problem

    After installing MSSQL EXPRESS 2005 (on Server 2003 Std. OS) there was no problem when connecting to MS SQL server remotely via Visual Basic 2005 or MS Access.
    But after updating SP2 I can't connect to it from another computer in no way any more.

    I'm getting error message:
    SQL server error: 10061
    SQL server error: 17

    May sameone has some ideas ???

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Have you checked http://blogs.msdn.com/sql_protocols/...14/492616.aspx? It seems like SQL Server Express is not listening for remote connections.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    May 2007
    Posts
    2
    Thank you. This is not the case. After installing MS SQLEXPRESS I'v enabled remote connections and everything was OK. But after installing MS SQLEXPRESS SP2 I can't connect to it even localy from any program except Management console. Definitely the problem caucsed installation of SP2 (after reinstalling MS SQLEXPRESS without updating to SP2 everything is OK).

Posting Permissions

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