While working on SQL (see my previous post…) we of course got locked out…

I found a post that helped! (Thanks Google-fu!)

You can either run this query:

or via GUI, uncheck the box:

sqluser

 

PS: Dear Vendor, if you are selling a product, please know the ins and outs of the product AND the other products that are needed to get everything to work. Thank you.

Source:
http://www.sqldbadiaries.com/2010/07/21/unlock-sql-user-without-changing-the-password/#ixzz2OBIJCsqv

 

I was working with a vendor for some specialty software, they could install the software but were not able to configure SQL… though the software is heavily integrated with SQL.

I have to admit, I am not too familiar with SQL so troubleshooting it, I have to utilize my Google fu…

Error:

“Error: Test connection to the database server has failed because of network problems:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.”

Fix:

1. Login to the server -> Start -> All Programs -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> right click “TCP/IP” and select “Enable”.

2. Start -> Run -> type “services.msc” -> Restart SQL service.

PROTIP:
Also check a service called ‘SQL Server Browser‘ and make sure it is running…