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. 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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
|
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...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was...
|
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.
...
|
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...
|
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...
|
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...
|
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...
|
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...
| |