I am in process of instaling WSS3.0. I need to know whether we can use sql server 2005 express edition(as it is the free one) to create sharepoint database.
If yes, then what steps needs to be followed to create this database and giving the exta needed permission to database users.
Regards
sql express edition with WSS3.0
chris29
Hi Mike,
Thanks for your reply.Ya this is true that wss database gets installed automatically in the sql expresss edition but i want to make two point here.
1.WSS gives problems during installation like giving proper permissions in application pool in IIS and also the WSS databases created if WE ARE RUNNING AN SQL SERVER 2005 ENTERPRISE EDITION on that machine.
2.This is a bit basic level question but please answer it keeping in mind that i don't have prior exp in using sql server express edition. If i need to check and see the database of wss created while using sql express edition, how can i do so
Regards
rodniko
Mike Hildner
AFAIK, the SQL Server which comes with WSS and installs in "Basic" option is not Express edition but Embedded edition. The difference is that Embedded has even less features. E.g., it has no management tools other but common osql command-line tool.
So I prefer using stand-alone SQL Server Express installation and setup WSS in "Web Front-end" configuration. This way you can always use SQL Server Management Studio to check if database exists or manage permissions. But normally you don't need to. When running WSS Configuration Wizard it asks you about configuration database creation. And if you (i.e. user who ran the Configuration Wizard) have administrative rights for SQL server, the Wizard configures proper permissions for you. Actually it grants "dbcreator" and "securityadmin" roles to your Database Access Account as it is used to run Central Administration Application Pool and performing system tasks (such as creating new databases).