i'm logged with windows authentification and create an entry/user in the login table...
the new testuser has a sql-server authentification, but if a try to login local or remote, only fault 18456...
is there any trick... this should be so simple as explained... but should work?!
ideas?!
I don't quite understand your question - can you clarify a bit?
You're logged in with a Windows account - so does that Windows account (or a Windows group it belongs to) have a "login" in SQL Server?
How do you try to login with the new "testuser" ? How are you trying to connect? From an ADO.NET application? SQL Server Management studio?? Error 18456 can mean "login failed" - does your "testuser" have a SQL login? And is that login allowed to use the database you're trying to use??
Please give us a bit more information to go on - thanks!
Marc
i believe it's just that the SQL server authentication is disabled by default installation. go check your SQL server properties in management studio (right-click on the server in object explorer, then select 'properties'), select 'security' menu in the left panel. you have the 'server authentication' option on the top of the right-side options panel with 2 options. make sure that the 'SQL server and windows authentication mode' is selected, not the 'windows authentication mode' which is default.