Prev: Alter table Add column to merge publication
Next: SQL Server 2008 Extended Events
From: Jason Huang on 1 Apr 2010 05:23
Hi,

I have SQL Server 2000 on my Win2008x64 server, the db file is on the D
drive, while the program file is on C drive.
Today I installed the SQL Server 2008 on the same machine.
After the installation, the SQL Server Service Manager is still the same as
just only SQL Server 2000 installed, I'm thinking isn't there some newer
version of the SQL Server Service Manager for the SQL Server 2008?
And in the SQL Server Management Studio, I can only find those db in the SQL
Server 2000 db folder, I can't find those SQL Server 2008 system database
like Master and Model.
How do I connect to the real SQL 2008 Server and not the SQL 2000 Server?
Thanks for help.


Jason



From: jgurgul on 1 Apr 2010 06:14
Hi

There is nothing which really resembles "SQL Server Service Manager" from
SQL2005 onwards as this functionality can either be achieved via the new gui
SQL Server Management Studio (SSMS) or by accessing the services directly.

I would open up SSMS and see what you can see from a sql instance point of
view.

Did you install a new instance? In which case you will need use the
following to access it:

SERVERNAME\INSTANCENAME

Jon

"Jason Huang" wrote:

> Hi,
>
> I have SQL Server 2000 on my Win2008x64 server, the db file is on the D
> drive, while the program file is on C drive.
> Today I installed the SQL Server 2008 on the same machine.
> After the installation, the SQL Server Service Manager is still the same as
> just only SQL Server 2000 installed, I'm thinking isn't there some newer
> version of the SQL Server Service Manager for the SQL Server 2008?
> And in the SQL Server Management Studio, I can only find those db in the SQL
> Server 2000 db folder, I can't find those SQL Server 2008 system database
> like Master and Model.
> How do I connect to the real SQL 2008 Server and not the SQL 2000 Server?
> Thanks for help.
>
>
> Jason
>
>
>
> .
>
 | 
Pages: 1
Prev: Alter table Add column to merge publication
Next: SQL Server 2008 Extended Events