Can I do register page that hosted in PC-1 and my server and SQL at PC-2and to connect between them? if yes, how?
Printable View
Can I do register page that hosted in PC-1 and my server and SQL at PC-2and to connect between them? if yes, how?
With a PHP register page you could, look around here theres one that you could slightly modify for your purpose.
I mean ASP not PHP...and I want to host all the site in one computer not just register, I want clans too.
In the server field what I need to write instead of XXX\SQLEXPRESS??
Yes, this is possible. Try your ip/SQLEXPRESS or whatever your server is named. Or you can also just try just using your ip, just make sure that you have tcp/ip protocol for SQL manager enabled, and the ports open correctly. You will probably get best results if you use your private/internal ip.
all tcp ports(except dynamic, they set to blank) are 1433, one ip is my WAN and the second is my LAN...My Lan\SQLEXPRESS work but my WAN\SQLEXPRESS doesn't work...What I need to do?
Use lan ip. If your getting problems through WAN it's a configuration problem with the protocols.
but I want to use WAN ip because the website and the SQL server are not on the same PC...help me configure
It sounds like a protocol problem, use the client management utility and look around through the tcp/ip protocol. Try all IP variances in it.
I don't have client management utility..it comes only with the trial version not the express...Quote:
Originally Posted by HappyHardcore
Why did you download the trial version? MsSQL 2005 Express and Manager are both free downloads.
I downloaded the express!!
the express does not contain the client management utility
Thats ok, because you can download the managment utility as a third party extra. For some Reason MS doesn't pre-pack it with MSSQL Express. Do you have the configuration manager Utility?
Yes I have...so?
I have that lol..
^ If you have everything then try the advice.Quote:
Originally Posted by HappyHardcore
lol Okie Dokie...
- Open up the configuration manager.
- Now hit the plus next to Network Configuration
- Click on the Protocols.
- On the right side double click TCP/IP
- Click the IP Addresses Tab
- Under IP1, make it...
Active=yes
Enabled=yes
IP Address=WAN IP
TCP Dynamic Ports=1433
TCP Port=Leave Blank
Leave IP2 Alone.
For IP All
TCP Dynamic Port=1433
TCP Port=Leave Blank
Do not fill in both TCP Dynamic Port and TCP Port with the the port 1433. It will in most cases cause your SQL server not to start, and your SQL Server Browser not to turn on.
While you are At it, in the Configuration Managment Utility, Restart both the SQL Server, and the SQL Browser. Both need to be started.
Now when it comes time to connect to your server from the there remote server, there's different ways you can attempt to connect.
Your WAN IP,1433
or
Your LAN IP,1433
Examples
Another Method would be to add your \SQLINSTANCE name after the IP and port.Code:24.123.456.789,1433
or
192.168.1.78,1433
Your WAN IP,1433\SQLINSTANCENAME
Your LAN IP,1433\SQLINSTANCENAME
Examples
You will also need to make sure the port 1433 is open in your router for the computer that will be running the SQL server.Code:24.123.456.789,1433\SQLEXPRESS
or
192.168.1.78,1433\SQLEXPRESS
It worked!! Thank you HappyHardcore and thank you SiK for helping me...