A simple way to test database connection

Have you ever been troubleshooting a problem with remote SQL or remote DB connection and want to see if an account could make a remote connection to SQL but didnt want to install the SQL tools? There is a simpel way to test the database connection.

Just go anywhere on your system and create an empty text file named anything but instead of txt make sure the extension is UDL. Then, double-click on the file and up pops a SQL connectivity window to allow testing of remote SQL connections.

Lämna ett svar

E-postadressen publiceras inte. Obligatoriska fält är märkta *

ERROR: Failed to get SID for user (NT Service\MSSQLSERVER)

During the installation of the new System Center Configuration Manager 2012 with Microsoft SQL Server 2012 I got the following error and the installtion couldn´t continue. ERROR: Failed to get

“Error while enabling Windows feature Netfx3. Error Code 2146498298 ” during SQL 2012 installation

During SQL 2012 SP1 installation on a Windows 2012 Server i got the following Error. The installation finished with some error. To fix this, first I need to install .Net

Wsus Post-configuration fails on Windows Server 2012 Sp1 with SQL Server 2012 Sp1

Hi! I got some problem when I tried to install Windows Server Update Services on my Test Windows Server 2012 Sp1 with SQL Server 2012 Sp1 installed. The Role installation