Posted by: wajahatabbas | December 6, 2010

Untrusted domain SQL Server 2008 r2 SharePoint

ERROR “Unknown SQL Exception 18452 occured. Additional error information from SQL Server is included below. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.”

This error took my whole day.

This error comes whenever we try to login SQL server from other machine, like SharePoint machine or if we define this user id during Sharepoint configuration wizard.

I am on SharePoint migration project, and this appears whenever i wanted to access SQL Server 2008 r2 instance from a domain account.

We thought that it is something related to firewall policy, we open the TCP 1433 & UDP 1434 port. But nothing get works.

You will be surprise to know that, the only thing left,, which we made correct and it started working was that SQL Server 2008 R2 server machine time setting was different. The server time was changed from other server machine like SharePoint server. We just ask the Network guy, who installed the Network time service.

After that it started working.

Advertisements

Responses

  1. this very informative blogs about sharepint sql nd these tips are working…i like your every blogs.thanks to you for sharing this information.

  2. Thanks for another informative site. Where else could
    I get that kind of information written in such a perfect manner?
    I’ve a venture that I am just now running on, and I’ve been
    on the look out for such information.

  3. I pay a quick visit daily a few web pages and information
    sites to read articles, however this web site presents quality based articles.

  4. Very good blog post. I absolutely love this website.
    Thanks!

  5. Hey! This is my 1st comment here so I just wanted to give a quick shout out
    and tell you I truly enjoy reading your blog posts.
    Can you suggest any other blogs/websites/forums that go
    over the same subjects? Many thanks!

  6. Link exchange is nothing else but it is simply placing the other person’s website
    link on your page at proper place and other person will also do similar in support of you.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: