SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database permission


Database permission

Author
Message
mike 57299
mike 57299
SSC Veteran
SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)

Group: General Forum Members
Points: 209 Visits: 507
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
tony28
tony28
SSChasing Mays
SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)

Group: General Forum Members
Points: 614 Visits: 889
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



How to post data/code on a forum to get the best help: Option 1 / Option 2
mike 57299
mike 57299
SSC Veteran
SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)

Group: General Forum Members
Points: 209 Visits: 507
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".
tony28
tony28
SSChasing Mays
SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)

Group: General Forum Members
Points: 614 Visits: 889
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 ...



How to post data/code on a forum to get the best help: Option 1 / Option 2
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2696 Visits: 4391
Have you added that login [yourdomain\yourusername] to the logins in SSMS?
sqlbuddy123
sqlbuddy123
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2362 Visits: 2243
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
HanShi
HanShi
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4373 Visits: 3668
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’! **
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search