Results 1 to 7 of 7

Thread: Unable to connect to sqlserver2005

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Mar 2007
    Posts
    82

    Unable to connect to sqlserver2005

    Hello

    I am new to SQL Server 2005 database and I can't connect to the server on the web, it works only on localhost.

    I am using ADO and the connection string looks like this

    Driver={SQL Native Client};Server=ServerIP\SQLEXPRESS;Database=DatabaseName;Trusted_Connection=yes;

    When trying to connect I get the following error:
    [Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified[xFFFFFFFF].

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Unable to connect to sqlserver2005

    If it can't locate it then I would submit you connection string is in error.

  3. #3
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Unable to connect to sqlserver2005

    Verily, I submit the same as my partial-namesake brother here. Check if you have the correct server name. The correct instance name. Firewall connections.

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Mar 2007
    Posts
    82

    Re: Unable to connect to sqlserver2005

    The server name is OK...there's something else wring but I really can imagine what.....
    Cound there be a problem in the sql server configuration?

  5. #5
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Unable to connect to sqlserver2005

    Can you check the configuration in SQL Server Surface Area Configuration?

  6. #6
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Unable to connect to sqlserver2005

    Is it setup to allow remote connections?

  7. #7
    Member Walter_Ego's Avatar
    Join Date
    Jun 2004
    Posts
    50

    Re: Unable to connect to sqlserver2005

    is the SQL Browser service running?

Posting Permissions

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



Click Here to Expand Forum to Full Width