>That should work (g)
>Better: In SSMS take a close look at the permssions you have granted the user- check not only the obvious (like Login enabled) but also whether the account has sufficient permissions to the relevant database etc. Get access to your satisfaction via SSMS before attempting it via ASP.NET

This new user has Public access. Should I gave him all access permissions?

Right now I simply can not login using this user's credentials.

Getting

TITLE: Connect to Server
------------------------------

Cannot connect to < ....... >

------------------------------
ADDITIONAL INFORMATION:

Cannot open user default database. Login failed.
Login failed for user 'user name'. (Microsoft SQL Server, Error: 4064)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


And I didn't yet took a cup.