Geek asks and answers

SQL Server 2008 is installed, although the running version is still 2005

While I installed SQL Server 2008 on a development machine that already released Sql Server 2005 from Visual Studio. When I look in my programs, I see "Microsoft Sql Server 2008", which contains a management studio, etc. Also I can see "MS Sql Server 2005".

When I run a query in Management Studio 2008 to select the version running on my machine, it appears in 2005 and leaves me scratching my head. When I look in the configuration manager, all I see is an SQLEXPRESS instance working ...

Are there any “quick” solutions to launch 2008 instead of 2005, given that 2008 is installed?

+3
source share
2 answers

If you are using SQL Server 2005 Configuration Manager, you will only see instances of 2005 and below.

To view instances of SQL Server 2008, you need to make sure that you are using SQL Server 2008 Configuration Manager.

The final option would be to view all services using the service manager. Here you need to see which instances of SQL Server you are running on the machine.

+2
source

If you want to find all instance names, one way is to start powershell and do the following

PS C:\> gwmi win32_service -filter "name like 'MSSQL%'" | fl DisplayName, pathname

For me, the result

DisplayName : SQL Server (SQLEXPRESS)
pathname    : "c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\B
              inn\sqlservr.exe" -sSQLEXPRESS

DisplayName : SQL Server (SQLEXPRESS2005)
pathname    : "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlserv
              r.exe" -sSQLEXPRESS2005

DisplayName : SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
pathname    : "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\
              Binn\fdlauncher.exe" -s MSSQL10.MSSQLSERVER

DisplayName : SQL Server (MSSQLSERVER)
pathname    : "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\
              Binn\sqlservr.exe" -sMSSQLSERVER

DisplayName : SQL Server Active Directory Helper
pathname    : "c:\Program Files\Microsoft SQL Server\90\Shared\sqladhlp90.exe"

DisplayName : SQL Active Directory Helper Service
pathname    : "C:\Program Files\Microsoft SQL Server\100\Shared\SQLADHLP.EXE"

DisplayName : SQL Server Analysis Services (MSSQLSERVER)
pathname    : "C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\bi
              n\msmdsrv.exe" -s "C:\Program Files\Microsoft SQL Server\MSAS10.M
              SSQLSERVER\OLAP\Config"

Look for one that has MSSQL10, and make sure the service is running. Then use this instance name when connecting through SSMS.

- , Exe - 2007.100.xxx

, , 2005 2008 Express, 2008

PowerShell, PathName,

+2

More articles:


All Articles