Friday, 15 February 2013

Intermittent connection to SQL server database. “The login is from an untrusted domain and cannot be used with Windows authentication” -


I have to add some random interoperable issues to a database that is running on a SQL Server 2008 instance, which is a Active Directory 2003 domain is just starting to do all of a sudden, all workstations are Windows 7 Professional 32 bits, and Eddie Domains is a server 2003 domain controller.

There is no clear error, its completely intermittent, and if the workstation is rebooted some time then it will not connect properly, no problem. This is not just a workstation, it randomly happens for other workstations, there is no clear mistake in network setup, they are running through the Cisco GB switch on the GB network connection, all other Windows features and networks There is no problem with the drives.

The SQL Server is running from Dell on a very new 64 bit hardware, so this is not a hardware issue. It's okay for a while, and this random connection problem has just started recently. Can this be the size of the database? The MDF file developed as 32 GB, and the log file size has a very large 135 GB

Any help would be appreciated

Post-text "itemprop =" text ">

It is very difficult to understand what the problem can say, so I think you need to do some more investigation (this may be your DNS, AD, ETC, ).

There is a feature to check the connection issues called Connectivity Ring Buffer in SQL Server 2008

more information can be found


No comments:

Post a Comment