Impossibly remote connections to SQL 2005 express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gregory.white@ntlworld.com - 29 Nov 2006 17:06 GMT

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 :-)

Reply to this Message

Arnie Rowland - 29 Nov 2006 19:22 GMT

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.

Signature

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

>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
[quoted text clipped - 24 lines]
>
> Makes my confusion a little more bearable :-)

Reply to this Message