April 3, 2009 at 6:56 am
Dear All,
I am in big trouble...One of our client installed SQL 2000 on top of LIVE SQL SERVER 2005.
Our database was detached. I uninstalled SQL 2000. But SQL 2005 database engine was not
appearing. I tried to reinstall, then was getting message DATABASE instance is existing..
but it's not avialable to select ..I unistalled ...but it's not going from ADd/Remove pgms.
In program file am able to see SQL Server configuration tools only....
Can anyone help me pls....very very urgent...
April 3, 2009 at 7:10 am
Actually the install of sql2000 shouldn't cause a technical problem.
Who detached your database ?
Where has it gone to ?
Did someone just uninstall the sql2005 engine ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 3, 2009 at 9:03 am
It got detahced when they installed SQL 2000.
I uninstalled wot they had instaled...after that I was not able to login into SQL 2005. it was not allowing me to REINSTALL with default instance name...saying it's existing...at the same time I was not able to login also.
became a mess....Tried to uninstall...but it was not going...
I installed everything again with different instance name...but then SQL MANAGEMENT STUDIO was not gettng displayed....
April 3, 2009 at 9:04 am
Gila monster ....Are u there..?????
April 3, 2009 at 9:30 am
Since your databases are already offline, you've got failed installs and failed uninstalls on the same server, manually digging out will take way too long. I'd suggest backing up any online databases, make copies of the backups. Make copies of the detached files. First and foremost, protect your data.
Then, I'd reformat the system and start again. It's going to take you forever to try to hack the registry to remove the failed uninstall. You don't want to leave that kind of mess on your production server. It's not a good place to be, but that's what I'd recommend.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2009 at 9:34 am
I'm with Grant on this one. You're going to be better off rebuilding the server than trying to repair it. Faster, and guarantees you aren't leaving any junk behind.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 5, 2009 at 10:43 pm
Dear All,
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo box I dont see any installed SQL server names there. I dont see anything in "Local Servers & Network Servers" tab. But am able to login by typing "machineName\instanceName". Why SO..?
I re attached the databases and all the data seems to be OK.
Also one more doubt, I had 6 jobs runing in the server. Since I reinstalled SQL2k5 I lost all those jobs. Is there any way to get it back..?
Thank you all......
April 5, 2009 at 10:44 pm
Dear All,
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo box I dont see any installed SQL server names there. I dont see anything in "Local Servers & Network Servers" tab. But am able to login by typing "machineName\instanceName". Why SO..?
I re attached the databases and all the data seems to be OK.
Also one more doubt, I had 6 jobs runing in the server. Since I reinstalled SQL2k5 I lost all those jobs. Is there any way to get it back..?
Thank you all......
April 5, 2009 at 11:48 pm
If you have (recent) backups (or the old files) of msdb, you should be able to restore it and your jobs will be back.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 6, 2009 at 6:32 am
Dear All,
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo box I dont see any installed SQL server names there. I dont see anything in "Local Servers & Network Servers" tab. But am able to login by typing "machineName\instanceName". Why SO..?
April 6, 2009 at 6:36 am
San (4/5/2009)
Also one more doubt, I had 6 jobs runing in the server. Since I reinstalled SQL2k5 I lost all those jobs. Is there any way to get it back..?
Thank you all......
restore your msdb database from a backup file of the same.
April 6, 2009 at 7:03 am
San (4/6/2009)
Dear All,Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo box I dont see any installed SQL server names there. I dont see anything in "Local Servers & Network Servers" tab. But am able to login by typing "machineName\instanceName". Why SO..?
It's hard to know without being there, but it's entirely possible that you've changed the port numbers on the servers from the defaults. If you changed the port used for discovery, you're not going to see normal behavior on the connections.
I still think you should reformat. You're spending more time working on trying to recover than it would have taken to rebuild cleanly from scratch.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2009 at 7:17 am
San (4/6/2009)
Dear All,Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo box I dont see any installed SQL server names there. I dont see anything in "Local Servers & Network Servers" tab. But am able to login by typing "machineName\instanceName". Why SO..?
- Is Service Broker service running ?
- 64 bit ? (known discovery bug)
Also after you restore msdb, be sure to update "target server" to local for all jobs.
See BOL "restore system databases"
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 6, 2009 at 7:38 am
ALZDBA (4/6/2009)
San (4/6/2009)
Dear All,Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo box I dont see any installed SQL server names there. I dont see anything in "Local Servers & Network Servers" tab. But am able to login by typing "machineName\instanceName". Why SO..?
- Is Service Broker service running ?
Hi ALZ I think if Service broker is not running then initially he would not be able to connect to the instance at all, isn't it?
- 64 bit ? (known discovery bug)
Wow.. is it?, I never knew that there was a bug in 64 bit, ill research on that thanks.
April 6, 2009 at 7:45 am
Krishna Potlakayala (4/6/2009)
ALZDBA (4/6/2009)
San (4/6/2009)
Dear All,Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo box I dont see any installed SQL server names there. I dont see anything in "Local Servers & Network Servers" tab. But am able to login by typing "machineName\instanceName". Why SO..?
- Is Service Broker service running ?
Hi ALZ I think if Service broker is not running then initially he would not be able to connect to the instance at all, isn't it?
- 64 bit ? (known discovery bug)
Wow.. is it?, I never knew that there was a bug in 64 bit, ill research on that thanks.
My mistake : It should be SQL Server Browser service (broker is a totally different story)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply