Hi All,

I'm using Visual Web Developer 2005 Express Edition and Microsoft SQL
Server Express Edition.  I have a database which was originally
created using SQL Server 2000 that I'm using in an ASP.NET
application.  I can open the database just fine and use it in the
Visual Web Developer, but when I try to attach to it from SSMS
Express, I get an error "Access is denied.  Microsoft SQL Server Error
5120".  I have attached to other SQL 2000 databases using SSMS Express
with no problems.

What could I be missing and how do I use SSMS Express to manage this
database?

Thanks,
Steve

Steve Harp (NoSpam@NoPlace.com) writes:
If you can access the database from Visual Web Developer, then obviously
there is no need to attach it to an SQL Server instance. Un attached
database is not something you can do much with.

It semes to me that Visual Web Devloper and SSMS Express are working against
different instances of SQL Server. My guess is that from SSMS Express you
access the \SQLEXPRESS instance, and from Visual Web Developer you aer
using a user instance. When you try to attach the database to \SQLEXPERSS
this fails, as the database file is already open by the the user instance.

It's possible to access a user instance from Mgmt Studio, but it requires
some digging. This viedeo from SQL Server MVP Chuck Boyce explains:
http://www.sswug.org/sswugradio/files/Tuesday_28MAR2006.wmv

Query to split Firstname Lastname into 2 fields
sp_trace_setfilter does not work
Stored procedure debugging
Management Studio
Recommendations for SQL Server-compatible database design tool?
Can SQL 2000 Enterprise Manager & SQL 2005 Mgnt Studio coexist ?
SS2005 Mngmnt Studio - how to disable / "turn off" UNICODE??
Tool to create link between multiple databases
BOL (2005) Favorites
Fickle Import Performance Data... for profiler 2005