The Network Administrator

The weblog of an IT pro specializing in virtualization, storage, servers and networking
  • rss
  • Home
  • About
  • Downloads
  • Contact

Using Windows Authentication from a non-domain joined machine for Microsoft SQL Management Studio

MWahl | December 8, 2010 | 9:04 am

Modify the shortcut’s target as follows:

SQL Server 2008 x64: C:\Windows\System32\runas.exe /user:YourDomain\YourUsername /netonly "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\binn\VSShell\Common7\IDE\Ssms.exe -nosplash"

SQL Server 2008 x86: C:\Windows\System32\runas.exe /user:YourDomain\YourUsername /netonly "C:\Program Files\Microsoft SQL Server\100\Tools\binn\VSShell\Common7\IDE\Ssms.exe -nosplash"

SQL Server 2005 x64: C:\Windows\System32\runas.exe /user:YourDomain\YourUsername /netonly "C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SqlWb.exe -nosplash"

SQL Server 2005 x86: C:\Windows\System32\runas.exe /user:YourDomain\YourUsername /netonly "C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SqlWb.exe -nosplash"

sm1sm2

Modifying the shortcut’s target messes up the icon. You’ll want to fix that by pressing the Change Icon… button again and restoring the path to the one you saved earlier. In case you didn’t save the path, the default values for the path to the icon are:

sm3

SQL Server 2008 x64: %ProgramFiles% (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

SQL Server 2008 x86: %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

SQL Server 2005 x64: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SqlWb.exe

SQL Server 2005 x86: C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SqlWb.exe

When you start SSMS or SQLwb from a modified shortcut, you’ll be prompted for your domain password:

sm4

Notice that the Connect to Server dialog is misleading after making this change. Although it properly shows I’m using Windows Authentication, it incorrectly indicates the credentials.  You are connected with the Domain\Username supplied in the modified shortcut.

Comments
Comments Off
Categories
Microsoft SQL Server, Windows tools
Comments rss Comments rss
Trackback Trackback

Easy photo editing software that enables you to fix and enhance photos

MWahl | November 7, 2010 | 7:31 pm

I am often asked what i use for photo editing. I like to use a free photo editor called Photoscape, which lets you do the following and more…

Viewer: View photos in your folder, create a slideshow

Editor: resizing, brightness and color adjustment, white balance, backlight correction, frames, balloons,

mosaic mode, adding text, drawing pictures, cropping, filters, red eye removal, blooming, clone stamp

Batch editor: Batch edit multiple photos

Page: Merge multiple photos on the page frame to create one final photo

Combine: Attach multiple photos vertically or horizontally to create one final photo

Animated GIF: Use multiple photos to create a final animated photo

Print: Print portrait shots, carte de visites(CDV), passport photos

Splitter: Slice a photo into several pieces

Screen Capture: Capture your screenshot and save it

Color Picker: Zoom in on images, search and pick a color

Rename: Change photo file names in batch mode

Raw Converter: Convert RAW to JPG

Paper Print: Print lined, graph, music and calendar paper

Face Search: Find similar faces on the Internet

Comments
3 Comments »
Categories
Photos, Windows tools
Comments rss Comments rss
Trackback Trackback

Troubleshooting an issue and wish you could see the screen?

MWahl | November 7, 2010 | 7:20 pm

We have all been there, someone is having an issue and we wish we could just see their screen. There are plenty of expensive solutions and a few free ones. I personally like https://join.me/, which offers free screen sharing. Have the person who needs your help go to https://join.me, click share and follow the easy steps on the screen. They will get a code, which they can email to you the guru or you can visit https://join.me, and choose join.

Comments
Comments Off
Categories
Windows tools
Comments rss Comments rss
Trackback Trackback

Windows Live Writer 2011

MWahl | November 1, 2010 | 8:33 pm

http://g.live.com/1rewlive4-web/en/wlsetup-web.exe??WLI=1&WLXID=851cc5cd-ad28-453f-9ab3-3cbaa633e2e2&RID=001dbb32c1a&TID=1288661382438&lid=

Windows Live Essentials 2011 includes Messenger, Photo Gallery, Movie Maker, Mail, Writer, Family Safety, and Windows Live Mesh, plus Bing Bar, Messenger Companion, Microsoft Silverlight, and Outlook Connector Pack (Microsoft OutlookHotmail Connector and Microsoft Outlook Social Connector Provider for Windows Live Messenger).

Comments
1 Comment »
Categories
Windows tools
Comments rss Comments rss
Trackback Trackback

More Network Security Tools

MWahl | November 1, 2010 | 8:04 pm

http://sectools.org/vuln-scanners.html
http://www.nessus.org/nessus/
http://www.wireshark.org/
http://www.hping.org/
http://www.cirt.net/nikto2
http://freeworld.thc.org/thc-hydra/
http://www.aircrack-ng.org/
http://www.foundstone.com/us/resources/proddesc/superscan.htm
http://www.eeye.com/Products/Retina.aspx
http://technet.microsoft.com/en-us/sysinternals/default.aspx

Comments
Comments Off
Categories
Windows Server, Windows tools
Comments rss Comments rss
Trackback Trackback

Have a virus!? Do a little research to find out exactly what it is here…

MWahl | September 29, 2010 | 9:26 pm

The Symantec Anti-virus Research Center

http://www.symantec.com/security_response/index.jsp

Also check this link which contains the removal tools, tips, etc

Comments
Comments Off
Categories
Windows tools
Comments rss Comments rss
Trackback Trackback

New to PowerShell? Try powergui!

MWahl | July 13, 2010 | 10:59 pm

Similar to the Exchange Management console it shows you the powershell script that was used!

Here is the site, and there is a tab to download.
http://powergui.org/index.jspa

Dont forget to check out the PowerGUI Library for more add-ons
http://powergui.org/kbcategory.jspa?categoryID=21

Tutorials Page
http://powergui.org/tutorials.jspa

Comments
Comments Off
Categories
Scripts, Windows Server, Windows tools
Comments rss Comments rss
Trackback Trackback

Must Have Tools For All IT Professionals

MWahl | May 11, 2010 | 10:23 pm

Virtual CloneDrive

http://www.slysoft.com/en/download.html

FileZilla

http://filezilla-project.org/

ImgBurn

http://www.imgburn.com/

VirtualBox

http://www.virtualbox.org/

Sysinternals Suite

http://download.sysinternals.com/Files/SysinternalsSuite.zip

HWiNFO32

http://www.hwinfo.com/download32.html

CCleaner

http://www.piriform.com/ccleaner/download/standard

Recuva

http://www.piriform.com/recuva/download/standard

Comments
Comments Off
Categories
Microsoft Apps, Windows tools
Comments rss Comments rss
Trackback Trackback

Simple way to monitor anything with an IP address

MWahl | February 20, 2010 | 10:22 am

This simple app can be scheduled as a windows Task. It will ping anything with a valid IP address at an interval in minutes you set. If a ping fails on an IP address you will receive an email to notify you that there is a problem.

You can download the program here http://apps.thenetworkadministrator.net/monitor_servers.zip

There is a configuration file called PingInfo.exe.config which will allow you to set your email server, polling interval and the the email address or group for the notifications.

add key=”EmailAddress” value=”name@foo.com
add key=”PollingInMinutes” value=”15″/>
add key=”SMTPHost” value=”mailserver.foo.com
>

Comments
1 Comment »
Categories
Windows Server, Windows tools
Comments rss Comments rss
Trackback Trackback

Uninstall those stubborn applications

MWahl | November 28, 2009 | 4:52 pm

Just run this microsoft application…and the select the application to remove.

http://apps.thenetworkadministrator.net/msicuu2.exe

Comments
Comments Off
Categories
Windows Desktops, Windows Server, Windows tools
Comments rss Comments rss
Trackback Trackback

« Previous Entries

some text

RSS Netcast

  • Increasing your AWS EC2 root partition (Windows) December 14, 2011
  • IIS SSL Certificate into Amazon Elastic Load Balancer December 7, 2011
  • Upgrade an Opsview Appliance August 13, 2011

Categories

  • Activesync (1)
  • Amazon EC2 (5)
  • Amazon S3 (2)
  • Antivirus (1)
  • Blackberry (9)
  • Blackberry Enterprise Server (1)
  • blogs (3)
  • Cisco (6)
  • Citrix Xenapp (2)
  • Databases (2)
  • HTC (1)
  • Internet Explorer (1)
  • iPhone (4)
  • Linux Server (18)
  • Linux tools (11)
  • Microsoft Apps (2)
  • Microsoft Exchange (12)
  • Microsoft Office (1)
  • Microsoft Sharepoint Services (1)
  • Microsoft SQL Server (3)
  • Monitoring (2)
  • MS IIS 6 (1)
  • MYSQL (1)
  • NetCast (3)
  • Networking (19)
  • OpsView/Nagios (1)
  • Photos (1)
  • RAID (1)
  • Scripts (4)
  • Secure FTP (1)
  • Security (10)
  • Smart Phones (1)
  • Tech Preview (8)
  • Uncategorized (40)
  • Virtual Servers (4)
  • Web Browsers (2)
  • Web Server load balancing (1)
  • Web Servers (9)
  • Windows Desktops (17)
  • Windows Server (24)
  • Windows tools (23)
  • WordPress (1)

Recent Posts

  • Increasing your AWS EC2 root partition (Windows)
  • IIS SSL Certificate into Amazon Elastic Load Balancer
  • Upgrade an Opsview Appliance
  • AppAssure Replay First Impressions
  • Linux Boot Process

Archives

Blogroll

  • IT Pro Security Community
  • Jeff Stevenson
  • kevin devin
  • lopsa lopsa
  • MWahl social.microsoft.com
  • Network Security
  • Petri
  • SVROPS
  • Technology blog from bbc
  • technology review
  • THE WAN LAN LORD
rss Comments rss valid xhtml 1.1 design by jide powered by Wordpress get firefox