|
|
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...
|
|
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" />
|
|
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.
|
|
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.
|
|
|
Guest |