| Author |
Topic |
|
spinoza
Starting Member
49 Posts |
 Posted - 2006-04-03 : 12:04:51
|
| Hi all,I am trying to connect my sql through a wireless network with no success. I can ping the sql server from my laptop pc(windows xp home while the server uses windows professional)but i cannot connect it...I went to client network utility where i set up the port 1433 and the ip address for the server...I went to enterprise manager to register but nothing...I was trying to connect through sql analyser but again nothing...I have disable any firewall from the server and the client(router etc)I am stucked...please someone to help??? |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-03 : 12:21:02
|
| Spinoza, Is ur SQL server in the same network (to which wireless connection is made)?Can u see the SQL server machine in ur Network Places?Srinika |
 |
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-04-03 : 12:50:51
|
| Srinika,Thank you for your immediate response...I can see the computer(server) name in the network places... i cant see the SQL server machine in my Network places...only the name of the server....i thought that If i could see the server pc i could see the sql server as well... but from your question i assume that i have to see the SQL server as well...if this is true how can i do that??? could you help me??? |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-03 : 14:10:26
|
| What do u mean by computer(server) name &SQL server machine Aren't those same?Srinika |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-04-03 : 15:46:30
|
| sorry for misunderstanding...its the same... I have installed the sql server in a desktop pc called CHR.I can see the files of the desktop pc (which is my server) but i cannot connect to my sql server which is installed in the same desktop.As i said before its a wireless connection...with no firewall...I have downloaded a software program which i have installed in my client trying to fingure out if my client can ping the SQL server...it works...it finds the sql server...but i dont know why I cant when i am trying to register the server or to log in through the Analyser... :(One more question... In the server I use windows authentication...what exactly does that mean??? That in the client i have to use the username and the password that i use in the server when i log in??? (i have already applied it with no result but I am asking just to confirm) |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-03 : 16:36:44
|
| Check books onLine for different Authentications (Windows & Mixed mode)these r some hints:-- Create a user in both machines (eg A windows login) and add that to the users list in SQL server and keep the Windows Auth-- Try changing windows auth to mixed authSrinika |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-04-04 : 02:56:11
|
| well nothing yet...the error messsage i got is unable to connect to server CHRserver message 17, level 16,state 1[Microsoft] [ODBC SQL SERVER DRIVER][TCP/IP SOCKETS]The SQL server does not exist or does not allow the pernissionsomeone to help...i would much appriciated it.Thank you |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-04 : 03:08:27
|
| Just a hints.. Instead of giving server name just give Ip Address and try to login.. and also try to login to the server from some other client pcs which are connected via LAN.. if they are able to connect then i guess there is some problem with the wireless settings..If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-04-04 : 03:19:43
|
| I have also notice that the system does not allow me to create an odbc connection...same error message...Chir..., unforunately there are only 2 pc on this network so i cannot test it :( |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-04-04 : 03:36:08
|
| There can be many issues that can cause this error. The first thing to check is to see if your SQL Server is actually listening on a TCP Port. The server network utility will show you which protocols SQL Server is listening on.ALso, What edition of SQL Server/Service Pack have you installed? What OS and Service Pack are you running? -ec |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-04-04 : 05:05:31
|
| well i think i made a stepIve manage to see through the query analyser my client from my server but not vice versa...when i am trying to connect through my client to server ive got the following error"login fail for user CHR\guest"notice that in the username i type sa not guest.... where does that find??? how can i overcome this? |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-04-04 : 07:26:05
|
| Well thank you all very much..after 3 days of searching Ive managed to make it work.... the problem was in the permissions... I went to "logins" and set the right pemissions...working like a charm now...thank you again |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-04 : 07:28:13
|
Congrates  If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
|
Need desperately your help