Difference between the SQL Server Express Bundled with C#/VB VS the downloadable SQL Server Expr

What is the Difference between the SQL Server Express Bundled with C#/VB VS the downloadable SQL Server Express SP1 with advanced Services?

I installed C# with SQL Server Express, however I wanted to add the Full Text Searching and the SQL Server Management Studio Express, so I downloaded and installed the SQL Server 2005 Express Edition with Advanced Services SP1. When I installed it over top of my current installation, it complained of version mismatching, and then C# failed to recognize that I had SQL 2005 Express installed at all.

What I'd like to know is, which version is more current (they have to be different, they had different version numbers, one was 9.xx.xxxx the other was 2005.9.xx.xxxx) The one bundled with C#, or the SP1 downloadable one.

Firstly, I want to be up todate as far as security patches, and Secondly, how do I add the full text searching and SSMSE to the one bundled with C# without breaking it.

THe one with Visual Studio does not have SP1 integrated, it also does not have the following features:

SQL Server Express with Advanced Services contains the following features:

SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.

Reporting Services, an integrated report creation and design environment to create reports.

Full-Text Search, a powerful search engine for searching text-intensive data.

(From: http://msdn.microsoft.com/vstudio/express/sql/download/)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Are there instructions for upgrading to the SP1 version?

I tried installing it directly overtop, and now it is broken.

When I try to add a database to a project, I get the following error:

Connection to SQL Server files require SQL Server Express 2005 to function properly. Please verify the isntallation of the component.

|||Follow the RTFM rule. The readme file can be found at http://go.microsoft.com/fwlink/?LinkId=58557. The instaruction there show step by step how to *migrate* the instance.

HTH, jens Suessmeyer.

http://www.sqlserver2005.desql

Difference between the SQL Server Express Bundled with C#/VB VS the downloadable SQL Server

What is the Difference between the SQL Server Express Bundled with C#/VB VS the downloadable SQL Server Express SP1 with advanced Services?

I installed C# with SQL Server Express, however I wanted to add the Full Text Searching and the SQL Server Management Studio Express, so I downloaded and installed the SQL Server 2005 Express Edition with Advanced Services SP1. When I installed it over top of my current installation, it complained of version mismatching, and then C# failed to recognize that I had SQL 2005 Express installed at all.

What I'd like to know is, which version is more current (they have to be different, they had different version numbers, one was 9.xx.xxxx the other was 2005.9.xx.xxxx) The one bundled with C#, or the SP1 downloadable one.

Firstly, I want to be up todate as far as security patches, and Secondly, how do I add the full text searching and SSMSE to the one bundled with C# without breaking it.

THe one with Visual Studio does not have SP1 integrated, it also does not have the following features:

SQL Server Express with Advanced Services contains the following features:

SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.

Reporting Services, an integrated report creation and design environment to create reports.

Full-Text Search, a powerful search engine for searching text-intensive data.

(From: http://msdn.microsoft.com/vstudio/express/sql/download/)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Are there instructions for upgrading to the SP1 version?

I tried installing it directly overtop, and now it is broken.

When I try to add a database to a project, I get the following error:

Connection to SQL Server files require SQL Server Express 2005 to function properly. Please verify the isntallation of the component.

|||Follow the RTFM rule. The readme file can be found at http://go.microsoft.com/fwlink/?LinkId=58557. The instaruction there show step by step how to *migrate* the instance.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Did SP1 fix Query Optimizer issues w/ Partitioned tables?

Hi there,

We've implemented a partitioned table to a large table within our EDW. However, we'd discovered that the Query Optimizer was not able to understand parameterized queries. It basically was scanning all the partitions even though a parameter was passed defining the partition to use. Consequently, the queries need to hard code parameter values!

Does anyone know if SP1 addressed this problem?

Thanks

-Walter

? Are you certain that it's scanning all of the partitions? You might want to look at the Actual Row Count in the execution plan to find out what's really happening. Partition elimination may not occur when the query is compiled -- instead, it may use a runtime value. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Walti@.discussions.microsoft.com> wrote in message news:fd66588f-8124-45c7-b977-6785bf117a17@.discussions.microsoft.com... Hi there, We've implemented a partitioned table to a large table within our EDW. However, we'd discovered that the Query Optimizer was not able to understand parameterized queries. It basically was scanning all the partitions even though a parameter was passed defining the partition to use. Consequently, the queries need to hard code parameter values! Does anyone know if SP1 addressed this problem? Thanks -Walter|||

Yes, I am sure that it is scanning all the partition. We had a MS champion at the site to overview the full EDW design, and he confirmed that it was a known problem and that it would have been fixed on a future SP release.

-Walter Biffi

|||? Can you describe the scenario in a bit more detail? Or better yet, post a script to reproduce the issue? -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Walti@.discussions.microsoft.com> wrote in message news:a11d1a77-7f52-43cb-bf37-5798188d9a0c@.discussions.microsoft.com... Yes, I am sure that it is scanning all the partition. We had a MS champion at the site to overview the full EDW design, and he confirmed that it was a known problem and that it would have been fixed on a future SP release. -Walter Biffi

Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

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 !

Device Information Settings - SimplePageHeader

I am trying to use the new SimplePageHeader device information setting
which was introduced in RS SP1 for Excel exporting but have not seen
any impact when using the setting. Following is an example of how I
am using the setting in an URL:
...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
My motivation for using this setting was an attempt to stop the export
from merging several of the columns in the report since this results
in the error "This operation requires the merged cells to be
identically sized" when trying to sort on various columns within
Excel. My thought was that by moving the header out of the actual
worksheet (which is my understanding from the documentation of what
the setting is supposed to do), the rendered report may not need to
merge cells to get the output formatted properly. Any suggestions
would be appreciated.I think the device info is SimplePageHeaders.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"f_mumble" <fred_mumble@.yahoo.com> wrote in message
news:5e9391dd.0406281737.724e4c66@.posting.google.com...
> I am trying to use the new SimplePageHeader device information setting
> which was introduced in RS SP1 for Excel exporting but have not seen
> any impact when using the setting. Following is an example of how I
> am using the setting in an URL:
> ...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
> My motivation for using this setting was an attempt to stop the export
> from merging several of the columns in the report since this results
> in the error "This operation requires the merged cells to be
> identically sized" when trying to sort on various columns within
> Excel. My thought was that by moving the header out of the actual
> worksheet (which is my understanding from the documentation of what
> the setting is supposed to do), the rendered report may not need to
> merge cells to get the output formatted properly. Any suggestions
> would be appreciated.|||Thanks for the follow-up, but adding the 's' didn't make a difference.
Are my expectations of what this device info setting supposed to
accomplish accurate?
As a test I completely removed the header from the report, and as I
suspected the columns are no longer merged in Excel. As a result,
Excel is able to sort any of the columns with no problems.
Unfortunately, having no header on the report is not an option, so any
other suggestions are welcome.
"Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message news:<uFBPjyXXEHA.796@.TK2MSFTNGP10.phx.gbl>...
> I think the device info is SimplePageHeaders.
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "f_mumble" <fred_mumble@.yahoo.com> wrote in message
> news:5e9391dd.0406281737.724e4c66@.posting.google.com...
> > I am trying to use the new SimplePageHeader device information setting
> > which was introduced in RS SP1 for Excel exporting but have not seen
> > any impact when using the setting. Following is an example of how I
> > am using the setting in an URL:
> >
> > ...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
> >
> > My motivation for using this setting was an attempt to stop the export
> > from merging several of the columns in the report since this results
> > in the error "This operation requires the merged cells to be
> > identically sized" when trying to sort on various columns within
> > Excel. My thought was that by moving the header out of the actual
> > worksheet (which is my understanding from the documentation of what
> > the setting is supposed to do), the rendered report may not need to
> > merge cells to get the output formatted properly. Any suggestions
> > would be appreciated.|||I eventually found out how to use the device info. Here are my findings:
It IS SimplePageHeaders - with an 's', plural
I used it as part of the URL when rendering directly to Excel. (I couldn't
find any way of settign this device information at design time?) The URL was
of this form
http://myserver/ReportServer?%2fTDSI%2fAssetsSummary&FxRate=1.2&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeaders=True
This outputted my report into Excel but I think SimplePageHeaders means no
header. My original report had images and text boxes in the header (which
were admittedly causing the cell merges) but following the above the
spreadsheet does not show any of these. Is this the best I can get?
"f_mumble" wrote:
> Thanks for the follow-up, but adding the 's' didn't make a difference.
> Are my expectations of what this device info setting supposed to
> accomplish accurate?
> As a test I completely removed the header from the report, and as I
> suspected the columns are no longer merged in Excel. As a result,
> Excel is able to sort any of the columns with no problems.
> Unfortunately, having no header on the report is not an option, so any
> other suggestions are welcome.
>
> "Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message news:<uFBPjyXXEHA.796@.TK2MSFTNGP10.phx.gbl>...
> > I think the device info is SimplePageHeaders.
> >
> > --
> > Nico Cristache [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "f_mumble" <fred_mumble@.yahoo.com> wrote in message
> > news:5e9391dd.0406281737.724e4c66@.posting.google.com...
> > > I am trying to use the new SimplePageHeader device information setting
> > > which was introduced in RS SP1 for Excel exporting but have not seen
> > > any impact when using the setting. Following is an example of how I
> > > am using the setting in an URL:
> > >
> > > ...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
> > >
> > > My motivation for using this setting was an attempt to stop the export
> > > from merging several of the columns in the report since this results
> > > in the error "This operation requires the merged cells to be
> > > identically sized" when trying to sort on various columns within
> > > Excel. My thought was that by moving the header out of the actual
> > > worksheet (which is my understanding from the documentation of what
> > > the setting is supposed to do), the rendered report may not need to
> > > merge cells to get the output formatted properly. Any suggestions
> > > would be appreciated.
>