hi Scott,
I have enabled TCP/IP connection in MSSQL. I also added 1433 port to my
firewall. I have installed MSSQL in sa mode, with a password(I guess its
called SQL Authentication mode??). Should i reinstall it with default
options??
Prajwal
Scott Golightly wrote:
Prajwal,
You may need to enable TCP/IP on the SQL Server. This is based on SQL
Server 2008 Express running on Windows Server 2008 but from what I
remember of XP the steps are the same.
To enable TCP/IP from the start menu go to start -> All Programs ->
Microsoft SQL Server 2008 -> SQL Server Configuration Manger.
In the left pane choose SQL Server Network Configuration -> Protocols
for <SQL Server Instance Name>. By default Shared Memory is the only
protocol enabled. Right click on TCP/IP in the right pane and choose
enable.
You will have to restart your SQL Server (You can do this by selecting
SQL Server Services in the left hand panel and right click on the SQL
server instance then choose restart from the menu).
Scott Golightly
