SQL Server 2005 Problems
Dear Microsoft Product Experts,
Recently I installed SQL Server 2005 Express Edition. I don't remember the installation sequence exactly, but I believe that I chose "windows integrated authentication" rather than sql server authentication. This has made the database unusable with PHP, and this deficiency is significant to me.
I could not figure out how to change the database from NT authentication to SQL Server authentication, so I decided that I would just try installing a new instance. To remove the old instance I used "Add/Remove Programs" from the Control Panel. Now when I go to install the new instance, I get
SQL Server 2005 CTP Setup has detected incompatible beta components from Visual Studio or SQL Server. You must run the build cleanup wizard from the CD to remove previous SQL Server 2005 components and .NET Framework components, and then run SQL Server 2005 CTP Setup again. For detailed instructions on uninstalling SQL Server builds, see the SQL Server 2005 CTP readme file.
I do not have the build cleanup wizard; I do not have any cds and the file sqlbuw.exe does not exist on my system. And where is the SQL Server 2005 CTP Readme file? This is quite frustrating, so please help.
Thank you very much
Adam
Hi
I have been driven nearly mad by SQLEXPRESS.
Hope this helps:
you can select Mix-mode authenication when installing.
OK so
To re-install you need to use add+remove programs then!
You need to get your executeable SQLEXPR.exe, which you downloaded
go to the command line
and type
SQLEXPR.exe \x
this will then ask you where you want to extract the files, choose a path for example
C: \sqlexpress_temp then continue, once done go to this directory
change into sub directory
setup tools from there you will find the clean uninstall program
Which is just the begining of a magical adventure, as it may or may not work for you when run, see my posts, scatter around the BB.
Good luck!
You don't need to run SQLEPR.exe at the command line, just run the setup, and look for the most recently-created folder. It will be something like, "C:\b037fd04e2f7e72b01\", the peruse the "Setup" folder for the cleanup tool.
The best advice I've gotten, was to examine the installation log files, "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\". Investigate the summary.txt and the other log files, under "Files".
I also had to reinstall .NET 2.0 in order to uninstall a SQL Server component. Beyond that, my "magical adventure" has only required a little patience. I'm not a Microsoftee-genius...if I can do it, you can. Just follow the instructions.
-Mark
