Post reply

Report wizard "test connection" succeeds, but "a connetion cannot be made to the database".

  • July 8, 2008 at 6:19 am

    #189222

    This is a strange one... a user contacted me for help connecting to a SQL Express instance using the report wizard from BIDS. The datasource settings look right to me, user has appropriate access, and when she does "test connection" from the wizard, she gets a successful response. When she clicks "Next" however, she get's "A connection can not be made to the database".... anyone seen something like this before?

  • July 8, 2008 at 12:14 pm

    #839713

    Wow... ok- maybe this will stir a response:

    SQL express is listening on Port 1860... SQL Browser service IS running. I can connect to the DB from another server which is on the same subnet... users are NOT on the same subnet... do I need to specify the port or something in the connection string?

    REally at a loss as to how the connection could test successfully, and still give "cant connect to the database"... any thoughts would be appreciated.

  • July 9, 2008 at 1:10 am

    #839901

    Try changing port in ODBC from 1860 to 1433 [sql2000 default]

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

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