.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error 26 while trying to Connect to a SQLExpress 2005 database on a remote computer

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

I have installed SQL Express 2005 on two computers networked and running windows XP.  I've copied the database from the first computer to the second and run queries on both to show that both computers have an active database that is up and running.  Now I am trying to use the Sql Server Management Studio Express (SSMSE) on the first machine to establish contact with the second machine.  In order to have the two machines communicate I've configured the SQL Server on the second machine as follows:

Under the protocols for the SQL Server 2005 Network Configuration I've enabled the TCP/IP pipes and set the TCP/Dynamic ports to 1032 (when I ran netstat -a it indicated that this was an active connection which I think this means it is available - though it says that the port has a Foreign Address and it State is listening).  As an aside the port 1433 was not among the active connections.

Both the SQLServer and the SQLServer browser are running (which presumably means they are both enabled).

I've run the surface Area Configuration For Services and Connections Tool to Set the SQLExpress Remote connections for Local and remote connections using TCP/IP and named pipes.

The Client Protocols for the SQL Native Client Configuration is stillset so that the default port is 1433. 

When I look at the most recent

View Complete Post

More Related Resource Links

Connect to existing sql 2005 database


Hello There,

I had successfully restored sql 2000 database to sql 2005. It works like charm

Now i am creating a database model in MVC

I follow these steps

Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name

But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error

"A network-related or instance-specific error 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.

Kindly help me with this


Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Connect SQL Server 2005 to Ms Access on another computer

I'm trying to create a "Linked Server" on my SQL Server 2005.  This linked server is a reference to an Access File on a remote computer.  I've set up all the permissions and shared resources.  I've created an ODBC DSN to connect to the database.  If i open the DSN in excel, i can retrieve data.  If I open a linked server connected to the DB I get the following error when i try to run a query against it.   ------------------ OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LS_Specialty". ---------------------   Why does this DSN work in Excel and Access, but not in SQL

Intermittent SharePoint database connect error on SQL cluster

SQL 2008 Cluster has two SQL instances. Two separate SharePoint farms are "connected" with each SQL instance. SharePoint frontend servers eventlog is flooded with "unable to connect with database.." kind of errors for few minutes during diferent time interval. This erros occurs at the same time on both SharePoint farms. (Note that both SharePoint farm doesn't share any info, that is, each farm is running independantly). Someone suggests SQL box has some bandwidth/network issue. Enabled SQL trace. But not sure how to analyze. Can someone help? Thanks in advance    

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

How to delete a sqlexpress database from the visual 2005

Hello, I created a database in my local sqlexpress server, using the 'Create New SQL server database ..." option in the Server Explorer of VS 2005. How can i delete this database now using VS 2005 ? it seems that the 'Delete' option, only remove the link in the 'Data Conncetions ' folder. Thanks and Regards Denis

I am Getting error in Sqlcoding while using my code in remote Sql database.

HaiI am getting Error in this code. I mention my ERROR in BOLD Letter in my Coding.. And i show u the Connectionstring Too.BUt this code is working Perfectly in My local "Connectionstring"Plz Help Me to solve this error. Conn = New SqlConnection("Data Source=xxx.xxx.xxx.xx;Initial Catalog=xxxxxxxxxxxxx;Persist Security Info=True;User ID=xxxxxxxxxx;pwd=xxxxxxxx;MultipleActiveResultSets=True")If (Conn.State = ConnectionState.Closed) Then                Conn.Open() End If            ErrMsg = ""            StrQry = ""            StrQry = " select * from MO_users where({ fn LCASE(username) } = { fn LCASE('" & Username & "') }) " & _                      " and (CAST(password AS binary) = CAST('" & Password & "' AS binary)) and status='1'"            Cmd = New SqlCommand(StrQry, Conn)            Dr = Cmd.Execute

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

Error while Deploying WebMatrix Beta Application having SQL Database on Remote Server


Hello All,

I have created "DotNetNuke SQL Database Application" from the WebMatrix Gallery.

Now I want to deploy it on the remote server using Web Deploy method.

Without selecting SQL database, application is deployed successfully but when I select SQL database it gives following error:

Publish : Error - Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy provider is dbFullSql).

Can anyone have the solution of this error?

Thanks in advance....

Cannot Connect to Remote MS SQL Express (error: 26)

Hey guys,
I have tried 
but non of them are working.

I have tried all the settings, without any success.

I am using 
windows 7 ultimate, 
 Visual Studio 2008, 
 linksys wireless router.

I currently disabled my firewall, and have enable traffic on 1037,1434,1433,52369 ports for my router.

So, does anyone have any solution(s) for me to connect to my database remotely?

My codes is as follow:

// attempt 1 : using external IP
String databaseName = "testDB";

string dataSource = @"xx.xx.xx.34\SQLEXPRESS";

how to connect my hosting database from my pc using sql server management studio 2005



I have one asp.net hosting account with some service provider.. 

They have given me some xxx.xxxxxx.com to access sql server from my desktop... 

I enter xxx.xxxxx.com in server name and username and password but it will not connect.. 

so please let me know what are the steps i have to do to access my hosting database...

they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect

thanks in advance

Cannot connect to a configuration database after renaming Windows 7 computer


I have just recently installed a standalone instance of SharePoint 2010 on Windows 7 64-bit.  Everything was working fine, however, as part of joining my computer to the domain, my computer was renamed.  Now that the computer has been renamed, I am no longer able to connect to my locally installed SharePoint instance.  I receive an error message stating "Cannot connect to the configuration database."

I found this article on renaming a server for SharePoint Foundation: http://technet.microsoft.com/en-us/library/cc288510.aspx.  However, it seems like the article is assuming that the rename operation occurred while SharePoint was still running.  However, I am running SharePoint Portal Server 2010 and now that I cannot connect to the configuration database, I cannot make any alterations to the SharePoint instance at all.

In addition, my instance of SQL Server as well as the standalone SharePoint instance was installed prior to the computer rename.  What are the steps that are required to address this situation?


503 Service Error and Cannot connect to configuration database.


We have a brand new installation of Windows Server 2008 R2, SQL Server 2008 R2, and SharePoint 2010, and configuration of SharePoint 2010 at end of installation.

So far after all of this was installed the only thing we've accomplished so far is this:

Accessing the website:  503 Service Unavailable.
Accessing admin site:  503 Service Unavailable and/or Cannot connect to configuation database.

I've installed teh recommended hotfixes.  I've rebooted.  I've reconfigured to ensure it was hitting the right database and everything else.  Googled and searched here, ALL to no avail.

Suggestions?  I'm at my wits end and won't spend another second on what, but all appearances, is turning out to be a crappy product that our company spent thousands on.  I've had better luck (100% success) running just the services.


Error : Unable to connect to the remote server, When using web service in window service

Hi All,

          I want to consume a web service in windows service but in windows service I am not able to access  web service. I have tried it in windows application and web application it is working fine but in windows service  it is not accessible.


i am getting error:-   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)--->   at System.Net.HttpWebRequest.GetRequestStream()
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Testmachone.MachWebRef.SimCardWS.ProvisionImsiCard(String MsMin, String MsEsn, String CardId, String UserId, String Password, String MscId, String BId, String NewValue, ActionTypes Command, String MDN, String COS, String MIP_KEY, String MEID, String RADIUSPassword, String IMSI, Boolean PrePaid)

 any body can help me what could be issue


Dreaded "Cannot connect to the configuration database" error in WSS 3.0 after MS updates yesterday (


I know this has been a common issue in the past after updates, patches, SPs etc. Tried several of the online "cures" no luck. I've got a standalone instance of WSS 3.0. Anyone else with this issue after yesterday's updates? If so, any luck?


Update: ran WSS 3.0 configuration wizard, held my breath, and voila it worked!

Cannot connect to Sql server 2005 database engine

Hello everybody!

I am having problems to connect to Sql Server Database Engine. I have recently(yesterday) installed Sql Server 2005 Developer Edition. The installation was totally successfull. Yesterday I was able to connect to Sql Server Database engine via SSMS but today it gives me an error:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

It is strange because only one day before It worked fine.

Thanks a lot

WSS 3.0 Error "Cannot Connect to the Configuration Database"


I tried re-running the configuration Wizard to no avail.  I can't even get to the Central Admin page.  When running the config wizard it tells me that it can't connect to the farm (it's a standalone install) and to disconnect from the farm to continue.  I disconnected from the farm and now it says that it can't get to the config database. 

Running psconfig -cmd upgrade -inplace b2b  and I get this error message:

No connection string to a WSS configuration database detected. 

I'm at a loss. 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend