Hi,
I have installed IBM Bigfix lifecycle management in windows 2012 server and database are running with same windows server (MS-SQL 2008R2 standard)
I want to upgrade the MS-SQL database from 2008R2 standard to 2012R2 standard.
is it possible to upgrade the database?
Thanks,
Nagaraj.
Yes, if you have IEM 9.0+ it’s supported.
Just before upgrade make sure you have a full backup of the database.
http://www-01.ibm.com/support/docview.wss?uid=swg21570458
Hi,
I have using ibm bigfix 9.2.6 with MS-SQL server 2008R2, the current database are running the same bigfix server now,
I want to move the database to another database server, so I followed the below link
but I get an error like Besadmin to run and “sa” password wrong stage.
how to solve this error.
Thanks,
Nagaraj.
Have you tried logging on the sql instance with the SA user. Does the user have correct rights?
Yes, SA user, also the user having all rights.
(note:My Bigfix application database server changed to another database server.)
ok, have you updated the odbc connection on the bigfix application server to point to the new DB server?
Yes, ODBC has been configured successfully.
Just go anywhere on your system and create an empty text file named anything but instead of txt make sure the extension is UDL. Then, double-click on the file and up pops a SQL connectivity window to allow testing of remote SQL connections. Test this and se if it fails here to.
hmm thats wierd. You have updated both the 32 and 64 bit odbc connection with the same data you used in the test? If you have i see no reason why you should get that error.
Thanks for your inputs @mfuglem
Are you able to leverage NT authentication instead of SQL authentication?
Hi,
Now I have changed the registry value (sa “password”) and then run the “besadmin.exe” tool, the console and other’s are working fine.
also i have one doubt, can i deploy any action to any machine?
Thanks,
Nagaraj.
