-
- Novice
- Posts: 6
- Liked: never
- Joined: Dec 03, 2010 7:57 pm
- Full Name: Christian Billiot
- Contact:
SQL issues with Monitor and Business View
Clean OS install
Installed Monitor including 2005 express, allowed install to create necessary database
added a couple host to monitor
left a few days
came back, everything looks good
tried to install business view but received "Could not connect to database server "MY database server"
checked in server options for monitor under database section
database status: database does not exist or is not accessible
checked current database properties and everything looks correct
checked database connection and everything looks correct and test connection works properly
clicked check database button and get same status as above database does not exist or is not accessible
tried change database, set authorization
tried choose available, picked one created during install = fail
connecting = success
checking database selected = error has occurred "external component has thrown an exception"
tried "enter the name of new database" to make new one and get same error
downloaded SQL SMSE to verify permissions and ability to create databases under the instance and everything works as expected, but still a no go for getting database status to be green in monitor or to install Business View
any help or suggestions would be highly appreciated
Build: XP PRO SP3, .net, IIS, all updates
Installed Monitor including 2005 express, allowed install to create necessary database
added a couple host to monitor
left a few days
came back, everything looks good
tried to install business view but received "Could not connect to database server "MY database server"
checked in server options for monitor under database section
database status: database does not exist or is not accessible
checked current database properties and everything looks correct
checked database connection and everything looks correct and test connection works properly
clicked check database button and get same status as above database does not exist or is not accessible
tried change database, set authorization
tried choose available, picked one created during install = fail
connecting = success
checking database selected = error has occurred "external component has thrown an exception"
tried "enter the name of new database" to make new one and get same error
downloaded SQL SMSE to verify permissions and ability to create databases under the instance and everything works as expected, but still a no go for getting database status to be green in monitor or to install Business View
any help or suggestions would be highly appreciated
Build: XP PRO SP3, .net, IIS, all updates
-
- VP, Product Management
- Posts: 27375
- Liked: 2799 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: SQL issues with Monitor and Business View
Hi Christian,
I haven't seen this behavior before, so I would suggest contacting our support team to troubleshoot this issue via WebEx session. On the other hand, you can take a look a VeeamDCS.log file (Monitor Client -> Help -> Support Information) to see what is causing this issue by yourself.
On top of that, I wonder how large your infrastructure is? Having everything deployed on Windows XP machine is not considered to be best practice, so moving SQL Server to Windows server machine should definitely help.
Thanks!
I haven't seen this behavior before, so I would suggest contacting our support team to troubleshoot this issue via WebEx session. On the other hand, you can take a look a VeeamDCS.log file (Monitor Client -> Help -> Support Information) to see what is causing this issue by yourself.
On top of that, I wonder how large your infrastructure is? Having everything deployed on Windows XP machine is not considered to be best practice, so moving SQL Server to Windows server machine should definitely help.
Thanks!
-
- Novice
- Posts: 6
- Liked: never
- Joined: Dec 03, 2010 7:57 pm
- Full Name: Christian Billiot
- Contact:
Re: SQL issues with Monitor and Business View
Call to tech support and 3rd wipe and reolad of the entire system did the trick.
Support technician was nice enough to watch my configuration (the 3rd time) and low and behold it worked.
Not sure what I did differently the 3rd time but I am happy it is all working now.
Support technician was nice enough to watch my configuration (the 3rd time) and low and behold it worked.
Not sure what I did differently the 3rd time but I am happy it is all working now.
-
- VP, Product Management
- Posts: 27375
- Liked: 2799 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: SQL issues with Monitor and Business View
Thanks for update! Glad that all is up and running now. Could you please post your support case for future readers?
-
- Novice
- Posts: 6
- Liked: never
- Joined: Dec 03, 2010 7:57 pm
- Full Name: Christian Billiot
- Contact:
Re: SQL issues with Monitor and Business View
@ Vitaliy
Support case 5164615
I tried to collect details but says data unavailable.
Support case 5164615
I tried to collect details but says data unavailable.
-
- Expert
- Posts: 173
- Liked: 25 times
- Joined: Aug 23, 2010 8:30 am
- Full Name: Vitaliy Mzokov
- Contact:
Re: SQL issues with Monitor and Business View
And that support technician was me It's been a long time since we closed this particular support case, but, from what I remember, the issue was specific to your environment and was probably related to the multiple .Net versions installed on the same box with Veeam Monitor v5. We tried to reinstall the product from scratch and point it to the pre-existed database. It worked like a charm.XIANLEE78 wrote:Support case 5164615
Nevertheless, I hope all is good now with your monitoring server, Christian, and you have already upgraded to the most recent super-cool Veeam ONE v6
- VM.
Who is online
Users browsing this forum: No registered users and 9 guests