Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sql Server/query analyzer Authetication
- Thread starter jeyasee
- Start date
timscronin
MIS
Steps
1.Can you ping the SQL Server, and can you connect using SQL Connection not NT?
2.To use NT Authentication, you must be added as part of an NT group or a NT login in SQL Server, and given permissions to do this. Check this out as next step.
3.Check you client tools configuration on you box and have tcp/ip and multi-protocol selected.
4.Does you NT domain use DNS, if not you might have to add the IP address to a lmhosts file
1.Can you ping the SQL Server, and can you connect using SQL Connection not NT?
2.To use NT Authentication, you must be added as part of an NT group or a NT login in SQL Server, and given permissions to do this. Check this out as next step.
3.Check you client tools configuration on you box and have tcp/ip and multi-protocol selected.
4.Does you NT domain use DNS, if not you might have to add the IP address to a lmhosts file
- Status
Similar threads
- Locked
- Question
- Locked
- Question