Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database permission Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 9:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:27 PM
Points: 138, Visits: 369
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
Post #1554754
Posted Tuesday, March 25, 2014 9:28 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:15 PM
Points: 175, Visits: 515
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
Post #1554755
Posted Tuesday, March 25, 2014 9:34 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:27 PM
Points: 138, Visits: 369
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".

Post #1554756
Posted Tuesday, March 25, 2014 9:55 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:15 PM
Points: 175, Visits: 515
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 ...
Post #1554759
Posted Wednesday, March 26, 2014 3:16 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 498, Visits: 1,842
Have you added that login [yourdomain\yourusername] to the logins in SSMS?
Post #1554833
Posted Wednesday, March 26, 2014 10:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:28 PM
Points: 1,194, Visits: 2,219
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
Post #1555082
Posted Wednesday, March 26, 2014 2:38 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:48 PM
Points: 2,305, Visits: 2,782
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?


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1555169
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse