Impossibly remote connections to SQL 2005 express

I have spent the best part of 4 days trying to connect to SQL 2005
express from an winforms app! Yes , I have checked surface config and
TCP/IP blah blah ...

I have trawled the net and spent countless hours on MSDN and many have
tried to help. I have changed the passwords to strongly typed... I have
recreated the login a zillion times,mapped to different databases ,
checked firewall settings, switched off firewall...tried different
database roles, run every possible sp I can find.....attached the
database using the connection string, attached using management studio
and changing the connection string back, tried every possible
connection string I can find, pored through the logs at evry turn ...

Then i did it all again and again and again.

Has anybody managed to connect from an application ever.. (excuse the
cynicysm but I am at wits end)

The best error has to be this one proclaiming success and failure all
at the same time:

2006-11-28 22:00:24.46 Logon Login succeeded for user 'FJUser'.
Connection: non-trusted. [CLIENT: 192.xxx.x.x]
2006-11-28 22:00:24.46 Logon Error: 18456, Severity: 14, State: 16.
2006-11-28 22:00:24.46 Logon Login failed for user 'FJUser'. [CLIENT:
192.xxx.x.x]

Makes my confusion a little more bearable :-)

.

Relevant Pages

  • Impossibly remote connections to SQL 2005 express
    ... I have trawled the net and spent countless hours on MSDN and many have ... database using the connection string, ...
    (microsoft.public.sqlserver.connect)
  • Impossibly remote connections to SQL 2005 express
    ... I have trawled the net and spent countless hours on MSDN and many have ... database using the connection string, ...
    (microsoft.public.sqlserver.clients)
  • Re: Creating Forms is tedious
    ... wished the original writer had spent a lot less time making the ... but forms and other database objects ... >that appear sloppy often are sloppy. ... >wizards, and other fluff, and so have made it far more ...
    (microsoft.public.access.forms)
  • Re: PHP site development
    ... Having spent lots of time in the database world, I must say that I relate ... > which identifies a development environment based on the 3 tier architecture. ... > possible to build and maintain web components with much less effort. ...
    (comp.lang.php)
  • Access to Visual Basic Conversion???
    ... Currently, I am using Access 2003, but the database is ... If I printed all the VB code behind the forms and reports, ... I spent some time looking into this an had decided on ... time consuming. ...
    (microsoft.public.access.formscoding)