>>>>>Thanks. I'm stuck right now with the user I'm trying to add for web app, so it would be the same as I had it on the test server.
>>>>>
>>>>>But may be I don't need the whole thing and new user, but rather use Windows Authentication for local tests?
>>>>
>>>>Not sure what you are asking about. Are you referring to a user account for the website or to the SQL account used by the site to access the database?
>>>
>>>SQL account. BTW, I can not find Project menu in the menu.
>>
>>I'm assuming a VS2005 WebApplication. 'Project' should be right there on the main menu (assuming you've got the project open and selected)
>>
>
>Nope, but I have Website menu, may be this is the one.
>
>>>
>>>I substituted the server name with my local server name in the connection string. But the original connection string was using a special user. I tried to create it in SQL Server, but it doesn't work and I can not login using this user's credentials.
>>>
>>>:(((((((((((((((
>>
>>I replied to your post in SQL section. As a first test Try using the login you created via SSMS.
>
>Well, I tried it in the different order (first from VS, then from SSMS), but still failing :(((((((((((
>
>Will grab one more cap of tea then.

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