If during installation you have named your server using server-name\instance-name you can also access it by using server-ip-address\instance-name.  You cannot access it by the ip address of the server alone. 

If this...

While SQL Server documentation does not address if UDFs are precompiled and stored, you may notice there is a WITH RECOMPILE option that is available for UDFs. It is...

Luis,

Win98 does not support named pipes. Win2000, XP or Server 2003 are the only Windows operating systems that do. If the problem is the dialup login popping up,...