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.
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
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
Now you may run flutter doctor command in command prompt (CMD) “Android SDK File not found ” error is fixed now
Okay we run the flutter doctor command successfully.it works fine.Thanks
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).
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.
Click Install Button .it will open a window for Dart Plugin instantiation also .click Yes button as shown below image
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
Okay .Now fixed the issue – Flutter Plugin not installed this adds flutter specific functionality ,Flutter Plugin not installed this adds flutter specific functionality
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?.
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
we will get Local Group Policy Editor window as shown below
3.On right side, you can see Require use of specific security layer for remote (RDP) connections as shown in below image
4. Double click Require use of specific security layer for remote (RDP) connections and edit it as shown below
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
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”.
So i decided to find a solution for the error. I connected SQL Server 2014 with SQL Server Management Studio Express (SSMSE).
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.
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 .
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.
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
Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)
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
Now I started SQL Server 2014 again from SQL Server Configuration Manager in order to effect changes that we made in TCP/IP Port.
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.
” 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) “
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
Click Start button to fix ” Could Not Open a Connection to SQL Server “
B.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.
Okay ,We enabled TCP/IP now and let us check 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 .
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
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
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
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.
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
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
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.
First Connect to SQL Server instance ,as shown in above picture .
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
When you click Next button ,you will get a window as shown below image
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
Now you may click Yes button and you will get a window as shown below
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
Account name —– SQL (you can give any name )
Description—–SQL Database Mail (you can give any description)
E-mail address —–firstname.lastname@example.org (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 email@example.com as Replay e-mail)
Server name —–smtp.gmail.com
This server requires a secure connection(SSL) makes enable by tick checkbox as shown in above image
Then choose Basic authentication
User name —– firstname.lastname@example.org
then click OK button ,you will get a new window as shown below
Please click Next button as shown in above picture ,you will get a new window as given below
Please Click Next button ,then you will get another window as shown in below image
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 .
Yes,When you click Send Test E-mail ,Mail will send to ‘email@example.com‘ from ‘firstname.lastname@example.org‘.
Okay Now it is time to configure SQL Mail in your SQL Server.