How to boot directly into your regular desktop Screen in Windows 8.1?

With the new windows 8.1, it is very simple to bypass the new start(Live Tiles) Screen if you want to and directly boot into regular Desktop mode. Let me show you how…

Nope! That’s not a setting in control Panel and not even in your task manager….! Once you login to your windows machine, switch to your legacy Desktop screen  and right click on task bar and go to Properties and navigate to “Navigation” tab.  Now at the bottom section(Start Screen) select “When I sign in or close all apps on a screen, go to desktop instead of start” as shown below and click Apply->ok. That’s it…You are good to go 🙂

1

 

Very Simple huh…!

The Network folder specified is currently mapped using a different user name and password

Today I was trying to map a network drive on my laptop and received a message saying “The Network folder specified is currently mapped using a different user name and password“. Well, I thought there is one and went into “My Computer”. interestingly….I don’t see it! Well, I rebooted the laptop hoping it would drop any hanging hidden cables. Unfortunately it didn’t do the trick.

BTW, My laptop already has 2 mapped drives(Y$ and Z$) and I’m trying to create  a 3rd one pointing to another share on completely different file server.(See below screenshot) 

1_a

Now, I tried issuing “NET USE” command to see if it shows anything useful. Surprisingly It said, I’ve 3 mapped drives(3rd one being the one which I’m trying to map without any Drive letter being assigned!!!). See below Screenshot…

1_b

As you can see there’s one more thing(well, without drive letter assignment) and that’s the exact share which I’m trying to create as a mapped drive on my laptop. Now I know the issue. All we need to do is to Delete that “Hanging from Nowhere” Mapped Drive using “NET USE” and retry to map it.

Syntax for deleting mapped drive using NET USE:

NET USE /DELETE \\My_ServerName\My_Sharename

Boom….It dissapeared as you can see below.

2

Notice in the above screenshot, that “magical and annoying” share got deleted succesfully and only Y$ and Z$ are present as expected.

Now, I was able to map that share to a new drive without any issues…Hope this helps if you get into same issue. Cheers 🙂

MAP(Microsoft Assessment and Planning Tool kit) 6.5 for SQL Server Discovery

Hello Folks! In this Blog Post let’s see how to make use of MAP tool for discovering all of your SQL Servers in your Environment. MAP is one of the wonderful tools(free) provided by Microsoft, which basically scans all over your Network and present you with a wonderful report on all of your Servers. They could be Windows Servers, Linux Servers, SQL Servers, Oracle, MySQL. Many companies use this fabulous tool for planning future road maps(Could Be Server Upgrades, Desktop Upgrades, MS Office Suite upgrade and what not), consolidations, upgrades, Licensing etc. In My Organization, we are planning to move on to SQL 2012 very soon and we need a report which basically gives us a clear and simple picture of our current SQL Server Environment and I was assigned to achieve this goal 🙂

Sooo….., let’s get started. First thing you’ve to do is download MAP ToolKit from below location

http://www.microsoft.com/en-us/download/details.aspx?&id=7826

Once downloaded, choose a Machine in your Domain where you want to Install MAP tool and start Discovery.

Note: MAP tool Installs SQL Server Express by Default for storing it’s Results.

Demo:

I’ve chosen “Mirror_Stand” machine in My Lab Domain to Install MAP. I copied over executable  to this box as the 1st step. Right click on the “Microsoft_Assessment_and_Planning_Toolkit_Setup.exe” and choose Run as Admin and you should be seeing the following Screen. (Make sure to Install all the Prereq’s. If not, you’ll be welcomed with an ugly X message as shown below!)

Once I finished meeting all the Prereq’s, I’ve opened the exe and now I’m welcomed with the below Screen 🙂

Click Next-> Accept License Terms and Next->Select your Installation Folder(I left it to default) and click Next. Now comes the interesting Screen where it asks for how do you want to Install SQL Express(see below Screenshot).

If your Box is connected to Internet, Just select the 1st Radio Button. If not, select 2nd option and provide it with the SQL express Installation media path.  I’ve chosen 2nd option and provided path for my SQL Express 2008R2 as shown below.

Once you read and accept the license terms, you should see a similar screen as below.(In My case, I already have a SQL Server Installed on this Machine, hence you can see “New Instance” being stated by the Installation wizard).

Click on Install and go and grab a cup of coffee :). It’ll take a while!  As you can see, my Installation is successful now.

It Installed SQL Express Edition Instance on my machine with Name “MAPS”. See below Screencap

We are done with the Installation. Now, let’s see how can we discover SQL Servers across our Domain using this Tool.

Step1: You will be welcomed with the below screen where you’ve to create an Inventory DB(I named it as “SQL_Inven”) for the First time. (You can create separate Databases for separate Discoveries, eg: One DB for SQL Servers, another for Exchange, another for VMWare Servers etc).

Step2: Select on Databases and Choose to perform an Inventory as shown below.

Step 3: Select SQL Servers to discover your SQL Servers as shown below.

Step 4: Choose a Discovery Method. I’ve left to default to AD as you can see below.

Step 5: Provide domain Credentials and select which parts of your AD Forest to scan for as shown below.

Once you proceed upto Finish, it automatically starts gathering info as per the options you’ve chosen. It will take a while for gathering all the required info…

Once it finished, you can see a neat and very useful summary of MAP assessment of your SQL Servers as shown below.

Don’t say it’s useless…It’s actually wonderful Summary of your Environment. For detailed Reports, gather the performance metrics as well and click on “Generate Report/Proposal” on your Tasks Pane to your Right. Once finished it’ll create couple of excel Reports which are very very detailed and useful…You’ll find those reports in your documents folder. In My case, it is “C:\Users\sreekanth\Documents\MAP\SQL_Inven”

Nice thing is, It’s agent less. All it needs is an Account name which has access to the Servers and the Servers should be Up and Running while It scans.

Hope this is informational and useful. Cheers!…

SQL Server 2012 RC0 on Windows 8

Today I got some leisure time and thought of Installing SQL 2012 on my Win8 machine and sharing my experiences at a very high level. Well,  I’ve Installed SQL Server 2012 RC0 on my Windows 8(Consumer Preview – Evaluation Copy, Build 8250) Machine.

To be honest, I was expecting few bugs and annoying errors. But let me tell you this, My Installation went Flawless. FYI, I’ve Installed only basic components(DB Engine – with Replication, SSIS,Complete Client Tools, SDK Connectivity).

Just a screenshot of how it looks like on Win8. Well, Technically there is no difference in how SSMS looks and how it behaves, but as most of you are already aware of…there is no START Button on my Menu bar on my Desktop! See below on the bottom Left corner.

So, where did I open SSMS from?? If you said “Metro Screen” yes, you are correct. See the below Screenshot for how Windows8 organized programs on my Metro Screen.

Hmm…this is something which really disappointed me. Basically, It created bunch of Apps for each exe! Imagine how ugly your Metro Screen gets if you Install all the components of SQL Server!! I Wish it was smart enough to create at least folders/Groups and place related exe’s accordingly.

Btw, if you want to Run SSMS as Admin, just right click on the App and you will see the available options in the bottom of your Screen as shown below. ( This applies to all the Executables)