I have question reagrding to SQL Server Authentication, I use SQL express and Microsoft SQL Server Management Studio Express. For creating and editing databases, I login whit Windows Authentication and it works fine, but as I need this new empty database for ASP script on my localhost ISS, I dont know what to enter for Username and Password as SQL Server Authentication.
Ex. here is this connection string where I need to enter U/P but what to enter if I use Windows Authentication?
strCon = "Provider=SQLOLEDB;Connection Timeout=90;Server=AMD\SQLEXPRESS;User ID=?;Password=?;Database=test_database;"
Connectionstrings can be found on www.connectionstrings.com , for Windows Authentication you would have to do something like this:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
More details on this can be found on the site mentioned above.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Have a look at this post from SQL Server Central on the Security and login functions for SQL Server 2005.
|||Hy again,
thanx, I was able to create new SQL login whit pass, but now when I try to login whit that U/P I get this error:
Login failed for user 'test'. The user is not associated whit a trusted sql server connection.
Microsoft SQL server, Error: 18452
Then I search for microsoft for this error and try this http://support.microsoft.com/kb/269587/en-us but I still get the same error.
|||
hi,
in order to accept the changes, SQL Server service must be restart after you modify this security setting...
do you still have torubles?
regards
|||I have restarted ISS before, but I tryied to restart my computer and it works now finaly. Thanx to all!