[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL SERVER 2008

Posted on 2011-05-10
15
Medium Priority
?
201 Views
Last Modified: 2012-06-21
..."Login failed. The login is from an untrusted domain and cannot be used with Windows authentication"...

WIN2008 R2 = DomainControler (DC)

WIN2008R2 = Cliente With SQLSERver2008

Give that error....
0
Comment
Question by:Aquinos
  • 8
  • 3
  • 3
  • +1
15 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 35730645
Are the on the same domain?
0
 
LVL 10

Expert Comment

by:GlobaLevel
ID: 35730678
how are you connecting..by what device..mobile..? check the sql connection string make that trusted security = true is there...

maybe this?
http://stackoverflow.com/questions/858678/sql-server-2008-login-failed-the-login-is-from-an-untrusted-domain-and-cannot
0
 

Author Comment

by:Aquinos
ID: 35730769
@acko72:
Yes! both in same domain.....
with a clean installation


@GlobaLevel:
In the installation with one account with admin privileges...
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
LVL 29

Expert Comment

by:Paul Jackson
ID: 35730860
PLease explain exactly what it is you are doing when this error occurs.
0
 
LVL 10

Expert Comment

by:GlobaLevel
ID: 35730905
did you try to create a SA account...?
0
 

Author Comment

by:Aquinos
ID: 35730920
In the instal
it gives that error....


See the attachment
Error-SQL.gif
0
 

Author Comment

by:Aquinos
ID: 35730935
With an SA account it gonna be ok....

However i need that the Domain NT Accounts  access the Datacenter at the future......
0
 
LVL 10

Expert Comment

by:GlobaLevel
ID: 35731142
the SQL install/app sits on a bunch of stuff..did you verify all the way through...that your server is ready to recieve the isntall?

that being said...an example would be:
r u running VM on this machine..could be a problem with the network device...you may need to reinstall the OS..if that is the case...
0
 

Author Comment

by:Aquinos
ID: 35731260
If I install with The Administrator (DOmain or local) account
It gives me no error....

And yes it's the 2 server virtualized
0
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 35732261
MAke sure your account isn't locked out
0
 

Author Comment

by:Aquinos
ID: 35732496
Is not!
If was locked out, i can't login and can't start the installation...
However, with that account i can't ping or access other machines on the network.
Maybe was a problem in the standard gpo...
But how could i reset that gpo with policie!?
Its a confusion.... All of that!

0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35735581
Please make sure user has no limited access..
0
 

Author Comment

by:Aquinos
ID: 35735621
The user could install app!
Add local users
Have permissions for everything.

But misterously can't ping other machines or access them in the network.
0
 

Accepted Solution

by:
Aquinos earned 0 total points
ID: 36478425
PROBLEM AT VIRTULIZATION ID
THE DOMAIN HAVE THE SAME ID AS AS SQL SERVER

NEW SERVER INSTALLATION  AND WORKS OK.
0
 

Author Closing Comment

by:Aquinos
ID: 36501237
WORKING WITH THE ACCEPTED SOLUTION
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

834 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