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

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

How to Configure SQL Express to Established Remote Connection at the time of installation?

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

hey guys,

does any one know How to Configure SQL Express  to Established Remote Connection at the time of installation?



View Complete Post

More Related Resource Links

Configure SQL for Remote Connection



Does any one know how to configure SQLExpress  for remote connection at the time of installation.

and how to add its configuration file(.ini file) in Prerequistes or run it at the time of installing





connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

An existing connection was forcibly closed by the remote host


I get this message when I try to launch a report (.rdl) from Windows Sharepoint 2007.  I have followed the steps to integrate SQL 2005 SP2 with Sharepoint 2007.  I can launch the report by navigating to "http://server:880/reportserver/.."  I am using a shared datasource that I created within sharepoint.  Any help would be appreciated.

How to Establish a Remote Web Site Connection in SharePoint Designer 2007


I am modifying a SharePoint site and so far so good.  Some of the objects were created using Visual Studio 2008 (C#).  I was able to modify these objects and implement them on the targete machine without issue.  The final step is to implement the ASPX pages that were modified using SharePoint Designer 2007.  These are aspx pages that are used to modify items in lists.  All the pages involved in this upgrade are customized.  I need to upgrade the target site with the modified version of these pages.  My intent is to copy the code from the page in the source site and past it into the same page on the target site.  I tried using the Remote Web Site connection tool in SharePoint Designer 2007 but received the following error message:

"Unable to open 'https://(site address)'.  Server Error:  Could not find a Web server at 'website'.  Please check to make sure that the Web server name is valid and your proxy settings are set correctly.  If you are sure that everything is correct, the Web server may be temporarily out of service."

I am not sure how to first check to see if the Web Server is temporarily out of service.  I would appreciate your input on how to verify this.

Background information of target machine:  WinServer 2008, IIS 7, Sharepoint (MOSS2007), site on port 80

Remoting from WebService throws: An existing connection was forcibly closed by the remote host

Hello everyone, I have a problem with using .NET remoting from webservice. When using remoting from console application, there is no problem. I suppose problem is somewhere in IIS. My system is Windows Vista. Thank you for any help. Best regards, Jozef

WCF issues sending large data - "An existing connection was forcibly closed by the remote host"

Hi Guys I have posted the following on www.asp.net but thought it might be productive posting here too.I have been pulling my hair out trying to fix an issue with sending data over WCF, I have read pretty much every THREAD on this forum regarding or similar to this issue without any successful solution.  I have a simple data object which has a [DataMember] with a data type of byte[]. I use this to send binary data from my web app as follows: Asp.net MVC website --> WCF Client (Has my Service References) --> My Services (MyServices.svc) --> Business/Data Tier Everything is being executed from within VS 2008 Pro.   Now I have successfully sent data up to 2.2MB, however it fails if i try and send a file such as 2.3MB or larger i get the following exceptions: General Exception Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)   at SoftApp.WCFClient.MyServiceReference.IMyService.Document_Save(DtoDocument dtoDocument, Int32 usercode)   at SoftApp.WCFClient.MyServiceReference.MyServiceClient.Document_Save(DtoDocument dtoDocument, Int32 usercode) in c:\dev\softapp\softapp.wcfclient\service references\myservicereference\refe

Just-In-Time Debugger error when opening SQL Server studio express

Hi,   I am new to these forums; hope I am posing in the correct forum   I have problem opening the SQL Server 2005 Management Studio Express. Getting the error below   'An unhandled win32 exception occurred in ssmsee.exe [5336]'   Searched in many forums but none of the suggestions resolved my issue..   I have re-installed .net 2.0, upgraded to 3.5 but still no luck either   Have re-installed SQL server management studio express again no luck   Deleted the shell folder from both documents and settings and in registry still have the same problem   Appreciated your suggestions to resolve this issue   Many thanks

Problem with connection to sql server : A connection was successfully established with the server, b

Hi all, I am trying to connect sql server using windows authentication . I am getting the fallowing when I try to establish a connection to sql server A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) Can any one tell me how to resolve this problem..

Remote Connection Unavailable

Hello, I am attempting to attach to my new Windows 2008 R2 SQL Server 2005 standard clustered remotely.  The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip.  I have attempted to check the browser configuration but I can't find this. I can attach to the sql server on my cluster but am unable to on a remote machine error is: Cannot connect to clustered name\instance name Addtional info A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is configured to allow remote connections. Ideas? Thx -- Paul Bergson MVP - Directory Services MCITP: Enterprise Administrator MCTS, MCT, MCSE, MCSA, Security+, BS CSci 2008, Vista, 2003, 2000 (Early Achiever), NT4 http://www.pbbergs.com    Twitter @pbbergs Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights.

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

How to Install Remote Debugging for a WPI installation?

I just ran the Web Platform Installer on my Windows 2003 Server and now I want to install remote debugging on it so I can debug some WCF services that are going to be running on it.  I want to debug them from my development PC.  The WPI did not give me the option to install remote debugging, so how do I get remote debugging installed on my server now?  

Connection to SQL Server 2005 Express?

Hi all, I've been reading other posts for awhile now and I can't figure out what I'm doing wrong. I'm a Web Developer and not a DBA. I have SQL Server 2005 Express installed on my machine and it's working just fine. I also have the Management Studio Express CTP installed and working. I'm trying to connect to a database using a username and password (from ColdFusion Server which is working fine for external Oracle and Access databases, so that's not an issue), so I set up the server to allow mixed mode authentication. I can log in to the Management Studio using Windows authentication OR the username and password without any issues. I have TCP/IP enabled in the Configuration Manager and enabled. This seems like a ridiculous question, but I need to know the servername, port, username and password to connect to the database. I'm trying all combinations of things but nothing's working. If I put in as the server, 1433 as the port, and use the username and password that worked in Management Studio I get this: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect If I use MACHINENAME\SQLEXPRESS I get this: java.sql.SQLException: [Macromedia][SQLServer

A connection was successfully established with the server, but then an error occurred during the pre

One of our IIS App pools serving a SharePoint site on one of the  Web Front End  went down suddenly at around 1pm today. Not entirely sure if  it's related yet or how, but we see a bunch of SQL errors from the Web server around that time as follows..    Event Type:         Error Event Source:     Windows SharePoint Services 3 Event Category:                Database Event ID:              5586 Date:                     8/24/2010 Time:                     12:57:21 AM User:                     N/A Computer:          xxxxx Description: Unknown SQL Exception -2146893056 occured. Additional error information from SQL Server is included below.   A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error

Remote Connection to SQL Server 2008

Hi everyone,    I'm allowing remote connections, have started the SQL Server Browser, and have the TCP/IP protocol enabled for my server instance, but I still can't connect to my SQL server remotely.   I have my router forwarding to the local IP for it when using port 1433 and it works when I put the router ip with 1433 locally, but it gives me an error when I try this remotely. It throws a timeout error, so it isn't even reaching it.   Any suggestions?

An established connection was aborted by the software in your host machine

Hello, i am facing problem with socket connection aborted for one of the service. Following is the detailed error,   ORIGINAL EXCEPTION:   An exception of type 'System.ServiceModel.CommunicationObjectAbortedException' occurred and was caught. ------------------------------------------------------------------------------------------------------- 06/25/2010 10:06:20 Type : System.ServiceModel.CommunicationObjectAbortedException, System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : The socket connection was aborted by your local machine. This could be caused by a channel Abort(), or a transmission error from another thread using this socket. Stack Trace :  Server stack trace:     at System.ServiceModel.Channels.SocketConnection.ReadCore(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout, Boolean closing)    at System.ServiceModel.Channels.SocketConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)    at System.ServiceModel.Channels.DelegatingConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)    at System.ServiceModel.Channels.SessionConnectionReader.Receive(TimeSpan timeout)    at System.ServiceModel.Channels.SynchronizedMessageSource.Receive(TimeSpan timeout)    at System.ServiceModel.Channels.FramingDup

SQL Express 2008 R2 Installation problem (getting error in silent installation)

Hi, I create install script that will install my application and also "Microsoft SQL Server Express 2008 R2"  (32 BIT) engine + Advanced tools (without the Management Studio). It been installed successful on Windows XP SP3 but on windows 7 i get an error. The full logs and Setup configuration are in the link files below. I will be grateful for any answer. Thanks, Shai. Log Files:  - **"MySetup.ini" file:**   http://justpaste.it/MySetupini  - **"ConfigurationFile.ini" that been generate by installation:** http://justpaste.it/ConfigurationFileinitxt  - **"Summary.txt file from "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log":**  http://justpaste.it/Summarytxt  - **"Details.txt" file that been created at "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_102314":**  http://justpaste.it/Detailstxt

SQL Express 2008 R2 Installation problem (getting error in silent installation)

Hello, I created install script that will install SQL Server 2008 R2 on windows XP SP3, windows vista and windows 7.  One of the command that i used in the installation is for silent installation of SQL Server 2008 R2. When i install it on windows XP everything works just fine but when i try to install it on Windows 7 i get an error. What am i doing wrong? Here is the command line that i use:  "Setup.exe /ConfigurationFile=Mysetup.ini" Mysetup.ini file: -------------------------------------End of ini file --------------------------------- ;SQL SERVER 2008 R2 Configuration File ;Version 1.0, 5 May 2010 ; [SQLSERVER2008] ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will reflect the instance ID of the SQL Server instance. INSTANCEID="MSSQLSERVER" ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, and Tools. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, Business Intelligence Development Studio, and other shared components. FEATURES=SQLENGINE ; Displays the command line parameter
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