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 |
|
quali74
Starting Member
5 Posts |
 Posted - 2007-05-06 : 14:43:16
|
| HiI am struggling to connect a remote MSDE SQL server using enterprise manager. I create a tunnel to connect the port 1433, and Enterprise manager has regisered the machine. Every time I enter my credentials I get: ConnectionRead(recv())I know my credentials are valid as I can connect the DB locally.I have changed the authenticatioin method and set it to mixed mode using this page: http://www.microforge.net/kb/41any idea? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-05-06 : 19:57:54
|
| the default installation of MSDE disables TCP/IP. look at the readme.html that is included with the MSDE install for details.You can enable TCP/IP by using the server network configuration tool and restarting the MSDE instance.-ec |
 |
|
|
quali74
Starting Member
5 Posts |
Posted - 2007-05-07 : 04:13:10
|
| TCP/IP is enabled but I still get same problem.SQL Query Analyzer display this message:Unable to connect to server 127.0.0.1Server: Msg 11, Level 16, State 1[Microsoft][ODBC SQL Server Driver][DNETLIB]general Network error. check your network documentation.I am wondering why Query analyzer can't connect the server. Enterprise manager seemedto found it. |
|
|
|
quali74
Starting Member
5 Posts |
Posted - 2007-05-07 : 04:30:47
|
| This page seems to summarise the problem: http://support.microsoft.com/kb/867581I checked my registry and I don't have 'MaxTokenSize' parameter. Am I supposed to create it? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-07 : 13:07:07
|
| Ensure sql is listening on correct ip address, check that in sql server log. |
|
|
|
quali74
Starting Member
5 Posts |
Posted - 2007-05-07 : 14:09:10
|
| Well,Looking at the log again, I noticed to my surprise it mentionned another port than 1433. Some of sql server config indicate port 1433 but in some other places it indicates another port making my tunnel not working. I made the necessary changes to my tunnel and now it works a treat! THANKS A LOT GUYS!! AWESOME! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-08 : 10:50:10
|
| MSDE uses dynamic port number by default, may change port number in next restart. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-05-08 : 12:51:27
|
quote:
Originally posted by rmiao
MSDE uses dynamic port number by default, may change port number in next restart.
it will only change port number if something else uses that port at startup. It is pretty rare that this occurs.-ec |
|
|
|
|
|
|
connect instance of MSDE