SQL 05 Database Question

I have been trying to connect to the database on the remote server and cant do it.

In VWD I do this:

Right Click on App_Data, Add new SQL Database

Right click on new datafile, then chose modify connection

Type in the server name then my SQL User Name and password

Type in the DB Name

Press Test and it doesnt work.

Am I doing something wrong?

I'm new, and am not sure if I messed it up or something.

I am using SQL Server Express locally. Do I NEED to go buy those $50 tools mentioned, or is there another way to do it right through VWD?

Thanks,
Mike

 

I am not able to replicate the steps you provided. When you click on Modify Connection on the mdf file, there is no option to specify the SQL server name. It's a file-based SQL server using your local machine's instance of SQL Express.

To connect to a remote database, go to the Server Explorer and add a Data Connection. Select Microsoft SQL Server as the data source.

Aristotle

DiscountASP.NET
www.DiscountASP.NET