Login failed for user '(null)'. Reason: Not associated with a trusted

[mflancour]

We've been experiencing a strange error withe sql server 2000/2005. Usually happens if I leave my computer logged in over night. I'll be working in management studio running querys agains verious servers with no problem. I come in the next day and try to run the exact same queries and get:
Login failed for user '(null)'. Reason: Not associated with a trusted

If I log off of windows and back on again it will be fine again.


As far as i can tell it's a windows bug that can be circomvented by using sql logins instead of windows auth. Problem is, we shouldn't have to do that. Anyone ran into this and know how to fix it perminatly?

 

[mrdenny]

Sounds like your machine or the SQL Server is having problems talking to the domain controllers. Are they rebooted nightly or something crazy like that?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mflancour]

no
it's like the login expires after some time.

 

[mrdenny]

It shouldn't be. What's the the Application Log and System Log of your Workstation and the SQL Server?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mflancour]

it's not something that is limited to one server. it's accross all servers.

 

[mrdenny]

Then it's either a Workstation issue or a domain issue. Is it all workstations or just one workstation?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mflancour]

All workstations

 

[mrdenny]

Then isn't an issue with the Windows Domain. Have your sysadmin check the application logs on the domain controllers.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com