SQL addon fails authentication

teresedalman0701 · 2009-12-04T04:36:33.000Z

We have been testing, well trying to test the SQL addon for the SpiceWorks beta 4.5 b4.

I am using a Windows Vista Business virtual machine housed in Windows Server 2008, under the instruction of my husband and business partner Lawrie5252 also a member of this community.

Lawrie installed the addon which all went smoothly, then after the installation we ran a network scan which found the 8 SQL servers in our office and development networks. In the Dashboard page the SQL gadget asked me to choose from the 8 available SQL servers, then there were several issues.

Authentication fails repeatedly, resulting in no option to choose another SQL source, only to change the credentials.
How can I now change the source SQL server for the addon now I have an impass in the Dashboard?

Thankyou in advance for your help.

nic-spiceworks · 2009-12-04T10:06:18.000Z

Moved to 4.5 Beta forum

nic-spiceworks · 2009-12-04T10:07:37.000Z

The SQL plugin only works on XP right now. Please try again once we get a version out that works on Vista and Windows 7.

teresedalman0701 · 2009-12-04T17:18:46.000Z

Thank you Nic, sorry about the waste of your time. RTFM…

nic-spiceworks · 2009-12-04T17:31:21.000Z

No biggie, happens to everyone

nic-spiceworks · 2009-12-04T17:33:55.000Z

Just got some good news - Build V of the beta was just released, and it allows you to now run the SQL server plugin on Vista and Windows 7. Let me know if it works ok after you install Build V:

http://community.spiceworks.com/topic/83435

teresedalman0701 · 2009-12-04T23:25:37.000Z

The update has been performed as reccomended and proceeded smoothly, one layer of dificulty has been passed… Phew…

Now all the Helpdesk functionality seems to be working… Which we did not mention before anyway as I wasn’t sure I had not misconfigured it.

Now however the SQL addon has passed the authentication phase on SQL 2005, but is providing no data, says simply “No data yet available.
Check back in a few minutes” continuously. I’ve tried 2 servers with the same result. We checked and both servers are configured to be accessed from the network and there are apps drawing data from both databases over the network no probs.

It also does not seem to see nor offer the SQL 2008 instances/servers housed on server 2008. The network scan does find the server 2008 hosts and reports no scan errors doing so. The scan of these hosts also reports under the software tab that SQL 2008 is installed.

Not sure that this is the right place to post this, but it does feel like a continuation of the same issue. Thank you.

Harold-Spiceworks · 2009-12-10T18:48:20.000Z

Please try Beta 7 with the 0.2 version of the SQL Plugin and let me know if you still have problems.

Plugin: http://community.spiceworks.com/plugin/211

Beta 7: http://community.spiceworks.com/topic/83895

Thanks,

Harold