You will find this article very useful if your planing to install SQL Server 2008 on Windows 2008 server. Once you have installed SQL Server and if you try to log into the server remotely, it will fail. I too have faced this issue recently. Configuration of Windows Firewall comes into action at this time.
http://www.mssqltips.com/tip.asp?tip=1961&ctc
Subscribe to:
Post Comments (Atom)
How to interpret Disk Latency
I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...
-
Do you know there is a new T-SQL command in SQL Server 2008 which facilitates you to insert several rows in single INSERT statement? This is... -
I wanted build an expression to make a folder name dynamically. (Basically expressions are anyway dynamic in nature) So I simply used the ... -
This can happen due to many factors like lack of indexes, out of dates statistics, if it returns a large number of records, etc. I observed...
No comments:
Post a Comment