July 22, 2008 at 1:22 pm
valid logon server access failure??
I keep getting this error for a windows group. The group has connect on the server and datareader/datawriter on the db it is connecting to.
If i assign it sysadmin role, it works fine. Remove sysadmin and logon failure occurs.
I am stumped and there is not much on MS site or internet about it.
July 22, 2008 at 1:52 pm
Are you getting it for any other Windows user or group? Can you get a test Windows user setup for you to experiment with? Do you have another SQL Server where you can test?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 23, 2008 at 5:34 am
Jack,
Found my own answer.
Very obscure setting was not there.
instance
security
roles
public
properties
permissions
Securables
(TSQL Default TCP Endpoint) was not there
added it and granted connect permissions
no more problem
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply