I am using command line to create a new site in a new db. Keep gettingerrors login failed for user not associated with trusted SQl server.error code 18452Has any one created site in new db. Pl advise process.
I do it all the time, sometimes 30 times a day!! Iwould venture a guess that your login ID is not adatabase administrator in SQLserver.Alternatively, there could be a problem f the databaseis elsewhere.
I solved the problem of log in by using mixed mode in authentication .But keep getting error that site exists.What is the database password. Is it same as user password