We are moving our current programs to a new server. I need to test them before they go live. This particular program is web based using c#. When I use Visual Studio and step through my code everything works like it should. When I publish the program and run it 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...
I am thinking it is a permissions problem but I am not familiar enough to know where to start. Can someone help me with this?
BTW- I looked at the 'Connections' for this sql server and the 'Allow remote connections to this server' is checked.