Category Archives: SQL Server
Useful Links for Installing SQL Server 2008 R2
I plan on posting a new procedure for creating a slipstreamed install media set, soon. Until then, here are some links regarding installing and patching SQL Server 2008 R2 that I’ve found useful. How to: Install SQL Server 2008 R2 … Continue reading
Helping Users Test Database Connections
From time to time, I have users that will say something like, “The application can’t connect to the database.” Often times they really don’t understand HOW the application’s connection is configured or established. In times like that, I find it … Continue reading
Posted in troubleshooting
Leave a comment
Script to Rename an SQL Server Instance
Let’s just say either: You have SQL Server installed on an VM that you’re going to clone often You moved a SQL Server intance to a new server You renamed the server that SQL Server is running on In any … Continue reading
Posted in Renaming a Server, scripts, SQL Server
Tagged rename, sp_addserver, sp_dropserver, SQL Server, Windows
2 Comments
Finding Which SQL Server Instances Just Restarted
Today, i’m troubleshooting an issue with the cluster where our SharePoint databases are housed. I got an alert from SCOM saying that one of the clustered SQL Server instances had failed. (Thanks SCOM a.k.a. OpsMgr for letting me know!) Anyways, … Continue reading