Prev: Selecting dynamic number of columns into fixed-structure table
Next: Ntext Data Type
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:

connectionString2 =
"Server=MyComputer\SQLEXPRESS;Database=adatabasename;User
ID=auserid;Password=apassword"

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
local computer.
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
> fine
> 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.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/



 | 
Pages: 1
Prev: Selecting dynamic number of columns into fixed-structure table
Next: Ntext Data Type