Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 15, 2012 12:59 PM by RameshRajendran
Dec 15, 2012 09:06 AM|LINK
I used SQL Server 2008 R2 management Studio version without any Issues. But I installed SQL Server 2012 management Studio (SQLManagementStudio_x64_ENU). It needed Visual Studio SP1(VS10sp1-KB983509) and SQL Server 2005 Sp4 (SQLServer2005SP4-KB2463332-x64-ENU)
I installed it. But I have not installed Sql Server 2005 in my machine. But installed Sql Server 2005 SP4 since it wanted to complete the installation of Sql Server 2012. Once I completed the installations, new SQL server 2012 it worked remote login for othe
servers. i am working on Windows 7 with SP1
My problem is I can not access my previous databases what I installed in the localhost. That mean It is not allowing me to login to ".\sqlexpress" like before.
Please can you advise me to find the exact issue and I need a solution from one of your experts. It would be a great support if you can help. I am struggling and wasting too much time now.
I am getting this error.
Error 26 error locating server instance specified
Please see the exact error through this screenshot by clicking on this link.
I can not browse sqlexpress localhost databases now through both 2008R2 and 2012 version. Please help.
Dec 15, 2012 11:05 AM|LINK
To create database in VS using sql express. In solution explorer right click app_data and add new item -> sql server database.
To create connection string. Drag sqldatasource using design mode, and follow the wizard. Save it. You will get connection string already exist in web.config.
Dec 15, 2012 11:34 AM|LINK
thank you for the reply. I do not need to get the connection string and I know it is simple if I can login to the local server or databses.
Not sure whether you got my issues properly. Sorry If i didnt mentioned it correctly.
My Problem is I can not login and see the databases through the Sql Server 2008 R2 (or 2012) Management Studio to the local server with the previous login information. I am getting an error like this.
Also I can not see any SQL services are running.. Please see this screenshot as well.
How can we activate this or enable?
What is SQL Server Browser? Where can i find this and how can I enable that?
Please advise me.
Dec 15, 2012 11:59 AM|LINK
Dec 15, 2012 12:48 PM|LINK
Ok Thanks! fixed myself.
Re-installed sqlexpress and enabled "SQL Server Browser" when installing. It is disabled by default. However I missed all my all my datbases.
But it did bring me back sqlexpress.
Dec 15, 2012 12:59 PM|LINK
Refer to this link: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx