Can't use system DSN to log user on

HI,
I have attempted to connect a user to a SQL 2000 server, running on a
Windows 2000 server using Windows Authentication and always get the
follwoing error message:
Connection failed
SQLstate:'28000'
sql server error: 18456
[microsoft][odbc sql server driver][sql server] login
failed for user "Domain\user1"
Can anyone explain to me why this is happening? I've looked at the
SQL Server Agent Properties and on the Connection tab it specifies use
Windows Authentication, but yet I can't get any Domain user to connect
to the server'!
Thanks,
ArtHi,
You have to give that domain user to authenticate to SQL Server.
1. Login to SQL Server using Query analyzer with a user with sysadmin role
2. Execute the below commmands:-
sp_grantlogin '[domainname\Groupname]'
eg:
EXEC sp_grantlogin '[Finance\RPTGROUP]'
Command to give access previlage to the user to database.
sp_grantdbaccess '& #91;domainname\Groupname]','user_name_in
_database'
Eg:
use dbname
go
EXEC sp_grantdbaccess '[Finance\RPTGROUP]','RPTGROUP'
After this login to domain user and tr to create the system DSN.
Thanks
Hari
MCDBA
"Art Billings" <abillings@.principle-tech.com> wrote in message
news:8c11e0tjdn66knipdut4te4vnb92e8gbtj@.
4ax.com...
> HI,
> I have attempted to connect a user to a SQL 2000 server, running on a
> Windows 2000 server using Windows Authentication and always get the
> follwoing error message:
> Connection failed
> SQLstate:'28000'
> sql server error: 18456
> [microsoft][odbc sql server driver][sql server] login
> failed for user "Domain\user1"
> Can anyone explain to me why this is happening? I've looked at the
> SQL Server Agent Properties and on the Connection tab it specifies use
> Windows Authentication, but yet I can't get any Domain user to connect
> to the server'!
> Thanks,
> Art|||Thanks for the response to my query. Didn't expect one, so that was a
pleasant surprise. We worked it out, turns out that the Domain Users
group had not been given expicit access to any of the databases. Once
we configured that, then allowed them public access and execute rights
on the stored procedure we were developing, everything worked as smooth
as silk. Imagine that!!
Thanks again!
Art
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!