|
|
Posted by Jack on 10/02/07 11:55
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" <esquel@sommarskog.se> wrote in message
news:Xns981D9098E16FDYazorman@127.0.0.1...
> Jack (jack@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, 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]
|