|
|
Posted by Jack on 10/02/25 11:55
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/ShowForum.aspx?ForumID=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" <esquel@sommarskog.se> wrote in message
news:Xns981ABC79B983BYazorman@127.0.0.1...
> Jack (jack@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, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|