SQL Server Performance Forum – Threads Archive
2005 Installation
Hi,1>I have installed SQL 2005 on my local machine where SQL 2000 was already installed.
Is this problematic.
As whenever i start SSMS it asks for the connection and connects to my sql instance dbs. 2>In 2005 BOL refers to AdventureWorks sample DB which i cant find in list.
I installed it afterwards but still not able to locate.
Hi,
i have done earlier as you said but dont find any problems yet , its still runing.
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
1) It is not a problem and SSMS needs an instance to connect that can give you options of this tool. Try extracting AdventureWorks from "Samples.cab" located in the Setup-dir on the SQL Server 2005 cd if you have. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
How do i connect to sql 2005 instance.
I installed it as default instance name.
Whenever i open SSMS it connects me to SQL2000 instance and shows me the dbs which i created in 2000
You have both in default instances??
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS†with no warranties for accuracy.
Yes Luis both are in default instances.
I never try that. Always I install ond defautl instance and the rest are named instances.
But, since I never try, I don’t know if is possible.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS†with no warranties for accuracy.
Hi Ranjit ,<br />yes the first is default and other is named (sqlexpress) and runing without any problem at my end and i feel its not possible to have two default instance !.<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Hi Hemant,
Yes that was the issue.
I uninstalled the SQL 2k and SQL 2k5 and again reinstalled sql 2005 and now i can connect to default of 2005. Thanks
Ranjit Jain
I had installed SQL 2005 as default instance and SQL 2000 and second instance. Up to now no issues and working happily —————————————-
http://spaces.msn.com/members/dineshasanka
The adventureworks msi extracts the databasees, you still have to attach them afterwards.
]]>