Sorry, just "thinking" out aloud....So you have an XP box on which you
have VS 2005, SQL Server 2005 Express (Not SQL Server 2005 Developer
Edition) and tried to install SQL Server 2005 Enterprise edition?

I believe that if you try and install SQL Server 2005 Enterprise
Edition on an XP machine you won't actually get the server only the
client tools (no DB Engine etc). If you require the functionality of
SQL Server 2005 Enterprise on your XP machine then I think you will
need SQL Server 2005 Developer Edition (different to SQL Server 2005
Express), which has all the functionality of Enterprise & can be
installed on your XP box (a difference between Dev and Ent is that the
license says that Dev can't act as a production server).

Also, to create a publication, you will need to connect to the SQL
Server instance that has the ability to be published. From what you are
saying, it appears that you have connected to the SQL Server instance
for the Express edition.

If you have a spare box running a server OS (like Windows Server 2003)
then you can install Enterprise on that, get the server running and
configure it to publish. You can then subscribe to it from the SQL
Server Express instance on your XP machine.

Hope that helps a bit.

Hello SQL 2005 Experts,

On a win xp sp2 box, I installed VS 2005, which also installed an express
(or dev) version of SQL 2005. Then I installed the SQL Server 2005
Enterprise.

The default db is [comp name]\SQLEXPRESS. I am trying to create a
publication (right click on replication, new subscription), but I keep
getting this error:

There are no publications to which you can subscribe, either because this
server has no publications or because you do not have sufficient privileges
to access the publications.

Yet I can find no way to add a publisher. When I right click on
replication, I only get the new subxription option, no option to create a
new publication. In my research, I read that you cannot create a
publication on express, but I have the full version and should be able to.

I am running IIS as well.

My question is - do I need to create a new db engine to make this work? And
if so, how? OR maybe I just don't know how to create a publication, please
help with that as well.

Thanks!