Post reply

sql 2008 to sql 2008 r2

  • October 31, 2013 at 8:44 am

    #284547

    Hi gurus

    I am in need of help very bad, here is my problem hope you gurus can help me

    I have a server that read like this when I open ssms

    1) Localhost(sql server 10.0.1600) but all my services shows like this

    2)Sql server(LSTEST)

    SQL Agent(LSTEST)

    3) when query SSMS for what is now connected ,this is what comes back

    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (VM)

    4) if I try to connect to LSTEST i does not exist.

    I am trying now to upgrade from 2008 dev to 2008 dev r2, but the only instance the upgrade see is the LSTESTwhich I dont see anywhere and when to the step of "reporting Auth" I get the following error

    " Check whether report server is correctly configured, the database server is running and you have permissions to access the database"

    all feature are grayed out so , no changes can be made on that setup screen

    any help would be gratefully appreciated, I got this server from a legacy so I am confused on what is going on in this machine

    Thanks a bunch gurus

  • October 31, 2013 at 9:47 am

    #1663137

    It sounds like you may have a copy of SQL Express running as a named instance (LSTest), and a default instance that you are trying to upgrade. For the default instance, you should be seeing a service named "SQL Server (MSSQLSERVER)". Can you run the following just to check out a few things?

    select serverproperty('InstanceName'), serverproperty('Edition'), serverproperty('ProductLevel')

    edit: Fixed syntax error

  • October 31, 2013 at 10:23 am

    #1663169

    SSC

    Thanks a bunch for battling with me here, I am realy grateful , I will run your statement and post back.

    I would like to take a screenshot and paste here, do you know how I can accomplish this

    Thanks a bunch again chief

  • October 31, 2013 at 10:28 am

    #1663175

  • October 31, 2013 at 10:46 am

    #1663185

    SSC

    All services that represent SQL run under LSTEST

  • October 31, 2013 at 1:13 pm

    #1663240

    Well, you certainly are connecting to the LSTest instance. Why the instance name does not show up in the banner along with localhost I am not so sure. If you run the upgrade against LSTest, you should have your localhost instance upgraded.

  • October 31, 2013 at 1:38 pm

    #1663247

    Thanks matt, ofr the help but for some reason every time I try to upgrade I get the error , that I show at the beginning .

    Thanks anyways

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply