I probably didn't explain myself clearly. I needed to connect to a database from asp.net page using User ID and Password. I didn't realize that SQL Server already had "sa" ID set up and that I could add other users in the Login window of the SQL Server. I thought I needed to change the SQL Server Registration property to have a User ID and a Password. So what I was saying is that instead of editing SQL Server Registration properties, all I needed was to go to the Logins and add a new ID and Password there. I hope I make sense now.
>Sorry but what you're saying doesn't make any sense to me.
>
>>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