Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sync00
Starting Member
24 Posts |
 Posted - 2011-01-18 : 13:06:02
|
| I have SQL Server Express 2005 on a peer to peer network. SQL Server is configured to allow remote connections. I set up the firewall on the host computer to allow SQL to get through. I am unable to connect to SQL Server from another computer on the network. Both computers can ping each other. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 13:27:24
|
| What is the exact error? Connecting with SQL authentication or NT authentication? |
 |
|
|
sync00
Starting Member
24 Posts |
Posted - 2011-01-18 : 13:36:15
|
| Here is a link to the error message.[url]http://timaratz.com/Images/SQL%20Error.GIF[/url]I'm using SQL authentication. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 13:51:46
|
| Make sure you have the correct instance name, and that you're using a valid login. |
|
|
|
sync00
Starting Member
24 Posts |
Posted - 2011-01-18 : 14:56:34
|
| I'm using the correct info.In the ODBC setup there is a dropdown to select the SQL server. When I click that the server is not found. That seems to indicate there is an unresolved technical issue. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 15:55:14
|
| Just type it in. |
|
|
|
sync00
Starting Member
24 Posts |
Posted - 2011-01-18 : 16:53:33
|
| I did type it in before starting this thread. My point is that I don't think it would be necessary to type it in if there wasn't a technical problem. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 20:35:47
|
| Nope. Doesn't indicate a problem just because it wasn't in the drop down.You can start the sql browser service on the host if you wish. |
|
|
|
|
|
|
Can't connect from networked computer