Connection failed

Hello, I'm trying to set up a New Data Source to SQL Server through ODBC and
am getting the following error message after trying to supply correct SQL
Login ID and Password:
Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'xxxxxxxxx'
Any help would be appreciated. Thanks.
Just for kicks, try to connect to SQL Server via Query Analyzer using that
login and password
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"zz12" <IDontLikeSpam@.Nowhere.com> wrote in message
news:ujWBaRJWIHA.5816@.TK2MSFTNGP06.phx.gbl...
> Hello, I'm trying to set up a New Data Source to SQL Server through ODBC
> and am getting the following error message after trying to supply correct
> SQL Login ID and Password:
> Connection failed:
> SQLState: '28000'
> SQL Server Error: 18456
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'xxxxxxxxx'
>
> Any help would be appreciated. Thanks.
>
|||Kind of strange in that after a while with really no changes it ended up
working. We were trying it from a wireless laptop first which then we
physically plugged in the network cable into the laptop and still didn't
work...but after about 10 minutes later the same steps did allow the ODBC
setup to finish logging in successfully. Kind of weird but I'm not
complaining.
Thanks a bunch for your speedy reply Kevin. Much appreciated. Take cares
:-)
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:u1L2GKTWIHA.2304@.TK2MSFTNGP06.phx.gbl...
> Just for kicks, try to connect to SQL Server via Query Analyzer using that
> login and password
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "zz12" <IDontLikeSpam@.Nowhere.com> wrote in message
> news:ujWBaRJWIHA.5816@.TK2MSFTNGP06.phx.gbl...
>