Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 747
  • Last Modified:

can't login to sql server from client workstation

Hi guys

I just installed a new server(windows server 2008) with sql server express 2008 R2, in the server everything works fine, to connect to the server i created an ODBC connection in the server, using windows authentication.
Now i am in a workstation in the same network, but i can't create an odbc connection, when trying to connect to the server i got this error
Connection failed:
SQL State:'01000'
SQl Server Error:67
[Microsoft][ODBC SQL Server Drive][DBNETLIB]ConnectionOpen(Connect())
Connection failed:
SQLState:'08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB][SQL Server does not exist or access denied.

Please advise
0
titorober23
Asked:
titorober23
  • 17
  • 4
  • 2
  • +1
8 Solutions
 
BartVxCommented:
A possbible cause can be that you have set authentication on the server to windows logons only.

Check the security page of the sql server instance properties and verify that authentication is set to ''SQL Server and Windows authentication mode"
0
 
DonovanRojasCommented:
Another thing to check is the Client Protocols you configured (Programs > Microsoft SQL 2008 R2 > Configuration Tools > SQL Server Configuration Manager) and reviewing that the Server Firewall, if there is one, is not blocking whichever port you set on those properties (Default 14336).
It is recommended that you set TCP as Primary (1) connection choice.
0
 
titorober23Author Commented:
I was able to create an ODBC connection in the same server, so I am using the right username.

i dont think i have a server firewall.

when i was creating the ODBC connection in the server, the drop down menu was listing all the servers with the instances, when i tried to do the same from other computers(same network, same domain), the dropdown was showing me all the sql servers with the instances but this one, it only showed the name of the server???
anything related??
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
BartVxCommented:
Is the TCP/IP protocol enabled in the SQL Server Configuration, as mentioned by DonovanRojas?
0
 
titorober23Author Commented:
Could it be that i install a 64 bit server and my workstations are running at 32 bits.

when i access the SQL server configuration manager, under sql server network configuration(32 bits), i didnt see anything, it's empty.

please advise
0
 
BartVxCommented:
Is the SQL Server Browser service running on the server?

Also, you might want to check out this excellent article on Daniel Walzenbach's blog:

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx
0
 
titorober23Author Commented:
0
 
titorober23Author Commented:
SWL Server  network configuration (32 bits) --> does not show anything
what should i do?????
0
 
DonovanRojasCommented:
That one does not matter, you're reviewing the Win32 Protocols for the server, which, in this case do not affect your case since you can connect to the ODBC from within the server.
Please select Protocols for SQLEXPRESS and send the screenshot
0
 
titorober23Author Commented:
I uninstall the 64 bits version and install only 32 bits

this i what i ahve see pic below
0
 
titorober23Author Commented:
0
 
titorober23Author Commented:
still can not connect to the server from another computer using odbc
0
 
titorober23Author Commented:
the workstation that i trying to connect from is runing window7 32 bits
and theserver is a windows server 2008 64 bits, runing sql server
is this maybe causing the problem

the problem is that i can not connect through ODBC connection, i was able to create an odbc ion the same server but now i need to do it in the workstations.
0
 
titorober23Author Commented:
any suggestion
0
 
BartVxCommented:
Maybe we are overlooking the obvious: Is the 'Allow Remote connections to this server' option enabled in the Connections properties page of you SQL Server?
0
 
titorober23Author Commented:
This seems to be correct
SQL2.png
0
 
Ramesh Babu VavillaCommented:
all you need is to start your SQL Server services with a domain user name, there after you can access SQL server in that domain
start-> services.msc-> sql server-> rt click->properties-> log on -This accont->? domain admin,/password , then restart your server,
0
 
titorober23Author Commented:
I have other servers and i never did that before, all of them are working fine
I am not sure why i can not see the instances of this server in the other computers, could it because this server is running a 64 OS

Another question, when login to the server do i have to change Network Protocol to TCP/IP or leave it as default
if i try to change it it does not so anywhere

sql3.png
0
 
titorober23Author Commented:
This is the screnshoot of the sql services runing, i change browser to network, but still cant connect
other servers have browser as local and work fine
sql4.png
0
 
titorober23Author Commented:
How can i verify the ports the server is using???
0
 
titorober23Author Commented:
I was checking the network configuration and saw that all ip did not show a port, i changed all of them to 1433
TCP Dynamic Port --> from 0 to --> blank
TCP IP --> from blank to --> 1433


sql5.png
0
 
titorober23Author Commented:
but nothing, still same issue

what could i do to fix it from one and for all
0
 
titorober23Author Commented:
FINALLY GOT IT TO WORK

THE ISSUE WAS FIREWALL CONFIGURRATION

THANKS ALL
0
 
titorober23Author Commented:
i PLAY WITH IT FOR 3 DAYS, FINALLY GOT IT TO WORK
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 17
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now