Solved

Sql server issue

Posted on 2014-10-30
3
311 Views
Last Modified: 2014-10-31
Hi

When im run sql server 2008R2 following code below working come with results
  xp_logininfo 'Domain\Username'

But when im run same command in the SQL server 2014 its showing Errors.Can any one show me where i have to to any implements.


Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 72
Could not obtain information about Windows NT group/user 'Domain\Username', error code 0x6e.
0
Comment
Question by:ukerandi
[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
  • 2
3 Comments
 
LVL 81

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 40414959
try running the sql server service as a domain user rather than localsysem or networkservice
0
 
LVL 10

Author Comment

by:ukerandi
ID: 40415451
I have Administration privilages for SQL server, its ok to run as a My Login Name?
My login name format is
{Domain]\Myusername
0
 
LVL 10

Author Closing Comment

by:ukerandi
ID: 40416750
Thanks
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Uncontrolled local administrators groups within any organization pose a huge security risk. Because these groups are locally managed it becomes difficult to audit and maintain them.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

717 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