>>>>>>Hi,
>>>>>>
>>>>>>I am testing access to a new customer database (not the first time a very similar environment). What happens is when I use Windows authentication (specify in the connection string IntegratedSecurity True) connection works. But when I try SQL Server authentication I get connection error (basically connection denied). For SQL Server authentication I created login and then in the database I created user of the same name. The user has roles: db_datareader, db_datawriter, db_owner. But nothing works. I have double checked the password (I made it very simple 'test') but can't make the SQL Server authentication to work.
>>>>>>What could be missing? TIA.
>>>>>
>>>>>Could you connect with SSMS using this login?
>>>>
>>>>No. I get error "Cannot connect to SERVERNAME" What could it tell me? Thank you
>>>
>>>Connect with SSMS using Windows authentication. Right click on this login and "Properties->Status"
>>>Also make sure that this login has rights on master DB.
>>
>>No problems there. The Status is Grant permission to connect to database engine and Enabled Login. The login also has rights on master DB. I even created a second login and user, very simple, both name and password are 'test' and still no luck.
>>Anything else I can try?
>
>You may not have SQL Server Authentication turned on.
http://msdn.microsoft.com/en-us/library/ms188670.aspxYou are so right! The SQL Server Authentication was not turned on. Thank you.
But now I need to restart the SQL server. How do you do that?
UPDATE. I found how to stop and restart the server.
Now I can connect. Thank you!
"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