Recently one of my application website went down. I checked all the basic connectivity troubleshooting and seem everything was looking and working fine. Finally, I found the problem with the browser service but that’s also in running state. Error from the event viewer: The quick solution is rebooting the SQL browser (Start –>All programs–>Microsoft SQL server 200X–>Configuration tools –>SQL server configuration Manager) without rebooting SQL service. I searched and found a couple of MS links (KB-2526552 And SQLBrowser Unable to start) but, I did not apply it. I used another way that is also a permanent fix. Troubleshooting ways and a permanent fix: For me it’s…
-
-
Create and setup a SQL clustering on your Desktop or Laptop
How to create and setup a SQL clustering on your Desktop or Laptop I thought to write this post after I discussed in a forum. SQL clustering is a bit complicated one. I mean most of the DBAs are not configured or tested it, because we don’t get a chance to do or to learn SQL clustering. Also it needs bit knowledge from out of SQL (Windows AD, Network and Storage (SAN)). In this post, I will give you an idea how to configure SQL failover clustering to yourself. We are doing everything in virtual environment (Single machine) the same you can do physically but you need all in…
-
Login failed for [SQLSTATE 28000] (Error 18456) the step failed
Login failed for [SQLSTATE 28000] (Error 18456) the step failed When you query the data from another SQL server (Linked server) and SQL server & agent service is run as a domain user. You may get the error following error message in your job history. Error: Executed as user: Domain\XXX.Service. Login failed for user ‘ SSBF\SQL.Service ‘. [SQLSTATE 28000] (Error 18456). The step failed. Solution: Step 1: Check the source SQL server agent logon service account name All programs –> SQL server 2008 –> Configuration Tools –> SQL server configuration manager. Go to the SQL server agent –> properties –> Check the logon tab and find the account name.…
-
Find the database free space sql server The transaction log for database is full
The transaction log for database is full. To find out why space in the log cannot be reused OR Could not allocate space for object because the filegroup is full Reema: Hello DBA it seems our application not working today. We got some error it looks like some problem with the database. DBA: This error mostly occurs because of insufficient space on the drive. Have you checked the drive space? Reema: Yeah, I have checked the drive space in a server –> my computer. It looks I have plenty of space on the server. DBA: Can you check the database auto growth setting in the database? Reema: I have 30…
-
SQL server failed to start the system cannot find the path specified
Recently one of our SQL server unable to start it. The problem with the storage LUNs. Things you have to do: When you get this above message while starting SQL server service. Check the event viewer both system and application log. There you will know the exact problem. Error: SQL server failed to start the system cannot find the path specified First check the drives and drive letters in my computer. Then verify the SQL server installed drive is available in your server. Go to Start –> All programs –> Microsoft SQL server 2008 –> configuration tools –> SQL server configuration manager –> Right click the…