SQL Login error from client computer

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Login error from client computer

SQL Login error from client computer

Rate Topic

Display Mode

Topic Options

Author

Message

shreyanshbhatt

Posted Thursday, January 31, 2013 2:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 5:31 AM
Points: 5, Visits: 32

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I can not connect to the SQL from the Other PC which is on the same network (non-domain environment). I will explain the old setup and new setup.
OLD Setup
Main PC was XP Pro which was hosting Sql server and the custom made application which had the database. NOW the other computer on the network with Vista Business was accessing that program without any problem.

NEW Setup
NOW the XP PC died. So we replaced with new Windows7 Pro(32bit) PC.
The Main program which uses the SQL on the main pc is working fine and all the sql services are running.
The folder of the program been shared and the other PC can see it and access it.
SQL browser, SQL server program has been allowed in exceptions.
TCP protocol is enabled, Remote Connections is enabled in Database Properties.
TCP port: 1433 and UDP port: 1434 is allowed in the exceptions.

Troubleshooting done.
From the other PC when I telnet port 1433 then it was not connecting. And so I found out that the SQL hosting pc was giving random port. So I have given default port 1433 in the SQL. And after that I am able to telnet pcname 1433.
BUT I can not telnet pcname 1434. It keeps denying.

What else I can check to troubleshoot that why UDP port 1434 is not accepting the connection.
I was reading some article allowing port number in the string. But how can I do that if i got the string like Target path "\\pcname\programfolder\filename.exe \\pcname\programfolder\filename.udl". Start In "\\pcname\programfolder\filename.exe"

Could it be the router. But the whole setup has been working fine before with XP Pro as the main pc.

any help will be appreciated

thanks

Post #1413921

opc.three

Posted Thursday, January 31, 2013 5:27 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724, Visits: 11,771

I have not found telnet to be all that reliable since some firewalls will block it. PortQry is what I use for things like this. It will allow you to test 1433 TCP and 1434 UDP from wherever you need to.

http://www.microsoft.com/en-us/download/details.aspx?id=17148

PortQry.exe -n localhost -p udp -e 1434

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414017

shreyanshbhatt

Posted Thursday, January 31, 2013 10:49 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 5:31 AM
Points: 5, Visits: 32

thanks opc.three
it was quite helpful in getting to the bottom of the problem. I found out that the UDP port is opened but its getting filtered. So sql browser is not listening it.
So got to find out why?

Post #1414445

opc.three

Posted Friday, February 01, 2013 6:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724, Visits: 11,771

What do you mean by filtered? SQL Browser listens on UDP 1434 if the service is enabled. Is the service enabled and set to auto-start when the machine starts?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414621

shreyanshbhatt

Posted Saturday, February 02, 2013 3:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 5:31 AM
Points: 5, Visits: 32

The SQL browser service is running and enabled.

C:\PortQryV2>portqry.exe -n mainpc -p udp -e 1434

Querying target system called:

mainpc

Attempting to resolve name to IP address...

Name resolved to 192.168.200.25

querying...

UDP port 1434 (ms-sql-m service): LISTENING or FILTERED

Sending SQL Server query to UDP port 1434...

UDP port 1434 (ms-sql-m service): FILTERED

--- The above is the output I get when execute from the client pc and the above IP address is where the SQL is runninng.

Post #1414932

opc.three

Posted Sunday, February 03, 2013 9:49 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724, Visits: 11,771

Filtered means no response was received. Just to confirm, did you run the command on mainpc or from a different machine, i.e. the remote client? Make sure there are no firewalls in between the remote client and mainpc that might interefere with network traffic. Also try running the portqry command on mainpc itself as a baseline to ensure the Broswer service is running, listening and responding as expected.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1415099

shreyanshbhatt

Posted Tuesday, February 05, 2013 1:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 5:31 AM
Points: 5, Visits: 32

I ran that on the Remote PC. But after your comment when I ran it on the main PC I am getting same result FILTERED.
Is it something to do with the Browser Service?
I have checked the SQL Browser service and its running and in Automatic Mode. I have stopped the Windows Firewall and also Anti-Virus. But same result.
So I should get LISTENING from the portquery output which I am not - is that right?

I think we are not too far at root cause of the problem. your prompt reply is highly appreciated.

Post #1415631

opc.three

Posted Tuesday, February 05, 2013 5:18 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724, Visits: 11,771

shreyanshbhatt (2/5/2013)

Yes, you ought to see LISTENING.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1415759

shreyanshbhatt

Posted Tuesday, February 05, 2013 5:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 5:31 AM
Points: 5, Visits: 32

Hi opc.three,

thanks for your help. And the problem is resolved. And we had to get the connection string changed to the UDL file.

thanks,
Shree

Post #1415763

opc.three

Posted Tuesday, February 05, 2013 5:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724, Visits: 11,771

Just a heads up, I just noticed you're using DBNETLIB which is a deprecated driver in SQL 2008 and to my knowledge is no longer supported being supported in SQL 2012.

What did you have to change in your connection string?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1415775

« Prev Topic | Next Topic »

Permissions