I modified the connection.asp page to read the following:
strSQLServerName = "MACHINENAME\SQLEXPRESS"
strSQLDBUserName = "webwiz"
strSQLDBPassword = "BLAHBLAHBLAH"
strSQLDBName = "webwizforums"
where machinename and blahblahblah are replaced with real data. I also created a webwiz account via SQL Server 2005 Express Managment studio then:
On the General page for the login profile:
1) set the password to match what's in the strSQLDBPassword variable above
2) enabled enfore password policy
3) set the default database to webwizforums
On the Server roles I enabled all.
On the User Mapping tab I enabled map on the webwizforums db, user webwiz, default schema dbo
On the Securables tab I didn't do anything
On the Status tab Permission was granted and Login enabled.
Sorry for the simplicity of the question.
Topic Options
Post Options
Thanks(0)
