Thursday, September 21, 2006

Starting Database Engine in Single User Mode - SQL Server 2005

(a) Start --> SQL Server 2005 --> SQL Server Configuration Manager
(b) Select the Database Engine Service which u want to Start in Single User Mode and press Right Button
© You will have a SQL Server Properties window
(c) select Startup Parameter
(d) press “End” button of your key board
(e) Type ;-m
(f) Restart the Service

Sunday, September 3, 2006

SQL Browser Service in SQL 2005

SQL Server Browser Service in SQL 2005 provides information about the SQL Server 2005 instances installed on a machine. It provides the instance name and version number for each instance of the database engine and analysis server engine installed on a system. Its counter part in SQL Server 2000 is SQL Server Resolution Service which operates on UDP Port 1434 and provides information about the SQL Server 2000 instances on a particular machine. SQL Server Browser service is instance insensitive and it gets installed with the first instance of a machine. When SQL Server Browser Service starts, it accumulate information about Port number, named pipes of all instances installed on the system from windows registry. The it begins to listen network request on UDP port 1434.

It is not necessary to have SQL Server browser running , if it is not running you can still connect to a instance of a system by providing protocol , ServerName/,PortNumber or named pipe directly in the connection string Eg. TCP:ServerName,1456. If you have only one default instance then SQL Server Browser does not have any significance, because default instance always listens to 1433.
 
Locations of visitors to this page