Re: Impossibly remote connections to SQL 2005 express
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Wed, 29 Nov 2006 11:22:55 -0800
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
<gregory.white@xxxxxxxxxxxx> wrote in message
news:1164819977.653122.170830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 :-)
.
- References:
- Impossibly remote connections to SQL 2005 express
- From: gregory . white
- Impossibly remote connections to SQL 2005 express
- Prev by Date: Impossibly remote connections to SQL 2005 express
- Next by Date: Backup/restore msdb to new server
- Previous by thread: Impossibly remote connections to SQL 2005 express
- Next by thread: Backup/restore msdb to new server
- Index(es):
Relevant Pages
|
