Got a new ride this week…a Specialized Roubaix comp, double…sweeeeettt 😀
I can’t register SQL Server in Enterprise manager…I get “Cannot generate SSPI Context” error…
Log onto the domain the SQL Server is in, not the local machine…(after much other troubleshooting was done).
Hey kids, if you are going to change the Service account passwords on your SQL Server 2000 cluster, please use Enterprise Manager 🙂
Oh…and make sure you don’t lock the accounts in AD…that will cause major issues as well.
Did a Time Trial today….came in last at 19 mph, which is my fastest ride all year, including the full-draft group rides…:-)
So a customer asked me yesterday:
“How can I search all my DTS packages in SQL 2000 for certain field/table names? Peoplesoft patches sometimes change these at the schema level.”
Answer: You can’t, using any native SQL Server utility. The best you can do is save the DTS packages as a Visual Basic File (.bas or .txt) and either aggregate them or index them via some other utility.
Alternative Answer: DTS Compare from www.red-gate.com might do it, but I have not tested it.
Interesting issue I’m working on…
Company with SQL Servers all over the world applies MS06-014 and SQL Server 2000 SP4 close together.
Now none of their applications can make a TCP connection. Named Pipes is fine, but the application requires TCP.
Did all the normal stuff like checked the Server Network Utility (SNU), checked the firewalls to ensure the appropriate ports were open, explicity specified tcp in the servername (tcp:servername, port). No go.
Duh moment…check the SQL Server ERRORLOG. Nope…SQL Server was not listening on TCP, even though the SNU had it enabled. No errors in the log, or in the application log…just not listening on that protocol.
Check the value of the tcpport parameter in:
In this instance, it was NULL. SNU was reporting 1433. Apparently SNU caches the port, or if the registry is NULL, it uses a default value to fill in the blank.
So we set the value manually, and all was good.
Check the ERRORLOG earlier in the process, and never trust a GUI.