March 25, 2014 at 9:13 pm
I have a 2012 SQL server. If I am on another machine on the nextwork and run SSMS to login to that server, I can. If I am on the server machine, i can't login w/Windows authentication.
I am a domain admin and enterprise admin. What is wrong?
Mike
March 25, 2014 at 9:28 pm
Hello,
Do you have same login to this server like you logon on another machines ?
Because I have another login on my pc to domain than on SQL server.
login i mean Windows login to domain
So there can be problem that you have windows authentication just for your login
March 25, 2014 at 9:34 pm
My domain login gets me on the machine. I can add files via File Explorer/Windows Explorer. But I can't create a bak file in that same directory. "Access denied".
March 25, 2014 at 9:55 pm
mike 57299 (3/25/2014)
My domain login gets me on the machine. I can add files via File Explorer/Windows Explorer. But I can't create a bak file in that same directory. "Access denied".
I think that will be better logon with login from this server, which is administrator there. Directly on this server. You can check right click to computer > manage > and Local_users and Groups ...
March 26, 2014 at 3:16 am
Have you added that login [yourdomain\yourusername] to the logins in SSMS?
March 26, 2014 at 10:42 am
mike 57299 (3/25/2014)
I have a 2012 SQL server. If I am on another machine on the nextwork and run SSMS to login to that server, I can. If I am on the server machine, i can't login w/Windows authentication.I am a domain admin and enterprise admin. What is wrong?
Mike
Are you using same ID from another machine and the server both ? Or are you using SQL Authentication from another machine instead of your AD ID ?
--
SQLBuddy
March 26, 2014 at 2:38 pm
mike 57299 (3/25/2014)
I have a 2012 SQL server. If I am on another machine on the nextwork and run SSMS to login to that server, I can.
1. What windows account are you using to login (RDP?) on the other machine?
2. Do you connect to the SQL 2012 Instance with SSMS using Windows Integrated security or are you using a SQL account?
If I am on the server machine, i can't login w/Windows authentication.
3. What windows account are you using to login (RDP?) on this Windows server with SQL 2012 installed?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply