Updates from April, 2004 Toggle Comment Threads | Keyboard Shortcuts

  • Chewy Chong 5:04 am on April 30, 2004 Permalink | Reply  

    Error 10055 in function Listen. No buffer space available 

    This may also show up as a windows message:

    The Name Limit for the Local Computer Network Adapter Card Was Exceeded

    The Error 10055 error is caused when all available IP ports are used up.  Usually cause during TIME_WAIT phase of a connection being too long.  After a connection is finished, the port sits in this state for a while.  If a new port is needed, this port will be unavailable. 

    http://users.pandora.be/sonal.nv/ics/faq/General.html#TimeouttimeofTIMEWAIT23

    Here’s more information about the ‘name limit’:

    http://support.microsoft.com/?kbid=319504

    To modify the TIME_WAIT value in the Windows registry:  TIME_WAIT

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;149532

     

  • Chewy Chong 9:58 am on April 17, 2004 Permalink | Reply  

    Microsoft Memory Diag Tool (Boot) 

    Interesting tool I found used to test your PC’s memory from MS.  Another tool I was using (MemDoctor) did not work with my configuration because of my motherboard’s shared video ram (system ram is used as video ram).  This MS tool works like a champ and can be used as a lightweight burn-in tool.

    http://oca.microsoft.com/en/windiag.asp#top

    Kinda strange how there’s all these MS tools out there but not many people knows about them.  The Fiddler tool I talked about in a previous post is actually a MS tool also. 

     

  • Chewy Chong 11:27 pm on April 6, 2004 Permalink | Reply  

    Report Server URL Reference 

    While playing with Reporting Services on a Virtual Server, I noticed the following.  When you’re looking for a report in reporting services, you’re shown a ‘directory’ of available reports.  When you click on a report to view it, the directory links you to it.  Here’s the problem.

    If you don’t have DNS and all that stuff installed OR if you’re refering to your Reporting Server directly via an IP address… you can access the ‘directory’ but after clicking on a specific report, you are directed to the proper DNS URL of the reporting server (with a parameter referencing the target report ).

    You can modify this by modifying a variable in the RSWebApplication.config file.  Mine was located here (for a reference): 

    C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config

    Look for the following variable.  You can change this to an IP address, another URL referencing the server, etc…

    ReportServerUrl = http://theServerName/ReportServer

     

  • Chewy Chong 8:50 pm on April 6, 2004 Permalink | Reply  

    SQL Reporting Service Report ‘rsReportServerNotActivated’ After Install 

    Try manually activating Reporting Services locally on the Reporting Server:

    C:\Program Files\Microsoft SQL Server\80\Tools\Binn>RSActivate.exe -c “c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config” -t

    If you get:

    Failure starting the web service:
    System.Exception: The local NT Service is not activated
       at Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32 clientType)
       at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
       at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args, BaseCmdLine instance)

    Try deleting the encrypted key values in the RS database:

    rskeymgmt -d

     

  • Chewy Chong 7:02 pm on April 5, 2004 Permalink | Reply  

    IIS 6.0 ‘Service Unavailable’ may be caused by ‘Bypass traverse checking’ Local Policy 

    If you’re getting ‘Service Unavailable’ no matter what page you’re attempting to access on your IIS 6 box, you might want to check if the credentials being used by your application pools are memebers of a local policy called ‘Bypass traverse checking’.  The eventlog should also be reporting a http.sys communications error by W2SVC-WP.

    I’m looking up what this policy does and will fill you in.

     

  • Chewy Chong 2:52 am on April 5, 2004 Permalink | Reply  

    Tip: Install SQL with a Mapped Drive (not UNC path) 

    I’ve been meaning to put this post up.  Anyhow, I put together a SQL cluster build guide here on a project.  We had to rebuild the cluster and Paul was tasked with the rebuild.  He followed my build guide but was not able to install the SQL cluster.  When the install goes out to install SQL on the other node, it would fail without giving a meaningful error message.

    Why?  Good question.  Did you know while creating a SQL 2000 cluster on Windows 2003, you have to configured named-pipes communication because Windows 2003 is aware the SQL 2000 base install (without SP3) has some security issues making the box vulnerable to attacks so… the OS automatically blocks certain communication to SQL until you install SP3.

    This is a problem… you need this communication enabled to install a SQL cluster.  To fix this, you have to enable a named-pipe for the install.  Click the following link for the details: 

    http://support.microsoft.com/?kbid=815431

    Well… I knew about this issue and it was documented in my guide.  Using the same guide, I was able to successfully create a cluster the first time.  Poor Paul rebuilt the cluster at least 5x.  What stinks was our cluster (two Unisys ES7000) takes 10+ mins or so just for a reboot.  This does not take into account how long the SQL install takes.  Ugh… poor Paul. 

    He did figure it out though… I usually map a drive to our software share.  He was using a UNC path to the share (\\ourserver\sql2000\xxx).  Yup… that was the problem.  Don’t you love it? 

    So what is the point of the story? 

    Always use a mapped drive.  Avoid using UNC paths whenever possible. 
    And… Paul is one of the most patient people I know.  But I’m still the best looking… at least that is what my mom tells me.

     

  • Chewy Chong 8:44 am on April 4, 2004 Permalink | Reply  

    What’s Wrong with this SQL Reporting Services Chart? 

    I’ve been working on developing some MOM Performance Metrics reports for a project.  We had a few restrictions that prevented us from using the ‘canned’, out-of-the-box reports provided in MOM 2000.  Worked out the best solution in our situation was SQL Reporting Services. 

    So, I’ve been working on creating some custom charts on performance data collected by MOM.  However, my charts ain’t looking right.  Here’s what it looks like.  Care to take a guess as to what is wrong?


    I’ll fill you in later.

     

  • Chewy Chong 7:41 am on April 2, 2004 Permalink | Reply  

    Cool Tool: Fiddle – An Http Debugging Proxy 

    Found an interesting tool.  It acts as an http proxy and allows you to fiddle with incoming and outgoing requests… live.  You can even set breakpoints.  Oh yeah, you can write your own custom inspector dlls (tool exposes an API).

    Ready for the best part?  Form what I can tell… I think the tool is free.  Can’t seem to find a ‘pay here’ button anywhere.   

    Sweet.

    http://www.bayden.com/Fiddler/

     

  • Chewy Chong 9:42 pm on April 1, 2004 Permalink | Reply  

    Attaching to Collected Performance Data in a MOM Data Warehouse 

    You can use Excel to directly attach to performance data in a MOM Data Warehouse.  Took a bit to figure out how the OnePoint database stores collected performance information.  The query is as follows:

    select C.Name, PCS.ObjectName + ‘: ‘ + PCS.CounterName As Metric,
    SND.TimeSampled,
    SND.SampleValue as RawValue,
    SND.SampleValue * PCS.ScaleFactor as ScaledValue,
    PCS.ScaleFactor,
    PCS.ScaleLegend

    FROM SampledNumericData SND,
    Computer C,
    SampledNumericDataSource SNDS,
    PerfmonCounterScale PCS

    WHERE SND.idSampledNumericDataSource = SNDS.idSampledNumericDataSource and
    SNDS.idComputer = C.idComputer and
    SNDS.idPerfmonCounterScale = PCS.idPerfmonCounterScale

    I will add more information to this post soon.

     

c
compose new post
j
next post/next comment
k
previous post/previous comment
r
reply
e
edit
o
show/hide comments
t
go to top
l
go to login
h
show/hide help
esc
cancel