“[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied” after installing SQL Management Studio?

I recently installed SQL Management Studio (which also installed SQL server 2016 to my local machine), and now am unable to connect to SQL server from applications on my machine. It will come up with the error message below:

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"

At this point, should I just uninstall SQL management studio/SQL server, or is there an easy way to resolve this issue without needing to do so?

Here is the code I am attempting to execute which worked before installing SQL server and SSMS.
                string connectionstring = ConfigurationManager.ConnectionStrings["B2BConnString"].ToString();

                OleDbConnection conn = new OleDbConnection("Provider=SQLOLEDB;"+connectionstring);
                conn.Open();

                string strSQL = "select [aliasname], [apikey], [password], [sharedsecret], [url], [isTest], [lastid] from ShopifyWSSetup as s Inner Join Clients as c on s.cno = c.cno where isactive = 1 and aliasname = '"+aliasname+"';";
                OleDbCommand comm = new OleDbCommand(strSQL, conn);

                OleDbDataReader reader = comm.ExecuteReader();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        apikey = reader.GetString(1);
                        password = reader.GetString(2);
                        sharedsecret = reader.GetString(3);
                        url = reader.GetString(4);
                        isTest = reader.GetBoolean(5);
                        if (!reader.IsDBNull(6))
                        {
                            lastid = reader.GetString(6);
                        }
                    }
                }

                conn.Close();
                conn.Dispose();
                reader.Close();

Open in new window


Connection string:
<connectionStrings> <add name="ExampleConnString" connectionString="Data Source=10.0.1.111;Initial Catalog=Example;User ID=Example;Password=examplePW;Connect Timeout=30" providerName="System.Data.SqlClient"/> </connectionStrings>

Open in new window


I uninstalled SQL Server 2016 which came with the SSMS. Now I only have SQL Server 2008 on the machine, but the error is still occurring.
Jordan JohnsonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
Do you have a named instance? -> then you would need to specify it in your connection string (10.0.1.111\NameOfYourInstance)

Could it be a firewall issue? Try disabling it for 10 minutes

Is the TCP IP protocol enabled in SQL Configuration tool?

Try adding "Network Library=DBMSSOCN" to your connection string to force using the TCP protocol.

Is the database local or remote to your process?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arnoldCommented:
Using sql 2008 configuration to make sure you did not alter/upgrade the installed instance. Often during install you can choose which components you are installing..

Pointed out by prior what information is missing.

the issue might be the new sql native client library installed.


Get and install the sql 2008 SSMSE version. Then it will help you trouble shoot the issue.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Jordan Johnson, do you still need help with this question?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.