Monthly Archives: November 2011

Cannot connect to SQL Server from remote machine?

Check each of these… Make sure SQL Server is running on the target machine (SQL Server Configuration) Ensure TCP/IP is enabled (SQL Server Configuration) Ensure “Allow remote connections to this server” is enabled (SSMS server properties) Note default setting:  2005=disabled, … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , , , , | Leave a comment

Reporting Services 2008 R2 running on local machine

If like me you prefer to use Firefox rather than Internet explorer then you might run in to problems when setting up SQL Server Reporting Services on your local machine for development. By default SSRS allows only local administrators to … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , | 1 Comment