Post reply

accessing SQL server from 3rd party application

  • July 26, 2011 at 11:14 pm

    #244859

    Hi All,

    I have some 3rd party tool installed on 32 Bit Windows server.In the tool i have pointed shared SQL server to write data.I am using sql server authentication.

    when i tried to connect to database it says unable to connect.

    But the same kind of setup is working on my local machine.

    I have used profiler to trace the login host name. My local machien is getting logged but not even a single connection made from the server.

    How do we debug this please help me.

  • July 27, 2011 at 6:33 am

    #1359161

    is your instance an "Express" instance?

    by default, an express isntance does not allow remote connections...meaning you can work just fiine locally, but nothing can connect to your machine until you change that default setting:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

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