Did it really successfully install?

SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed =
SQL Server 7 on the server and although the installer ended successfully =
I have this in the sqlstp.log:
20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sqldbreg.exe -RegServer
20:44:13 Process Exit Code: (-2147312566) Error loading type =
library/DLL.
....
20:44:16 Installation Succeeded
Should I fix this and if so how? Thanks.
I looked to see if I have the file sqldbreg.exe and I do. It is in =
Microsoft Visual Studio 6\Common\...
--=20
George Hester
_________________________________
This sounds like the installer had an issue registring the sql debuger
utility integrated with your Visual Studio instalation. This should affect
the SQL Server installation but might keep you from properly using the
debuging tools.
I would service pack your SS7 installation and then service pack your VS
installations.
Sincerely,
Anthony Thomas

"George Hester" <hesterloli@.hotmail.com> wrote in message
news:Oqunpls8EHA.1084@.TK2MSFTNGP15.phx.gbl...
SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed SQL
Server 7 on the server and although the installer ended successfully I have
this in the sqlstp.log:
20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sqldbreg.exe -RegServer
20:44:13 Process Exit Code: (-2147312566) Error loading type library/DLL.
....
20:44:16 Installation Succeeded
Should I fix this and if so how? Thanks.
I looked to see if I have the file sqldbreg.exe and I do. It is in
Microsoft Visual Studio 6\Common\...
George Hester
_________________________________
|||Yes that is what it was. It turned out DCOM settings and file locations =
were not set right. I manually fixed it. Thanks.
--=20
George Hester
_________________________________
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message =
news:etAJppIDFHA.3132@.TK2MSFTNGP09.phx.gbl...
> This sounds like the installer had an issue registring the sql debuger
> utility integrated with your Visual Studio instalation. This should =
affect
> the SQL Server installation but might keep you from properly using the
> debuging tools.
>=20
> I would service pack your SS7 installation and then service pack your =
VS
> installations.
>=20
> Sincerely,
>=20
>=20
> Anthony Thomas
>=20
>=20
> --=20
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:Oqunpls8EHA.1084@.TK2MSFTNGP15.phx.gbl...
> SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed =
SQL
> Server 7 on the server and although the installer ended successfully I =
have
> this in the sqlstp.log:
>=20
> 20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sqldbreg.exe =
-RegServer
> 20:44:13 Process Exit Code: (-2147312566) Error loading type =
library/DLL.
> ...
> 20:44:16 Installation Succeeded
>=20
> Should I fix this and if so how? Thanks.
>=20
> I looked to see if I have the file sqldbreg.exe and I do. It is in
> Microsoft Visual Studio 6\Common\...
>=20
> --=20
> George Hester
> _________________________________
>=20
>=20

Did it really successfully install?

SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed = SQL Server 7 on the server and although the installer ended successfully = I have this in the sqlstp.log:
20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sqldbreg.exe -RegServer
20:44:13 Process Exit Code: (-2147312566) Error loading type = library/DLL.
...
20:44:16 Installation Succeeded
Should I fix this and if so how? Thanks.
I looked to see if I have the file sqldbreg.exe and I do. It is in = Microsoft Visual Studio 6\Common\...
-- George Hester
_________________________________This sounds like the installer had an issue registring the sql debuger
utility integrated with your Visual Studio instalation. This should affect
the SQL Server installation but might keep you from properly using the
debuging tools.
I would service pack your SS7 installation and then service pack your VS
installations.
Sincerely,
Anthony Thomas
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:Oqunpls8EHA.1084@.TK2MSFTNGP15.phx.gbl...
SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed SQL
Server 7 on the server and although the installer ended successfully I have
this in the sqlstp.log:
20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sqldbreg.exe -RegServer
20:44:13 Process Exit Code: (-2147312566) Error loading type library/DLL.
...
20:44:16 Installation Succeeded
Should I fix this and if so how? Thanks.
I looked to see if I have the file sqldbreg.exe and I do. It is in
Microsoft Visual Studio 6\Common\...
--
George Hester
_________________________________|||Yes that is what it was. It turned out DCOM settings and file locations =were not set right. I manually fixed it. Thanks.
-- George Hester
_________________________________
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message =news:etAJppIDFHA.3132@.TK2MSFTNGP09.phx.gbl...
> This sounds like the installer had an issue registring the sql debuger
> utility integrated with your Visual Studio instalation. This should =affect
> the SQL Server installation but might keep you from properly using the
> debuging tools.
> > I would service pack your SS7 installation and then service pack your =VS
> installations.
> > Sincerely,
> > > Anthony Thomas
> > > -- > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:Oqunpls8EHA.1084@.TK2MSFTNGP15.phx.gbl...
> SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed =SQL
> Server 7 on the server and although the installer ended successfully I =have
> this in the sqlstp.log:
> > 20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sqldbreg.exe =-RegServer
> 20:44:13 Process Exit Code: (-2147312566) Error loading type =library/DLL.
> ...
> 20:44:16 Installation Succeeded
> > Should I fix this and if so how? Thanks.
> > I looked to see if I have the file sqldbreg.exe and I do. It is in
> Microsoft Visual Studio 6\Common\...
> > -- > George Hester
> _________________________________
> >=20

Did it really successfully install?

SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed =
SQL Server 7 on the server and although the installer ended successfully =
I have this in the sqlstp.log:
20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sq
ldbreg.exe -RegServer
20:44:13 Process Exit Code: (-2147312566) Error loading type =
library/DLL.
...
20:44:16 Installation Succeeded
Should I fix this and if so how? Thanks.
I looked to see if I have the file sqldbreg.exe and I do. It is in =
Microsoft Visual Studio 6\Common\...
--=20
George Hester
_________________________________This sounds like the installer had an issue registring the sql debuger
utility integrated with your Visual Studio instalation. This should affect
the SQL Server installation but might keep you from properly using the
debuging tools.
I would service pack your SS7 installation and then service pack your VS
installations.
Sincerely,
Anthony Thomas
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:Oqunpls8EHA.1084@.TK2MSFTNGP15.phx.gbl...
SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed SQL
Server 7 on the server and although the installer ended successfully I have
this in the sqlstp.log:
20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sq
ldbreg.exe -RegServer
20:44:13 Process Exit Code: (-2147312566) Error loading type library/DLL.
...
20:44:16 Installation Succeeded
Should I fix this and if so how? Thanks.
I looked to see if I have the file sqldbreg.exe and I do. It is in
Microsoft Visual Studio 6\Common\...
George Hester
_________________________________|||Yes that is what it was. It turned out DCOM settings and file locations =
were not set right. I manually fixed it. Thanks.
--=20
George Hester
_________________________________
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message =
news:etAJppIDFHA.3132@.TK2MSFTNGP09.phx.gbl...
> This sounds like the installer had an issue registring the sql debuger
> utility integrated with your Visual Studio instalation. This should =
affect
> the SQL Server installation but might keep you from properly using the
> debuging tools.
>=20
> I would service pack your SS7 installation and then service pack your =
VS
> installations.
>=20
> Sincerely,
>=20
>=20
> Anthony Thomas
>=20
>=20
> --=20
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:Oqunpls8EHA.1084@.TK2MSFTNGP15.phx.gbl...
> SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed =
SQL
> Server 7 on the server and although the installer ended successfully I =
have
> this in the sqlstp.log:
>=20
> 20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sq
ldbreg.exe =
-RegServer
> 20:44:13 Process Exit Code: (-2147312566) Error loading type =
library/DLL.
> ...
> 20:44:16 Installation Succeeded
>=20
> Should I fix this and if so how? Thanks.
>=20
> I looked to see if I have the file sqldbreg.exe and I do. It is in
> Microsoft Visual Studio 6\Common\...
>=20
> --=20
> George Hester
> _________________________________
>=20
>=20

did debugging with SP3 ever get fixed for Visual Studio.NET?

When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
from Visual Studio - single stepping into the stored procedure.
I spent a day trying to fix it maybe 8 months ago - and gave up.
Are there any tech notes that actually work to restore the ability to debug when
SQL Server is on the same machine as Visual Studio?
If not, can I fix the problem by un-installing SQL Server and then installing
the SP2 version? I'm unclear if the database files would have any problems with
this - or have any problems when moving SP2 databases to my SP3 production
boxes?
--
Thanks in advance, Les CaudleWe can get it to single step through the procedure, but not set a breakpoint.
Was it ever possible to breakpoint? I note the documentation states it will
not "Break", but we took that to mean one could not break the execution and
re-start.
Cheers
Happy Harry
"Les Caudle" wrote:
> When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
> from Visual Studio - single stepping into the stored procedure.
> I spent a day trying to fix it maybe 8 months ago - and gave up.
> Are there any tech notes that actually work to restore the ability to debug when
> SQL Server is on the same machine as Visual Studio?
> If not, can I fix the problem by un-installing SQL Server and then installing
> the SP2 version? I'm unclear if the database files would have any problems with
> this - or have any problems when moving SP2 databases to my SP3 production
> boxes?
> --
> Thanks in advance, Les Caudle
>

Dictionarry order question

I have an installed sql server 2000 language English with server collation
set to SQL_Latin1_General_CP1_CI_AS on a W2k server box. There are several
applications running in production using that machine and those settings.
Now the company is getting a new program that has as the requirement for its
sql server dictionary order to be set to Custom, Case insensitive, Accent
insensitive, for use with 1252 character set.
This server has lots of capacity left and there is no way to justify
spending dollars on another processor license for this app when the server
we already have should be able to do the job.
Is it possible to change the dictionary order on the current server and its
databases and test my current apps? If they still work as before I can then
leave it like that, if not I would have to be able to come back to current
settings.
What is the expert opinion on the difference in settings between the new app
and the current settings as shown above, do you think we should try keeping
our current settings for the new app? The app coming in is using asp pages
and the users are all French, the data in the files will be French with
accented characters and also some English in some fields.
Any help would be greatly appreciated,
RD
If it was me, I'd set up a new instance of SQL Server (configured with the
collation sequence of your choice) and let 'er rip. But with SQL Server
2000, it's possible to have different collation sequences on the instance,
database, table, or even column (IIRC). So there's no reason to change your
existing apps and databases. As far as I know, changing collations is a
real pain in the butt, and involves DTS'ing or BCP'ing your data to a new
home, or out to a temporary one, and in to the re-built one.
Clint
"RD" <bdufour@.sgiims.com> wrote in message
news:#OXncM9hFHA.4000@.TK2MSFTNGP12.phx.gbl...
> I have an installed sql server 2000 language English with server collation
> set to SQL_Latin1_General_CP1_CI_AS on a W2k server box. There are several
> applications running in production using that machine and those settings.
> Now the company is getting a new program that has as the requirement for
its
> sql server dictionary order to be set to Custom, Case insensitive, Accent
> insensitive, for use with 1252 character set.
> This server has lots of capacity left and there is no way to justify
> spending dollars on another processor license for this app when the server
> we already have should be able to do the job.
> Is it possible to change the dictionary order on the current server and
its
> databases and test my current apps? If they still work as before I can
then
> leave it like that, if not I would have to be able to come back to current
> settings.
> What is the expert opinion on the difference in settings between the new
app
> and the current settings as shown above, do you think we should try
keeping
> our current settings for the new app? The app coming in is using asp pages
> and the users are all French, the data in the files will be French with
> accented characters and also some English in some fields.
> Any help would be greatly appreciated,
> RD
>

Dictionarry order question

I have an installed sql server 2000 language English with server collation
set to SQL_Latin1_General_CP1_CI_AS on a W2k server box. There are several
applications running in production using that machine and those settings.
Now the company is getting a new program that has as the requirement for its
sql server dictionary order to be set to Custom, Case insensitive, Accent
insensitive, for use with 1252 character set.
This server has lots of capacity left and there is no way to justify
spending dollars on another processor license for this app when the server
we already have should be able to do the job.
Is it possible to change the dictionary order on the current server and its
databases and test my current apps? If they still work as before I can then
leave it like that, if not I would have to be able to come back to current
settings.
What is the expert opinion on the difference in settings between the new app
and the current settings as shown above, do you think we should try keeping
our current settings for the new app? The app coming in is using asp pages
and the users are all French, the data in the files will be French with
accented characters and also some English in some fields.
Any help would be greatly appreciated,
RDIf it was me, I'd set up a new instance of SQL Server (configured with the
collation sequence of your choice) and let 'er rip. But with SQL Server
2000, it's possible to have different collation sequences on the instance,
database, table, or even column (IIRC). So there's no reason to change your
existing apps and databases. As far as I know, changing collations is a
real pain in the butt, and involves DTS'ing or BCP'ing your data to a new
home, or out to a temporary one, and in to the re-built one.
Clint
"RD" <bdufour@.sgiims.com> wrote in message
news:#OXncM9hFHA.4000@.TK2MSFTNGP12.phx.gbl...
> I have an installed sql server 2000 language English with server collation
> set to SQL_Latin1_General_CP1_CI_AS on a W2k server box. There are several
> applications running in production using that machine and those settings.
> Now the company is getting a new program that has as the requirement for
its
> sql server dictionary order to be set to Custom, Case insensitive, Accent
> insensitive, for use with 1252 character set.
> This server has lots of capacity left and there is no way to justify
> spending dollars on another processor license for this app when the server
> we already have should be able to do the job.
> Is it possible to change the dictionary order on the current server and
its
> databases and test my current apps? If they still work as before I can
then
> leave it like that, if not I would have to be able to come back to current
> settings.
> What is the expert opinion on the difference in settings between the new
app
> and the current settings as shown above, do you think we should try
keeping
> our current settings for the new app? The app coming in is using asp pages
> and the users are all French, the data in the files will be French with
> accented characters and also some English in some fields.
> Any help would be greatly appreciated,
> RD
>

Dictionarry order question

I have an installed sql server 2000 language English with server collation
set to SQL_Latin1_General_CP1_CI_AS on a W2k server box. There are several
applications running in production using that machine and those settings.
Now the company is getting a new program that has as the requirement for its
sql server dictionary order to be set to Custom, Case insensitive, Accent
insensitive, for use with 1252 character set.
This server has lots of capacity left and there is no way to justify
spending dollars on another processor license for this app when the server
we already have should be able to do the job.
Is it possible to change the dictionary order on the current server and its
databases and test my current apps? If they still work as before I can then
leave it like that, if not I would have to be able to come back to current
settings.
What is the expert opinion on the difference in settings between the new app
and the current settings as shown above, do you think we should try keeping
our current settings for the new app? The app coming in is using asp pages
and the users are all French, the data in the files will be French with
accented characters and also some English in some fields.
Any help would be greatly appreciated,
RDIf it was me, I'd set up a new instance of SQL Server (configured with the
collation sequence of your choice) and let 'er rip. But with SQL Server
2000, it's possible to have different collation sequences on the instance,
database, table, or even column (IIRC). So there's no reason to change your
existing apps and databases. As far as I know, changing collations is a
real pain in the butt, and involves DTS'ing or BCP'ing your data to a new
home, or out to a temporary one, and in to the re-built one.
Clint
"RD" <bdufour@.sgiims.com> wrote in message
news:#OXncM9hFHA.4000@.TK2MSFTNGP12.phx.gbl...
> I have an installed sql server 2000 language English with server collation
> set to SQL_Latin1_General_CP1_CI_AS on a W2k server box. There are several
> applications running in production using that machine and those settings.
> Now the company is getting a new program that has as the requirement for
its
> sql server dictionary order to be set to Custom, Case insensitive, Accent
> insensitive, for use with 1252 character set.
> This server has lots of capacity left and there is no way to justify
> spending dollars on another processor license for this app when the server
> we already have should be able to do the job.
> Is it possible to change the dictionary order on the current server and
its
> databases and test my current apps? If they still work as before I can
then
> leave it like that, if not I would have to be able to come back to current
> settings.
> What is the expert opinion on the difference in settings between the new
app
> and the current settings as shown above, do you think we should try
keeping
> our current settings for the new app? The app coming in is using asp pages
> and the users are all French, the data in the files will be French with
> accented characters and also some English in some fields.
> Any help would be greatly appreciated,
> RD
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia PupoI think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows[vbcol=seagreen]
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia PupoI think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > HI
> > i have installed VisualStudio Sp6 after this installation when open my
Sql
> > 2000 server Sp3 i can't visualize Diagrams. Any operation on this
windows
> > don't work.
> > I reinstalled Sql Sp3 but don't work.
> > Can help me?
> > Tia Pupo
> >
> >
>

Diagrams NOT appearing in Enterprise Manager

Hi
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON

Quote:

Originally posted by ANON
Hi
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON

Were you able to figure this out? I am having the EXACT same problem.
Any help would be greatly appreciated.
Thanks,
Jeff

Diagram in Yukon

Where can I find the diagram in SQL Server 2005? I installed the beta 2 version but i cannot find the diagram. Another thing is: how can i embed .net codes inside stored procedure or SQL Server 2005?

Thanks
Lou BelaroBeta 2 is very old and does not contain the database diagram tool. It is, however, in the most recent version of SQL Server 2005 (June CTP), which you can get from http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/ctp.mspx.

To use .NET code inside stored procedures, functions, triggers, etc. you need to create an assembly in SQL Server. Please see the following topics in SQL Server Books Online for additional information.

CREATE ASSEMBLY
Creating CLR Stored Procedures
CLR Programmability Samples|||I'll replace my current version.

Thanks alot,
Lou

DHCP Service fails to start after installing SQL Server 2005 April CTP

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Information
Event Source: Application Popup
Description: Application popup: Service Control Manager: At least one service or driver failed during system startup. Use Event Viewer to examine the event log for details.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to restore the database. The following error occurred: An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.

Event Type: Error
Event Source: DhcpServer
Description: The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I also have this same problem after installing the june sql server 2005 ctp. Tried restore of dhcp database. Tried to create empty database. Uninstalled service and app. Uninstalled the dhcp server and sql server 2005 and then reinstalled dhcp server and still the same problem.

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1014
===========
The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.
===========

Error 1018
===========
The DHCP service failed to restore the database. The following error occurred:
An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

|||Oh, great. I'm having this issue too. It must be. I installed the SQL Server CTP a few weeks ago, didn't like it very much and uninstalled. Now I'm trying to install DHCP Server and I can't. I get the same error messages in the EventLog which you describe.

Hasn't this been solved yet?

|||I think someone from Microsoft should address this issue.

Thanks,|||Anybody ever get a resolution to this, I've seen it mentioned in all sorts of forums, one of which indicated there was a registry fix posted on the MSDN site but I can't find a fix anywhere. Microsoft whats the deal? How do we fix these problems?|||Hi Mark,

Thanks for weighing in. I found this thread from a Google search and it was way down on the list in this forum. But I can't see that anyone has ever fixed this! As soon as I posted my own problem, the topic popped up to the top of the list. That's the nice thing about this forum. So everyone who is having this problem needs to report in. This will keep this at the top of the list and hopefully get Microsoft's attention. They really need to fix this.

Workaround tip: This may be a *duh* or this may not be obvious to you; I didn't realize this solution at first. If you're connected to the Internet via a Router/Switch, it is possible that the router device can provide DHCP services for you. My LinkSys CableModem router provides DHCP, so I'm OK personally, but Microsoft really should fix this.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

(As a side note, why on Earth is DHCP Server using a Jet database? For goodness sakes, it's 2005!)|||http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=6c2ce44d-72d2-416d-afee-c51c9298c746
This issue is because setup creates wrong default registry value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl. To fix DHCP service just delete VssAccessControl registry key.
|||It worked! Thanks a lot.
Mike
|||

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

|||Experiencing the exact same problem. There is no "VssAccessControl" registery key. DHCP is starting but each moring it shuts down.|||Worked for me.. thanks|||I am still having this issue as well. I am getting event ids 1010, 1016, and 1014. I don't have SQL installed on this computer at all. Please help.|||I am getting this same issue, but about the same time I started receiving errors from Executive Software Diskeeper Enterprise edition, telling me that I could no longer defrag my root drive, as I had Volume shadow copy enabled. This software had always worked fine before on this system and the only changed I can tie this too are the critical updates released last week.
|||

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Information
Event Source: Application Popup
Description: Application popup: Service Control Manager: At least one service or driver failed during system startup. Use Event Viewer to examine the event log for details.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to restore the database. The following error occurred: An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.

Event Type: Error
Event Source: DhcpServer
Description: The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I also have this same problem after installing the june sql server 2005 ctp. Tried restore of dhcp database. Tried to create empty database. Uninstalled service and app. Uninstalled the dhcp server and sql server 2005 and then reinstalled dhcp server and still the same problem.

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1014
===========
The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.
===========

Error 1018
===========
The DHCP service failed to restore the database. The following error occurred:
An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

|||Oh, great. I'm having this issue too. It must be. I installed the SQL Server CTP a few weeks ago, didn't like it very much and uninstalled. Now I'm trying to install DHCP Server and I can't. I get the same error messages in the EventLog which you describe.

Hasn't this been solved yet?

|||I think someone from Microsoft should address this issue.

Thanks,|||Anybody ever get a resolution to this, I've seen it mentioned in all sorts of forums, one of which indicated there was a registry fix posted on the MSDN site but I can't find a fix anywhere. Microsoft whats the deal? How do we fix these problems?|||Hi Mark,

Thanks for weighing in. I found this thread from a Google search and it was way down on the list in this forum. But I can't see that anyone has ever fixed this! As soon as I posted my own problem, the topic popped up to the top of the list. That's the nice thing about this forum. So everyone who is having this problem needs to report in. This will keep this at the top of the list and hopefully get Microsoft's attention. They really need to fix this.

Workaround tip: This may be a *duh* or this may not be obvious to you; I didn't realize this solution at first. If you're connected to the Internet via a Router/Switch, it is possible that the router device can provide DHCP services for you. My LinkSys CableModem router provides DHCP, so I'm OK personally, but Microsoft really should fix this.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

(As a side note, why on Earth is DHCP Server using a Jet database? For goodness sakes, it's 2005!)|||http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=6c2ce44d-72d2-416d-afee-c51c9298c746
This issue is because setup creates wrong default registry value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl. To fix DHCP service just delete VssAccessControl registry key.|||It worked! Thanks a lot.
Mike|||

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

|||Experiencing the exact same problem. There is no "VssAccessControl" registery key. DHCP is starting but each moring it shuts down.|||Worked for me.. thanks|||I am still having this issue as well. I am getting event ids 1010, 1016, and 1014. I don't have SQL installed on this computer at all. Please help.|||I am getting this same issue, but about the same time I started receiving errors from Executive Software Diskeeper Enterprise edition, telling me that I could no longer defrag my root drive, as I had Volume shadow copy enabled. This software had always worked fine before on this system and the only changed I can tie this too are the critical updates released last week.|||

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Information
Event Source: Application Popup
Description: Application popup: Service Control Manager: At least one service or driver failed during system startup. Use Event Viewer to examine the event log for details.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to restore the database. The following error occurred: An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.

Event Type: Error
Event Source: DhcpServer
Description: The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I also have this same problem after installing the june sql server 2005 ctp. Tried restore of dhcp database. Tried to create empty database. Uninstalled service and app. Uninstalled the dhcp server and sql server 2005 and then reinstalled dhcp server and still the same problem.

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1014
===========
The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.
===========

Error 1018
===========
The DHCP service failed to restore the database. The following error occurred:
An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

|||Oh, great. I'm having this issue too. It must be. I installed the SQL Server CTP a few weeks ago, didn't like it very much and uninstalled. Now I'm trying to install DHCP Server and I can't. I get the same error messages in the EventLog which you describe.

Hasn't this been solved yet?

|||I think someone from Microsoft should address this issue.

Thanks,|||Anybody ever get a resolution to this, I've seen it mentioned in all sorts of forums, one of which indicated there was a registry fix posted on the MSDN site but I can't find a fix anywhere. Microsoft whats the deal? How do we fix these problems?|||Hi Mark,

Thanks for weighing in. I found this thread from a Google search and it was way down on the list in this forum. But I can't see that anyone has ever fixed this! As soon as I posted my own problem, the topic popped up to the top of the list. That's the nice thing about this forum. So everyone who is having this problem needs to report in. This will keep this at the top of the list and hopefully get Microsoft's attention. They really need to fix this.

Workaround tip: This may be a *duh* or this may not be obvious to you; I didn't realize this solution at first. If you're connected to the Internet via a Router/Switch, it is possible that the router device can provide DHCP services for you. My LinkSys CableModem router provides DHCP, so I'm OK personally, but Microsoft really should fix this.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

(As a side note, why on Earth is DHCP Server using a Jet database? For goodness sakes, it's 2005!)|||http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=6c2ce44d-72d2-416d-afee-c51c9298c746
This issue is because setup creates wrong default registry value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl. To fix DHCP service just delete VssAccessControl registry key.
|||It worked! Thanks a lot.
Mike
|||

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

|||Experiencing the exact same problem. There is no "VssAccessControl" registery key. DHCP is starting but each moring it shuts down.|||Worked for me.. thanks|||I am still having this issue as well. I am getting event ids 1010, 1016, and 1014. I don't have SQL installed on this computer at all. Please help.|||I am getting this same issue, but about the same time I started receiving errors from Executive Software Diskeeper Enterprise edition, telling me that I could no longer defrag my root drive, as I had Volume shadow copy enabled. This software had always worked fine before on this system and the only changed I can tie this too are the critical updates released last week.
|||

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Information
Event Source: Application Popup
Description: Application popup: Service Control Manager: At least one service or driver failed during system startup. Use Event Viewer to examine the event log for details.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to restore the database. The following error occurred: An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.

Event Type: Error
Event Source: DhcpServer
Description: The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I also have this same problem after installing the june sql server 2005 ctp. Tried restore of dhcp database. Tried to create empty database. Uninstalled service and app. Uninstalled the dhcp server and sql server 2005 and then reinstalled dhcp server and still the same problem.

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1014
===========
The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.
===========

Error 1018
===========
The DHCP service failed to restore the database. The following error occurred:
An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

|||Oh, great. I'm having this issue too. It must be. I installed the SQL Server CTP a few weeks ago, didn't like it very much and uninstalled. Now I'm trying to install DHCP Server and I can't. I get the same error messages in the EventLog which you describe.

Hasn't this been solved yet?

|||I think someone from Microsoft should address this issue.

Thanks,|||Anybody ever get a resolution to this, I've seen it mentioned in all sorts of forums, one of which indicated there was a registry fix posted on the MSDN site but I can't find a fix anywhere. Microsoft whats the deal? How do we fix these problems?|||Hi Mark,

Thanks for weighing in. I found this thread from a Google search and it was way down on the list in this forum. But I can't see that anyone has ever fixed this! As soon as I posted my own problem, the topic popped up to the top of the list. That's the nice thing about this forum. So everyone who is having this problem needs to report in. This will keep this at the top of the list and hopefully get Microsoft's attention. They really need to fix this.

Workaround tip: This may be a *duh* or this may not be obvious to you; I didn't realize this solution at first. If you're connected to the Internet via a Router/Switch, it is possible that the router device can provide DHCP services for you. My LinkSys CableModem router provides DHCP, so I'm OK personally, but Microsoft really should fix this.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

(As a side note, why on Earth is DHCP Server using a Jet database? For goodness sakes, it's 2005!)|||http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=6c2ce44d-72d2-416d-afee-c51c9298c746
This issue is because setup creates wrong default registry value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl. To fix DHCP service just delete VssAccessControl registry key.
|||It worked! Thanks a lot.
Mike
|||

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

|||Experiencing the exact same problem. There is no "VssAccessControl" registery key. DHCP is starting but each moring it shuts down.|||Worked for me.. thanks|||I am still having this issue as well. I am getting event ids 1010, 1016, and 1014. I don't have SQL installed on this computer at all. Please help.|||I am getting this same issue, but about the same time I started receiving errors from Executive Software Diskeeper Enterprise edition, telling me that I could no longer defrag my root drive, as I had Volume shadow copy enabled. This software had always worked fine before on this system and the only changed I can tie this too are the critical updates released last week.
|||

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Information
Event Source: Application Popup
Description: Application popup: Service Control Manager: At least one service or driver failed during system startup. Use Event Viewer to examine the event log for details.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to restore the database. The following error occurred: An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.

Event Type: Error
Event Source: DhcpServer
Description: The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I also have this same problem after installing the june sql server 2005 ctp. Tried restore of dhcp database. Tried to create empty database. Uninstalled service and app. Uninstalled the dhcp server and sql server 2005 and then reinstalled dhcp server and still the same problem.

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1014
===========
The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.
===========

Error 1018
===========
The DHCP service failed to restore the database. The following error occurred:
An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

|||Oh, great. I'm having this issue too. It must be. I installed the SQL Server CTP a few weeks ago, didn't like it very much and uninstalled. Now I'm trying to install DHCP Server and I can't. I get the same error messages in the EventLog which you describe.

Hasn't this been solved yet?

|||I think someone from Microsoft should address this issue.

Thanks,|||Anybody ever get a resolution to this, I've seen it mentioned in all sorts of forums, one of which indicated there was a registry fix posted on the MSDN site but I can't find a fix anywhere. Microsoft whats the deal? How do we fix these problems?|||Hi Mark,

Thanks for weighing in. I found this thread from a Google search and it was way down on the list in this forum. But I can't see that anyone has ever fixed this! As soon as I posted my own problem, the topic popped up to the top of the list. That's the nice thing about this forum. So everyone who is having this problem needs to report in. This will keep this at the top of the list and hopefully get Microsoft's attention. They really need to fix this.

Workaround tip: This may be a *duh* or this may not be obvious to you; I didn't realize this solution at first. If you're connected to the Internet via a Router/Switch, it is possible that the router device can provide DHCP services for you. My LinkSys CableModem router provides DHCP, so I'm OK personally, but Microsoft really should fix this.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

(As a side note, why on Earth is DHCP Server using a Jet database? For goodness sakes, it's 2005!)|||http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=6c2ce44d-72d2-416d-afee-c51c9298c746
This issue is because setup creates wrong default registry value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl. To fix DHCP service just delete VssAccessControl registry key.|||It worked! Thanks a lot.
Mike|||

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

|||Experiencing the exact same problem. There is no "VssAccessControl" registery key. DHCP is starting but each moring it shuts down.|||Worked for me.. thanks|||I am still having this issue as well. I am getting event ids 1010, 1016, and 1014. I don't have SQL installed on this computer at all. Please help.|||I am getting this same issue, but about the same time I started receiving errors from Executive Software Diskeeper Enterprise edition, telling me that I could no longer defrag my root drive, as I had Volume shadow copy enabled. This software had always worked fine before on this system and the only changed I can tie this too are the critical updates released last week.|||

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !

DHCP Service fails to start after installing SQL Server 2005 April CTP

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

Event Type: Error
Event Source: Service Control Manager
Description: The DHCP Server service terminated with service-specific error 20013 (0x4E2D).

Event Type: Information
Event Source: Application Popup
Description: Application popup: Service Control Manager: At least one service or driver failed during system startup. Use Event Viewer to examine the event log for details.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service is shutting down due to the following error: The service has returned a service-specific error code.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to restore the database. The following error occurred: An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.

Event Type: Error
Event Source: DhcpServer
Description: The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.

Event Type: Error
Event Source: DhcpServer
Description: The DHCP service failed to initialize the database. The following error occurred: %%65535

I have the same issue. Did you find an anwser yet?|||

I also have this same problem after installing the june sql server 2005 ctp. Tried restore of dhcp database. Tried to create empty database. Uninstalled service and app. Uninstalled the dhcp server and sql server 2005 and then reinstalled dhcp server and still the same problem.

I have searched everywhere and several people have had this issue, but no resolution.
The service can't start. In the event viewer, I have the following errors:

Error 1004
===========
The DHCP service failed to initialize the database. The following error occurred:
%%65535
===========

Error 1014
===========
The following problem occurred with the Jet database -1811: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetRestore.
===========

Error 1018
===========
The DHCP service failed to restore the database. The following error occurred:
An error occurred while accessing the DHCP database. Look at the
DHCP server event log for more information on this error.
===========

Error 1008
===========
The DHCP service is shutting down due to the following error:
The service has returned a service-specific error code.
===========

Error 7024
===========
The DHCP Server service terminated with service-specific error 20013 (0x4E2D).
===========

|||Oh, great. I'm having this issue too. It must be. I installed the SQL Server CTP a few weeks ago, didn't like it very much and uninstalled. Now I'm trying to install DHCP Server and I can't. I get the same error messages in the EventLog which you describe.

Hasn't this been solved yet?

|||I think someone from Microsoft should address this issue.

Thanks,|||Anybody ever get a resolution to this, I've seen it mentioned in all sorts of forums, one of which indicated there was a registry fix posted on the MSDN site but I can't find a fix anywhere. Microsoft whats the deal? How do we fix these problems?|||Hi Mark,

Thanks for weighing in. I found this thread from a Google search and it was way down on the list in this forum. But I can't see that anyone has ever fixed this! As soon as I posted my own problem, the topic popped up to the top of the list. That's the nice thing about this forum. So everyone who is having this problem needs to report in. This will keep this at the top of the list and hopefully get Microsoft's attention. They really need to fix this.

Workaround tip: This may be a *duh* or this may not be obvious to you; I didn't realize this solution at first. If you're connected to the Internet via a Router/Switch, it is possible that the router device can provide DHCP services for you. My LinkSys CableModem router provides DHCP, so I'm OK personally, but Microsoft really should fix this.

Thanks to the Microsoft guys. I'm sure you're hard at work to find a fix for us.

(As a side note, why on Earth is DHCP Server using a Jet database? For goodness sakes, it's 2005!)|||http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=6c2ce44d-72d2-416d-afee-c51c9298c746
This issue is because setup creates wrong default registry value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl. To fix DHCP service just delete VssAccessControl registry key.
|||It worked! Thanks a lot.
Mike
|||

I have also same problem (errors) but i didn't install sql server 2005. There is no "VssAccessControl" registery key under the "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\"

I can't understand why this happened and I could not found a solution...

I dont know what should i do...

|||Experiencing the exact same problem. There is no "VssAccessControl" registery key. DHCP is starting but each moring it shuts down.|||Worked for me.. thanks|||I am still having this issue as well. I am getting event ids 1010, 1016, and 1014. I don't have SQL installed on this computer at all. Please help.|||I am getting this same issue, but about the same time I started receiving errors from Executive Software Diskeeper Enterprise edition, telling me that I could no longer defrag my root drive, as I had Volume shadow copy enabled. This software had always worked fine before on this system and the only changed I can tie this too are the critical updates released last week.
|||

Same problem. No VssAccessControl but the service will not start. error msg: "Error 65535: 0xffff"

Any suggestions from Microsoft ?

Thanks in advance !