>To see if you have mixed mode security, right click on the name of your server in Enterprise Manager and select Properties. Then select the security tab and look at the Authentication setting. You want SQL Server and Windows selected.
>
My SQL Server has SQL Server and Windows selected, pretty much as you said that it should.
>
>As for Enterprise Manager, it does not ask you for your username and password because the connection to you database in Enterprise Manager has saved that information (right-click on the name of your server in Enterprise Manager and select Edit SQL Server Registration Properties to see this).
>
However, when I look at the Edit SQL Server Registration Properties, "Use Windows Authentication" is selected. I realize that I need to change it to "Use SQL Server Authentication". But when I do that and then enter User Name and Password, I get error:
SQL Server Registration Failed because of the connection failure displayed below. Do you wish to modify anyway?
If I say yes, I still get error trying to connect to the server. So I have to go back and change it to use "Use Windows Authentication".
If you have any suggestions, please let me know.
"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
