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.
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.
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.
try use this address .\sqlexpress or localhost\sqlexpress. I think you can not connect to local because you have not install sql server instance. I think you are able to install sql server instance in windows server only.
maduranga001
Member
162 Points
235 Posts
SQL Server connecting error 26
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.
http://www.freeimagehosting.net/aria9
I can not browse sqlexpress localhost databases now through both 2008R2 and 2012 version. Please help.
Thank You!
oned_gk
All-Star
31523 Points
6437 Posts
Re: SQL Server connecting error 26
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.
maduranga001
Member
162 Points
235 Posts
Re: SQL Server connecting error 26
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.
http://www.freeimagehosting.net/aria9
Also I can not see any SQL services are running.. Please see this screenshot as well.
How can we activate this or enable?
http://www.freeimagehosting.net/2knkf
What is SQL Server Browser? Where can i find this and how can I enable that?
Please advise me.
oned_gk
All-Star
31523 Points
6437 Posts
Re: SQL Server connecting error 26
Dec 15, 2012 11:59 AM|LINK
maduranga001
Member
162 Points
235 Posts
Re: SQL Server connecting error 26
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.
RameshRajend...
Star
7983 Points
2099 Posts
Re: SQL Server connecting error 26
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