Category: SQLServer

SQL Server 2005 Backup Set Database Differs From Existing Database Fix

Categories: SQLServer 2015-10-25 root Comments (0)

I’ve always used SQL Server 2000 before, but now, keeping up with the trends and since the requirements specify using SQL Server 2005, I’m using it in the current project. There are a few things to watch out for with SQL Server 2005. For instance, when restoring a database, it doesn’t clearly separate the database and files like 2000 did …

How to Set a Non-1433 Port for SQL Server 2008

Categories: SQLServer 2015-07-03 root Comments (0)

In SQL Server Configuration Manager, double-click “TCP/IP” and under TCP/IP settings, only configure the TCP port for IPALL at the bottom. Click OK and restart the SQL Server service. Open SQL Server Management Studio, and in the Server name field, enter 127.0.0.1,port number — the port number being the one you just configured …