Question My website project isn't finished yet!
Question My website project isn't finished yet!
I have set up and is operating both an SQL Server and an IIS Server on my laptop. The SQL Server can be seen and accessed via the network using the Server Credentials method. Regarding the IIS, it is not visible over the network. I attempted to ping the IIS IP address from the command prompt, but it timed out and did not connect.
The SQL Server setup is configured as follows:
LAN or Wi-Fi connections? The SQL server is wired, the laptop uses wireless.
IP addresses and subnet masks are in use; you can ping specific IPs. Are they static or DHCP assigned?
Can the laptop access other network devices and display them?
During connection attempts, what error messages appear?
Are there any additional laptops already connected and functioning properly?
Do the router logs or SQL Server logs contain relevant details?
Further troubleshooting is required before proceeding. The ping test is only a preliminary step.
Many questions have been raised, and more clarification may be needed.
Fair enough.
Don’t feel pressured to hurry, especially here.
Pause and reflect on your actions, weighing the outcomes.
Think on your own and consider the broader picture.
Question the results and look for confirmation when you can.
Use common sense and avoid assuming anything is certain.
How is the SQL Server configured? How is the laptop's IIS Server configured?
SQL Server is configured as a 'Database Engine' with mixed mode authentication.
IIS Server is configured with Defaults. Firewall ports are granted for both HTTP and HTTPs.
Wired or wireless LAN connections? SQL server = wired, laptop = wireless? (Laptop using wireless if I understand correctly.)
My officer has granted me permission to bring my personal laptop to office to conduct the office automation development until the ordered machine arrives. I have been given an WiFi account with an username and password configured and dedicated to me. Since I cannot change the firewall rules and has less control in my office Desktop. I decided to proceed installing both SQL server and also IIS in my laptop. Laptop and Desktop (client computer) are both connected to the same network but different modes. My laptop through wifi the rest of the desktops all over the network through LAN.
Can the laptop connect to or otherwise see (and be seen by) other network devices?
Yes. I am able to connect my SQL server over the network through server credentials that is with username and password. Windows authentication mode fails for SQL Server.
When attempting to connect via the laptop what error messags appear?
Laptop connects seamlessly as both events are happening inside the same system i.e my laptop. 'Localhost' lands on the default IIS page.
Anything beyond failed ping attempts?
Browser navigation also fails
Are there any other laptops already thus connected and working?
Not tried before atleast in my department
Do the router's logs or the SQL Server logs provide any related information?
SQL Server works fine and connects like a charm.
Again you must do much more troubleshooting upfront and provide what was done and the applicable results.
The ping test is very basic but is just a starting point.
You need to follow through with more diagnostic efforts and gather more data prior to posting.
I have asked many questions here and there may be other questions as well.
Answer my questions but also think ahead and consider what those other questions might be.
All the necessary ports have been granted to the Firewall on the server system (Laptop). Clients firewall can't be touched as sonicwall firewall is installed and managed by hardware team.
The issue arises because the Windows authentication mode for SQL Server is not functioning properly. Several factors contribute to this: the user has been granted permission to use their personal laptop for office tasks, but firewall settings remain unchanged due to the hardware team managing the sonicwall firewall. Additionally, the user lacks full control over their office desktop and has opted to install both SQL Server and IIS on the laptop. This situation suggests that even with permissions, the laptop may not have all the necessary rights for the installations. It is not recommended to allow personal laptops in the workplace, and resolving this requires coordination among the user, their officer, the client, and the hardware team. To address it, a formal meeting should be arranged to discuss the problem and possible solutions. This process should now be part of your expertise.
What will occur if you switch off the WiFi on your laptop and connect it via Ethernet? First thing in office to try tomorrow! Any Guess in the meantime?
Are you attempting to test this via the office LAN and their configurations? That isn't the proper approach.