April 24, 2007 at 9:32 am
Which instance was he trying to connect to? How did you grant him login rights to the SQL Server?
K. Brian Kelley
@kbriankelley
April 24, 2007 at 9:50 am
He was trying to connect to the default instance (servername only). I gave him permissions first through Enterprise Manager, then tried giving it using T-SQL and Query analyzer. Neither worked even though both times I could see his login in the database sysusers table.
April 24, 2007 at 10:11 am
And you could see his login in sysxlogins? If so, was he denied access for some reason, such as a particular Windows group he was a member of being denied access?
K. Brian Kelley
@kbriankelley
April 24, 2007 at 10:18 am
Yes, he was in sysxlogins too. I don't have access denied to any particular Windows group - I just grant access on this server to the individual developers based on the database they are using. Doesn't make sense but I had the same problem with a second developer. Again, when I grant sysadmin rights it works fine. I thought it might be because of the instances since this is the only server I have that uses named instances.
April 24, 2007 at 2:49 pm
It's not a named instance thing. Something else is going on. Anything in the server application, security, or system event logs which seem to correlate? What about the SQL Server log?
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply