Re: SQL Server Management Studio Cannot Open SQL Express Files

May there be two separate instances are installed on your computer?

I suggest you to open SQL Server Configuration Manager and see how many SQL Server instances are installed and you can see what instance of SQL Server is being used by VS from VS's Tools->Options->Database Tools->Data Connections.

Your databases that you create may be attached to the instance "X" and the instance that you connect from SSMS may be instance "Y" and because databases can be attached only to one instance, you experience this problem.

Note:
When you have SSMS installed on your computer, you don't need SSMSE (Express edition of SSMS) because SSMSE is a light version of SSMS which comes with not-for-free SQL Server editions.

--
Ekrem Önsoy



"EagleRed@xxxxxxxxxxxxxxxxxxx" <EagleRedHighFlyingBirdscom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FEFDB265-5936-473D-B764-D8049639F018@xxxxxxxxxxxxxxxx
I am writing an application on a Vista machine with SQL Server 2005 Developer
Edition installed using VS2005 Team Architect. I also have SQL Express
installed. I have a requirement to develop and deploy a Web service that
connects to a SQL Express database.

Here is the problem. If I create the database in VS2005 using the
Membership wizard, I can create the database in the App_Data directory and I
can work with it in the Server Explorer. However, I cannot open the files in
the Management Studio to perform any administrative functions like creating
logons and setting permissions.

If I create the DB in Management Studio I cannot work with it in VS2005.

In both case I get access denied errors on the files in the alternate
environment. Since I have the main Management Studio running on the machine
I cannot install the SQL Express Management Studio.

How can I resolve this so I can work with the database in VS2005 and in
Management Studio?

Any pertinent input is greately appreciated.

Thanks,
Eagle

.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... As you said this is a fresh install, so it should not be an issue. ... If you are installing are installing a fresh version of SQL Server 2000, ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: Why do I need to restart the SQL service?
    ... > I use Wise Installation utility to install MSDE 2000A. ... what I do within the app is: ... Check to see if the database exists. ... > SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL SERVER 2008 Express + SP1
    ... Again there are three service pack setups which are provided by Microsoft. ... Are u sure you are using correct version for your install? ... DB Dev SQL Server 2005 ... Script level upgrade for database 'master' failed because upgrade step ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... I'm willing to continue because I need this database to be up and working on ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
Quantcast