![]() ![]() Simply added the permissions again to the backup destination drive and the issue was resolved. To fix this issue, generate a new license file with the correct hostname and MAC address. When the Quest LiteSpeed job then executed on the preferred node it was clear the previous permissions for SQL server user X had been lost on drive N and SQLSTATE 10100 was reported. System Error: 11001 'WinSock: Host not found (HOSTNOTFOUND)'' Wrong hostname or MAC address in the license file. In my case this was related to permission on drive N following an SQL Server failover on an Active/Passive SQL cluster.Īll SQL resources where failed over to the seconary resouce and back to the preferred node following maintenance. The previous system message is the reason for the failure. (Message 1) LiteSpeed for SQL Server could not open backup file: (N:\BACKUP2\filename.BAK). SQL Agent - Jobs Failed: The SQL Agent Job "LiteSpeed Backup Full" has failed with the message "The job failed. Received SQLSTATE 01000 in the following error message below: In case someone has tried all of these older answers, and is still running into problems like: : SOCKSHTTPConnectionPool(host'myhost', port80): Max retries exceeded with url: /my/path (Caused by NewConnectionError('<.socks.SOCKSConnection object at 0x106812bd0>: Failed to establish a new connection: Errno 8 nodename nor.If shown Database is your database, click Next and then Finish. Select With SQL Server authentication using a login ID and password entered by the user.Īt the bellow enter your login ID and password which you created on first step. In User DSN or System DSN, click Add button and select Sql Server driver and then press Finish.Įnter Server, note that: if you want to enter host computer address, you should enter that`s IP address without "\\". Control panel -> Administrative tools -> Data sources (ODBC). Hope this will be useful for someone else in future. In Remote computer/server, open Data source administrator. Found the solution: Fiddler->WinInet options->Connections tab->click Lan settings button->Check the checkbox for 'use a proxy server for.'->Click OK in subsquent screens. On the right hand, check TCP/IP Protocol be Enabled. On the left hand select client protocols (based on your operating system 32/64 bit). go to All programs -> Microsoft SQL server 2008 -> Configuration Tools -> open Sql server configuration manager. In host computer/server go to Sql server management studio -> open Security Section on left hand -> right click on Login, select New Login and then create a new account for your database which you want to connect to.Ĭheck the TCP/IP Protocol is Enable. To create a new Data source to SQL Server, do the following steps:
0 Comments
Leave a Reply. |