Start Free Trial

asked on

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

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

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??

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

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

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

ASKER

SWL Server network configuration (32 bits) --> does not show anything
what should i do?????

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

I uninstall the 64 bits version and install only 32 bits

this i what i ahve see pic below

ASKER

ASKER

still can not connect to the server from another computer using odbc

ASKER

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.

ASKER

any suggestion

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

This seems to be correct
SQL2.png

SOLUTION

Ramesh Babu Vavilla

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

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

ASKER

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

ASKER

How can i verify the ports the server is using???

ASKER

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

ASKER

but nothing, still same issue

what could i do to fix it from one and for all

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

i PLAY WITH IT FOR 3 DAYS, FINALLY GOT IT TO WORK