February 8, 2012 at 10:48 pm
HI,
we have installed SQL 2008 on server 2 and application is installed on server 1.
We are able to create DB using our application using SQL credentials on remote server, but if we try to create DB on remote server using windows authentication we are encountering following error.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
the windows credentials are domain Admin users, also added as the machine admin group.
We are able to created DB with our application using windows authentication (domain user) on same server.
February 9, 2012 at 1:40 am
Open a command prompt on the server and type:
ECHO %USERNAME%
Is the username correct? Great, go on and connect to SQL Server using SQLCMD:
SQLCMD -Syourservername -E
Does this work?
-- Gianluca Sartori
February 9, 2012 at 1:53 am
nope the server name is showing as administrator not the domain user. do i need to login as domain user.
February 10, 2012 at 7:29 am
Q. Are they in the same domain, if not does one domain trust the other?
"We never plan to Fail, We just fail to plan":)
February 10, 2012 at 7:37 am
shahid_jambagi (2/9/2012)
nope the server name is showing as administrator not the domain user. do i need to login as domain user.
So, where's the problem? Log off, log in as domain user and start SQLCMD.
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply