Wireless Access

 View Only
last person joined: 23 hours ago 

Access network design for branch, remote, outdoor, and campus locations with HPE Aruba Networking access points and mobility controllers.
Back to discussions
Expand all | Collapse all

Move GMS database from SQL 2005 to SQL 2008R2

This thread has been viewed 0 times

  • 1.  Move GMS database from SQL 2005 to SQL 2008R2

    Posted Apr 24, 2013 12:34 PM

    I have to move my gms database from SQL 2005 server to a sql 2008R2 cluster!

     

    I have detached the database on the sql 2005 server, copied the db-files to the sql 2008R2 instance and attached it there, created a user called gms that have db_owner and db_creator rights in the gms database.

     

    My problem is that when i try to connect the gms software to the new database i get an error! gms can not connect to the database, i even get the same error trying to connect to the database with the sa user.

     

    Tested to connect to the database via an odbc connection with both sa and the specific gms user and it worked fine.

     

     

    Does gms 5.4.0.0 support sql 2008R2 cluster, how do i type the host name in the gms configuration?

     

    Anybody having any suggestions

     

     


    #SQL