One of the issues I realized after the update was the change in network sharing and security features. We kept getting database connectivity errors and some of the client PCs needed the data connection reset using the IP address of the server.
An unrelated question: The sql server seems to use almost 4 GM ram on the server and at times chokes the server. Is that normal behavior or I should worry about a bug or upgrade RAM? Any suggestions??
