Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:
Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).
If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
[quoted text, click to view] <gregory.white@ntlworld.com> wrote in message
news:1164820093.256855.318050@14g2000cws.googlegroups.com...
>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 :-)
>
