March 30, 2015 at 10:15 am
Hello,
i am a SQL rookie and in need of help. I had to re-install SQL2008R2 and restored the master from a backup I had previous to losing my old server.
I was able to restore the databases but cannot login with the windows user account I had previously. This user is very critical as it is used for replication .
Steps taken: Created the user in windows ; Repluser
Created the user in SQL2008 with both SQL and windows authentication (using the same password). repluser
this user can connect to SQL, control server, authenticate server , create any database
I still cannot login to SQL server. HELP
March 30, 2015 at 11:31 am
Did you try 'sp_help_revlogin'?
March 30, 2015 at 12:54 pm
Can you provide more details on what error are you getting?
Can you check the SQL Server error logs as well for more details?
March 30, 2015 at 3:45 pm
Error from SQL log:
Login failed for use 'adhoc2\adhoc_repl' reason: Token-based server access validation failed with an infrastructure error. Check for previous errors: {CLIENT:<local machine>}
March 30, 2015 at 6:20 pm
This looks like an AD error. Please contact your system administrator and provide the error info and they should be able to rectify the issue....
Dropping the login and re-creating it would do it in some scenarios... or running the SSMS as an Admin will do the job...
Also, please take a look into the below articles....
http://www.sqlservercentral.com/Forums/Topic644009-6-1.aspx
Hope this helps!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply