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?
> > >
> > >
> >
> >
>
Showing posts with label sp3a. Show all posts
Showing posts with label sp3a. Show all posts
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...
> 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 7, 2012
Enterprise Manager Error
Hi All,
I am running into an error in Enterprise Manager on SQL 2000 SP3a.
I added 6 databases to a server bring the total database count to 16.
Once I added the 6 databases to the server the databases would
not display in EM. The databases just dissapeared. However,
If I tried to view the databases from with DbArtisan I did not have a probem.
Also, If I tried to use Query Analyzer the databases were visible.
Is there a limit within EM on the number of databases it will display.
I Beleive this is a bug in EM. Has anybody encountered this problem.
Its certainly not 16 :-) I take it you tried closing EM and reopening it ?
Do the databases have any non alphanumeric characters in them ? Do you have
the latest service pack on your client pc ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Victor Flores" <vflores@.dot.state.tx.us> wrote in message
news:BCA07EB4-0BDF-4341-AF0A-AEDBA001DEFC@.microsoft.com...
> Hi All,
> I am running into an error in Enterprise Manager on SQL 2000 SP3a.
> I added 6 databases to a server bring the total database count to 16.
> Once I added the 6 databases to the server the databases would
> not display in EM. The databases just dissapeared. However,
> If I tried to view the databases from with DbArtisan I did not have a
probem.
> Also, If I tried to use Query Analyzer the databases were visible.
> Is there a limit within EM on the number of databases it will display.
> I Beleive this is a bug in EM. Has anybody encountered this problem.
|||I am at the Latest Service Pack.
I tried opening and closing EM.
DBs do not have any special characters or spaces.
max databaases is 32,267 for SQL Server.
This error occurs when I create more than 15 databases.
Any ideas.
TIA
Victor
I am running into an error in Enterprise Manager on SQL 2000 SP3a.
I added 6 databases to a server bring the total database count to 16.
Once I added the 6 databases to the server the databases would
not display in EM. The databases just dissapeared. However,
If I tried to view the databases from with DbArtisan I did not have a probem.
Also, If I tried to use Query Analyzer the databases were visible.
Is there a limit within EM on the number of databases it will display.
I Beleive this is a bug in EM. Has anybody encountered this problem.
Its certainly not 16 :-) I take it you tried closing EM and reopening it ?
Do the databases have any non alphanumeric characters in them ? Do you have
the latest service pack on your client pc ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Victor Flores" <vflores@.dot.state.tx.us> wrote in message
news:BCA07EB4-0BDF-4341-AF0A-AEDBA001DEFC@.microsoft.com...
> Hi All,
> I am running into an error in Enterprise Manager on SQL 2000 SP3a.
> I added 6 databases to a server bring the total database count to 16.
> Once I added the 6 databases to the server the databases would
> not display in EM. The databases just dissapeared. However,
> If I tried to view the databases from with DbArtisan I did not have a
probem.
> Also, If I tried to use Query Analyzer the databases were visible.
> Is there a limit within EM on the number of databases it will display.
> I Beleive this is a bug in EM. Has anybody encountered this problem.
|||I am at the Latest Service Pack.
I tried opening and closing EM.
DBs do not have any special characters or spaces.
max databaases is 32,267 for SQL Server.
This error occurs when I create more than 15 databases.
Any ideas.
TIA
Victor
Enterprise Manager Error
Hi All,
I am running into an error in Enterprise Manager on SQL 2000 SP3a.
I added 6 databases to a server bring the total database count to 16.
Once I added the 6 databases to the server the databases would
not display in EM. The databases just dissapeared. However,
If I tried to view the databases from with DbArtisan I did not have a probem
.
Also, If I tried to use Query Analyzer the databases were visible.
Is there a limit within EM on the number of databases it will display.
I Beleive this is a bug in EM. Has anybody encountered this problem.Its certainly not 16 :-) I take it you tried closing EM and reopening it ?
Do the databases have any non alphanumeric characters in them ? Do you have
the latest service pack on your client pc ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Victor Flores" <vflores@.dot.state.tx.us> wrote in message
news:BCA07EB4-0BDF-4341-AF0A-AEDBA001DEFC@.microsoft.com...
> Hi All,
> I am running into an error in Enterprise Manager on SQL 2000 SP3a.
> I added 6 databases to a server bring the total database count to 16.
> Once I added the 6 databases to the server the databases would
> not display in EM. The databases just dissapeared. However,
> If I tried to view the databases from with DbArtisan I did not have a
probem.
> Also, If I tried to use Query Analyzer the databases were visible.
> Is there a limit within EM on the number of databases it will display.
> I Beleive this is a bug in EM. Has anybody encountered this problem.|||I am at the Latest Service Pack.
I tried opening and closing EM.
DBs do not have any special characters or spaces.
max databaases is 32,267 for SQL Server.
This error occurs when I create more than 15 databases.
Any ideas.
TIA
Victor
I am running into an error in Enterprise Manager on SQL 2000 SP3a.
I added 6 databases to a server bring the total database count to 16.
Once I added the 6 databases to the server the databases would
not display in EM. The databases just dissapeared. However,
If I tried to view the databases from with DbArtisan I did not have a probem
.
Also, If I tried to use Query Analyzer the databases were visible.
Is there a limit within EM on the number of databases it will display.
I Beleive this is a bug in EM. Has anybody encountered this problem.Its certainly not 16 :-) I take it you tried closing EM and reopening it ?
Do the databases have any non alphanumeric characters in them ? Do you have
the latest service pack on your client pc ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Victor Flores" <vflores@.dot.state.tx.us> wrote in message
news:BCA07EB4-0BDF-4341-AF0A-AEDBA001DEFC@.microsoft.com...
> Hi All,
> I am running into an error in Enterprise Manager on SQL 2000 SP3a.
> I added 6 databases to a server bring the total database count to 16.
> Once I added the 6 databases to the server the databases would
> not display in EM. The databases just dissapeared. However,
> If I tried to view the databases from with DbArtisan I did not have a
probem.
> Also, If I tried to use Query Analyzer the databases were visible.
> Is there a limit within EM on the number of databases it will display.
> I Beleive this is a bug in EM. Has anybody encountered this problem.|||I am at the Latest Service Pack.
I tried opening and closing EM.
DBs do not have any special characters or spaces.
max databaases is 32,267 for SQL Server.
This error occurs when I create more than 15 databases.
Any ideas.
TIA
Victor
Sunday, February 26, 2012
Enterprise Manager Error
Hi All
I am running into an error in Enterprise Manager on SQL 2000 SP3a
I added 6 databases to a server bring the total database count to 16
Once I added the 6 databases to the server the databases woul
not display in EM. The databases just dissapeared. However
If I tried to view the databases from with DbArtisan I did not have a probem
Also, If I tried to use Query Analyzer the databases were visible
Is there a limit within EM on the number of databases it will display
I Beleive this is a bug in EM. Has anybody encountered this problem.Its certainly not 16 :-) I take it you tried closing EM and reopening it ?
Do the databases have any non alphanumeric characters in them ? Do you have
the latest service pack on your client pc ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Victor Flores" <vflores@.dot.state.tx.us> wrote in message
news:BCA07EB4-0BDF-4341-AF0A-AEDBA001DEFC@.microsoft.com...
> Hi All,
> I am running into an error in Enterprise Manager on SQL 2000 SP3a.
> I added 6 databases to a server bring the total database count to 16.
> Once I added the 6 databases to the server the databases would
> not display in EM. The databases just dissapeared. However,
> If I tried to view the databases from with DbArtisan I did not have a
probem.
> Also, If I tried to use Query Analyzer the databases were visible.
> Is there a limit within EM on the number of databases it will display.
> I Beleive this is a bug in EM. Has anybody encountered this problem.
I am running into an error in Enterprise Manager on SQL 2000 SP3a
I added 6 databases to a server bring the total database count to 16
Once I added the 6 databases to the server the databases woul
not display in EM. The databases just dissapeared. However
If I tried to view the databases from with DbArtisan I did not have a probem
Also, If I tried to use Query Analyzer the databases were visible
Is there a limit within EM on the number of databases it will display
I Beleive this is a bug in EM. Has anybody encountered this problem.Its certainly not 16 :-) I take it you tried closing EM and reopening it ?
Do the databases have any non alphanumeric characters in them ? Do you have
the latest service pack on your client pc ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Victor Flores" <vflores@.dot.state.tx.us> wrote in message
news:BCA07EB4-0BDF-4341-AF0A-AEDBA001DEFC@.microsoft.com...
> Hi All,
> I am running into an error in Enterprise Manager on SQL 2000 SP3a.
> I added 6 databases to a server bring the total database count to 16.
> Once I added the 6 databases to the server the databases would
> not display in EM. The databases just dissapeared. However,
> If I tried to view the databases from with DbArtisan I did not have a
probem.
> Also, If I tried to use Query Analyzer the databases were visible.
> Is there a limit within EM on the number of databases it will display.
> I Beleive this is a bug in EM. Has anybody encountered this problem.
Subscribe to:
Posts (Atom)