Going From SQL Enterprise to SQL Standard

We mistakenly installed SQL Enterprise on a production server, and it should
've been SQL Standard. How can we go from Enterprise to Standard? Will we
have to move the database to a different SQL server, then uninstall SQL Ente
rprise and install SQL Stan
dard? Or, is there an easier way?Hi,
I feel that we can not come down from Enterprise to Standard, but the other
way is possible.
I think you may need to Reinstall standard edition and copy back the
databases. Please wait for 2 more days till all our experts confirm the
possibilities.
Incase if you need to reinstall then,
As a precausion take a backup of all databases
do
1. Stop current sql server service
2. Copy all mdf and ldf to a safe folder
3. Uninstall SQL server EE
4. nstall SQL server Standard and SP3a with same folder structure as old
5. Copy back the mdf and ldf files to same folders as old
6. start sql server.
Mostly the sql server will be up will all the databases, if not use the
backup files we backup to restore each databases.
Thanks
Hari
MCDBA
Thanks
Hri
MCDBA
"Mickey" <mmorris@.tacenergy.com> wrote in message
news:FFF4D5BD-1569-4FEB-988C-D2D9820E78AD@.microsoft.com...

quote:

---

> We mistakenly installed SQL Enterprise on a production server, and it

---

should've been SQL Standard. How can we go from Enterprise to Standard?
Will we have to move the database to a different SQL server, then uninstall
SQL Enterprise and install SQL Standard? Or, is there an easier way?|||Thanks Hari...I'll wait a couple more days and see. I appreciate the info.

Going From SQL Enterprise to SQL Standard

We mistakenly installed SQL Enterprise on a production server, and it should've been SQL Standard. How can we go from Enterprise to Standard? Will we have to move the database to a different SQL server, then uninstall SQL Enterprise and install SQL Standard? Or, is there an easier way?Hi,
I feel that we can not come down from Enterprise to Standard, but the other
way is possible.
I think you may need to Reinstall standard edition and copy back the
databases. Please wait for 2 more days till all our experts confirm the
possibilities.
Incase if you need to reinstall then,
As a precausion take a backup of all databases
do
1. Stop current sql server service
2. Copy all mdf and ldf to a safe folder
3. Uninstall SQL server EE
4. nstall SQL server Standard and SP3a with same folder structure as old
5. Copy back the mdf and ldf files to same folders as old
6. start sql server.
Mostly the sql server will be up will all the databases, if not use the
backup files we backup to restore each databases.
Thanks
Hari
MCDBA
Thanks
Hri
MCDBA
"Mickey" <mmorris@.tacenergy.com> wrote in message
news:FFF4D5BD-1569-4FEB-988C-D2D9820E78AD@.microsoft.com...
> We mistakenly installed SQL Enterprise on a production server, and it
should've been SQL Standard. How can we go from Enterprise to Standard?
Will we have to move the database to a different SQL server, then uninstall
SQL Enterprise and install SQL Standard? Or, is there an easier way?

Going from Express to SQL 2005 Standard

I have used VWD and SQL Express with success. Now I have uninstalled SQL Express and installed SQL Server 2005 Standard along with Visual Studio 2005 Standard editions. The problem that I am having is when I go to use the ASP .Net configuration tool, it cannot connect to the new instance.

Now I did run the aspnet_regsql utility to create the membership tables.

Did I do something wrong in the setup of the new SQL Server 2005? I have been trying to get an answer and find an answer to this problem for 2 days now.

Thanks for any help.

Have you posted this on the ASP.Net forums? (http://forums.asp.net/146/ShowForum.aspx)

What is the specific error message you are seeing?

|||I have posted it to ASP .Net forums and have not got an answer. I did find out the answer this weekend though. It was something in the web.config file that was note properly syntaxed.

Thanks.