Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m_z_iqbal
Starting Member
28 Posts |
 Posted - 2008-11-15 : 02:05:02
|
| Hi, I am using SQL 2000 on win XP machine, on the same machine i installed SQL 2005, when i connect to SQL 2005, it connects to SQL 2000 (showing SQL Server 8.0.2050)How can i connect to SQL 2005(version 9.x)Your response will be highly appreciated.Regards.M.Zafar Iqbal |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-15 : 02:37:12
|
You have to connect to the SQL Server 2005 instance, like "MachineName\InstanceName".The SQL Server 2000 server is the default instance.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
AShehzad
Starting Member
8 Posts |
Posted - 2008-11-15 : 02:37:25
|
| Did you make a named instance while installing SQL Server 2005? I use named instance of SQL Server 2008 with default instance of SQL Server 2005 and found no problem.Atif Shehzad DBA Pakistan Revenue Automation Limited |
|
|
|
m_z_iqbal
Starting Member
28 Posts |
Posted - 2008-11-15 : 02:49:27
|
| i make the default instance, and when i connect to sql 2005 , it takes me to the sql 2000 |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-15 : 04:10:46
|
| possibly it could help you.http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262967,00.htmlaasim |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-15 : 05:01:03
|
It is because SQL Server 2000 is the default instance...What instance name did you choose when installing SQL Server 2005?Or did you do an upgrade? If so, restart computer where you installed SQL Server 2005.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
m_z_iqbal
Starting Member
28 Posts |
Posted - 2008-11-26 : 06:37:10
|
| i selected the default instance, and i didn't upgraded. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-26 : 07:37:43
|
Connect to your database and type this in a query window:SELECT @@VERSIONPlease post back the result from the above query.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
|
|
SQL Version Problem