myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

How do I know which port the database is running on? Options · View
codequery
Posted: Friday, September 18, 2009 11:06:36 AM
Rank: Newbie
Groups: Member

Joined: 9/18/2009
Posts: 2
Points: 6
Location: UK
Within myLittleAdmin, is there any way to tell which port the database instance is running on? When I telnet to the default port of 1433 I get the following:

telnet xxx.xxx.xxx.xxx 1433
Connecting to xxx.xxx.xxx...Could not open connection to the host, on port 1433: Connect failed

I also get the following error from an asp:Login when trying to connect:

A network-related or instance-specific error occurred 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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

Thanks for any help you can give...
elian
Posted: Friday, September 18, 2009 11:24:27 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
You can specify the port in the config.xml file:
<sqlserver address="server,port" name="SQL 2K8" />
codequery
Posted: Friday, September 18, 2009 11:56:43 AM
Rank: Newbie
Groups: Member

Joined: 9/18/2009
Posts: 2
Points: 6
Location: UK
That would be ok if I had access to that file. I can only use dotNetPanel and myLittleAdmin. Do I have to somehow enable remote connections to the database within myLittleAdmin? I created the database via dotNetPanel and can connect to it from dotNetPanel via myLittleAdmin but just can't seem to connect to it from the production website.
elian
Posted: Friday, September 18, 2009 12:08:57 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
In this case, you must contact your webhoster. He's the one who can configure myLittleAdmin correctly.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.