472,353 Members | 1,341 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?

Hello,

I had SQL2000 server running fine on the windows 2003 box. I then installed
SQL 2005 Express. They both worked together fine. I then uninstalled SQL
2005 Express and installed SQL 2005 Server. But when I open SQL Server
Management Studio, I can only connect to the SQL 2000 engine. In the Object
explorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I can
see the existing SQL 2000 databases).

How can I get SQL Server Management Studio to 'see' the SQL 2005 database
engine so I can create tables? I *think* its running because there is the
'sqlservr.exe' process running, and during installation there is no issues.

When I open SQL Server Management Studio, I choose 'Database Engine', then
my local Servername with Windows Authentication. How do I connect to the SQL
2005 instance?

Thanks,
Jack.

Aug 9 '06 #1
5 4081
Jack (ja**@nospam.com.uk) writes:
I had SQL2000 server running fine on the windows 2003 box. I then
installed SQL 2005 Express. They both worked together fine. I then
uninstalled SQL 2005 Express and installed SQL 2005 Server. But when I
open SQL Server Management Studio, I can only connect to the SQL 2000
engine. In the Object explorer, it says v8.0.2039 (which I think is SQL
2000 Server, because I can see the existing SQL 2000 databases).

How can I get SQL Server Management Studio to 'see' the SQL 2005
database engine so I can create tables? I *think* its running because
there is the 'sqlservr.exe' process running, and during installation
there is no issues.
Did you actually try to connect to it? Your Express instance was presumably
called SQLEXPRESS, but you did not use this instance name when you installed
Enterprise/Standard edition.

You can use SQL Configuration Manager to view which instances you have
installed, and whether they are running.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 9 '06 #2
Hi Erland ,

When I open SQL Server Management Studio (SSMS) a window pops up asking me
to 'Connect To Server'. This works fine because when I connect, SSMS
contains the databases that I had previously defined in SQL Server 2000. I
still can't see anywhere to connect to a SQL 2005 instance. I then launch
SQL Server Configuration Manager (SSCM) which contains no information in any
of the items in the tree.

Even if I do not connect using SSMS, SSCM still contains no information in
any of the items in the tree. At:
http://forums.microsoft.com/MSDN/Sho...ID=93&SiteID=1 someone
asked how to create an instance and apparently you have to do this by
putting in the CD and re-run the installation. I did this, but when
selecting " Run the SQL Native Client Installation Wizard" it says that I've
got a higher version and cannot finish. (The reason for this is thatI've
installed the SP1). How can I create a new instance (like, what tool?) so I
can connect to one?

I'm not sure why this is so difficult for me?

Jack.

"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
Jack (ja**@nospam.com.uk) writes:
>I had SQL2000 server running fine on the windows 2003 box. I then
installed SQL 2005 Express. They both worked together fine. I then
uninstalled SQL 2005 Express and installed SQL 2005 Server. But when I
open SQL Server Management Studio, I can only connect to the SQL 2000
engine. In the Object explorer, it says v8.0.2039 (which I think is SQL
2000 Server, because I can see the existing SQL 2000 databases).

How can I get SQL Server Management Studio to 'see' the SQL 2005
database engine so I can create tables? I *think* its running because
there is the 'sqlservr.exe' process running, and during installation
there is no issues.

Did you actually try to connect to it? Your Express instance was
presumably
called SQLEXPRESS, but you did not use this instance name when you
installed
Enterprise/Standard edition.

You can use SQL Configuration Manager to view which instances you have
installed, and whether they are running.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 12 '06 #3
Jack (ja**@nospam.com.uk) writes:
When I open SQL Server Management Studio (SSMS) a window pops up asking me
to 'Connect To Server'. This works fine because when I connect, SSMS
contains the databases that I had previously defined in SQL Server 2000.
In this window you can specify a different server instance, for instance
..\MMV if MMV was the name you gave to the SQL 2005 instance. On the
other hand:
I then launch SQL Server Configuration Manager (SSCM) which contains no
information in any of the items in the tree.
It does not seem that you have any SQL 2005 instances installed at all.
apparently you have to do this by putting in the CD and re-run the
installation. I did this, but when selecting " Run the SQL Native Client
Installation Wizard" it says that I've got a higher version and cannot
finish. (The reason for this is thatI've installed the SP1). How can I
create a new instance (like, what tool?) so I can connect to one?
If you already have SQL Native Client installed, there is no need to
install it. Just pick "Server components, tools, Books Online and samples"
under the "Install" header.

Pay particular attention when it comes to selecting an instance. If you
select default instance, you will upgrade you SQL 2000 instance. There is
also a button where you can view installed instances.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 12 '06 #4
Thanks Erland.

After many, many hours I finally got it working:

When I originally installed SQL 2005 I installed it with the 'default
instance' option. I wrongly assummed that it would have set up a default
'SQL 2005' instance, but what it seemed to have done was take the EXISTING
SQL 2000 instance and treated this as the default. This is why there were no
SQL 2005 instances created.

You have to press the 'Change' button in Add/Remove programs for SQL 2005 to
get the installation running again, and NOT the CD. This is the only way
that I know of to create instances in SQL2005

Again, thanks so for your help and direction.

Regards,
Jack.
"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
Jack (ja**@nospam.com.uk) writes:
>When I open SQL Server Management Studio (SSMS) a window pops up asking
me
to 'Connect To Server'. This works fine because when I connect, SSMS
contains the databases that I had previously defined in SQL Server 2000.

In this window you can specify a different server instance, for instance
.\MMV if MMV was the name you gave to the SQL 2005 instance. On the
other hand:
>I then launch SQL Server Configuration Manager (SSCM) which contains no
information in any of the items in the tree.

It does not seem that you have any SQL 2005 instances installed at all.
>apparently you have to do this by putting in the CD and re-run the
installation. I did this, but when selecting " Run the SQL Native Client
Installation Wizard" it says that I've got a higher version and cannot
finish. (The reason for this is thatI've installed the SP1). How can I
create a new instance (like, what tool?) so I can connect to one?

If you already have SQL Native Client installed, there is no need to
install it. Just pick "Server components, tools, Books Online and samples"
under the "Install" header.

Pay particular attention when it comes to selecting an instance. If you
select default instance, you will upgrade you SQL 2000 instance. There is
also a button where you can view installed instances.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 13 '06 #5
Jack (ja**@nospam.com.uk) writes:
When I originally installed SQL 2005 I installed it with the 'default
instance' option. I wrongly assummed that it would have set up a default
'SQL 2005' instance, but what it seemed to have done was take the
EXISTING SQL 2000 instance and treated this as the default. This is why
there were no SQL 2005 instances created.
In that case, the existing SQL 2000 instance would be upgraded, but maybe
you managed to back out of that.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 13 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: RvGrah | last post by:
After much hair-pulling, I've finally found the answer to a problem that many are fighting with, difficulty connecting from Sql 2005 Server...
2
by: thomas_vicker | last post by:
Hi, I need to maintain both SQL Server 2000 and 2005 on my PC for support purposes. I am using the developer additions. After I install...
4
by: HandersonVA | last post by:
compare to ms sql 2000, the newer version seems to be slow when i try to open or modify a table. is this a demerit of the newer vesion or my...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only...
5
by: Ted | last post by:
I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the...
6
by: mike | last post by:
Help; Im New with a company and the sql server is maxing out the cpu's We have 3 web servers load balanced.... large volume of data the...
2
by: Robert | last post by:
I'm a newbie trying to find the SQL Server Enterprise Manager so I can create a database. I have installed SQL Server 2005 Express and SQL Server...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.