Russ' Do It Yourself Home Workshop

Finding Fixes to Just About Anything and Everything

Archive for the ‘Computer Software’ Category

Getting SQL Express to Listen So You Can Connect Remotely

Posted by Russell Wright on April 22, 2014

Dang!  We had a situation where a new tool we were implementing in our back office, BillQuick Web Services 2014, would not use SQL Server since we purchased the "Pro" version and not the "Enterprise" version.  Unfortunately, it appears the trial version we installed has all the enterprise version capabilities and, after entering our license information, we were locked down to the pro version and it wouldn’t connect to the SQL Server anymore.

So, that meant I needed to install SQL Express to support the tool.  Okay, no biggie…except for the fact that SQL Express does not enabled Named Pipes or TCP/IP protocols, by default.  This took me a bit to figure out.

This is not a new problem, as posted by Peter van Ooijen in 2006.  Some things never change…

The easy way to fix this is to use SQL Server Configuration Manager.

image

Navigate to the Protocols section for your SQL Express instance and switch it on! 

image

And if that’s not enough, you need to change the TCP/IP properties to listen on the correct port.  I set the port to 1077 (one the SQL Server is NOT listening on).  It appears if you set it in the the IPAll section, the same port will be used for each IP address and you only have to enter it one time.

image

Oh, and then recycle your SQL server instance!

The connection string to use looks like this.

SQLServer\Instance,Port

image

 

Advertisements

Posted in Computer Software, SQL Server | Leave a Comment »

So You Want to Remotely Manage a Computer From Another on Different Workgroups/Domains?

Posted by Russell Wright on November 4, 2013

Let’s say you have a Windows 7 computer, A, which is not in a domain, but simply in a workgroup at home.

Let’s say you have a Windows server, B, which is a VM host but not in a domain.

Let’s also say you have network connectivity between the two.

If you want to run the compmgmt.msc mmc snap-in and manage computer B from computer A try this:

  1. Open an administrative command prompt on computer A (shift right-click, Run As Administrator)
  2. Type the following Runas command:  runas /noprofile /netonly /user:ComputerB\administrator “mmc comp
    mgmt.msc”
  3. You should be prompted for your administrative password on computer B.
  4. When computer management opens, select Action | Connect to another computer from the menu.

image

Now you can also turn this into a desktop shortcut and automatically connect to the remote computer using this adjustment to the command line:

runas /noprofile /netonly /user:ComputerB\administrator “mmc comp mgmt.msc /computer:\\ComputerB”

You should be good to go…at least I was.

 

Posted in Computer Software, Networking | Leave a Comment »

Reordering and Hiding Fields and Passing URL Parameters on a New Item Form in SharePoint 2010

Posted by Russell Wright on March 6, 2013

Let’s say you are creating a new item form using SPD 2010 and you don’t have InfoPath because the company didn’t purchase the Enterprise version of SharePoint.  Your goal is to pass a URL parameter to the new item form from some other part of the SharePoint application you are building.  Perhaps the link that contains the URL parameter was created by a workflow (hint hint).

image

You insert the custom list form like this.

image

The goal is to move this field down to the end of the form to get it out of the way.

image

You select the row and cut it for repositioning to the end of the form.

image

Now you’ve got it at the bottom of your form.

image

Now you test your form (before adding the parameter to pass) and it "works" but it doesn’t correctly save the data in the field you relocated.

The correct way to do this is to delete the field row at the top, add a new row at the bottom and insert a new text field and bind it to the column.

image

Bind the Data field to the column and format it as a Text Box.

image

Under Options, select Parameters and add a New Parameter, giving it a name that is memorable for you.  Then, bind it to the Query String variable of your choice.

image

With your text box selected, find the text property and change it from @Fieldname to $Parametername.

image

If you don’t get the name correct, you’ll see an error displayed instead of your form.

image

If you want to hide the field completely on the form to eliminate any human intervention, add class=ms-hidden to the table row.

image

Posted in Computer Software | Leave a Comment »

Stop IE Performance Advisor from Asking bout Disabling Add-ons

Posted by Russell Wright on February 19, 2013

If you are tired of seeing that message that takes more time to dismiss than it does for the add-ons to start, you can disable it using the Group Policy editor.

Click your Start buttong and type gpedit.msc and press enter.

image

Navigate to the Internet Explorer folder under Computer Configuration | Administrative Templates | Windows Components | Internet Explorer.  On the right side double-click Disable add-on performance notifications.

image

Select Disabled and click OK.

image

At this point you might want to investigate the long list of other options and see what else you want to configure while you’re here!

image

Posted in Computer Software | Leave a Comment »

BGInfo on Windows Server 2012

Posted by Russell Wright on December 30, 2012

Here’s how I setup BGInfo on Windows Server 2012.

I created a folder in the Program Files (x86) directory and copied the BGInfo.exe file to the folder.

image

I used the scheduler (Win-Q and start typing “Scheduler”) method to run BGInfo.  Here are my scheduler settings.  The important thing here is to specify an account with administrative privileges. 

image

For triggers, I used the following.  I have it run on a schedule so it is updated regularly, in case things change.  I also have it run at each logon and at startup.  I think I have all the bases covered.

image

The action is, of course, Start a program.  The full command line is as follows.

"C:\Program Files (x86)\BGInfo\Bginfo.exe" "C:\Program Files (x86)\BGInfo\Bginfo.bgi" /TIMER:0 /SILENT

I’ve always found it’s better to include the full path to the BGInfo.bgi file.

image

The settings are pretty standard.  I always stop the task if it runs longer than 1 minute (plenty of time) in case something gets hung. 

image

That ought to do it.

Keywords:

Windows Server 2012
BGInfo
Automatic scheduled execution of BGInfo
BGInfo command line options

Posted in Computer Software | Leave a Comment »

Another RunAs Hint–TSAdmin.msc

Posted by Russell Wright on November 29, 2012

Terminal Services Administrator RunAs string in a big company domain with UAC enforced by policy (no GPEdit here).  Problem is "the requested operation requires elevation."

Trick is to use the /netonly switch.

C:\Windows\system32>runas /netonly /user:domain\userid "mmc %windir%\system32\tsadmin.msc"

References:

http://social.technet.microsoft.com/Forums/en-US/itprovistaapps/thread/afb2a94a-fa9a-4d15-b43d-e492b44cf1e6/

Posted in Computer Software | Leave a Comment »

Microsoft Office 365 Lync “Sharing failed to connect due to network issues”

Posted by Russell Wright on November 29, 2012

This problem was caused by Kaspersky Antivirus 2012.  This is NOT Kaspersky Internet Security.

Trying to share my screen in Lync 2010.

image

Received errors:

Sharing failed to connect due to network issues.

Screen sharing stopped due to server connectivity issues.

Sharing ended due to network issues.

Stopping Kaspersky Antivirus fixed the issue, so how do you configure an exception for Lync?

Open Kaspersky

Click Settings.

image

Select Detected Threats and Exclusion Rules and then Settings.

image

Trusted applications tab.  Click Add.

image

Using either the Applications flyout or Browse, locate communicator.exe and add it.

image

Select “Do not scan network traffic” and click OK.

image

Sharing should now work!

image

Posted in Computer Software | Leave a Comment »

Visio 2010 Keeps Crashing–Remove "Send To Bluetooth" Add-in

Posted by Russell Wright on August 11, 2011

If you are running Visio 2010 on Windows 7 x64 and it keeps crashing, you might be experiencing the "Send to Bluetooth" add-in issue.  To remove the add-in follow these steps.

  1. Start Visio as administrator by Shift-right clicking the Visio shortcut and select "Run as administrator."
  2. Select File | Options.
  3. Select Add-Ins from the links on the left of the Options dialog.
  4. Click the Go… button next to the Manage COM Add-ins drop-down list at the bottom of the Options dialog.
  5. Select the Send to Bluetooth add-in and click Remove.

Now maybe your Visio won’t keep crashing!

Posted in Computer Software | 18 Comments »

Microsoft Visio has Stopped Working

Posted by Russell Wright on August 8, 2011

I’ve been having some issues with Visio 2010 throwing an error (Microsoft Visio has stopped working) when I’m closing it down and tracked it back (with the help of others) to potentially the "Send to Bluetooth" add-in.  I’ve since disabled it using this procedure.

image

Under the File menu (backstage), select Options.  Click on Add-Ins.  Click on Manage Visio Add-ins and click the Go button.

image

Uncheck Send to Bluetooth and click OK.

image

It should show up in the Inactive Application Add-ins.  Check it out and see if you still get the error.

image

Posted in Computer Software | Leave a Comment »

Gmail Constantly Refreshes on IE9

Posted by Russell Wright on July 26, 2011

I was getting a constant loop when logging in to a Gmail account (domain.gmail.com).  Luckily, I found this article.

http://www.google.com/support/forum/p/gmail/thread?tid=4b96896bb7f22920&hl=en

Let me summarize.

Remove any references to google.com from your trusted sites.

image

Posted in Computer Software | Leave a Comment »