This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using the Upsizing Wizard to convert an Access DB to and SQL database.
I am getting an error message that the SQL Server does not exist or access denied. All worked fine last week when I did this.
I have SQL Server Management Studio 2016 installed on my computer (Windows 7 Professional operating system).
Last week I could access my local DB via the connect button (Servername = MARCIA-PC\SQLEXPRESS) but no longer. I now receive this error message:
"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: SQL Network Interfaces, error :26 - Error Locating Server /Instance Specified( (Microsoft SQL Server)
I did delete an old version of SQL Server Management Studio 2008 from my computer and that's when I started having problems. I tried to do a restore - but the restore did not work. I have deleted and reinstalled both SQL Server Management Studio 2014 Express and SQL Server Management Studio 2016.
i have rebooted my computer. All to no avail. I just want to .
When I go to SQL Server Configuration Manager (Local) there are no SQL Server Services. so I cannot even start the service. How do I get a new local service??
Help is appreciated as I have working onthis for about 6 hours today to no avail.
MF
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Use SSMS to connect to a SSDE. Then right-click the Databases node and select Attach. Browse to a MDF file.
Thank you!!! I've gotten everything working again.
Another question.
The DBs that I converted last week were all put in a folder called MSSQL10.SQLEXPRESS.
How do I get SSMS to see them?
All the new DBs that I converted tonight are in a folder called MSSQL12.SQLEXPRESS. I tried moving the other ones to MSSQL12.SQLEXPRESS but I still cannot view them in SSMS.
Thanks for your help.
Marcia
There is a difference between SQL Server Management Studio (SSMS) and the SQL Server database engine (SSDE).
Run SSMS, and in the Connect to Server dialog in the Server name field choose Browse for more. If this tool can't find any SSDEs, then you will need to re-install SSDE.