IOException

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

IOException

Postby tiago.balabuch » Fri Oct 11, 2013 12:36 am

Hi,

I have been received this error:

Event: Open: I:\\Volumes\\Data01\\Microsoft SQL Server\\MSSQL.2\\MSSQL\\LOG\\ERRORLOG

Outcome:
Cannot connect

Exception:
IOException

Exception message:
The network name cannot be found.

This error occur in SQL 2005/2008/2008R2 and 2012.
I have opened all ports in firewall but error still occur.

Anyone could tell me how do I fix it?
tiago.balabuch
 
Posts: 4
Joined: Fri Oct 11, 2013 12:03 am

Postby Brian Donahue » Mon Oct 14, 2013 2:10 pm

Hello,

Can you please let us know which version of SQL Monitor you have installed? There was a problem that caused this issue a few minor versions ago.

Otherwise it may be that admin shares are disabled on the SQL Server or the SQL Server has incorrect information in its' registry about where it keeps its' error log.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby tiago.balabuch » Mon Oct 14, 2013 10:22 pm

Brian Donahue wrote:Hello,

Can you please let us know which version of SQL Monitor you have installed? There was a problem that caused this issue a few minor versions ago.

Otherwise it may be that admin shares are disabled on the SQL Server or the SQL Server has incorrect information in its' registry about where it keeps its' error log.


Hello Brian,

I have installed version 3.5.0.497.

This problem appeared after I have installed a new version.

Thanks,

Tiago
tiago.balabuch
 
Posts: 4
Joined: Fri Oct 11, 2013 12:03 am

Postby Brian Donahue » Tue Oct 15, 2013 8:29 am

SQL Monitor gets the location of the error log from the registry at HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\<version>.<instancename>\\MSSQLServer\\Parameters\\SQLArg1

Either the information there is not correct, or admin shares are disabled. SQL Monitor needs to get to \\\\computername\\I$. You can enable admin shares from Windows Computer Management console.
Last edited by Brian Donahue on Wed Oct 16, 2013 2:34 pm, edited 1 time in total.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby tiago.balabuch » Wed Oct 16, 2013 3:34 am

Hi Brian, Thanks for your reply.

I'll check with security team about admin shared. I think it is disabled for some reason of securtity.

Tiago
tiago.balabuch
 
Posts: 4
Joined: Fri Oct 11, 2013 12:03 am

Postby tiago.balabuch » Thu Nov 21, 2013 4:00 am

Hi Brian,

I still got same error!

The location of the error log is correct and now my security team enable admin shares.

What can I do?
tiago.balabuch
 
Posts: 4
Joined: Fri Oct 11, 2013 12:03 am

Postby rooseveltalphonso » Sat Nov 30, 2013 8:37 am

That's good i appreciate your information.
rooseveltalphonso
 
Posts: 1
Joined: Sat Nov 30, 2013 8:36 am
Location: United Kingdom


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests