?
Solved

Login failed for user ".  The user is not associated with a trusted SQL Server connection

Posted on 2010-11-29
5
Medium Priority
?
421 Views
Last Modified: 2012-05-10
There are two servers:  db1 and db2.  They are remote to us and I'm sure a firewall is involved.  They also use a domain and windows authentication for us to connect to.  We also have an account that the web server uses, we can also try to connect with (username/password).  Several of us users are able to connect and work normally with db2.  However, all of us are having connection issues with db1.  

It's intermittent, though:

Sometimes I can connect to db1 and run a query (using Windows Authentication), or use the SQL Server Management Studio and explore the databases, but other times it hangs and I get the error (in the title).  It may switch within seconds.  When it does retrieve data, it is fast and doesn't skip like it would with packet loss.  (I do not believe packet loss is the issue here.)

To db1, I can never connect using the username/password, however the web server always can.  I can always connect both ways to db2 without issue.

The database administrator verifies that other people are able to connect OK, and that our accounts are not blocked or locked.  He can see in the logs where we attempt to connect (by our IP).  He says it does not appear to be anything on his end.  We think there is nothing that is on our end (since we can connect to db2 just fine, which is essentially in the same location).

What could be causing this?  Some closed obscure port on a firewall?
0
Comment
Question by:InkEye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 34237780
There's a similar question with solution. Check if it applies to your problem:
http://www.experts-exchange.com/Database/Miscellaneous/Q_21868099.html

Good luck
0
 

Author Comment

by:InkEye
ID: 34238953
I think his situation is somewhat different:  In our case, there are other users in other remote locations that apparently are connecting without issue.  In my case, I can connect only sometimes, and even after I have connected it may randomly perform functions/queries (or not).

Yet, on the other server, it always works fine.

The thinking is that perhaps the firewall at their end has blocked a range of ports for the first db server, but not all the ports.  Thus, depending on what ports are available, I am able to connect.  But this doesn't explain everything.
0
 

Accepted Solution

by:
InkEye earned 0 total points
ID: 34276461
The answer became somewhat clear(er).  After ruling out any firewall issues, the DBA was able to duplicate the problem.  After a hard reboot (which was not a simple matter), the problem was apparently solved.  However, the next day, the 2nd database server (which was fine) was now experiencing the problem.  After close examination, it was discovered that several services had not started.  (I don't know which ones, but possibly something having to do with a domain controller might have been involved.)  DBA started the necessary services, and everything works fine.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 34282182
That's great :)

Cheers
0
 

Author Closing Comment

by:InkEye
ID: 34308624
I really had nothing to do with the solution, though.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question