Create database "intranet", run this file in query analyzer to create tables. you can then import the default data or data you have already created from the access database.
This is an update to our existing file, contributed by Blaine Trimmel, who had this to say:
MS does not map the files from access to sql server correctly and fails to create indexes and primary keys. I convert from access to sql server all the time and have a util that spits out scripts to create the tables. So I used it to create a script and here it is. Feel free to pass it along to whoever needs it.