Hi all, I'm trying to connect to SQL and enumerate all Agent jobs to find a
particular and call job.envoke on it.
Looked every where but can't find a code snippet on it or a sample.
Anyone can assist? CheersYou can use this to list all the jobs.
USE msdb
EXEC sp_help_job
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/|||Oops... Just read the subject line about SMO.. My fault..
You can try this link..
http://msdn2.microsoft.com/en-us/li...nt.
aspx
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/|||Thanks omnibuzz, I've tried that uri but since I'm new to SQL prog I haven't
figured out how to use for instance jobbasecollection classes to find out if
the job I'm interested in exist on the server.
Any help there with the code\implementation? Thanks.
"Omnibuzz" wrote:
> Oops... Just read the subject line about SMO.. My fault..
> You can try this link..
> http://msdn2.microsoft.com/en-us/li...n
t.aspx
> --
> -Omnibuzz (The SQL GC)
> http://omnibuzz-sql.blogspot.com/
>
>
Showing posts with label connect. Show all posts
Showing posts with label connect. Show all posts
Thursday, March 29, 2012
Monday, March 26, 2012
EnterpriseManager/SQL Query Analysier (Authentication)
We have a sql 2005 server mirror set that we need to connect to.
I am in one active directory domain (eg DomainA) and the sql 2005 mirror is in another (eg DomainB).
We are not allowed (by the sql 2005 server provider) to put a trust between the two active directory domains and if we use a sql server login then if the mirror fails over then we will lose access since the master does not get mirrored.
Is there a way of logining in to the sql server 2005 mirror in DomainB with out logging my whole machine into DomainB or is there a way to mirror the sql users between the two sql 2005 mirror servers.
Any help would be grreatly apperiated
Hi,
Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Thursday, March 22, 2012
Enterprise manger won't connect
Installed SQL 2000 on a completely up to date windows 2003 advanced server,
then applied sp3a, then I installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
I Get "SQL_alloc_handle on SQL_handle_env failed"
Tried all types of registrations.
Seems to be some sort of ODBC problem since I can attach to the database
remotely from access.
Any suggestions short of starting from scratch?I haven't encountered this particular problem, but I'd suggest you could try
re-intalling the SQL client tools only & see if that solves your problems.
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> Installed SQL 2000 on a completely up to date windows 2003 advanced
server,
> then applied sp3a, then I installed reporting service developer addition,
> then installed VS .net 2003 the reinstalled reporting services to get the
> Report Developer.
> Now I can't connect to the Server using EM.
> I Get "SQL_alloc_handle on SQL_handle_env failed"
> Tried all types of registrations.
> Seems to be some sort of ODBC problem since I can attach to the database
> remotely from access.
> Any suggestions short of starting from scratch?
>|||Thanks, I will give it a try.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > Installed SQL 2000 on a completely up to date windows 2003 advanced
> server,
> > then applied sp3a, then I installed reporting service developer
addition,
> > then installed VS .net 2003 the reinstalled reporting services to get
the
> > Report Developer.
> >
> > Now I can't connect to the Server using EM.
> >
> > I Get "SQL_alloc_handle on SQL_handle_env failed"
> >
> > Tried all types of registrations.
> >
> > Seems to be some sort of ODBC problem since I can attach to the database
> > remotely from access.
> >
> > Any suggestions short of starting from scratch?
> >
> >
>|||I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
related DLL's in the windows\system32 directory. Restoring them fixed the
problem.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > Installed SQL 2000 on a completely up to date windows 2003 advanced
> server,
> > then applied sp3a, then I installed reporting service developer
addition,
> > then installed VS .net 2003 the reinstalled reporting services to get
the
> > Report Developer.
> >
> > Now I can't connect to the Server using EM.
> >
> > I Get "SQL_alloc_handle on SQL_handle_env failed"
> >
> > Tried all types of registrations.
> >
> > Seems to be some sort of ODBC problem since I can attach to the database
> > remotely from access.
> >
> > Any suggestions short of starting from scratch?
> >
> >
>|||Thanks for the feedback
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:eHipkUyAEHA.3988@.tk2msftngp13.phx.gbl...
> I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
> related DLL's in the windows\system32 directory. Restoring them fixed the
> problem.
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> > I haven't encountered this particular problem, but I'd suggest you could
> try
> > re-intalling the SQL client tools only & see if that solves your
problems.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> > news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > > Installed SQL 2000 on a completely up to date windows 2003 advanced
> > server,
> > > then applied sp3a, then I installed reporting service developer
> addition,
> > > then installed VS .net 2003 the reinstalled reporting services to get
> the
> > > Report Developer.
> > >
> > > Now I can't connect to the Server using EM.
> > >
> > > I Get "SQL_alloc_handle on SQL_handle_env failed"
> > >
> > > Tried all types of registrations.
> > >
> > > Seems to be some sort of ODBC problem since I can attach to the
database
> > > remotely from access.
> > >
> > > Any suggestions short of starting from scratch?
> > >
> > >
> >
> >
>
then applied sp3a, then I installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
I Get "SQL_alloc_handle on SQL_handle_env failed"
Tried all types of registrations.
Seems to be some sort of ODBC problem since I can attach to the database
remotely from access.
Any suggestions short of starting from scratch?I haven't encountered this particular problem, but I'd suggest you could try
re-intalling the SQL client tools only & see if that solves your problems.
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> Installed SQL 2000 on a completely up to date windows 2003 advanced
server,
> then applied sp3a, then I installed reporting service developer addition,
> then installed VS .net 2003 the reinstalled reporting services to get the
> Report Developer.
> Now I can't connect to the Server using EM.
> I Get "SQL_alloc_handle on SQL_handle_env failed"
> Tried all types of registrations.
> Seems to be some sort of ODBC problem since I can attach to the database
> remotely from access.
> Any suggestions short of starting from scratch?
>|||Thanks, I will give it a try.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > Installed SQL 2000 on a completely up to date windows 2003 advanced
> server,
> > then applied sp3a, then I installed reporting service developer
addition,
> > then installed VS .net 2003 the reinstalled reporting services to get
the
> > Report Developer.
> >
> > Now I can't connect to the Server using EM.
> >
> > I Get "SQL_alloc_handle on SQL_handle_env failed"
> >
> > Tried all types of registrations.
> >
> > Seems to be some sort of ODBC problem since I can attach to the database
> > remotely from access.
> >
> > Any suggestions short of starting from scratch?
> >
> >
>|||I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
related DLL's in the windows\system32 directory. Restoring them fixed the
problem.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > Installed SQL 2000 on a completely up to date windows 2003 advanced
> server,
> > then applied sp3a, then I installed reporting service developer
addition,
> > then installed VS .net 2003 the reinstalled reporting services to get
the
> > Report Developer.
> >
> > Now I can't connect to the Server using EM.
> >
> > I Get "SQL_alloc_handle on SQL_handle_env failed"
> >
> > Tried all types of registrations.
> >
> > Seems to be some sort of ODBC problem since I can attach to the database
> > remotely from access.
> >
> > Any suggestions short of starting from scratch?
> >
> >
>|||Thanks for the feedback
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:eHipkUyAEHA.3988@.tk2msftngp13.phx.gbl...
> I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
> related DLL's in the windows\system32 directory. Restoring them fixed the
> problem.
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> > I haven't encountered this particular problem, but I'd suggest you could
> try
> > re-intalling the SQL client tools only & see if that solves your
problems.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> > news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > > Installed SQL 2000 on a completely up to date windows 2003 advanced
> > server,
> > > then applied sp3a, then I installed reporting service developer
> addition,
> > > then installed VS .net 2003 the reinstalled reporting services to get
> the
> > > Report Developer.
> > >
> > > Now I can't connect to the Server using EM.
> > >
> > > I Get "SQL_alloc_handle on SQL_handle_env failed"
> > >
> > > Tried all types of registrations.
> > >
> > > Seems to be some sort of ODBC problem since I can attach to the
database
> > > remotely from access.
> > >
> > > Any suggestions short of starting from scratch?
> > >
> > >
> >
> >
>
Enterprise manger won't connect
Installed SQL 2000 on a completely up to date windows 2003 advanced server,
then applied sp3a, then I installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
I Get "SQL_alloc_handle on SQL_handle_env failed"
Tried all types of registrations.
Seems to be some sort of ODBC problem since I can attach to the database
remotely from access.
Any suggestions short of starting from scratch?I haven't encountered this particular problem, but I'd suggest you could try
re-intalling the SQL client tools only & see if that solves your problems.
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> Installed SQL 2000 on a completely up to date windows 2003 advanced
server,
> then applied sp3a, then I installed reporting service developer addition,
> then installed VS .net 2003 the reinstalled reporting services to get the
> Report Developer.
> Now I can't connect to the Server using EM.
> I Get "SQL_alloc_handle on SQL_handle_env failed"
> Tried all types of registrations.
> Seems to be some sort of ODBC problem since I can attach to the database
> remotely from access.
> Any suggestions short of starting from scratch?
>|||Thanks, I will give it a try.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> server,
addition,
the
>|||I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
related DLL's in the windows\system32 directory. Restoring them fixed the
problem.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> server,
addition,
the
>|||Thanks for the feedback
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:eHipkUyAEHA.3988@.tk2msftngp13.phx.gbl...
> I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
> related DLL's in the windows\system32 directory. Restoring them fixed the
> problem.
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> try
problems.
> addition,
> the
database
>
then applied sp3a, then I installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
I Get "SQL_alloc_handle on SQL_handle_env failed"
Tried all types of registrations.
Seems to be some sort of ODBC problem since I can attach to the database
remotely from access.
Any suggestions short of starting from scratch?I haven't encountered this particular problem, but I'd suggest you could try
re-intalling the SQL client tools only & see if that solves your problems.
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> Installed SQL 2000 on a completely up to date windows 2003 advanced
server,
> then applied sp3a, then I installed reporting service developer addition,
> then installed VS .net 2003 the reinstalled reporting services to get the
> Report Developer.
> Now I can't connect to the Server using EM.
> I Get "SQL_alloc_handle on SQL_handle_env failed"
> Tried all types of registrations.
> Seems to be some sort of ODBC problem since I can attach to the database
> remotely from access.
> Any suggestions short of starting from scratch?
>|||Thanks, I will give it a try.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> server,
addition,
the
>|||I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
related DLL's in the windows\system32 directory. Restoring them fixed the
problem.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> server,
addition,
the
>|||Thanks for the feedback
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:eHipkUyAEHA.3988@.tk2msftngp13.phx.gbl...
> I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
> related DLL's in the windows\system32 directory. Restoring them fixed the
> problem.
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> try
problems.
> addition,
> the
database
>
Wednesday, March 21, 2012
Enterprise Manager Substitute
Is there a product I can use that would allow me to connect to a remote database and manage data locally? I downloaded the trial version and am using enterprise manager, but once the trial has expired, I"ll need something else. My database is hosted at a
commercial hosting company and I don't need to do any further development. I just need to get into the database and make minor data modifications. Is there something more affordable than purchasing the entire SQL Server suite?
Try this:
http://www.microsoft.com/downloads/d...displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||Thanks Aaron. I wanted to send you an email off the list but your email address got bounced so if you can send me your email address, that would be great.
|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.
commercial hosting company and I don't need to do any further development. I just need to get into the database and make minor data modifications. Is there something more affordable than purchasing the entire SQL Server suite?
Try this:
http://www.microsoft.com/downloads/d...displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||Thanks Aaron. I wanted to send you an email off the list but your email address got bounced so if you can send me your email address, that would be great.
|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.
Enterprise Manager Substitute
Is there a product I can use that would allow me to connect to a remote data
base and manage data locally? I downloaded the trial version and am using en
terprise manager, but once the trial has expired, I"ll need something else.
My database is hosted at a
commercial hosting company and I don't need to do any further development. I
just need to get into the database and make minor data modifications. Is th
ere something more affordable than purchasing the entire SQL Server suite?Try this:
A332CB7F959&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Thanks Aaron. I wanted to send you an email off the list but your email addr
ess got bounced so if you can send me your email address, that would be grea
t.|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.
base and manage data locally? I downloaded the trial version and am using en
terprise manager, but once the trial has expired, I"ll need something else.
My database is hosted at a
commercial hosting company and I don't need to do any further development. I
just need to get into the database and make minor data modifications. Is th
ere something more affordable than purchasing the entire SQL Server suite?Try this:
A332CB7F959&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Thanks Aaron. I wanted to send you an email off the list but your email addr
ess got bounced so if you can send me your email address, that would be grea
t.|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.
Enterprise Manager Substitute
Is there a product I can use that would allow me to connect to a remote database and manage data locally? I downloaded the trial version and am using enterprise manager, but once the trial has expired, I"ll need something else. My database is hosted at a commercial hosting company and I don't need to do any further development. I just need to get into the database and make minor data modifications. Is there something more affordable than purchasing the entire SQL Server suite?Try this:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Take out the TRASH.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Take out the TRASH.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.
Monday, March 19, 2012
Enterprise Manager runs slow on some computers
I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Enterprise Manager runs slow on some computers
I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?
I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?
I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Enterprise Manager Question
I have two clients who are on the same Remote SQL server with a webhost (SQLSERVERS1500.COM). Is there a way to connect to add this server to enterprise manager twice so I can connect to each of their accounts separately? Currently when I try to do this Ent. Manager tells me that the Server name already exists. I tried addding one of the servers to a different group, but that gave me the same error message.
thanksYes. You want to use client network utility (cliconfg.exe) to create an
alias then connect via the alias.
--
-oj
RAC & QALite!
http://www.rac4sql.net
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Create aliases in the client network utility, such as Servername_userA and
Servername_userB, that point to the same IP address or domain name. Then
you can create a registration for each "dynamic server name" with different
users.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Use the client network utility to define an alias for one.
>--Original Message--
>I have two clients who are on the same Remote SQL server
with a webhost (SQLSERVERS1500.COM). Is there a way to
connect to add this server to enterprise manager twice so
I can connect to each of their accounts separately?
Currently when I try to do this Ent. Manager tells me
that the Server name already exists. I tried addding one
of the servers to a different group, but that gave me the
same error message.
>thanks
>.
>|||Actually, I see it now, its in the sql server groups when I add a new
server. That worked.
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
thanksYes. You want to use client network utility (cliconfg.exe) to create an
alias then connect via the alias.
--
-oj
RAC & QALite!
http://www.rac4sql.net
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Create aliases in the client network utility, such as Servername_userA and
Servername_userB, that point to the same IP address or domain name. Then
you can create a registration for each "dynamic server name" with different
users.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Use the client network utility to define an alias for one.
>--Original Message--
>I have two clients who are on the same Remote SQL server
with a webhost (SQLSERVERS1500.COM). Is there a way to
connect to add this server to enterprise manager twice so
I can connect to each of their accounts separately?
Currently when I try to do this Ent. Manager tells me
that the Server name already exists. I tried addding one
of the servers to a different group, but that gave me the
same error message.
>thanks
>.
>|||Actually, I see it now, its in the sql server groups when I add a new
server. That worked.
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Sunday, March 11, 2012
Enterprise manager problem
hi, i've just installed sql server2000 on my home pc, im using to connect to
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guysTry adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.
****************************************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
****************************************
*********
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guysTry adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.
****************************************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
****************************************
*********
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys
Enterprise manager problem
hi, i've just installed sql server2000 on my home pc, im using to connect to
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guys
Try adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.
*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
*************************************************
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guys
Try adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.
*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
*************************************************
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys
Enterprise Manager Problem
Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJ
Try reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegr oups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJ
Try reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegr oups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>
Enterprise Manager Problem
Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>
Enterprise Manager Problem
Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>
Enterprise Manager Port?
What port does SQL Server Enterprise Manager need open to connect to a
remote database? I'm not finding documentation on this.
Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>
|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
remote database? I'm not finding documentation on this.
Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>
|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
Enterprise Manager Port?
What port does SQL Server Enterprise Manager need open to connect to a
remote database? I'm not finding documentation on this.Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
remote database? I'm not finding documentation on this.Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
Enterprise Manager Port?
What port does SQL Server Enterprise Manager need open to connect to a
remote database? I'm not finding documentation on this.Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
remote database? I'm not finding documentation on this.Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
Enterprise Manager over a VPN gets No items
I have an environment that has 18 separate SQL server machines. When
connected to the LAN I can connect to each and expand the databases tab no
problem. When I try the same over a VPN I find that three of my servers will
connect but on expanding the databases I get a long pause then 'No items'.
I've checked around and found some references to the same problem (SQL
server mag site) but no resolutions. I'm running XP pro and my SQL is sp3.
The three servers in question have only TCP and named pipes in the net lib,
they are all on Win2K one is on sp3, one on sp2 and one is 'out of the box'.
The VPN has ports 1433 and 1434 udp and tcp allowed.
connected to the LAN I can connect to each and expand the databases tab no
problem. When I try the same over a VPN I find that three of my servers will
connect but on expanding the databases I get a long pause then 'No items'.
I've checked around and found some references to the same problem (SQL
server mag site) but no resolutions. I'm running XP pro and my SQL is sp3.
The three servers in question have only TCP and named pipes in the net lib,
they are all on Win2K one is on sp3, one on sp2 and one is 'out of the box'.
The VPN has ports 1433 and 1434 udp and tcp allowed.
Does anyone have any suggestions as to what is causing this, its got to be
something simple but I've been looking at this so long now I cant see the
wood for the trees.
Help appreciated.There is a least one known issue that can produce this:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q315523
Here are some comments from an MS engineer on it:
http://groups.google.ch/groups?hl=e...%40cpmsftngxa06
There are several Google groups hits on this, by the way:
http://groups.google.com/groups?hl=...ems&sa=N&tab=wg
Simon
"Simon" <spamplin@.hss.com> wrote in message
news:bdpe27$k71$1@.hercules.btinternet.com...
> I have an environment that has 18 separate SQL server machines. When
> connected to the LAN I can connect to each and expand the databases tab no
> problem. When I try the same over a VPN I find that three of my servers
will
> connect but on expanding the databases I get a long pause then 'No items'.
> I've checked around and found some references to the same problem (SQL
> server mag site) but no resolutions. I'm running XP pro and my SQL is sp3.
> The three servers in question have only TCP and named pipes in the net
lib,
> they are all on Win2K one is on sp3, one on sp2 and one is 'out of the
box'.
> The VPN has ports 1433 and 1434 udp and tcp allowed.
> Does anyone have any suggestions as to what is causing this, its got to be
> something simple but I've been looking at this so long now I cant see the
> wood for the trees.
> Help appreciated.
enterprise manager on Windows XP x64
I have just installed Windows XP Pro x64 on new computer and having hard
time installing enterprise manager (SQL Server 2000) to connect to my SQL
2000 Server running on remote machine.
Is there any version of SQL Client Tools for x64 or I have to purchase SQL
Server 2005.
Thanks,
Vlado"Vlado Jasovic \(www.excelleinc.com\)" <vjasovicATexcelleincDOTcom>
wrote in news:LIydnU5LKY-WLuLenZ2dnUVZ_tidnZ2d@.giganews.com:
> I have just installed Windows XP Pro x64 on new computer and having
> hard time installing enterprise manager (SQL Server 2000) to connect
> to my SQL 2000 Server running on remote machine.
You can install and run the 32-bit version of Enterprise Manager. As far as
I know there is no 64-bit version of it.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
time installing enterprise manager (SQL Server 2000) to connect to my SQL
2000 Server running on remote machine.
Is there any version of SQL Client Tools for x64 or I have to purchase SQL
Server 2005.
Thanks,
Vlado"Vlado Jasovic \(www.excelleinc.com\)" <vjasovicATexcelleincDOTcom>
wrote in news:LIydnU5LKY-WLuLenZ2dnUVZ_tidnZ2d@.giganews.com:
> I have just installed Windows XP Pro x64 on new computer and having
> hard time installing enterprise manager (SQL Server 2000) to connect
> to my SQL 2000 Server running on remote machine.
You can install and run the 32-bit version of Enterprise Manager. As far as
I know there is no 64-bit version of it.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
Subscribe to:
Posts (Atom)