I am getting an error on SQL Server 2012. Whenever I am trying to connect with with the database, I get this error:
Cannot connect to the database.
ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Serverdoes not exist or access denied.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
The server is localhost and authorization have also done with the correct username and password but still it is the same result, I have also tried the Windows Authorization
Does anyone know any solution for this error?
у меня вот такая проблема когда я хочу добавить в базу DNS то выдает такую ошибку, что у меня не так клиет сервер влючен все работает
—————————
Вход в SQL-сервер Microsoft
—————————
Подключение не выполнено:
SQLState: ‘01000’
Ошибка SQL-сервер: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Подключение не выполнено:
SQLState: ‘08001’
Ошибка SQL-сервер: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL-сервер не существует, или отсутствует доступ.
—————————
Вход в SQL-сервер Microsoft
—————————
Подключение не выполнено:
SQLState: ‘01000’
Ошибка SQL-сервер: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Подключение не выполнено:
SQLState: ‘08001’
Ошибка SQL-сервер: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL-сервер не существует, или отсутствует доступ.
—————————
ОК
—————————
[color=red]
8. Дальше, нажимаем 2 раза на кнопку "OK".
9. Внимание . -> Поставьте Галочку возле "Change the default database to:" и выберите там "MuOnline".
I have a Windows SBS 2003 Server, Service Pack 2, 2gb ram and 200gb disk.
I have installed MS SQL Server 2000 with its latest Service Pack 4 and left in tact its standard "MSSQL Desktop Engine (SBSMonitoriing)" and "MSSSQL Desktop Engine (Sharepoint)" installation that came with SBS 2003 Server install.
I have search the .experts-exchange and found a question ("SQL Server Login error when attempting ODBC connection") my exact error message:
Connection failed:
SQLState: ‘01000’
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Invalid Instance()).
Connection failed:
SQLState: ‘08001’
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Invalid connection.
I have defined an Alias as it recommended but, still no conection.
I have created the ODBC from within the Server and works fine. I can connect to my SQL.
I’ve tried the following at the workstation:
1. Ping ServerName, tested ok
2. Ping server IP address, tested ok
3. In ODBC, in the "Create a New Data Source..", I place the server IP address, and still no connect
4. Tested command-line "Telnet ServerName 1433", and I get a blank screen,
where I type anything and is also blank (dont know what that means, but thats the result)
5. Verified that the server name and the machine name are the same; tested ok
6. Disable all firewall in the server and the workstation, still no connect
7. Disable all antivirus & antispyware, still no connect
8. Uninstalled SQL 2000, rebooted server, deleted all folders related to SQL2000 and reinstall
**************
Moved to MS SQL Server / Database Zones
250 points added
jason1178 Community Advisor
**************