Filed under: MS SqlServer | Tags: Remote Connection, Remote Login, SQL Server Connection, SQL Server Remote Login
When i was migrated to SQL Server 2005 from 2000, I faced some technical problems. I could not able to connect the server remotly after installing the default setting. Even i could not connect the SQL server from the Visiual Studio. All the cases the system prompt that the remote connection did not enable or server does not exit. But by default SOL server remote connetion is enable.
I did some special task to resolve the problem that are listed belows,
1. Creating windows firewall exception for SQL server port(Default 1433) and SQlSERV.exe. Before that check your SQL server listening port number from Logfile( “C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\\ERRORLOG”).
2. Surface area Configuration
a. Select Start Menu>SQL Server 2005>Configuration Tools>Surface area Configuration
b. Click Serface area Connection
c. Select Using Both TCP/IP and named piped
d. Apply
3. Network Configuration
a. Select Start Menu>SQL Server 2005>Configuration Tools>Server Configuration Manager
b. Click Nenwork Configuration
c. Select Protocol for SQL Server
d. Enable TCP/IP
Thanks
Khayer
GIS Programmer, CEGIS
Bangladesh
Filed under: MS SqlServer
## Simple Function
CREATE FUNCTION GetName (@SID int)
RETURNS varchar(30) AS
BEGIN
declare @sName varchar(30)
select @sName=SName from tblTest where SID= @sID
return @sName
END
