Android SDK File not found Flutter installation error Fixed

Hi everybody, i found an error while installing Flutter in my windows 10, 64 bit operating system .When i run flutter doctor command in command prompt(CMD) i got the below error message ” Android SDK file not found ” .So i decided to find the solution.

Android SDK File not found Flutter installation error Fixed

Yes ,I fixed the error .i will explain it in step by step

1.Open Android Studio

2. Click Tools from menu

3. Select SDK Manager from drop down list

4.Settings for New Projects window will open as shown below image. Click Appearance & Behavior on left side as follow as shown below

Appearance & Behavior –> System Settings –> Android SDK

Android SDK File not found Flutter installation error Fixed

5. Click SDK Tools from Top menu bar ,Then choose SDK files to install /Updates available as shown in below image. At last Click Apply and then OK to download and install respective files

Android SDK File not found Flutter installation error Fixed

Now you may run flutter doctor command in command prompt (CMD) “Android SDK File not found ” error is fixed now

Android SDK File not found Flutter installation error Fixed

Okay we run the flutter doctor command successfully.it works fine.Thanks

Flutter Plugin not installed this adds flutter specific functionality Flutter installation Error fixed

Hi friends ,when i installed Flutter in my computer i got an error ” Flutter Plugin not installed this adds flutter specific functionality ,Dart Plugin not installed this adds flutter specific functionality” .I will show you the error image which i got while running flutter doctor command in command prompt (CMD).

I will show you the error image which i got while running flutter doctor command in command prompt (CMD).

 Flutter Plugin not installed this adds flutter specific functionality ,Flutter Plugin not installed this adds flutter specific functionality

So i planned to install Flutter plugin and Dart Plugin from android studio.i will explain How to fix the error step by step

Step 1. Open Android Studio

Step 2. Click Tools from menu bar

Step 3. Click SDK Manager from drop down list

Step 4. Settings for New Projects window will be opened,Then Click Plugins and type flutter in search column .it will show flutter plugin as shown in the image.

 Flutter Plugin not installed this adds flutter specific functionality ,Flutter Plugin not installed this adds flutter specific functionality

Click Install Button .it will open a window for Dart Plugin instantiation also .click Yes button as shown below image

 Flutter Plugin not installed this adds flutter specific functionality ,Flutter Plugin not installed this adds flutter specific functionality

When installation completed ,please restart android studio .Now we have installed flutter plugin and Dart plugin in the computer So i run flutter doctor command again in command prompt(CMD) window

 Flutter Plugin not installed this adds flutter specific functionality ,Flutter Plugin not installed this adds flutter specific functionality

Okay .Now fixed the issue – Flutter Plugin not installed this adds flutter specific functionality ,Flutter Plugin not installed this adds flutter specific functionality

Thanks

An internal error has occurred Remote Desktop Connection not working Error fixed

Hi friends, i got an error message “An internal error has occurred” while connecting windows server 2016 machine from my computer . So as a technical support engineer ,i started to find why remote desktop connection not working in my computer?.

How to fix An internal error has occurred   Remote Desktop Connection not working

When i clicked Connect button ,i got the error message as given below

“An internal error has occurred”

Al last i found the solution .I will explain it step by step

1.Click WINDOWS + R key and type gpedit.msc and click OK button

How to fix An internal error has occurred   Remote Desktop Connection not working

we will get Local Group Policy Editor window as shown below

How to fix An internal error has occurred   Remote Desktop Connection not working

2. Click Computer Configuration –> Administrative Templates –> Windows Components –> Remote Desktop Services –> Remote Desktop Session Host –> Security

3.On right side, you can see Require use of specific security layer for remote (RDP) connections as shown in below image

How to fix An internal error has occurred   Remote Desktop Connection not working

4. Double click Require use of specific security layer for remote (RDP) connections and edit it as shown below

How to fix An internal error has occurred   Remote Desktop Connection not working

Choose Enabled option and set RDP as Security Layer ,then click Appy and then OK button

Ok ,we did it .it is time to connect server machine again using Remote Desktop(RDP). If you get “An internal error has occurred” message again ,please restart the computer to effect the changes we made in Local Group Policy Editor window.Yes it ‘s working now.So we studied how to fix “An internal error has occurred” error in Remote Desktop Connection

The function requested is not supported in windows 7 An Authentication error has occurred RDP fixed

An authentication error has occurred.The function requested is not supported Remote computer counter-1

Hi friends,

one day i was trying to connect another computer counter-1 through remote desktop connection


Unfortunately i couldn’t connect counter- 1 machine and i got an error as shown below

So i started to find the solution and i will explain How to fix An authentication error has occurred.The function requested is not supported error

Step 1:

Go to RUN ,then type gpedit.msc and press ENTER key.you will get Local Group Policy Editor window as given below

Step 2:

Click on Computer Configuration –> Administrative Templates –> System –> Credentials Delegation ,then click on Encryption Oracle Remediation

Double Click on Encryption Oracle Remediation ,then you will get a window as given below

Choose Enabled option and select Protection Level to Vulnerable from drop down list.Then Click Apply and OK button as explained in above picture.

Now I tried to connect computer counter-1 through Remote Desktop connection again .It connected and works fine. So We fixed The function requested is not supported error .

SQL error -Index was outside the bounds of the array. (Microsoft.SqlServer.Express.Smo) in SQL Server

Hi friends, when i was trying to create/restore database to SQL Server 2014 ,i got an error “Index was outside the bounds of the array”.

Index was outside the bounds of the array in SQL Server 2014

So i decided to find a solution for the error. I connected SQL Server 2014 with SQL Server Management Studio Express (SSMSE).

How To Fix Index was outside the bounds of the array  in SQL Server 2014

As per Microsoft documentation,SSMSE is used for  SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services .

So i installed SQL Server Management Studio for SQL Server 2014 version.

Finally i solved the error.This error occurs when we create / restore database in SQL Server 2014 using SQL Server Management Studio Express(SSMSE). So In order to fix the error ,i installed SQL Server Management Studio for SQL 2014 version. It works fine for me.

Index was outside the bounds of the array in SQL Server 2014 fixed

Okay friends,So if you get ” Index was outside the bounds of the array ” error in SQL Server ,Please check SQL Server Management Studio version .

Instance Failure.(system.data) Error in SQL Server 2014

Hi, One day when i started to connect SQL Server 2014 instance using SQL Server Management Studio ,i got an error message “Instance Failure.(system.data) “.So i planned to fix the error by checking the system.

Instance Failure.(system.data) Error in SQL Server  2014 fixed

So first I checked how many SQL Server instances are running in my system .I found two SQL Server instances are installed and running in the system

1.DESKTOP-AEGCR6Q\SQL2008

Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)

2. DESKTOP-AEGCR6Q\SQL2014

Microsoft SQL Server 2014 – 12.0.2000.8 (X64)

So i checked TCP/IP Port Number of both SQL Server instances .it is 1433 for both SQL Server 2008 and SQL Server 2014 instances.I changed port number of SQL Server 2014 instance to 1434 as shown below

How To Fix Instance Failure.(system.data) Error in SQL Server

Now I started SQL Server 2014 again from SQL Server Configuration Manager in order to effect changes that we made in TCP/IP Port.

Solved Instance Failure.(system.data) Error in SQL Server 2014

Then I tried to connect SQL Server 2014 instance again .It connects and works fine for me.Finally I found How to fix the SQL Server error “Instance Failure.(system.data)” .So both SQL Server Instances were using same TCP/IP port number (1433) .So i changed SQL Server 2014 instances’s port number to 1434 .It worked for me .

Okay friends,this error can be fixed in another way also.i stopped SQL Server 2008 instance and tried to connect SQL Server 2014 instance .it worked for me.

So if you installed more than one SQL Server instances in the system,only one of them can have default TCP/IP port number 1433 at a time.

SQL error: 40 – Could not open a connection to SQL Server fixed

” A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 – Could not open a connection to SQL Server) (.Net SqlClient Data Provider) “

SQL error: 40 - Could not open a connection to SQL Server fixed

Hi everybody ,one evening, i opened SQL Server management studio and tried to connect to my SQL Server 2014 instance .but i could not connect to SQL Server and i got an error message as shown above.

So i tried to fix it in different ways .Today i am going to explain all solutions for the SQL error 40 – ” Could not open a connection to SQL Server”.

1. Make sure that you have started SQL Server 2014 instance by checking SERVICES.MSC or SQL Server Configuration Manager.

A. Using SERVICES.MSC

Open Services.msc and do as shown in the below picture

SQL error: 40 - Could not open a connection to SQL Server fixed using services.msc

Click Start button to fix ” Could Not Open a Connection to SQL Server “

OR

B.Using SQL Server Configuration Manager

SQL error: 40 - Could not open a connection to SQL Server fixed using SQL Server Configuration Manager



Click Start button to fix ” Could Not Open a Connection to SQL Server ”

2.Make Sure that SQL Server 2014 instance , TCP/IP port is enabled and check default port number 1433 is assigned .if you have more than one SQL Server instance in the system ,one SQL Server instance will take TCP/IP default port number 1433 and for second SQL Server instance ,we can give another port number manually . if we don’t give a TCP/IP port number for second SQL Server instance manually ,It automatically gets another port number .

Open SQL Server Configuration Manager and do as shown in the below pictures.

SQL error: 40 - Could not open a connection to SQL Server fixed by enabling TCP/IP

Okay ,We enabled TCP/IP now and let us check Port Number

SQL error: 40 - Could not open a connection to SQL Server fixed by enabling TCP/IP port number

After Enabling TCP/IP and assigning port number ,we have to restart SQL Server instance ,in order to effect the changes that we made in the SQL Server. Please check now that SQL Server error 40 is fixed.

3.Another fix for SQL server error 40 is to Tick Allow remote connections to this server.So we need to open SQL Server Management Studio and Right Click SQL Server instance name and choose Connections then Tick Allow remote connections to this server and Click OK button .

SQL error: 40 - Could not open a connection to SQL Server fixed by allow remote connections to this server

Any of the above three solutions helped me to fix the SQL Server error 40 ” Could not open a connection to SQL Server”.So if you have any another fix for the error .please comment below ,it will help a lot of SQL DBA around the world

SQL error ” Specified cast is not valid (SqlManagerUI) ” in SQL Server 2014 Database Restore

Hi friends,One day, one of my friend gave me a database backup for restoring. He was facing issue in restoring that database backup.he gets error ” Specified cast is not valid (SqlManagerUI) ” .So i tried to restore it in my SQL Server 2008 instance as shown below

Step 1

SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)

Step 2

Specified cast is not valid (SqlManagerUI)

Step 3

Specified cast is not valid (SqlManagerUI)

Step 4

Specified cast is not valid (SqlManagerUI)

Step 5

Specified cast is not valid (SqlManagerUI)

Yes This is the same error got for my friend,when he tried to restore this backup file.

Specified cast is not valid (SqlManagerUI)

But i tried to restore that same database backup in SQL server 2014 instance which is also in my system.It works fine .it restored successfully

Specified cast is not valid (SqlManagerUI)

So fix for SQL error “Specified cast is not valid (SqlManagerUI)” is to restore the database backup in same SQL Server version or higher versions.In this case,Database backup was taken from SQL Server 2014,but we were trying to restore it in SQL Server 2008 .So we got the error.But it can restore in SQL Server 2014 and higher versions without any error.

SQL Database Mail not sending error ” The mail could not be sent to the recipients because of the mail server failure.Cannot send mails to mail server”

Hi friends, One day morning I was configuring SQL Database Mail in SQL Server 2014 installed on my laptop.I tried to send SQL test mail but when i login into my gmail account and checked inbox ,i couldn’t find any mail.So i checked Database Mail log to find error message.

” The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1. Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at).) ”

So i planned to fix SQL Mail error using below steps

Step 1.Make sure that you have configured SQL Database Mail in proper way.Please check each steps as explained in my another blog

SQL Database Mail Configuration in SQL Server Step by Step

Step 2.You have to give valid mail id as User name and correct Password in in Password and Confirm password columns at the time of mail configuration

SQL Database Mail not Sending error Gmail Account

Step 3.Make sure that you have ticked The server requires a secure connection(SSL) as shown in the below picture

It is the fix for “The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required” error message .

The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required

Step 4.If above three steps not working in your SQL Database Mail ,Please log into sending email id and check that you got a Gmail critical security alert mail as shown below

SQL Database Mail  test mail not sending error fixed in Gmail account

Please open above mail and Click on Check activity button

The mail could not be sent to the recipients because of the mail server failure. Cannot send mails to mail server


You may click on Yes,it was me as shown in below image

SQL Database Mail not sending error fixed SQL test mail not getting in  Gmail account

Now please send SQL test Mail again and check it weather it works .if you still get same error, go to next step

Step 5.Make Less secure app access to ON State in your Gmail account(sending email id )

1. Login in to Gmail

2.Switch Allow less secure apps to ON state

SQL Mail not working in SQL Server 2017 and fix SQL Mail not sending error solutions

Now Check by sending a test mail from your SQL Database Mail using your Mail Profile .

I hope any of five steps mentioned above will help your Database Mail not sending error problem.If you have any alternate solutions please comment below .it will help a lot of SQL DBA students around the world

SQL Database Mail Configuration in SQL Server 2008 Step by Step

Hi ,Today i am going to teach you How to enable SQL Database Mail in your SQL Server .I have enabled SQL Database Mail in Microsoft SQL Server 2008 R2 installed on my computer.In all SQL version -SQL Server 2008,SQL Server 2008 R2,SQL Server 2012,SQL Server 2014 ,SQL Server 2016,SQL Server 2017,SQL Database Mail configuration can be done as shown in this article.

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

First Connect to SQL Server instance ,as shown in above picture .

DESKTOP-AEGCR6Q\SQL2008

Then Click Management ->SQL Server Logs ->Database Mail

Right Click Database Mail and Choose Configure Database Mail

you will get a window as shown below

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

When you click Next button ,you will get a window as shown below image

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Please Choose Set up Database Mail by performing the following tasks option and Click Next button then you will get a window as shown below

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Now you may click Yes button and you will get a window as shown below

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Now let us give values as shown above

Profile name —– SQLMAIL

Description —– SQL Database Mail

Then Click Add button.you will get a window as shown below

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Account name —– SQL (you can give any name )

Description—–SQL Database Mail (you can give any description)

E-mail address —–fromemailid@gmail.com (this is your sending email id.SQL Mail is sent from this mail id )

Display name —–SQL Database Mail (you can give any display name.This display name will appear in your mail)

Replay e-mail—–fromemailid@gmail(you will get replay to this mail id from email recipients.if you want to get replay to another email id ,then you can give it here .i choose to get replay mails to same email id .so i gave fromemailid@gmail.com as Replay e-mail)

Server name —–smtp.gmail.com

Port number—–587

This server requires a secure connection(SSL) makes enable by tick checkbox as shown in above image

Then choose Basic authentication

User name —– fromemailid@gmail.com

Password—–*****

Confirm password—–******

then click OK button ,you will get a new window as shown below

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Please click Next button as shown in above picture ,you will get a new window as given below

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Please Click Next button ,then you will get another window as shown in below image

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Okay now we almost configured SQL Database Mail in SQL Server 2008 R2.Let us send a test mail using SQL Database Mail Profile ‘SQLMAIL‘ which we created in above steps .

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard
SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard

Yes,When you click Send Test E-mail ,Mail will send to ‘toemailid@gmail.com‘ from ‘fromemaild@gmail.com‘.

SQL Mail configuration step by step tutorial .How to configure SQL Mail in SQL Server 2008 R2 .How to enable SQL Mail using SQL Database Mail wizard


Okay Now it is time to configure SQL Mail in your SQL Server.