>>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

The link should give you the answer. What have you set as the default database for this user? Have you given the user sufficient permissions to access this default database?