difference between SQL standard Edition and Enterprise Edition

Hi, there,

We are running SQL 2000 & SP4 with our ASP.NET application, now we plan to upgrade to Enterprise Edition due to the huge diffirence in price. Can any one of u give an brief introduction of the difference between these two, and what is the advantages of enterprise edition?

Any suggestion will greately appreciated.

Shermaine

There's a good comparison of the various versions of SQL Server here:-

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

shermaine wrote:

now we plan to upgrade to Enterprise Edition due to the huge diffirence in price.

That seems logical.

Diff. between using XML DOM and SQL Server 2000

Please Can I know the difference between using XML DOM(in any application language) and using the XML services of SQL Server 2000 to create XML data from SQL Server 2000 database?
The DOM is a specific API to access data that is already XML or has an XML
representation. It is useful in close-coupled programming environments and
where navigational access is more important than data storage and data
access cost.
SQL Server 2000 generates the XML in a streaming way that then can be
processed in a streaming pipeline or can be loaded into a DOM. The streaming
generation provides a more memory-efficient, more performant and scalable
way to generate XML than buffering all the data in a DOM and then passing
the DOM.
Best regards
Michael
"Rani Ponmathi" <ranibackup@.yahoo.com> wrote in message
news:0DC00FE5-67FB-4B08-BD83-84DF0809EE0D@.microsoft.com...
> Please Can I know the difference between using XML DOM(in any application
> language) and using the XML services of SQL Server 2000 to create XML
> data from SQL Server 2000 database?

Diff betw Clustered and Non-Clustered Index and their Application

Hi experts,
I have being reading up on index, in particular the difference between a
cluster index and non-cluster index, and how they should be used. However th
e
more I read the more I am.
Basically if anyone can advise me on this question:
- Which kind of index should I use for PRIMARY KEY column, a clustered or
non-clustered index?
- Similarly which kind of index should I use for FOREIGN KEY column, a
clustered or non-clustered index?
A background of how I become .
My understanding of clustered index is, basically rows with column value
that fit an index value are grouped together. In another words, 1 index
value, multiple rows (1-to-many relationship).
Furthermore these rows are sorted within the group itself.
Therefore when SQL Server queries the DB along a column with clustered
index, it will be able to quickly find and return all the rows.
As for non-clustered index, it is basically an index that points directly to
that row. So, 1 index value, 1 row (1-to-1 relationship "ideally").
However on one article, it recommends that primary keys should be clustered
(which is what SQL Server does by default). But on another article, it
recommends that pimary keys should be non-clustered! And that is when I
become .
Since primary keys are unique, so rows are not grouped under a clustered
index at all. SQL Server cannot find more than one row under that index. So
there is no performance value gain.
However non-clustered index is more suited to set on the primary key column.
Afterall one-index value, one primary key.
So I think it makes more sense to set non-cluster index for primary key,
while reserving the clustered index for foreign keys, especially the child
table's foreign key (back to the parent row). The power of the clustered
index should not be wasted on primary key column.
Is my understanding correct?
Could u please kindly advise. TQ very much in advance.Hi
This is very,very big and important issue.
Start with
http://www.sql-server-performance.c...red_indexes.asp
http://www.sql-server-performance.c...red_indexes.asp
http://www.sql-server-performance.c...ing_indexes.asp
"HardKhor" <HardKhor@.discussions.microsoft.com> wrote in message
news:BABFB6D4-09F7-482B-89F9-DF10DFCF1242@.microsoft.com...
> Hi experts,
> I have being reading up on index, in particular the difference between a
> cluster index and non-cluster index, and how they should be used. However
the
> more I read the more I am.
> Basically if anyone can advise me on this question:
> - Which kind of index should I use for PRIMARY KEY column, a clustered or
> non-clustered index?
> - Similarly which kind of index should I use for FOREIGN KEY column, a
> clustered or non-clustered index?
> A background of how I become .
> My understanding of clustered index is, basically rows with column value
> that fit an index value are grouped together. In another words, 1 index
> value, multiple rows (1-to-many relationship).
> Furthermore these rows are sorted within the group itself.
> Therefore when SQL Server queries the DB along a column with clustered
> index, it will be able to quickly find and return all the rows.
> As for non-clustered index, it is basically an index that points directly
to
> that row. So, 1 index value, 1 row (1-to-1 relationship "ideally").
> However on one article, it recommends that primary keys should be
clustered
> (which is what SQL Server does by default). But on another article, it
> recommends that pimary keys should be non-clustered! And that is when I
> become .
> Since primary keys are unique, so rows are not grouped under a clustered
> index at all. SQL Server cannot find more than one row under that index.
So
> there is no performance value gain.
> However non-clustered index is more suited to set on the primary key
column.
> Afterall one-index value, one primary key.
> So I think it makes more sense to set non-cluster index for primary key,
> while reserving the clustered index for foreign keys, especially the child
> table's foreign key (back to the parent row). The power of the clustered
> index should not be wasted on primary key column.
> Is my understanding correct?
> Could u please kindly advise. TQ very much in advance.

Dialogue security Vs Transport Security

Hi

I'm designing a distributed application where I will have SQL Server 2005 distributed databases replicating data to my central hub which is again a SQL Server 2005 database using SQL Service Broker. Data will be sent from the central hub to the distributed sites and vice versa. I need to authenticate the communication and also secure the communication by encrypting the messages. Which security shall I use? Where do I configure the type of security being used? What is the difference between transport security Vs dialogue security - Full security model?

Thanks

Pl. chk the post

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=608211&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425871&SiteID=1

HTH

Paritosh

|||

Transport security only secures the TCP connections between two hosts. Dialog security secures the dialog end to end between services. Since dialogs can span multiple hosts (eg> when there are forwarders in the middle), there is a need to secure the communication end-to-end. Use full dialog security unless you have a reason to use anonymous or unsecure. Books online will tell you what are the special cases when you may not want full security.

Also, why are you using Service Broker instead of Replication Services for solving your problem?

|||

Thanks for the response.

Using Service broker because it is not just replication, sometime routing and other things have to be managed.

Other reason is the scale and complexity of the environment, we can have around 2500 SQL distributed databases all over converging in to one central database.

Cheers!

Dialogue security Vs Transport Security

Hi

I'm designing a distributed application where I will have SQL Server 2005 distributed databases replicating data to my central hub which is again a SQL Server 2005 database using SQL Service Broker. Data will be sent from the central hub to the distributed sites and vice versa. I need to authenticate the communication and also secure the communication by encrypting the messages. Which security shall I use? Where do I configure the type of security being used? What is the difference between transport security Vs dialogue security - Full security model?

Thanks

Pl. chk the post

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=608211&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425871&SiteID=1

HTH

Paritosh

|||

Transport security only secures the TCP connections between two hosts. Dialog security secures the dialog end to end between services. Since dialogs can span multiple hosts (eg> when there are forwarders in the middle), there is a need to secure the communication end-to-end. Use full dialog security unless you have a reason to use anonymous or unsecure. Books online will tell you what are the special cases when you may not want full security.

Also, why are you using Service Broker instead of Replication Services for solving your problem?

|||

Thanks for the response.

Using Service broker because it is not just replication, sometime routing and other things have to be managed.

Other reason is the scale and complexity of the environment, we can have around 2500 SQL distributed databases all over converging in to one central database.

Cheers!

Diagram multiple database

Hi,
I have an application that use 2 databases. I would like to be able to
produce a diagram with tables from both databases. Is this possible ?
USE VISIO
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
> Hi,
> I have an application that use 2 databases. I would like to be able to
> produce a diagram with tables from both databases. Is this possible ?
|||Hi Randy,
Thanks for your quick answer but I realized that I needed to
clarify my question. My goal is to apply referential integrity between two
tables that are not part of the same database.
"Randy Pitkin" wrote:

> USE VISIO
> "TheOne" <TheOne@.discussions.microsoft.com> wrote in message
> news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
>
>

Diagram multiple database

Hi,
I have an application that use 2 databases. I would like to be able to
produce a diagram with tables from both databases. Is this possible ?USE VISIO
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
> Hi,
> I have an application that use 2 databases. I would like to be able to
> produce a diagram with tables from both databases. Is this possible ?|||Hi Randy,
Thanks for your quick answer but I realized that I needed to
clarify my question. My goal is to apply referential integrity between two
tables that are not part of the same database.
"Randy Pitkin" wrote:
> USE VISIO
> "TheOne" <TheOne@.discussions.microsoft.com> wrote in message
> news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
> > Hi,
> > I have an application that use 2 databases. I would like to be able to
> > produce a diagram with tables from both databases. Is this possible ?
>
>

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 !

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 !

Development Direction

I'm hoping that someone can suggest a direction for me to get started to
update a current application that I built several years ago. I want to move
the following application to our organization's intranet and will need to get
training in the best method to achieve this. I am versed in Office VBA and
VB 6.0 but have not moved into the .NET arena yet.
The application in question uses SQL Server 2000 as a back end and Access
2000 for the front end. Users basically select options on an Access form
that is used in a pass-through query to SQL Server. The query logs into the
server runs the query and returns the data, not to Access, but to an Excel
spreadsheet. I did this at the request of the users and they have been very
happy with it for many years.
The problem lies when users get new machines or have their machines
re-imaged and our computer support group has to re-install yet another
application. It would be great if I could figure out a way to build a
web-enabled version of this application and it has been beyond the scope of
my knowledge for some time now. I would really appreciate any suggestions
you might have or if you feel I need to direct this question to a different
newsgroup. Please advise. Thank you... AlIf you are able to use Reporting Services this is pretty easy to do what you
want. You have the queries designed. They can use the portal that ships with
RS (Report Manager). Select the parameters and view the report and then
export to Excel. If you had your own web page you could go directly to Excel
but since you don't want to be creating your own web app my suggestion
totally uses the feature of RS. You design and deploy the report and there
you are BUT the problem is going to be the administration. It requires
having RS server somewhere that you can deploy against.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <Al@.discussions.microsoft.com> wrote in message
news:FD312550-1020-4D2B-B913-AE40BB5A28BC@.microsoft.com...
> I'm hoping that someone can suggest a direction for me to get started to
> update a current application that I built several years ago. I want to
> move
> the following application to our organization's intranet and will need to
> get
> training in the best method to achieve this. I am versed in Office VBA
> and
> VB 6.0 but have not moved into the .NET arena yet.
> The application in question uses SQL Server 2000 as a back end and Access
> 2000 for the front end. Users basically select options on an Access form
> that is used in a pass-through query to SQL Server. The query logs into
> the
> server runs the query and returns the data, not to Access, but to an Excel
> spreadsheet. I did this at the request of the users and they have been
> very
> happy with it for many years.
> The problem lies when users get new machines or have their machines
> re-imaged and our computer support group has to re-install yet another
> application. It would be great if I could figure out a way to build a
> web-enabled version of this application and it has been beyond the scope
> of
> my knowledge for some time now. I would really appreciate any suggestions
> you might have or if you feel I need to direct this question to a
> different
> newsgroup. Please advise. Thank you... Al

Developing a client server app using SQLServer - Steps

How do we go about setting a C/S application. Here are the steps.
1. Network Operating system.
2. SQL Server 2000 Installation on a Client / Server Network.
3. Install and setup Active Directory Services on a Client / Server
Network.
4. Concept of Domain Controller in a Windows Network.
5. Setup a Domain Model and Client / Server Model on a Network.
6. Secure Databases in Sql Server.
7. Setup and use Windows Authentication in Sql Server.
8. Setup and use SQL Server Authentication.
9. Create Logins in Sql Server.
10. Define Database Roles in Sql Server.
11. Define Server Roles in Sql Server.
12. Use the Enterprise Manager of Sql Server.
13. Use the Query Analyzer of Sql Server.
14. Create a Database.
15. Create a Table using SQL Script.
16. Create Primary Keys and Foreign Keys.
17. Create Indexes, Clustered and Non Clustered Indexes.
18. Establish Connection with SQL Server over a Network.
19. Create a Connection Object.
20. Create a Command Object, its Properties and Methods.
21. Create a Recordset Object in a Visual Basic ( VB ) application.
22. Access SQL Server Database using ADO.
23. Retreive Data From SQL Server Over a client server Network.
24. Create Multiple Command Objects using a Single Connection.
25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
server application.
26. Pass Connection Information to SQL Server over a network using
Visual Basic ( VB.).
27.Insert a New Record in SQL server using Visual Basic ( VB ).
28.Update and Delete a record using the Execute Method.
29.Execute a Stored Procedure using a Command Object.
30.Create a Input Parameter.
31.Create a Output Parameter.
32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
Forward Only Recordsets.
33.Create Client Side Only Recordsets.
34.Assign a lock for Client Side Recordsets.
35.Navigate and Bind Controls to a Recordset.
36.Retrieve Fields of Recordsets.
37.Manually Populate Controls.
38.Add a new Record, Modify and Delete a Record.
39.Setup a DNS server.
40.Setup a DHCP Server.
41.Assign IP Address in a Client Server network.
42.Setup a Network Topology.
43.How to Create a Project.
44.How to Create a Menu.
45.SQL Server Security.
46.Standard Security Mode.
47.Setup a Integrated Security Mode.
48.Create Constants.
49.Relational Databases are used in a Client Server Accounting
application.
50.Implement relationships using Key Fields.
51.Client/Server Architecture.
52.Create a Class for developing a database application.
53.Object Oriented Programming is used in a VB/SQL Environment.
54.Use a Datagrid in a VB, Sql server accounting application.
55.Create and Use Standard Modules in a database application.
56.Design the database using SQL Server.
57.Program the Form_Load() event procedure.
58.Program the Form_Activate() event procedure.
59.Program the Cancelbutton.
60.Setup and Validate the data entered in the text box control.
61.Create and Add a Class using Visual basic ( VB ) for a client server
application.
62.How to write Property Procedures.
63.How to write Get Property Procedure.
Any questions email me. Before that you can have a look at the FAQ i
have collected and posted here http://www.vkinfotek.com/faq.html
Regards
MadhWha-a-a-a-t?
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<pedaammulu@.yahoo.com> wrote in message
news:1151489920.428568.278820@.x69g2000cwx.googlegroups.com...
> How do we go about setting a C/S application. Here are the steps.
> 1. Network Operating system.
> 2. SQL Server 2000 Installation on a Client / Server Network.
> 3. Install and setup Active Directory Services on a Client / Server
> Network.
> 4. Concept of Domain Controller in a Windows Network.
> 5. Setup a Domain Model and Client / Server Model on a Network.
> 6. Secure Databases in Sql Server.
> 7. Setup and use Windows Authentication in Sql Server.
> 8. Setup and use SQL Server Authentication.
> 9. Create Logins in Sql Server.
> 10. Define Database Roles in Sql Server.
> 11. Define Server Roles in Sql Server.
> 12. Use the Enterprise Manager of Sql Server.
> 13. Use the Query Analyzer of Sql Server.
> 14. Create a Database.
> 15. Create a Table using SQL Script.
> 16. Create Primary Keys and Foreign Keys.
> 17. Create Indexes, Clustered and Non Clustered Indexes.
> 18. Establish Connection with SQL Server over a Network.
> 19. Create a Connection Object.
> 20. Create a Command Object, its Properties and Methods.
> 21. Create a Recordset Object in a Visual Basic ( VB ) application.
> 22. Access SQL Server Database using ADO.
> 23. Retreive Data From SQL Server Over a client server Network.
> 24. Create Multiple Command Objects using a Single Connection.
> 25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
> server application.
> 26. Pass Connection Information to SQL Server over a network using
> Visual Basic ( VB.).
> 27.Insert a New Record in SQL server using Visual Basic ( VB ).
> 28.Update and Delete a record using the Execute Method.
> 29.Execute a Stored Procedure using a Command Object.
> 30.Create a Input Parameter.
> 31.Create a Output Parameter.
> 32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
> Forward Only Recordsets.
> 33.Create Client Side Only Recordsets.
> 34.Assign a lock for Client Side Recordsets.
> 35.Navigate and Bind Controls to a Recordset.
> 36.Retrieve Fields of Recordsets.
> 37.Manually Populate Controls.
> 38.Add a new Record, Modify and Delete a Record.
> 39.Setup a DNS server.
> 40.Setup a DHCP Server.
> 41.Assign IP Address in a Client Server network.
> 42.Setup a Network Topology.
> 43.How to Create a Project.
> 44.How to Create a Menu.
> 45.SQL Server Security.
> 46.Standard Security Mode.
> 47.Setup a Integrated Security Mode.
> 48.Create Constants.
> 49.Relational Databases are used in a Client Server Accounting
> application.
> 50.Implement relationships using Key Fields.
> 51.Client/Server Architecture.
> 52.Create a Class for developing a database application.
> 53.Object Oriented Programming is used in a VB/SQL Environment.
> 54.Use a Datagrid in a VB, Sql server accounting application.
> 55.Create and Use Standard Modules in a database application.
> 56.Design the database using SQL Server.
> 57.Program the Form_Load() event procedure.
> 58.Program the Form_Activate() event procedure.
> 59.Program the Cancelbutton.
> 60.Setup and Validate the data entered in the text box control.
> 61.Create and Add a Class using Visual basic ( VB ) for a client server
> application.
> 62.How to write Property Procedures.
> 63.How to write Get Property Procedure.
> Any questions email me. Before that you can have a look at the FAQ i
> have collected and posted here http://www.vkinfotek.com/faq.html
> Regards
> Madh
>

developer edition vs standard edition

I have an application that a client would like to review.
They have the developer edition of SQL and would like to
try my app before buying the standard edition. Is there
anything they would not be able to do. I have a db that I
will attach with demo data, there are stored procedures,
views, etc.
Thanks in advanceThe Developer edition has the same functionality of the Enterprise =edition, so it can do everything that the Standard edition can do.
-- Keith
"max" <mshaneyfelt@.ciomsult.com> wrote in message =news:00fc01c3d3c5$b4915fb0$a501280a@.phx.gbl...
> I have an application that a client would like to review. > They have the developer edition of SQL and would like to > try my app before buying the standard edition. Is there > anything they would not be able to do. I have a db that I > will attach with demo data, there are stored procedures, > views, etc.
> > Thanks in advance|||In addition to Keith's comment, Dev Edition is meant for development
purposes only. You should not be using it for production.
http://www.microsoft.com/sql/howtobuy/development.asp
--
-oj
http://www.rac4sql.net
"max" <mshaneyfelt@.ciomsult.com> wrote in message
news:00fc01c3d3c5$b4915fb0$a501280a@.phx.gbl...
> I have an application that a client would like to review.
> They have the developer edition of SQL and would like to
> try my app before buying the standard edition. Is there
> anything they would not be able to do. I have a db that I
> will attach with demo data, there are stored procedures,
> views, etc.
> Thanks in advance|||oj, thanks. The client will not use it for production but
they already own the developer edition so this way they
can look at the application before laying out the funds
for a processor license.
>--Original Message--
>In addition to Keith's comment, Dev Edition is meant for
development
>purposes only. You should not be using it for production.
>http://www.microsoft.com/sql/howtobuy/development.asp
>--
>-oj
>http://www.rac4sql.net
>
>"max" <mshaneyfelt@.ciomsult.com> wrote in message
>news:00fc01c3d3c5$b4915fb0$a501280a@.phx.gbl...
>> I have an application that a client would like to
review.
>> They have the developer edition of SQL and would like to
>> try my app before buying the standard edition. Is there
>> anything they would not be able to do. I have a db that
I
>> will attach with demo data, there are stored procedures,
>> views, etc.
>> Thanks in advance
>
>.
>

Developer Edition / Desktop Edition

I'm developing a windows (c#) application that currently uses SQL 2000. I've
developed the app using Developer Edition on my laptop.
The requirements of the app, are such that when the user is not at the
office, they can still use the application on thier laptop, but use a local
copy of the database. So I thought..ok just provide Desktop Edition with the
application.
Can I install Desktop Edition on my development machine with out messing up
the Developer Edition installation? What I'm concerned with is hosing my
currently installed DE.
As part of the application, I want the user to be able to use a Desktop
version of the database so when not at the office, the user can still use th
e
application.Jeff,
The short answer is yes you can do this. Is Developer Edition currently
installed as the default instance? If so, MSDE would have to be a named
instance. Honestly, I've never had a need to do this, so I'm not 100% sure
about exact installation needs. But I know 100% it is supported. You'll find
some good info if you google
install sql MSDE named instance
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Jeff" <nowhere@.nowhere.com> wrote in message
news:507FB9A4-80E6-4099-AEBD-E248434965B0@.microsoft.com...
> I'm developing a windows (c#) application that currently uses SQL 2000.
I've
> developed the app using Developer Edition on my laptop.
> The requirements of the app, are such that when the user is not at the
> office, they can still use the application on thier laptop, but use a
local
> copy of the database. So I thought..ok just provide Desktop Edition with
the
> application.
> Can I install Desktop Edition on my development machine with out messing
up
> the Developer Edition installation? What I'm concerned with is hosing my
> currently installed DE.
>
>
>
>
>
> As part of the application, I want the user to be able to use a Desktop
> version of the database so when not at the office, the user can still use
the
> application.