'SQL Server' Tag

• How to open up the Windows firewall for SQL Server 2008 on Windows Server 2008 R2

  November 1, 2009

  After you have installed SQL Server, you might have noticed that the firewall will block access to it. In order to remedy this, you will have to open 2 ports in the firewall. TCP port 1433 for the actual SQL Server engine, and UDP port 1434 for the SQL Server Browser. This could be done [...]

  posted in Blog by InsomniacGeek

• IIs requirements for installing SQL Server 2005/8 on Windows Vista or Windows 7

  January 8, 2009

  In order to install SQL Server 2005 or SQL Server 2008, some IIs features must be installed on Windows Vista. First, install IIs 7 using the following steps: Start Control Panel Programs Programs and Features Turn Windows features on or off Enable <Internet Information services> Select these features: Web management tools: – IIS 6 Management [...]

  posted in Blog by InsomniacGeek

• Cannot insert the value NULL into column ”, table ”; column does not allow nulls. INSERT fails.

  June 10, 2008

  I stumbled upon this error all of a sudden when I was working in a project. There was this SQL Server 2000 database that existed, that very few knew nothing about. This error message confused me a lot, because it didn’t show up when I was running some scripts from the Query Analyzer, but is [...]

  posted in Blog by InsomniacGeek