|
 |
aspx_beginners thread: help connecting to msde
Message #1 by "Dan McKinnon" <mddonna@q...> on Wed, 29 May 2002 23:34:00
|
|
Hi -
I installed the .NET SDK on my machine, but I can't access any of the
msde .mdf database files through my SQL Server 2000 Enterprise Manager or
Query Analyzer. There are two instances of SQL Server running, according
to the icon in the task bar. I tried to register the .NET instance, but
it gives me an error saying that either the server isn't running or
permission is denied. I checked the permissions on the files (.mdf) and
the files I want access to are accessible to various groups, including
Administrator, but the files that I can already access are only
accessible by Administrator. So it doesn't seem like this is the problem.
Any ideas, or anyone else dealt with this?
Thank you,
Dan
Message #2 by Colin.Montgomery@C... on Thu, 30 May 2002 11:18:08 +0100
|
|
I've experienced the same, and would be keen to find an answer also.
Col
-----Original Message-----
From: Dan McKinnon [mailto:mddonna@q...]
Sent: 30 May 2002 00:34
To: aspx_beginners
Subject: [aspx_beginners] help connecting to msde
Hi -
I installed the .NET SDK on my machine, but I can't access any of the
msde .mdf database files through my SQL Server 2000 Enterprise Manager or
Query Analyzer. There are two instances of SQL Server running, according
to the icon in the task bar. I tried to register the .NET instance, but
it gives me an error saying that either the server isn't running or
permission is denied. I checked the permissions on the files (.mdf) and
the files I want access to are accessible to various groups, including
Administrator, but the files that I can already access are only
accessible by Administrator. So it doesn't seem like this is the problem.
Any ideas, or anyone else dealt with this?
Thank you,
Dan
*******
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.
Message #3 by Imar@S... on Thu, 30 May 2002 12:24:01
|
|
Hi there,
How do you connect to the MSDE instance? When you have two or more
instances of SQL server running, you should connect to the second instance
like this:
machineName\InstanceName
Just using InstanceName will not work.
HtH
Imar
> Hi -
> I installed the .NET SDK on my machine, but I can't access any of the
m> sde .mdf database files through my SQL Server 2000 Enterprise Manager
or
Q> uery Analyzer. There are two instances of SQL Server running, according
t> o the icon in the task bar. I tried to register the .NET instance, but
i> t gives me an error saying that either the server isn't running or
p> ermission is denied. I checked the permissions on the files (.mdf) and
t> he files I want access to are accessible to various groups, including
A> dministrator, but the files that I can already access are only
a> ccessible by Administrator. So it doesn't seem like this is the problem.
> Any ideas, or anyone else dealt with this?
> Thank you,
D> an
Message #4 by "Kyle" <Kyle@T...> on Thu, 30 May 2002 07:40:35 -0400
|
|
I don't believe MSDE supports these management features. MSDE is purely
a database deployment environment for the desktop. I hope I'm wrong
about this but that's what I think at this point. To manage the
databases you will have to detach them from the MSDE instance of SQL and
attach them to the SQL Server 2000 instance of SQL. Using stored
procedures you can view what databases are attached to MSDE, detach
them, re-attach them and do other maintenance tasks as well but if you
want SQL Server Management you'll have to move them to SQL Server. I'm
hoping someone will speak up with a better approach.
Kyle
-----Original Message-----
From: Colin.Montgomery@C...
[mailto:Colin.Montgomery@C...]
Sent: Thursday, May 30, 2002 6:18 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: help connecting to msde
I've experienced the same, and would be keen to find an answer also.
Col
-----Original Message-----
From: Dan McKinnon [mailto:mddonna@q...]
Sent: 30 May 2002 00:34
To: aspx_beginners
Subject: [aspx_beginners] help connecting to msde
Hi -
I installed the .NET SDK on my machine, but I can't access any of the
msde .mdf database files through my SQL Server 2000 Enterprise Manager
or
Query Analyzer. There are two instances of SQL Server running, according
to the icon in the task bar. I tried to register the .NET instance, but
it gives me an error saying that either the server isn't running or
permission is denied. I checked the permissions on the files (.mdf) and
the files I want access to are accessible to various groups, including
Administrator, but the files that I can already access are only
accessible by Administrator. So it doesn't seem like this is the
problem.
Any ideas, or anyone else dealt with this?
Thank you,
Dan
*******
This message and any attachment are confidential and may be privileged
or otherwise protected from disclosure. If you are not the intended
recipient, please telephone or email the sender and delete this message
and any attachment from your system. If you are not the intended
recipient you must not copy this message or attachment or disclose the
contents to any other person.
For further information about Clifford Chance please see our website at
http://www.cliffordchance.com or refer to any Clifford Chance office.
Message #5 by "Kyle" <Kyle@T...> on Thu, 30 May 2002 09:08:23 -0400
|
|
Imar,
This sounds right. Have you had MSDE and SQL 2000 installed on the same
machine and been able to see both with the SQL 2000 Enterprise Manager?
Kyle
-----Original Message-----
From: Imar@S... [mailto:Imar@S...]
Sent: Thursday, May 30, 2002 8:24 AM
To: aspx_beginners
Subject: [aspx_beginners] Re: help connecting to msde
Hi there,
How do you connect to the MSDE instance? When you have two or more
instances of SQL server running, you should connect to the second
instance
like this:
machineName\InstanceName
Just using InstanceName will not work.
HtH
Imar
> Hi -
> I installed the .NET SDK on my machine, but I can't access any of the
m> sde .mdf database files through my SQL Server 2000 Enterprise Manager
or
Q> uery Analyzer. There are two instances of SQL Server running,
according
t> o the icon in the task bar. I tried to register the .NET instance,
but
i> t gives me an error saying that either the server isn't running or
p> ermission is denied. I checked the permissions on the files (.mdf)
and
t> he files I want access to are accessible to various groups, including
A> dministrator, but the files that I can already access are only
a> ccessible by Administrator. So it doesn't seem like this is the
problem.
> Any ideas, or anyone else dealt with this?
> Thank you,
D> an
Message #6 by Imar@S... on Thu, 30 May 2002 15:59:34
|
|
Hi Kyle,
I can't remember whether I have seen them somewhere in EM while running on
the same computer. However, I have a server with MSDE and I can use EM to
connect to it and connect to another SQL server in my network as well. So
at least I am sure you can use EM to connect to an MSDE.
Imar
===========================================
Imar,
This sounds right. Have you had MSDE and SQL 2000 installed on the same
machine and been able to see both with the SQL 2000 Enterprise Manager?
Kyle
-----Original Message-----
From: Imar@S... [mailto:Imar@S...]
Sent: Thursday, May 30, 2002 8:24 AM
To: aspx_beginners
Subject: [aspx_beginners] Re: help connecting to msde
Hi there,
How do you connect to the MSDE instance? When you have two or more
instances of SQL server running, you should connect to the second
instance like this:
machineName\InstanceName
Just using InstanceName will not work.
HtH
Imar
Message #7 by "Kyle" <Kyle@T...> on Thu, 30 May 2002 11:20:05 -0400
|
|
Hi Imar,
I tried it out. It was just that simple. Thanks!
Kyle
-----Original Message-----
From: Imar@S... [mailto:Imar@S...]
Sent: Thursday, May 30, 2002 12:00 PM
To: aspx_beginners
Subject: [aspx_beginners] Re: help connecting to msde
Hi Kyle,
I can't remember whether I have seen them somewhere in EM while running
on
the same computer. However, I have a server with MSDE and I can use EM
to
connect to it and connect to another SQL server in my network as well.
So
at least I am sure you can use EM to connect to an MSDE.
Imar
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Imar,
This sounds right. Have you had MSDE and SQL 2000 installed on the same
machine and been able to see both with the SQL 2000 Enterprise Manager?
Kyle
-----Original Message-----
From: Imar@S... [mailto:Imar@S...]=3D20
Sent: Thursday, May 30, 2002 8:24 AM
To: aspx_beginners
Subject: [aspx_beginners] Re: help connecting to msde
Hi there,
How do you connect to the MSDE instance? When you have two or more
instances of SQL server running, you should connect to the second
instance like this:
machineName\InstanceName
Just using InstanceName will not work.
HtH
Imar
|
|
|
View Cart
