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 |
|
OldMySQLUser
Constraint Violating Yak Guru
301 Posts |
 Posted - 2008-01-13 : 08:12:17
|
| I have setup a box as a SQL 2005 Express Server. It accepts remote connections and has the users/permissions setup. Both TCP/IP and Named Pipes are enabled.When connecting to the server with MS SQL Server management Studio Express from another machine, on the same network, I have to try and login several times before it connects OK.Can anyone suggest how to increase connection reliability please? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-01-13 : 11:20:17
|
Is there a limit on the number of remote connections? Would there be a high volume of traffic, where a limited number of connections would hinder your access?
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
OldMySQLUser
Constraint Violating Yak Guru
301 Posts |
Posted - 2008-01-13 : 13:02:03
|
quote:
Originally posted by dataguru1971
Is there a limit on the number of remote connections? Would there be a high volume of traffic, where a limited number of connections would hinder your access?
Not at all. The current setup is the server and just me on another machine doing the development work. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-13 : 13:45:03
|
| Which netlib did you use? Tried connect with ip address and port number? |
|
|
|
OldMySQLUser
Constraint Violating Yak Guru
301 Posts |
Posted - 2008-01-14 : 04:27:05
|
quote:
Originally posted by rmiao
Which netlib did you use? Tried connect with ip address and port number?
How do I ascertain which netlib is in use please? |
|
|
|
|
|
|
Unreliable remote connection(s)