From: AJ on 2 Jul 2010 11:04
I'm recieving the error "Logon Failed For User". Everything looks right to
me, so I am unsure what could be wrong.
Here is the connection string I am using in my vb code:
The SQLExpress version is 2008 R2.
Can you think of anything I should check besides the user account and
password, which seems fine? I am able to connect to the database just fine
with my windows authentication.
It is a newly created database that I imported from another server to my
From: Dan Guzman on 5 Jul 2010 12:57
> Can you think of anything I should check besides the user account and
> password, which seems fine? I am able to connect to the database just
> with my windows authentication.
> It is a newly created database that I imported from another server to my
> local computer.
Check to ensure the instance is configured to allow both SQL and Windows
Authentication. By default, only Windows Authentication is permitted.
Hope this helps.
SQL Server MVP
Prev: Selecting dynamic number of columns into fixed-structure table
Next: Ntext Data Type