I asked this one a while back but I still haven't got it figured out yet.
What my problem boils down to is that SQL server diagrams created with
Access XP (latest version with patches) created through an ADP and diagrams
created with enterprise manager (latest version + patches) seem to be
completely incompatible. Whenever I open a diagram created with one tool in
the other tool, the tool doing the opening crashes, completely crashes at
that. I'm working on a project and the DB is growing to a complexity where I
really need a reliable way to share the diagrams with my team members. I
don't want to put too much work into good diagrams with one tool if they're
going to be useless in the other. Other developers I have spoken with don't
seem to have this problem. Have I missed a patch? Is this a known
incompatibility? Is something configured wrong? I'm at wits end.
Sorry for the cross posting but this anomaly is really annoying me and we
need to use both Enterprise Manager and Access and this is holding us up
somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
advance to anyone who can give me a clue on this one!
Jon
I have used both interchangeably without a problem. It would seem a drastic
step to start uninstalling/reinstalling without knowing exactly what the
problem may be or if it will be cured. I suggest just creating and viewing
all the diagrams in Access because everyone should have that installed.
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
"Jon" <jonremovemewest@.msn.com> wrote in message
news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> I asked this one a while back but I still haven't got it figured out yet.
> What my problem boils down to is that SQL server diagrams created with
> Access XP (latest version with patches) created through an ADP and
diagrams
> created with enterprise manager (latest version + patches) seem to be
> completely incompatible. Whenever I open a diagram created with one tool
in
> the other tool, the tool doing the opening crashes, completely crashes at
> that. I'm working on a project and the DB is growing to a complexity where
I
> really need a reliable way to share the diagrams with my team members. I
> don't want to put too much work into good diagrams with one tool if
they're
> going to be useless in the other. Other developers I have spoken with
don't
> seem to have this problem. Have I missed a patch? Is this a known
> incompatibility? Is something configured wrong? I'm at wits end.
> Sorry for the cross posting but this anomaly is really annoying me and we
> need to use both Enterprise Manager and Access and this is holding us up
> somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
> advance to anyone who can give me a clue on this one!
>
> Jon
>
|||Which version of Access do you use? Access2002(XP) or Access2003? Since I
have the same problem with SQL Server2000(Developer edition) and AccessXP,
i.e. Diagram created in one program crashes othe other program when opening.
I just wonder whether Access 2003 has the same problem or not. At least,
with AccessXP, it is not "Just me" thing.
"Arvin Meyer" <a@.m.com> wrote in message
news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I have used both interchangeably without a problem. It would seem a
drastic[vbcol=seagreen]
> step to start uninstalling/reinstalling without knowing exactly what the
> problem may be or if it will be cured. I suggest just creating and viewing
> all the diagrams in Access because everyone should have that installed.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
> "Jon" <jonremovemewest@.msn.com> wrote in message
> news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
yet.[vbcol=seagreen]
> diagrams
> in
at[vbcol=seagreen]
where[vbcol=seagreen]
> I
> they're
> don't
we[vbcol=seagreen]
in
>
|||I forgot to mention that the diagram created in Enterprise Manager also
crashes Visual Studio2003, if I try to open it in Server Explorer. So, the
problem seems from Enterprise Manager, rather than AccessXP. As I said, I am
using SQL Server2000 developer edition with SP3.
"Norman Yuan" <nobody@.nowhere.no> wrote in message
news:OyDRGNMcEHA.3476@.tk2msftngp13.phx.gbl...
> Which version of Access do you use? Access2002(XP) or Access2003? Since I
> have the same problem with SQL Server2000(Developer edition) and AccessXP,
> i.e. Diagram created in one program crashes othe other program when
opening.[vbcol=seagreen]
> I just wonder whether Access 2003 has the same problem or not. At least,
> with AccessXP, it is not "Just me" thing.
>
> "Arvin Meyer" <a@.m.com> wrote in message
> news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> drastic
viewing[vbcol=seagreen]
> yet.
tool[vbcol=seagreen]
> at
> where
I[vbcol=seagreen]
> we
up[vbcol=seagreen]
Thanks
> in
>
|||I'm on Access XP, I also have 2000 installed I bet it would be the same
there though. I'd have to check to be sure. Yeah it looks like some of us
have this problem and some aren't, I'm hoping that someone knows something
as I'm really starting to like ADPs but I need this to work correctly. I
really don't want to go through the whole reinstall rigmarole either as it's
a huge time sink and I have real work to do(plus like you all said there's
no guarantee that it will fix anything).
Jon
|||Ditto here on the SQL config...SQL 2000 developer edition with SP3 applied.
Although I tried it with enterprise edition and got the same bad results.
Jon
|||There's a thread on microsoft.public.sqlserver.server called "Diagram Editor
doesn't work in SQLServer 2000", it says something about a dll conflict
caused by installation of VB6. I do have VB 6 installed so I wonder if this
is the culprit. What do you all think? I'm not fooling with my registrations
until I know what's up with this. What do you all have installed? Any
suggestions.
Jon
|||I don't think there's any question but that it is a DLL conflict, Jon. The
issue is, of course, which DLL, and what to do about it.
I had problems with the diagram editor on my old PC, which had Visual Studio
6 (including VB6) installed. I do not have problems on my new PC, which has
never had Visual Studio 6 installed. So yes, it would seem likely that the
problem DLL is installed by Visual Studio 6. But that doesn't rule out the
possibility that it may also be installed by other applications.
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Jon" <jonremovemewest@.msn.com> wrote in message
news:Ode5H%23lcEHA.3716@.TK2MSFTNGP11.phx.gbl...
> There's a thread on microsoft.public.sqlserver.server called "Diagram
Editor
> doesn't work in SQLServer 2000", it says something about a dll conflict
> caused by installation of VB6. I do have VB 6 installed so I wonder if
this
> is the culprit. What do you all think? I'm not fooling with my
registrations
> until I know what's up with this. What do you all have installed? Any
> suggestions.
> Jon
>
|||Well I broke down and sent a support email to MS. Maybe I'll get lucky and
get a good quick response back from them on this one. This thing is driving
me nuts!
Jon
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Tuesday, March 20, 2012
Access/Enterprise Manager Diagrams Incompatible?
I asked this one a while back but I still haven't got it figured out yet.
What my problem boils down to is that SQL server diagrams created with
Access XP (latest version with patches) created through an ADP and diagrams
created with enterprise manager (latest version + patches) seem to be
completely incompatible. Whenever I open a diagram created with one tool in
the other tool, the tool doing the opening crashes, completely crashes at
that. I'm working on a project and the DB is growing to a complexity where I
really need a reliable way to share the diagrams with my team members. I
don't want to put too much work into good diagrams with one tool if they're
going to be useless in the other. Other developers I have spoken with don't
seem to have this problem. Have I missed a patch? Is this a known
incompatibility? Is something configured wrong? I'm at wits end.
Sorry for the cross posting but this anomaly is really annoying me and we
need to use both Enterprise Manager and Access and this is holding us up
somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
advance to anyone who can give me a clue on this one!
JonI have used both interchangeably without a problem. It would seem a drastic
step to start uninstalling/reinstalling without knowing exactly what the
problem may be or if it will be cured. I suggest just creating and viewing
all the diagrams in Access because everyone should have that installed.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
"Jon" <jonremovemewest@.msn.com> wrote in message
news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> I asked this one a while back but I still haven't got it figured out yet.
> What my problem boils down to is that SQL server diagrams created with
> Access XP (latest version with patches) created through an ADP and
diagrams
> created with enterprise manager (latest version + patches) seem to be
> completely incompatible. Whenever I open a diagram created with one tool
in
> the other tool, the tool doing the opening crashes, completely crashes at
> that. I'm working on a project and the DB is growing to a complexity where
I
> really need a reliable way to share the diagrams with my team members. I
> don't want to put too much work into good diagrams with one tool if
they're
> going to be useless in the other. Other developers I have spoken with
don't
> seem to have this problem. Have I missed a patch? Is this a known
> incompatibility? Is something configured wrong? I'm at wits end.
> Sorry for the cross posting but this anomaly is really annoying me and we
> need to use both Enterprise Manager and Access and this is holding us up
> somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
> advance to anyone who can give me a clue on this one!
>
> Jon
>|||Which version of Access do you use? Access2002(XP) or Access2003? Since I
have the same problem with SQL Server2000(Developer edition) and AccessXP,
i.e. Diagram created in one program crashes othe other program when opening.
I just wonder whether Access 2003 has the same problem or not. At least,
with AccessXP, it is not "Just me" thing.
"Arvin Meyer" <a@.m.com> wrote in message
news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I have used both interchangeably without a problem. It would seem a
drastic
> step to start uninstalling/reinstalling without knowing exactly what the
> problem may be or if it will be cured. I suggest just creating and viewing
> all the diagrams in Access because everyone should have that installed.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
> "Jon" <jonremovemewest@.msn.com> wrote in message
> news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
yet.[vbcol=seagreen]
> diagrams
> in
at[vbcol=seagreen]
where[vbcol=seagreen]
> I
> they're
> don't
we[vbcol=seagreen]
in[vbcol=seagreen]
>|||I forgot to mention that the diagram created in Enterprise Manager also
crashes Visual Studio2003, if I try to open it in Server Explorer. So, the
problem seems from Enterprise Manager, rather than AccessXP. As I said, I am
using SQL Server2000 developer edition with SP3.
"Norman Yuan" <nobody@.nowhere.no> wrote in message
news:OyDRGNMcEHA.3476@.tk2msftngp13.phx.gbl...
> Which version of Access do you use? Access2002(XP) or Access2003? Since I
> have the same problem with SQL Server2000(Developer edition) and AccessXP,
> i.e. Diagram created in one program crashes othe other program when
opening.
> I just wonder whether Access 2003 has the same problem or not. At least,
> with AccessXP, it is not "Just me" thing.
>
> "Arvin Meyer" <a@.m.com> wrote in message
> news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> drastic
viewing[vbcol=seagreen]
> yet.
tool[vbcol=seagreen]
> at
> where
I[vbcol=seagreen]
> we
up[vbcol=seagreen]
Thanks[vbcol=seagreen]
> in
>|||I'm on Access XP, I also have 2000 installed I bet it would be the same
there though. I'd have to check to be sure. Yeah it looks like some of us
have this problem and some aren't, I'm hoping that someone knows something
as I'm really starting to like ADPs but I need this to work correctly. I
really don't want to go through the whole reinstall rigmarole either as it's
a huge time sink and I have real work to do(plus like you all said there's
no guarantee that it will fix anything).
Jon|||Ditto here on the SQL config...SQL 2000 developer edition with SP3 applied.
Although I tried it with enterprise edition and got the same bad results.
Jon|||There's a thread on microsoft.public.sqlserver.server called "Diagram Editor
doesn't work in SQLServer 2000", it says something about a dll conflict
caused by installation of VB6. I do have VB 6 installed so I wonder if this
is the culprit. What do you all think? I'm not fooling with my registrations
until I know what's up with this. What do you all have installed? Any
suggestions.
Jon|||I don't think there's any question but that it is a DLL conflict, Jon. The
issue is, of course, which DLL, and what to do about it.
I had problems with the diagram editor on my old PC, which had Visual Studio
6 (including VB6) installed. I do not have problems on my new PC, which has
never had Visual Studio 6 installed. So yes, it would seem likely that the
problem DLL is installed by Visual Studio 6. But that doesn't rule out the
possibility that it may also be installed by other applications.
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Jon" <jonremovemewest@.msn.com> wrote in message
news:Ode5H%23lcEHA.3716@.TK2MSFTNGP11.phx.gbl...
> There's a thread on microsoft.public.sqlserver.server called "Diagram
Editor
> doesn't work in SQLServer 2000", it says something about a dll conflict
> caused by installation of VB6. I do have VB 6 installed so I wonder if
this
> is the culprit. What do you all think? I'm not fooling with my
registrations
> until I know what's up with this. What do you all have installed? Any
> suggestions.
> Jon
>|||Well I broke down and sent a support email to MS. Maybe I'll get lucky and
get a good quick response back from them on this one. This thing is driving
me nuts!
Jon
What my problem boils down to is that SQL server diagrams created with
Access XP (latest version with patches) created through an ADP and diagrams
created with enterprise manager (latest version + patches) seem to be
completely incompatible. Whenever I open a diagram created with one tool in
the other tool, the tool doing the opening crashes, completely crashes at
that. I'm working on a project and the DB is growing to a complexity where I
really need a reliable way to share the diagrams with my team members. I
don't want to put too much work into good diagrams with one tool if they're
going to be useless in the other. Other developers I have spoken with don't
seem to have this problem. Have I missed a patch? Is this a known
incompatibility? Is something configured wrong? I'm at wits end.
Sorry for the cross posting but this anomaly is really annoying me and we
need to use both Enterprise Manager and Access and this is holding us up
somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
advance to anyone who can give me a clue on this one!
JonI have used both interchangeably without a problem. It would seem a drastic
step to start uninstalling/reinstalling without knowing exactly what the
problem may be or if it will be cured. I suggest just creating and viewing
all the diagrams in Access because everyone should have that installed.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
"Jon" <jonremovemewest@.msn.com> wrote in message
news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> I asked this one a while back but I still haven't got it figured out yet.
> What my problem boils down to is that SQL server diagrams created with
> Access XP (latest version with patches) created through an ADP and
diagrams
> created with enterprise manager (latest version + patches) seem to be
> completely incompatible. Whenever I open a diagram created with one tool
in
> the other tool, the tool doing the opening crashes, completely crashes at
> that. I'm working on a project and the DB is growing to a complexity where
I
> really need a reliable way to share the diagrams with my team members. I
> don't want to put too much work into good diagrams with one tool if
they're
> going to be useless in the other. Other developers I have spoken with
don't
> seem to have this problem. Have I missed a patch? Is this a known
> incompatibility? Is something configured wrong? I'm at wits end.
> Sorry for the cross posting but this anomaly is really annoying me and we
> need to use both Enterprise Manager and Access and this is holding us up
> somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
> advance to anyone who can give me a clue on this one!
>
> Jon
>|||Which version of Access do you use? Access2002(XP) or Access2003? Since I
have the same problem with SQL Server2000(Developer edition) and AccessXP,
i.e. Diagram created in one program crashes othe other program when opening.
I just wonder whether Access 2003 has the same problem or not. At least,
with AccessXP, it is not "Just me" thing.
"Arvin Meyer" <a@.m.com> wrote in message
news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I have used both interchangeably without a problem. It would seem a
drastic
> step to start uninstalling/reinstalling without knowing exactly what the
> problem may be or if it will be cured. I suggest just creating and viewing
> all the diagrams in Access because everyone should have that installed.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
> "Jon" <jonremovemewest@.msn.com> wrote in message
> news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
yet.[vbcol=seagreen]
> diagrams
> in
at[vbcol=seagreen]
where[vbcol=seagreen]
> I
> they're
> don't
we[vbcol=seagreen]
in[vbcol=seagreen]
>|||I forgot to mention that the diagram created in Enterprise Manager also
crashes Visual Studio2003, if I try to open it in Server Explorer. So, the
problem seems from Enterprise Manager, rather than AccessXP. As I said, I am
using SQL Server2000 developer edition with SP3.
"Norman Yuan" <nobody@.nowhere.no> wrote in message
news:OyDRGNMcEHA.3476@.tk2msftngp13.phx.gbl...
> Which version of Access do you use? Access2002(XP) or Access2003? Since I
> have the same problem with SQL Server2000(Developer edition) and AccessXP,
> i.e. Diagram created in one program crashes othe other program when
opening.
> I just wonder whether Access 2003 has the same problem or not. At least,
> with AccessXP, it is not "Just me" thing.
>
> "Arvin Meyer" <a@.m.com> wrote in message
> news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> drastic
viewing[vbcol=seagreen]
> yet.
tool[vbcol=seagreen]
> at
> where
I[vbcol=seagreen]
> we
up[vbcol=seagreen]
Thanks[vbcol=seagreen]
> in
>|||I'm on Access XP, I also have 2000 installed I bet it would be the same
there though. I'd have to check to be sure. Yeah it looks like some of us
have this problem and some aren't, I'm hoping that someone knows something
as I'm really starting to like ADPs but I need this to work correctly. I
really don't want to go through the whole reinstall rigmarole either as it's
a huge time sink and I have real work to do(plus like you all said there's
no guarantee that it will fix anything).
Jon|||Ditto here on the SQL config...SQL 2000 developer edition with SP3 applied.
Although I tried it with enterprise edition and got the same bad results.
Jon|||There's a thread on microsoft.public.sqlserver.server called "Diagram Editor
doesn't work in SQLServer 2000", it says something about a dll conflict
caused by installation of VB6. I do have VB 6 installed so I wonder if this
is the culprit. What do you all think? I'm not fooling with my registrations
until I know what's up with this. What do you all have installed? Any
suggestions.
Jon|||I don't think there's any question but that it is a DLL conflict, Jon. The
issue is, of course, which DLL, and what to do about it.
I had problems with the diagram editor on my old PC, which had Visual Studio
6 (including VB6) installed. I do not have problems on my new PC, which has
never had Visual Studio 6 installed. So yes, it would seem likely that the
problem DLL is installed by Visual Studio 6. But that doesn't rule out the
possibility that it may also be installed by other applications.
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Jon" <jonremovemewest@.msn.com> wrote in message
news:Ode5H%23lcEHA.3716@.TK2MSFTNGP11.phx.gbl...
> There's a thread on microsoft.public.sqlserver.server called "Diagram
Editor
> doesn't work in SQLServer 2000", it says something about a dll conflict
> caused by installation of VB6. I do have VB 6 installed so I wonder if
this
> is the culprit. What do you all think? I'm not fooling with my
registrations
> until I know what's up with this. What do you all have installed? Any
> suggestions.
> Jon
>|||Well I broke down and sent a support email to MS. Maybe I'll get lucky and
get a good quick response back from them on this one. This thing is driving
me nuts!
Jon
Access/Enterprise Manager Diagrams Incompatible?
I asked this one a while back but I still haven't got it figured out yet.
What my problem boils down to is that SQL server diagrams created with
Access XP (latest version with patches) created through an ADP and diagrams
created with enterprise manager (latest version + patches) seem to be
completely incompatible. Whenever I open a diagram created with one tool in
the other tool, the tool doing the opening crashes, completely crashes at
that. I'm working on a project and the DB is growing to a complexity where I
really need a reliable way to share the diagrams with my team members. I
don't want to put too much work into good diagrams with one tool if they're
going to be useless in the other. Other developers I have spoken with don't
seem to have this problem. Have I missed a patch? Is this a known
incompatibility? Is something configured wrong? I'm at wits end.
Sorry for the cross posting but this anomaly is really annoying me and we
need to use both Enterprise Manager and Access and this is holding us up
somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
advance to anyone who can give me a clue on this one!
JonI have used both interchangeably without a problem. It would seem a drastic
step to start uninstalling/reinstalling without knowing exactly what the
problem may be or if it will be cured. I suggest just creating and viewing
all the diagrams in Access because everyone should have that installed.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
"Jon" <jonremovemewest@.msn.com> wrote in message
news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> I asked this one a while back but I still haven't got it figured out yet.
> What my problem boils down to is that SQL server diagrams created with
> Access XP (latest version with patches) created through an ADP and
diagrams
> created with enterprise manager (latest version + patches) seem to be
> completely incompatible. Whenever I open a diagram created with one tool
in
> the other tool, the tool doing the opening crashes, completely crashes at
> that. I'm working on a project and the DB is growing to a complexity where
I
> really need a reliable way to share the diagrams with my team members. I
> don't want to put too much work into good diagrams with one tool if
they're
> going to be useless in the other. Other developers I have spoken with
don't
> seem to have this problem. Have I missed a patch? Is this a known
> incompatibility? Is something configured wrong? I'm at wits end.
> Sorry for the cross posting but this anomaly is really annoying me and we
> need to use both Enterprise Manager and Access and this is holding us up
> somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
> advance to anyone who can give me a clue on this one!
>
> Jon
>|||Which version of Access do you use? Access2002(XP) or Access2003? Since I
have the same problem with SQL Server2000(Developer edition) and AccessXP,
i.e. Diagram created in one program crashes othe other program when opening.
I just wonder whether Access 2003 has the same problem or not. At least,
with AccessXP, it is not "Just me" thing.
"Arvin Meyer" <a@.m.com> wrote in message
news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I have used both interchangeably without a problem. It would seem a
drastic
> step to start uninstalling/reinstalling without knowing exactly what the
> problem may be or if it will be cured. I suggest just creating and viewing
> all the diagrams in Access because everyone should have that installed.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
> "Jon" <jonremovemewest@.msn.com> wrote in message
> news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> > I asked this one a while back but I still haven't got it figured out
yet.
> > What my problem boils down to is that SQL server diagrams created with
> > Access XP (latest version with patches) created through an ADP and
> diagrams
> > created with enterprise manager (latest version + patches) seem to be
> > completely incompatible. Whenever I open a diagram created with one tool
> in
> > the other tool, the tool doing the opening crashes, completely crashes
at
> > that. I'm working on a project and the DB is growing to a complexity
where
> I
> > really need a reliable way to share the diagrams with my team members. I
> > don't want to put too much work into good diagrams with one tool if
> they're
> > going to be useless in the other. Other developers I have spoken with
> don't
> > seem to have this problem. Have I missed a patch? Is this a known
> > incompatibility? Is something configured wrong? I'm at wits end.
> >
> > Sorry for the cross posting but this anomaly is really annoying me and
we
> > need to use both Enterprise Manager and Access and this is holding us up
> > somewhat. So I'm hoping to fish for answers in the largest pool. Thanks
in
> > advance to anyone who can give me a clue on this one!
> >
> >
> > Jon
> >
> >
>|||I forgot to mention that the diagram created in Enterprise Manager also
crashes Visual Studio2003, if I try to open it in Server Explorer. So, the
problem seems from Enterprise Manager, rather than AccessXP. As I said, I am
using SQL Server2000 developer edition with SP3.
"Norman Yuan" <nobody@.nowhere.no> wrote in message
news:OyDRGNMcEHA.3476@.tk2msftngp13.phx.gbl...
> Which version of Access do you use? Access2002(XP) or Access2003? Since I
> have the same problem with SQL Server2000(Developer edition) and AccessXP,
> i.e. Diagram created in one program crashes othe other program when
opening.
> I just wonder whether Access 2003 has the same problem or not. At least,
> with AccessXP, it is not "Just me" thing.
>
> "Arvin Meyer" <a@.m.com> wrote in message
> news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > I have used both interchangeably without a problem. It would seem a
> drastic
> > step to start uninstalling/reinstalling without knowing exactly what the
> > problem may be or if it will be cured. I suggest just creating and
viewing
> > all the diagrams in Access because everyone should have that installed.
> > --
> > Arvin Meyer, MCP, MVP
> > Microsoft Access
> > Free Access downloads:
> > http://www.datastrat.com
> > http://www.mvps.org/access
> >
> > "Jon" <jonremovemewest@.msn.com> wrote in message
> > news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> > > I asked this one a while back but I still haven't got it figured out
> yet.
> > > What my problem boils down to is that SQL server diagrams created with
> > > Access XP (latest version with patches) created through an ADP and
> > diagrams
> > > created with enterprise manager (latest version + patches) seem to be
> > > completely incompatible. Whenever I open a diagram created with one
tool
> > in
> > > the other tool, the tool doing the opening crashes, completely crashes
> at
> > > that. I'm working on a project and the DB is growing to a complexity
> where
> > I
> > > really need a reliable way to share the diagrams with my team members.
I
> > > don't want to put too much work into good diagrams with one tool if
> > they're
> > > going to be useless in the other. Other developers I have spoken with
> > don't
> > > seem to have this problem. Have I missed a patch? Is this a known
> > > incompatibility? Is something configured wrong? I'm at wits end.
> > >
> > > Sorry for the cross posting but this anomaly is really annoying me and
> we
> > > need to use both Enterprise Manager and Access and this is holding us
up
> > > somewhat. So I'm hoping to fish for answers in the largest pool.
Thanks
> in
> > > advance to anyone who can give me a clue on this one!
> > >
> > >
> > > Jon
> > >
> > >
> >
> >
>|||I'm on Access XP, I also have 2000 installed I bet it would be the same
there though. I'd have to check to be sure. Yeah it looks like some of us
have this problem and some aren't, I'm hoping that someone knows something
as I'm really starting to like ADPs but I need this to work correctly. I
really don't want to go through the whole reinstall rigmarole either as it's
a huge time sink and I have real work to do(plus like you all said there's
no guarantee that it will fix anything).
Jon|||Ditto here on the SQL config...SQL 2000 developer edition with SP3 applied.
Although I tried it with enterprise edition and got the same bad results.
Jon|||There's a thread on microsoft.public.sqlserver.server called "Diagram Editor
doesn't work in SQLServer 2000", it says something about a dll conflict
caused by installation of VB6. I do have VB 6 installed so I wonder if this
is the culprit. What do you all think? I'm not fooling with my registrations
until I know what's up with this. What do you all have installed? Any
suggestions.
Jon|||I don't think there's any question but that it is a DLL conflict, Jon. The
issue is, of course, which DLL, and what to do about it.
I had problems with the diagram editor on my old PC, which had Visual Studio
6 (including VB6) installed. I do not have problems on my new PC, which has
never had Visual Studio 6 installed. So yes, it would seem likely that the
problem DLL is installed by Visual Studio 6. But that doesn't rule out the
possibility that it may also be installed by other applications.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Jon" <jonremovemewest@.msn.com> wrote in message
news:Ode5H%23lcEHA.3716@.TK2MSFTNGP11.phx.gbl...
> There's a thread on microsoft.public.sqlserver.server called "Diagram
Editor
> doesn't work in SQLServer 2000", it says something about a dll conflict
> caused by installation of VB6. I do have VB 6 installed so I wonder if
this
> is the culprit. What do you all think? I'm not fooling with my
registrations
> until I know what's up with this. What do you all have installed? Any
> suggestions.
> Jon
>|||Well I broke down and sent a support email to MS. Maybe I'll get lucky and
get a good quick response back from them on this one. This thing is driving
me nuts!
Jon
What my problem boils down to is that SQL server diagrams created with
Access XP (latest version with patches) created through an ADP and diagrams
created with enterprise manager (latest version + patches) seem to be
completely incompatible. Whenever I open a diagram created with one tool in
the other tool, the tool doing the opening crashes, completely crashes at
that. I'm working on a project and the DB is growing to a complexity where I
really need a reliable way to share the diagrams with my team members. I
don't want to put too much work into good diagrams with one tool if they're
going to be useless in the other. Other developers I have spoken with don't
seem to have this problem. Have I missed a patch? Is this a known
incompatibility? Is something configured wrong? I'm at wits end.
Sorry for the cross posting but this anomaly is really annoying me and we
need to use both Enterprise Manager and Access and this is holding us up
somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
advance to anyone who can give me a clue on this one!
JonI have used both interchangeably without a problem. It would seem a drastic
step to start uninstalling/reinstalling without knowing exactly what the
problem may be or if it will be cured. I suggest just creating and viewing
all the diagrams in Access because everyone should have that installed.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
"Jon" <jonremovemewest@.msn.com> wrote in message
news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> I asked this one a while back but I still haven't got it figured out yet.
> What my problem boils down to is that SQL server diagrams created with
> Access XP (latest version with patches) created through an ADP and
diagrams
> created with enterprise manager (latest version + patches) seem to be
> completely incompatible. Whenever I open a diagram created with one tool
in
> the other tool, the tool doing the opening crashes, completely crashes at
> that. I'm working on a project and the DB is growing to a complexity where
I
> really need a reliable way to share the diagrams with my team members. I
> don't want to put too much work into good diagrams with one tool if
they're
> going to be useless in the other. Other developers I have spoken with
don't
> seem to have this problem. Have I missed a patch? Is this a known
> incompatibility? Is something configured wrong? I'm at wits end.
> Sorry for the cross posting but this anomaly is really annoying me and we
> need to use both Enterprise Manager and Access and this is holding us up
> somewhat. So I'm hoping to fish for answers in the largest pool. Thanks in
> advance to anyone who can give me a clue on this one!
>
> Jon
>|||Which version of Access do you use? Access2002(XP) or Access2003? Since I
have the same problem with SQL Server2000(Developer edition) and AccessXP,
i.e. Diagram created in one program crashes othe other program when opening.
I just wonder whether Access 2003 has the same problem or not. At least,
with AccessXP, it is not "Just me" thing.
"Arvin Meyer" <a@.m.com> wrote in message
news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I have used both interchangeably without a problem. It would seem a
drastic
> step to start uninstalling/reinstalling without knowing exactly what the
> problem may be or if it will be cured. I suggest just creating and viewing
> all the diagrams in Access because everyone should have that installed.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
> "Jon" <jonremovemewest@.msn.com> wrote in message
> news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> > I asked this one a while back but I still haven't got it figured out
yet.
> > What my problem boils down to is that SQL server diagrams created with
> > Access XP (latest version with patches) created through an ADP and
> diagrams
> > created with enterprise manager (latest version + patches) seem to be
> > completely incompatible. Whenever I open a diagram created with one tool
> in
> > the other tool, the tool doing the opening crashes, completely crashes
at
> > that. I'm working on a project and the DB is growing to a complexity
where
> I
> > really need a reliable way to share the diagrams with my team members. I
> > don't want to put too much work into good diagrams with one tool if
> they're
> > going to be useless in the other. Other developers I have spoken with
> don't
> > seem to have this problem. Have I missed a patch? Is this a known
> > incompatibility? Is something configured wrong? I'm at wits end.
> >
> > Sorry for the cross posting but this anomaly is really annoying me and
we
> > need to use both Enterprise Manager and Access and this is holding us up
> > somewhat. So I'm hoping to fish for answers in the largest pool. Thanks
in
> > advance to anyone who can give me a clue on this one!
> >
> >
> > Jon
> >
> >
>|||I forgot to mention that the diagram created in Enterprise Manager also
crashes Visual Studio2003, if I try to open it in Server Explorer. So, the
problem seems from Enterprise Manager, rather than AccessXP. As I said, I am
using SQL Server2000 developer edition with SP3.
"Norman Yuan" <nobody@.nowhere.no> wrote in message
news:OyDRGNMcEHA.3476@.tk2msftngp13.phx.gbl...
> Which version of Access do you use? Access2002(XP) or Access2003? Since I
> have the same problem with SQL Server2000(Developer edition) and AccessXP,
> i.e. Diagram created in one program crashes othe other program when
opening.
> I just wonder whether Access 2003 has the same problem or not. At least,
> with AccessXP, it is not "Just me" thing.
>
> "Arvin Meyer" <a@.m.com> wrote in message
> news:ObcInaKcEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > I have used both interchangeably without a problem. It would seem a
> drastic
> > step to start uninstalling/reinstalling without knowing exactly what the
> > problem may be or if it will be cured. I suggest just creating and
viewing
> > all the diagrams in Access because everyone should have that installed.
> > --
> > Arvin Meyer, MCP, MVP
> > Microsoft Access
> > Free Access downloads:
> > http://www.datastrat.com
> > http://www.mvps.org/access
> >
> > "Jon" <jonremovemewest@.msn.com> wrote in message
> > news:ehiDwrHcEHA.2476@.TK2MSFTNGP09.phx.gbl...
> > > I asked this one a while back but I still haven't got it figured out
> yet.
> > > What my problem boils down to is that SQL server diagrams created with
> > > Access XP (latest version with patches) created through an ADP and
> > diagrams
> > > created with enterprise manager (latest version + patches) seem to be
> > > completely incompatible. Whenever I open a diagram created with one
tool
> > in
> > > the other tool, the tool doing the opening crashes, completely crashes
> at
> > > that. I'm working on a project and the DB is growing to a complexity
> where
> > I
> > > really need a reliable way to share the diagrams with my team members.
I
> > > don't want to put too much work into good diagrams with one tool if
> > they're
> > > going to be useless in the other. Other developers I have spoken with
> > don't
> > > seem to have this problem. Have I missed a patch? Is this a known
> > > incompatibility? Is something configured wrong? I'm at wits end.
> > >
> > > Sorry for the cross posting but this anomaly is really annoying me and
> we
> > > need to use both Enterprise Manager and Access and this is holding us
up
> > > somewhat. So I'm hoping to fish for answers in the largest pool.
Thanks
> in
> > > advance to anyone who can give me a clue on this one!
> > >
> > >
> > > Jon
> > >
> > >
> >
> >
>|||I'm on Access XP, I also have 2000 installed I bet it would be the same
there though. I'd have to check to be sure. Yeah it looks like some of us
have this problem and some aren't, I'm hoping that someone knows something
as I'm really starting to like ADPs but I need this to work correctly. I
really don't want to go through the whole reinstall rigmarole either as it's
a huge time sink and I have real work to do(plus like you all said there's
no guarantee that it will fix anything).
Jon|||Ditto here on the SQL config...SQL 2000 developer edition with SP3 applied.
Although I tried it with enterprise edition and got the same bad results.
Jon|||There's a thread on microsoft.public.sqlserver.server called "Diagram Editor
doesn't work in SQLServer 2000", it says something about a dll conflict
caused by installation of VB6. I do have VB 6 installed so I wonder if this
is the culprit. What do you all think? I'm not fooling with my registrations
until I know what's up with this. What do you all have installed? Any
suggestions.
Jon|||I don't think there's any question but that it is a DLL conflict, Jon. The
issue is, of course, which DLL, and what to do about it.
I had problems with the diagram editor on my old PC, which had Visual Studio
6 (including VB6) installed. I do not have problems on my new PC, which has
never had Visual Studio 6 installed. So yes, it would seem likely that the
problem DLL is installed by Visual Studio 6. But that doesn't rule out the
possibility that it may also be installed by other applications.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Jon" <jonremovemewest@.msn.com> wrote in message
news:Ode5H%23lcEHA.3716@.TK2MSFTNGP11.phx.gbl...
> There's a thread on microsoft.public.sqlserver.server called "Diagram
Editor
> doesn't work in SQLServer 2000", it says something about a dll conflict
> caused by installation of VB6. I do have VB 6 installed so I wonder if
this
> is the culprit. What do you all think? I'm not fooling with my
registrations
> until I know what's up with this. What do you all have installed? Any
> suggestions.
> Jon
>|||Well I broke down and sent a support email to MS. Maybe I'll get lucky and
get a good quick response back from them on this one. This thing is driving
me nuts!
Jon
Monday, March 19, 2012
Access Vs SQL Server
Hello!
I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.
http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp
I know the basics, just want stats and facts to back them up.
Thanks...Originally posted by swestenhofer
Hello!
I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.
http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp
I know the basics, just want stats and facts to back them up.
Thanks...
1) Volume of data
2) Scalbility
3) Performance
4) OLAP
5) Security features
6) Easy Query processing
7) Data distribution and replication
8) Job scheduling
9) Programmability
There are lots of reasons like this. Access is good if your data is less than 2GB and depends what you are looking from a database.|||Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.
Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.
In a nutshell, running Access as an Enterprise solution drags a network to its knees.|||Originally posted by blindman
Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.
Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.
In a nutshell, running Access as an Enterprise solution drags a network to its knees.
Thanks all!! This should be good fuel for my client to use... thanks for the help!|||Hey...no one told him about the cost...
What's the differences between a kia and a bentley?|||Originally posted by Brett Kaiser
Hey...no one told him about the cost...
What's the differences between a kia and a bentley?
I know the cost differences involved, and the client is aware as well, and in the long run, user connection timeouts and database size limitations may outway the costs based on recovery and migration...
Thanks again!
I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.
http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp
I know the basics, just want stats and facts to back them up.
Thanks...Originally posted by swestenhofer
Hello!
I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.
http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp
I know the basics, just want stats and facts to back them up.
Thanks...
1) Volume of data
2) Scalbility
3) Performance
4) OLAP
5) Security features
6) Easy Query processing
7) Data distribution and replication
8) Job scheduling
9) Programmability
There are lots of reasons like this. Access is good if your data is less than 2GB and depends what you are looking from a database.|||Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.
Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.
In a nutshell, running Access as an Enterprise solution drags a network to its knees.|||Originally posted by blindman
Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.
Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.
In a nutshell, running Access as an Enterprise solution drags a network to its knees.
Thanks all!! This should be good fuel for my client to use... thanks for the help!|||Hey...no one told him about the cost...
What's the differences between a kia and a bentley?|||Originally posted by Brett Kaiser
Hey...no one told him about the cost...
What's the differences between a kia and a bentley?
I know the cost differences involved, and the client is aware as well, and in the long run, user connection timeouts and database size limitations may outway the costs based on recovery and migration...
Thanks again!
Thursday, March 8, 2012
access to SQL from non-domain PC via Enterprise Manager
I have a developer on contract which will use her laptop to work, laptop is
not part of the domain, we install SQL tools on it and now I need to give th
at person access to one of our SQL databases, so I created sql user and then
try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not run
ning or you do no have an access to it” how do bypass it? I have not pro
blem to register this server in Enterprise Manager on my PC using same sql u
ser but my PC is part of do
main, any idea?Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I h
ad to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting
up
> a client alias using the Client Network Utility. Also, try connecting usin
g
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to gi
ve
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea
?
>
>
not part of the domain, we install SQL tools on it and now I need to give th
at person access to one of our SQL databases, so I created sql user and then
try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not run
ning or you do no have an access to it” how do bypass it? I have not pro
blem to register this server in Enterprise Manager on my PC using same sql u
ser but my PC is part of do
main, any idea?Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I h
ad to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting
up
> a client alias using the Client Network Utility. Also, try connecting usin
g
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to gi
ve
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea
?
>
>
access to SQL from non-domain PC via Enterprise Manager
I have a developer on contract which will use her laptop to work, laptop is not part of the domain, we install SQL tools on it and now I need to give that person access to one of our SQL databases, so I created sql user and then try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not running or you do no have an access to it” how do bypass it? I have not problem to register this server in Enterprise Manager on my PC using same sql user but my PC is part of do
main, any idea?
Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?
|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I had to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting up
> a client alias using the Client Network Utility. Also, try connecting using
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to give
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea?
>
>
r on her laptop in Enterprise Menager but getting error “server is not running or you do no have an access to it” how do bypass it? I have not problem to register this server in Enterprise Manager on my PC using same sql user but my PC is part of do
main, any idea?
Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?
|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I had to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting up
> a client alias using the Client Network Utility. Also, try connecting using
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to give
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea?
>
>
Tuesday, March 6, 2012
Access through MS Access ADP for everyone?
Hello,
We have recently installed SQL enterprise manager. I was testing the securi
ty to the databases when I realized that if I login to XP under a standard d
omain user account, open MS Access, create an ADP project, then under connec
tions, pick the sql server, I can see and pick any of the databases and then
I can open and view any of the tables in any of the databases. How can thi
s be possible? We are using NT authentication. This user has no account in
SQL and is just a domain user.It's allowed somehow with the security you have implemented
on the server, in the databases. It's not clear what version
or edition of SQL you are running, where the SQL Server
instance is installed - on the network and you are accessing
this over a network? It's not clear what operating system
the SQL Server is running on, is the SQL Server in a domain
or is this actually a workgroup? Did you change any of the
default security settings? Who are members of Local Admins
where SQL Server is installed? What is the status of the
guest account in Windows where SQL is installed?
What databases are you actually accessing and opening
tables? Are these system databases?
-Sue
On Tue, 11 Oct 2005 21:19:32 -0400, "Jack"
<jackhnospam@.jackandjay.com> wrote:
>Hello,
>We have recently installed SQL enterprise manager. I was testing the security to t
he databases when I realized that if I login to XP under a standard domain user acco
unt, open MS Access, create an ADP project, then under connections, pick the sql ser
ver
, I can see and pick any of the databases and then I can open and view any o
f the tables in any of the databases. How can this be possible? We are usi
ng NT authentication. This user has no account in SQL and is just a domain
user.
We have recently installed SQL enterprise manager. I was testing the securi
ty to the databases when I realized that if I login to XP under a standard d
omain user account, open MS Access, create an ADP project, then under connec
tions, pick the sql server, I can see and pick any of the databases and then
I can open and view any of the tables in any of the databases. How can thi
s be possible? We are using NT authentication. This user has no account in
SQL and is just a domain user.It's allowed somehow with the security you have implemented
on the server, in the databases. It's not clear what version
or edition of SQL you are running, where the SQL Server
instance is installed - on the network and you are accessing
this over a network? It's not clear what operating system
the SQL Server is running on, is the SQL Server in a domain
or is this actually a workgroup? Did you change any of the
default security settings? Who are members of Local Admins
where SQL Server is installed? What is the status of the
guest account in Windows where SQL is installed?
What databases are you actually accessing and opening
tables? Are these system databases?
-Sue
On Tue, 11 Oct 2005 21:19:32 -0400, "Jack"
<jackhnospam@.jackandjay.com> wrote:
>Hello,
>We have recently installed SQL enterprise manager. I was testing the security to t
he databases when I realized that if I login to XP under a standard domain user acco
unt, open MS Access, create an ADP project, then under connections, pick the sql ser
ver
, I can see and pick any of the databases and then I can open and view any o
f the tables in any of the databases. How can this be possible? We are usi
ng NT authentication. This user has no account in SQL and is just a domain
user.
Saturday, February 25, 2012
Access Sql 2005 from sql 2000
Hi,
I access the sql 2000 db's . Now, the dbs have been moved to 2005. Is it possible to connect to sql 2005 db from sql enterprise manager 2000. Or let me know if I have to upgrade to 2005 to access the same.
I get the error message To connect to the server you must use sql server management studio or sql server management objects(SMO) when trying to access the server from sql enterprise manager 2000.
Usually it is not possible to access higher version dbs from a lower version.
Please help me out as soon as possible as this is very urgent.
Thanks & Regards,
K. Sripriya
Hi Sripriya K,You will have to upgrade to sql 2005 management studio to manage sql 2005 database's
|||Priya you cannot access your SQL 2005 databases from SQL 2000 enterprise manager but vice-versa is possible......Yes you need to have SQL 2005 to access the same.......also you cannot restore sql 2005 dbs backup file in sql 2000.....and you also cannot perform detach and attach sql 2005 dbs in sql 2000|||If you are using SQL Express then you need the install SQL Management Express seperately, from there you can access your sql.
Download SQL Mangament Express
If you have other edition then you will have management studio installed already.
Goto run, type sqlwb, press enter.. You will get management studio to connect to sql 2005 server.
You cant use EM to connect to a Sql 2005 machine, but you can use query analyser to connect to sql 2005 server.
Friday, February 24, 2012
access permissions
hi all,
i have created a new login say "me" with the same userid and the password to access my database "test".I created this using the Enterprise Manager so i am not well aware of the securities and permissions in the sql server 2000.
The problem is that with this login "me" i can access the master and pubs database which i dont want as i have set the permissions to access only the "test" database.
I have checked this in the securties-->Logins-->Database Access tab.
Any help on this pls.
I could be wrong but I think you may have set the permissions in the Master database for the database permissions instead of the test database. Hope this helps.|||i am not sure abt this.But i have checked on the some sites..when you are creating the new login you have to specify the default database.So for my login "me" i specified the defaultdatabase as "test".Now the user "me" should only have the access to the test database.
But with the user "me" i can connect to the pubs and master database.Also when i am registerry the database i can access the pubs and master in the Enterprise Manager.
I m sure i m missing something..could anyone help me on this??
thanks
|||If you are using Enterprise manager SQL Server permissions are very simple, you have the database permissions you create in the database under User and the server permissions you create in the Security section of Enterprise manager. If your user can access Pubs and Master, then Master may have been your default database. Fixing such permissions problems may have you editing the Master database which I will not recommend in a production server. Hope this helps.|||
i have created a new login say "me" with the same userid and the password to access my database "test".I created this using the Enterprise Manager so i am not well aware of the securities and permissions in the sql server 2000.
The problem is that with this login "me" i can access the master and pubs database which i dont want as i have set the permissions to access only the "test" database.
I have checked this in the securties-->Logins-->Database Access tab.
Any help on this pls.
I could be wrong but I think you may have set the permissions in the Master database for the database permissions instead of the test database. Hope this helps.|||i am not sure abt this.But i have checked on the some sites..when you are creating the new login you have to specify the default database.So for my login "me" i specified the defaultdatabase as "test".Now the user "me" should only have the access to the test database.
But with the user "me" i can connect to the pubs and master database.Also when i am registerry the database i can access the pubs and master in the Enterprise Manager.
I m sure i m missing something..could anyone help me on this??
thanks
|||If you are using Enterprise manager SQL Server permissions are very simple, you have the database permissions you create in the database under User and the server permissions you create in the Security section of Enterprise manager. If your user can access Pubs and Master, then Master may have been your default database. Fixing such permissions problems may have you editing the Master database which I will not recommend in a production server. Hope this helps.|||
Thanks for your reply.I also thought that doing it with the Enterprise Manager would be a easy task and infact it is.But i am not sure for the reason of my problem.
I tried to do this also but my user "me" is not even shown in the pubs or the master databases users.
I searched this forum on this issue i found this post but without any solutions
http://forums.asp.net/715688/ShowPost.aspx
Any help pls??
Thanks
Try these links for Troubleshooting Orphaned Users and solutions. Hope this helps.
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
http://blogs.geekdojo.net/ryan/archive/2004/05/04/1849.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;274188&sd=tech
Sunday, February 19, 2012
access one remote SQL server using 2 different users accounts via Enterprise Manager
Hello,
I ran into a strange situation. I need to access the same remote SQL
server using 2 different user accounts at the same time. I can't seem
to do it using Enterprise Manager.
This is the first time I ran into this type of problem. I signed up for
web hosting service with a company called Netnation. They have a
strange policy- everytime, I create a database on their MS SQL server,
they give me a new user account to access the new database. so if i own
2 databases, then i will have to use 2 user names for the databases.
each user name can only access one database.
I am have problem configuring my Enterprise Manager to allow me to see
more than one database at a time because of the "one -user-one
-database" problem.
Does anyone know if there is anyway i can set up Enterprise Manager to
get round this problem?
Thank you in advance!
Eddy
One option is to register the server twice - create an alias
for the server and then register the second one with that
alias. You can use the second set of credentials to register
the second instance of the server with the alias.
So you'd end up with two server nodes pointing to the same
server but it would still be in one Enterprise Manager
console.
-Sue
On 16 Jan 2006 16:39:52 -0800, eddiekwang@.hotmail.com wrote:
>Hello,
>I ran into a strange situation. I need to access the same remote SQL
>server using 2 different user accounts at the same time. I can't seem
>to do it using Enterprise Manager.
>This is the first time I ran into this type of problem. I signed up for
>web hosting service with a company called Netnation. They have a
>strange policy- everytime, I create a database on their MS SQL server,
>they give me a new user account to access the new database. so if i own
>2 databases, then i will have to use 2 user names for the databases.
>each user name can only access one database.
>I am have problem configuring my Enterprise Manager to allow me to see
>more than one database at a time because of the "one -user-one
>-database" problem.
>Does anyone know if there is anyway i can set up Enterprise Manager to
>get round this problem?
>Thank you in advance!
>Eddy
|||Sue,
Thanks for the reply. I already tried registering the server twice but
it didn't let me. I can't remember the specifics of the error message.
Did it ever work for you?
Eddy
|||Hi Eddy,
Yes...worked fine. You need to have it registered under a
different name than the current registration. That's why I
said to create an alias first. Then register the alias. You
probably tried to register it twice with the same name.
-Sue
On 20 Jan 2006 12:34:49 -0800, eddiekwang@.hotmail.com wrote:
>Sue,
>Thanks for the reply. I already tried registering the server twice but
>it didn't let me. I can't remember the specifics of the error message.
>Did it ever work for you?
>Eddy
I ran into a strange situation. I need to access the same remote SQL
server using 2 different user accounts at the same time. I can't seem
to do it using Enterprise Manager.
This is the first time I ran into this type of problem. I signed up for
web hosting service with a company called Netnation. They have a
strange policy- everytime, I create a database on their MS SQL server,
they give me a new user account to access the new database. so if i own
2 databases, then i will have to use 2 user names for the databases.
each user name can only access one database.
I am have problem configuring my Enterprise Manager to allow me to see
more than one database at a time because of the "one -user-one
-database" problem.
Does anyone know if there is anyway i can set up Enterprise Manager to
get round this problem?
Thank you in advance!
Eddy
One option is to register the server twice - create an alias
for the server and then register the second one with that
alias. You can use the second set of credentials to register
the second instance of the server with the alias.
So you'd end up with two server nodes pointing to the same
server but it would still be in one Enterprise Manager
console.
-Sue
On 16 Jan 2006 16:39:52 -0800, eddiekwang@.hotmail.com wrote:
>Hello,
>I ran into a strange situation. I need to access the same remote SQL
>server using 2 different user accounts at the same time. I can't seem
>to do it using Enterprise Manager.
>This is the first time I ran into this type of problem. I signed up for
>web hosting service with a company called Netnation. They have a
>strange policy- everytime, I create a database on their MS SQL server,
>they give me a new user account to access the new database. so if i own
>2 databases, then i will have to use 2 user names for the databases.
>each user name can only access one database.
>I am have problem configuring my Enterprise Manager to allow me to see
>more than one database at a time because of the "one -user-one
>-database" problem.
>Does anyone know if there is anyway i can set up Enterprise Manager to
>get round this problem?
>Thank you in advance!
>Eddy
|||Sue,
Thanks for the reply. I already tried registering the server twice but
it didn't let me. I can't remember the specifics of the error message.
Did it ever work for you?
Eddy
|||Hi Eddy,
Yes...worked fine. You need to have it registered under a
different name than the current registration. That's why I
said to create an alias first. Then register the alias. You
probably tried to register it twice with the same name.
-Sue
On 20 Jan 2006 12:34:49 -0800, eddiekwang@.hotmail.com wrote:
>Sue,
>Thanks for the reply. I already tried registering the server twice but
>it didn't let me. I can't remember the specifics of the error message.
>Did it ever work for you?
>Eddy
access one remote SQL server using 2 different users accounts via Enterprise Manager
Hello,
I ran into a strange situation. I need to access the same remote SQL
server using 2 different user accounts at the same time. I can't seem
to do it using Enterprise Manager.
This is the first time I ran into this type of problem. I signed up for
web hosting service with a company called Netnation. They have a
strange policy- everytime, I create a database on their MS SQL server,
they give me a new user account to access the new database. so if i own
2 databases, then i will have to use 2 user names for the databases.
each user name can only access one database.
I am have problem configuring my Enterprise Manager to allow me to see
more than one database at a time because of the "one -user-one
-database" problem.
Does anyone know if there is anyway i can set up Enterprise Manager to
get round this problem?
Thank you in advance!
EddyOne option is to register the server twice - create an alias
for the server and then register the second one with that
alias. You can use the second set of credentials to register
the second instance of the server with the alias.
So you'd end up with two server nodes pointing to the same
server but it would still be in one Enterprise Manager
console.
-Sue
On 16 Jan 2006 16:39:52 -0800, eddiekwang@.hotmail.com wrote:
>Hello,
>I ran into a strange situation. I need to access the same remote SQL
>server using 2 different user accounts at the same time. I can't seem
>to do it using Enterprise Manager.
>This is the first time I ran into this type of problem. I signed up for
>web hosting service with a company called Netnation. They have a
>strange policy- everytime, I create a database on their MS SQL server,
>they give me a new user account to access the new database. so if i own
>2 databases, then i will have to use 2 user names for the databases.
>each user name can only access one database.
>I am have problem configuring my Enterprise Manager to allow me to see
>more than one database at a time because of the "one -user-one
>-database" problem.
>Does anyone know if there is anyway i can set up Enterprise Manager to
>get round this problem?
>Thank you in advance!
>Eddy|||Sue,
Thanks for the reply. I already tried registering the server twice but
it didn't let me. I can't remember the specifics of the error message.
Did it ever work for you?
Eddy|||Hi Eddy,
Yes...worked fine. You need to have it registered under a
different name than the current registration. That's why I
said to create an alias first. Then register the alias. You
probably tried to register it twice with the same name.
-Sue
On 20 Jan 2006 12:34:49 -0800, eddiekwang@.hotmail.com wrote:
>Sue,
>Thanks for the reply. I already tried registering the server twice but
>it didn't let me. I can't remember the specifics of the error message.
>Did it ever work for you?
>Eddy
I ran into a strange situation. I need to access the same remote SQL
server using 2 different user accounts at the same time. I can't seem
to do it using Enterprise Manager.
This is the first time I ran into this type of problem. I signed up for
web hosting service with a company called Netnation. They have a
strange policy- everytime, I create a database on their MS SQL server,
they give me a new user account to access the new database. so if i own
2 databases, then i will have to use 2 user names for the databases.
each user name can only access one database.
I am have problem configuring my Enterprise Manager to allow me to see
more than one database at a time because of the "one -user-one
-database" problem.
Does anyone know if there is anyway i can set up Enterprise Manager to
get round this problem?
Thank you in advance!
EddyOne option is to register the server twice - create an alias
for the server and then register the second one with that
alias. You can use the second set of credentials to register
the second instance of the server with the alias.
So you'd end up with two server nodes pointing to the same
server but it would still be in one Enterprise Manager
console.
-Sue
On 16 Jan 2006 16:39:52 -0800, eddiekwang@.hotmail.com wrote:
>Hello,
>I ran into a strange situation. I need to access the same remote SQL
>server using 2 different user accounts at the same time. I can't seem
>to do it using Enterprise Manager.
>This is the first time I ran into this type of problem. I signed up for
>web hosting service with a company called Netnation. They have a
>strange policy- everytime, I create a database on their MS SQL server,
>they give me a new user account to access the new database. so if i own
>2 databases, then i will have to use 2 user names for the databases.
>each user name can only access one database.
>I am have problem configuring my Enterprise Manager to allow me to see
>more than one database at a time because of the "one -user-one
>-database" problem.
>Does anyone know if there is anyway i can set up Enterprise Manager to
>get round this problem?
>Thank you in advance!
>Eddy|||Sue,
Thanks for the reply. I already tried registering the server twice but
it didn't let me. I can't remember the specifics of the error message.
Did it ever work for you?
Eddy|||Hi Eddy,
Yes...worked fine. You need to have it registered under a
different name than the current registration. That's why I
said to create an alias first. Then register the alias. You
probably tried to register it twice with the same name.
-Sue
On 20 Jan 2006 12:34:49 -0800, eddiekwang@.hotmail.com wrote:
>Sue,
>Thanks for the reply. I already tried registering the server twice but
>it didn't let me. I can't remember the specifics of the error message.
>Did it ever work for you?
>Eddy
access one remote SQL server using 2 different users accounts via Enterprise Manager
Hello,
I ran into a strange situation. I need to access the same remote SQL
server using 2 different user accounts at the same time. I can't seem
to do it using Enterprise Manager.
This is the first time I ran into this type of problem. I signed up for
web hosting service with a company called Netnation. They have a
strange policy- everytime, I create a database on their MS SQL server,
they give me a new user account to access the new database. so if i own
2 databases, then i will have to use 2 user names for the databases.
each user name can only access one database.
I am have problem configuring my Enterprise Manager to allow me to see
more than one database at a time because of the "one -user-one
-database" problem.
Does anyone know if there is anyway i can set up Enterprise Manager to
get round this problem?
Thank you in advance!
EddyOne option is to register the server twice - create an alias
for the server and then register the second one with that
alias. You can use the second set of credentials to register
the second instance of the server with the alias.
So you'd end up with two server nodes pointing to the same
server but it would still be in one Enterprise Manager
console.
-Sue
On 16 Jan 2006 16:39:52 -0800, eddiekwang@.hotmail.com wrote:
>Hello,
>I ran into a strange situation. I need to access the same remote SQL
>server using 2 different user accounts at the same time. I can't seem
>to do it using Enterprise Manager.
>This is the first time I ran into this type of problem. I signed up for
>web hosting service with a company called Netnation. They have a
>strange policy- everytime, I create a database on their MS SQL server,
>they give me a new user account to access the new database. so if i own
>2 databases, then i will have to use 2 user names for the databases.
>each user name can only access one database.
>I am have problem configuring my Enterprise Manager to allow me to see
>more than one database at a time because of the "one -user-one
>-database" problem.
>Does anyone know if there is anyway i can set up Enterprise Manager to
>get round this problem?
>Thank you in advance!
>Eddy|||Sue,
Thanks for the reply. I already tried registering the server twice but
it didn't let me. I can't remember the specifics of the error message.
Did it ever work for you?
Eddy|||Hi Eddy,
Yes...worked fine. You need to have it registered under a
different name than the current registration. That's why I
said to create an alias first. Then register the alias. You
probably tried to register it twice with the same name.
-Sue
On 20 Jan 2006 12:34:49 -0800, eddiekwang@.hotmail.com wrote:
>Sue,
>Thanks for the reply. I already tried registering the server twice but
>it didn't let me. I can't remember the specifics of the error message.
>Did it ever work for you?
>Eddy
I ran into a strange situation. I need to access the same remote SQL
server using 2 different user accounts at the same time. I can't seem
to do it using Enterprise Manager.
This is the first time I ran into this type of problem. I signed up for
web hosting service with a company called Netnation. They have a
strange policy- everytime, I create a database on their MS SQL server,
they give me a new user account to access the new database. so if i own
2 databases, then i will have to use 2 user names for the databases.
each user name can only access one database.
I am have problem configuring my Enterprise Manager to allow me to see
more than one database at a time because of the "one -user-one
-database" problem.
Does anyone know if there is anyway i can set up Enterprise Manager to
get round this problem?
Thank you in advance!
EddyOne option is to register the server twice - create an alias
for the server and then register the second one with that
alias. You can use the second set of credentials to register
the second instance of the server with the alias.
So you'd end up with two server nodes pointing to the same
server but it would still be in one Enterprise Manager
console.
-Sue
On 16 Jan 2006 16:39:52 -0800, eddiekwang@.hotmail.com wrote:
>Hello,
>I ran into a strange situation. I need to access the same remote SQL
>server using 2 different user accounts at the same time. I can't seem
>to do it using Enterprise Manager.
>This is the first time I ran into this type of problem. I signed up for
>web hosting service with a company called Netnation. They have a
>strange policy- everytime, I create a database on their MS SQL server,
>they give me a new user account to access the new database. so if i own
>2 databases, then i will have to use 2 user names for the databases.
>each user name can only access one database.
>I am have problem configuring my Enterprise Manager to allow me to see
>more than one database at a time because of the "one -user-one
>-database" problem.
>Does anyone know if there is anyway i can set up Enterprise Manager to
>get round this problem?
>Thank you in advance!
>Eddy|||Sue,
Thanks for the reply. I already tried registering the server twice but
it didn't let me. I can't remember the specifics of the error message.
Did it ever work for you?
Eddy|||Hi Eddy,
Yes...worked fine. You need to have it registered under a
different name than the current registration. That's why I
said to create an alias first. Then register the alias. You
probably tried to register it twice with the same name.
-Sue
On 20 Jan 2006 12:34:49 -0800, eddiekwang@.hotmail.com wrote:
>Sue,
>Thanks for the reply. I already tried registering the server twice but
>it didn't let me. I can't remember the specifics of the error message.
>Did it ever work for you?
>Eddy
Access MSDE Database
Hi All,
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||But you need to purchase a CAL
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||But you need to purchase a CAL
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Access MSDE Database
Hi All,
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.
yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.
|||But you need to purchase a CAL
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.
yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.
|||But you need to purchase a CAL
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Access MSDE Database
Hi All,
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||But you need to purchase a CAL :)
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL :)
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||But you need to purchase a CAL :)
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL :)
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Thursday, February 16, 2012
Access Linked Server
I was running SqlServer 2000, on windows 2k server with several Access linke
d
servers all running fine. I upgraded my server to 2003 Enterprise, and
applied sp4 to SqlServer and now cannot get the linked servers to work. Erro
r
7399 Authentication Failed.
Please helpI'm all set - had to re-set the systemDB key in the registry
"DrBob" wrote:
> I was running SqlServer 2000, on windows 2k server with several Access lin
ked
> servers all running fine. I upgraded my server to 2003 Enterprise, and
> applied sp4 to SqlServer and now cannot get the linked servers to work. Er
ror
> 7399 Authentication Failed.
> Please help
d
servers all running fine. I upgraded my server to 2003 Enterprise, and
applied sp4 to SqlServer and now cannot get the linked servers to work. Erro
r
7399 Authentication Failed.
Please helpI'm all set - had to re-set the systemDB key in the registry
"DrBob" wrote:
> I was running SqlServer 2000, on windows 2k server with several Access lin
ked
> servers all running fine. I upgraded my server to 2003 Enterprise, and
> applied sp4 to SqlServer and now cannot get the linked servers to work. Er
ror
> 7399 Authentication Failed.
> Please help
Subscribe to:
Posts (Atom)