Have a workstation1 with MSSQL Server 2008 installed running a piece of software.
There is another workstation2 that connects to the database stored on the WS1. This has been working for months.
Now when WS2 tried to launch the software that connects to the DB on WS1, we get the following SQL error:
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
The firewall on WS1 has been turned off. Ports 1433 have been opened on WS2. I have checked the priority on the SQL Configuration Manager for the protocols and TCP/IP is set higher. Have even tried disabling Named Pipes as well.
Still cannot get WS2 to start the program and connect ot the DB on WS1
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously.
This will be demonstrated using Windows 7 operating…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply.
This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.