thank you for the quick reply.
i have tried both, the install.aspx and run the nopCommerce_createDatabase.sql on the ms sql server management studio.
in both i get the same error Incorrect syntax near '('.
it seems that the next line is the problem:
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
I also get an error for the sql max
it does not recognize the max