Re: SQL Server Management Studio Cannot Open SQL Express Files

I have got things kind of working now. I cannot execute the stored
procedures in SSMS. When I execute stored procs in VS that should return a
result set, it is not shown. Also, when I publish VS does not have
permission to write the DB files to the publish media.

Any ideas on this.

Thanks,
Eagle

"EagleRed@xxxxxxxxxxxxxxxxxxx" wrote:

In VS2005 I am connected to the SQLExpress instance. I acually have 3
instances of SQL Server on my machine (I am doing some crazy stuff).
Currently I can work with the DB in SSMS but not in VS. I actually have
other projects, both VS2005 and VS2008, that work with the local instance.
When I open those projects I see the databases in the Server explorer and I
can work with them even though the ->Options->Database Tools->Data
Connections output shows I am connected to SQLEXPRESS at the time in VS

Good news, I just created a new connection to the DB using the
machine\SQLEXPRESS\DBName reference to the DB and it seems to be working. I
will see how it goes and post back one way or another.

Thanks very much for the input in any case.

HAVE A BLESSED DAY!!!!

Thanks,
Eagle.

"Ekrem Önsoy" wrote:

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

  • Error: 18456, Severity: 14, State: 16
    ... to connect to SQL Server 2005 Express Edition from the command line. ... CreateDatabase.sql when run in Management Studio successfully creates ... the database that I require so I know the error doesn't lie there. ...
    (microsoft.public.sqlserver.connect)
  • Error when Logging on - Error: 18456, Severity: 14, State: 16
    ... to connect to SQL Server 2005 Express Edition from the command line. ... CreateDatabase.sql when run in Management Studio successfully creates ... the database that I require so I know the error doesn't lie there. ...
    (microsoft.public.sqlserver.security)
  • Re: schema compare problem
    ... mapped the system databases setting database role membership to db_owner. ... we are trying to connect to local .MDF files ... If we attach the .MDF file to SQL Server Express, ... Management Studio Express - No. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error: 18456, Severity: 14, State: 16
    ... to connect to SQL Server 2005 Express Edition from the command line. ... CreateDatabase.sql when run in Management Studio successfully creates ... the database that I require so I know the error doesn't lie there. ...
    (microsoft.public.sqlserver.connect)
  • SQL Server 2005 Express - only one connection
    ... I have SQL Server 2005 Express and Visual Studio 2005 installed on the same ... I created a database using Management Studio Express, ... See the SQL Server errorlog for details. ...
    (microsoft.public.sqlserver.connect)
Loading