| Author |
Topic |
|
slimslidey
Starting Member
4 Posts |
 Posted - 2010-02-19 : 04:20:39
|
| Hi allSQL 2008 express. Tried installing management studio as an add on but installer wouldnt let me so decided to uninstall and reinstall the 'with tools' version. Big mistake! I can now only install a named instance (sqlexpress). The default instance seems to have disappeared, but everytime i select it in the installer, it tries to install a named instance. Tried uninstalling again and took off .net then went through the reg and deleted all reference to mssqlserver (default instance)Rebooted, reinstalled .net and SQL - same problem. Tried running sp_addserver - it tells me mssqlserver exists. So I run sp_dropserver and get told it doesnt exist!Help!! |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-02-19 : 14:17:19
|
| Try naming the instance MSQLSERVER. I believe there is a bug that the default instance for Express is "SQLEXPRESS" which is not a default instance, of course. |
 |
|
|
Liz Lyons
Starting Member
22 Posts |
Posted - 2010-02-19 : 16:04:46
|
| Was reading a chapter on uninstalls as part of my SQL Svr '08 studies, because I've had my own issues.They say (1) uninstall using Control Panel (2) uninstall Reporting Services (3) separately uninstall the ReportServer and ReportServerTempDB (4) drop the reporting services log files (5) uninstall Analysis Svces if present (not your prob with Express) (6) Delete the log files from SQL Server DB Engine (7) You may have to remove SQL Server Native Client separately and you may find that the 100 directory needs to be removed manually also. If you have no other instance of SQL Server you can delete the entire MS SQL Server directory under Program Files.Lastly, but not least "The PSS group is working to define a manual uinstall process. If you find yourself in a failed uninstall where there is no SQL '08 entry in the Add/ Remove Programs, run the following program from the command line and see if it brings up the Add/ Remove GUI: "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\ARPWrapper.exe". PSS warns against manually trying to hack the instance out of the registry."Ho hum!! |
|
|
|
slimslidey
Starting Member
4 Posts |
Posted - 2010-02-22 : 06:46:12
|
quote:
Originally posted by RobertKaucher
Try naming the instance MSQLSERVER. I believe there is a bug that the default instance for Express is "SQLEXPRESS" which is not a default instance, of course.
Hmm, think you're right. Maybe it is actually the default instance im looking at, which is a pain because you have to enter the connection string all the time. Trouble is, first time I installed it I had MSSQLSERVER, so not sure. Renamed current instance to be MSSQLSERVER, any ideas how to change the service name so I dont have to enter hostname\servername to connect? A quick google drew blanks |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-02-23 : 19:38:53
|
| Can you reinstall? I think that is the only option... I have not heard of renaming a service in this way. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-02-23 : 21:45:29
|
| You can't rename an instance without reinstalling, but you can instead create an alias that points to the correct name. You can create the alias in SQL Server Configuration Manager. It can be named anything you like, it just needs to point to the servername\instancename that you want to connect to.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
slimslidey
Starting Member
4 Posts |
Posted - 2010-02-25 : 10:08:09
|
| thanks for your help, but I reinstalled windows in the end. When I set up SQL again I did so as a named instance called MSSQLSERVER. Apparently express doesnt let you install a default instance, but instead you can trick it into thinking its the default by naming the named instance MSSQLSERVER |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-02-26 : 10:39:27
|
| Yes, that is correct. I called it a bug in my first message but it might be considered a limitation. I'm reluctant to call it a limitation, though, as there is a workaround... It stinks you had to do a reinstall of the OS. I suppose it's working now, though? |
|
|
|
slimslidey
Starting Member
4 Posts |
Posted - 2010-03-01 : 06:08:57
|
| yeah thanks rob. works a treat. |
|
|
|
|
Default Instance Disappeared