Error connecting from remote computer

[developer155]

I am running asp.net app on my work pc and trying to conenect to sql server running on remote machine. Getting an error that remote machine may not allow remote connections when the application tries to connect to SQL Server 2005. I see that on remote machine SQL server is set to allow remote IP connections. Also the remote machine is not running firewall. What else could be causing this?

thanks

 

[onpnt]

This error could be a few things.

First, does it work locally?
Is the account you are using to connect granted the proper access and or is windows credentials being passed correctly. If you are making a few jumps you have to remember windows will not be retained. Are these machines still on a local network? or is this going over the net? Can you even see the sql box through EM or studio?

What version of sql is this?

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[onpnt]

ignore the version ? I see it in your post

When you say you see if allow remote connections is that in surface config?

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[mrdenny]

You should check out this FAQ faq962-5481.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[developer155]

yep in surface config