Someone on the .NET forum helped me to solve the problem. Basically I didn't need to edit the SQL Server Registration Property. All I needed is to add new login to the SQL Server Logins.
>Does SQL Server set up to allow SQL Server Authentication?
>
>>When I select this choice (Right Mouse Click on the Server Name (local) | Edit SQL Server Registration Properties, "Use Windows Authontication" is selected.
>>
>>I want to change it to "Use SQL Server Authontication". When I click on this choice, the User Name and Password fields are enabled. I enter a user name and a password, click on Ok but I get error that
>>
>>
>>SQL Server Registration Failed bacause of the connection failure
>>displayed below..
>>
>>
>>Actually nothing is displayed below. What am I missing here?
>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
