I am trying to install the ASP.NET WOL web app (http://wol.codeplex.com/
) as referenced in various technet articles. The idea is to make a webpage that will allow users to wake up their computers so they can access them via remote desktop. However, I'm getting tripped up with the SQL aspects.
To create the database using the provided script, I am running the following SQL command.
SqlCmd -S . -E -i c:\inetpub\wwwroot\WakeOnLan\App_Data\Schema.sql
This as I understand it (I don't know much about SQL), should create a new database on SERVER\WakeOnLan and allow for integrated authentication.
The problem is that at the end of the script I get the following error:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
I get the same error if I try to open the named instance via SQL Management Studio. Under server name, the named instance shows up, but it does not show up in my list of registered servers and does not show up in SQL Server Configuration. The script has correctly created a new path in my SQL database folder, but the binn folder is empty.
If you need any further information, please let me know. I'm a complete novice at SQL. Any help is greatly appreciated.
I have attached the Schema.sql file for reference.
Thanks in advance.