Remote Connection to file-based Express DB

Hi,

This might be obvious - but if so I've missed it so far.

Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename?

As far as I can tell these databases don't have a name and aren't mounted until an attempt is made to access them. I certainly can't see any sign of it in SQL Management Studio.

Thanks,

Dale

[454 byte] By [Dale_Burrell] at [2008-2-22]
# 1

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team

MikeWachal-MSFT at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
# 2

Hi Mike - thanks for your reply.

Just to clarify further if I use an SQL Server 2005 Express database as part of my web app hosted with my web site; the only way I can remotely access the data in that database is by physically copying the database locally - essentually the same as if I used an MS Access database?

Cheers,

Mike Wachal - MSFT wrote:

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team

Dale_Burrell at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...

SQL Server

Site Classified