|
|
Rank: Newbie
Groups: Member
Joined: 11/6/2006
Posts: 4
Points: 0
Location: UK
|
Hi,
I get the following error when connecting:
.Net SqlClient Data Provider
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)
I also use the Web Administrator Tool and this works fine, so not sure why your program should come back with this error?
Regards
Edward
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
In myLittleAdmin, connect using TCP/IP instead of Shared Memory:
While on the Login page, click on the Options button then choose TCP/IP as Network Protocol.
Note you can set TCP/IP as a default value. Please refer to the installation guide for that.
Hope this helps.
|
|
Rank: Newbie
Groups: Member
Joined: 11/6/2006
Posts: 4
Points: 0
Location: UK
|
Hi,
Thanks but I now get the following error:
.Net SqlClient Data Provider
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: 26 - Error Locating Server/Instance Specified)
Regards
Edward
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Could you please give us a short description of your config (IIS version, SQL Server version, IIS and SQL Server on the same machine?, etc...)
Could you please also check that your SQL Server 2005 is accepting Local AND remote connections using the Surface Area Configuration Tool ?
Thanks.
|
|
Rank: Newbie
Groups: Member
Joined: 11/6/2006
Posts: 4
Points: 0
Location: UK
|
Hi,
I am running Windows 2003 Standard with IIS 6.0 and SQL 2005 standard both on the same machine.
Local and Remote connections are enabled in the SQL Surface Area Configuration Tool for both Local and Remote TCP/IP and Named Pipe instances.
Regards
Edward
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Thanks for the info.
Could you please edit config.xml file
and change the node value of myLittleAdmin/connection/debug from false to true.
You will then be able to see the connection string in the error box.
Could you also post the address attribute you are using in the myLittleAdmin/sqlservers/sqlserver node?
Thanks.
|
|
Rank: Newbie
Groups: Member
Joined: 11/6/2006
Posts: 4
Points: 0
Location: UK
|
Hi, OK, fixed it. I changed the server address section from localhost (127.0.0.1) to my servers IP address and also changed the default connection type to TCP/IP. <sqlserver address="***.***.***.***" name="localhost" /> <protocol value="dbmssocn" name="lDefault" localization="true" /> Thanks for your assistance. Regards Edward
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Glad to hear it's working now.
Best regards.
|
|
|
Guest |