SQL Server Error: 1326

[rsbutterfly16]

hi guys, i am trying to connect to my backend tables in sql server 2000 from my front end access database and i keep getting this error message:

Connection Failed:

SQLState: 01000

SQL Server Error 1326

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile())

Connection Failed:

SQLState 08001

SQL Server Error: 1326

[Microsoft][ODBC SQL Server Driver] Client unable to establish connection

After doing research for this error message i saw that it could be something with the MDAC version so i ran my component checker:
for my client computer is MDAC 2.8 SP1 on windows xp sp2 , when i checked my server is MDAC 2.8 RTM. Can this be the problem? if not what else could it be? any help will be greatly apreciate it.

 

[mrdenny]

Please check out this FAQ faq962-5481 and post the answers to the questions in it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[rsbutterfly16]

Thanks! i solved there was an issue in how the user was created in active directory. thanks for all your help.