TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 41 - Cannot open a Shared Memory connection to a remote SQL server) (Microsoft SQL Server, Error: 87)
For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
TITLE: Browse Server for Database
------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
ABove is the error msg. Anybody any suggesstion. I'm newbie in SQL Server. This happen when i follow the tutorial for server registration at Server Management Studio.
'To register the AdventureWorks database'
I had enable all the protocol. I'm using win XP Sp2.
Server Registration
Stefan Hasslinger
You can install 16 separate instances of SQL Express.
Regards,
Mike Wachal
SQL Express team
----
Please mark your thread as Answered when you get your solution.
Marc.
Thank You for reply..actually which part of firewall AV or window firewall..sorry to ask stupid question..
I already turn off the windows firewall and for AV i'm using AVG freeedition and I dont know which setting to disabled the firewall for this AV
After turn off, the error still happen.
rayBristol
I have sql server 2005 installed and when I try to use an asp.net demo that uses sql express I get the following error message:- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
Is there a workaround or do i also need to install sql express
mikirere
Bo Cordell
Hi,
If you already have SQL Server 2k5 installed on your machine, you just have to move or create the demo database on the server (perhaps its already existing). I don’t know which ASP.NET Demo you are using perhpas it is based on the adventureworks database and you already installed that on your machine ! If the ASP.NET demo normally uses the SQLExpress database for connecting and querying data you probably have to change the connectionstring of the application to tell that the database is resided on another instance, rather than the SQLExpress one. So look for a web.config or another .config / XML file of the application, where you can find something like MachineName\SQLExpress or .\SQLExpress. Change this to the name of your machine (if you are using a default instance.
So if the whole connectionstring is written in the configuration file, that should be something like:
"DataSource=MachineName;Initial Catalog=Thenameofthedemodatabase;Integrated Security=True"
More connectionstrings can be found at http://www.connectionstrings.com
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Dave Westhead
AV sounds like (A)nti (V)irus. I ment the Windows firewall.
Are you sure the service is started properly, look in the event log, perhaps there is a problem starting the protocol binding to the instance or any other issues starting the instance.
HTH, Jens Suessmeyer.
---
http://Www.sqlserver2005.de
---
kebo
just to be sure, although the error is stating that it is using named pipes, temporary disable the firewall to make sure that this error is not related to firewall problems. If it not working after disabling the firewall come back here to see if something was not setup properly.
HTH, jens Suessmeyer.
---
http://www.sqlserver2005.de
---
David Vestal
Hi,
If you already have SQL Server 2k5 installed on your machine, you just have to move or create the demo database on the server (perhaps its already existing). I don’t know which ASP.NET Demo you are using perhpas it is based on the adventureworks database and you already installed that on your machine ! If the ASP.NET demo normally uses the SQLExpress database for connecting and querying data you probably have to change the connectionstring of the application to tell that the database is resided on another instance, rather than the SQLExpress one. So look for a web.config or another .config / XML file of the application, where you can find something like MachineName\SQLExpress or .\SQLExpress. Change this to the name of your machine (if you are using a default instance.
So if the whole connectionstring is written in the configuration file, that should be something like:
"DataSource=MachineName;Initial Catalog=Thenameofthedemodatabase;Integrated Security=True"
More connectionstrings can be found at http://www.connectionstrings.com
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Roycepat
Hi,
as you are using SQL Server Express and as of my understanding you can install multiple instances of SQLExpress on the same machine (although I never tried that). For that you just have to run the setup again with specifying the new instance name of SQLExpress.
HTH, Jens Suessmeyer.
---
http://www.sqlsever2005.de
---