hey gracias por responder estoy usando vwd 2008 sql server 2005. cuando le doy al test en provider me sale esto:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
Y en la parte de security estoy:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
Es decir las tablas y demas cosas predeterminadas no estan.
Cita:
Iniciado por eperedo 
Pero por qué no puedes conectar???
Puedes describir o poner alguna imagen del error??
Que versión de visual web developer y sql server estás usando???
