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