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 |
|
fan
Starting Member
10 Posts |
 Posted - 2004-06-13 : 21:49:18
|
| Hi,I've come across a connection problem in my office's LAN, i installed a instance of SQL SERVER2000 on my machine called "mysqlserver" for purpose of development, it has been running well for days. suddenly, the sql server service manager couldn't start my server. I checked it, found that the server's name became another machine (for example, WKS18) which is in same LAN, but my machine's server disappeared, though I can still connect to my machine's server.And another problem is about ODBC DSN, i was trying to set up a system dsn on a client machine in same LAN manually, when entering the server's name, it can show me both my machine's name and the other one(i.e. WKS18), here should I add my instance name after a '\' or not? like WKS24\mysqlserver, I suppose instance name should be added because I did same thing on my own machine to set up ODBC, and it's working. However even I added instance name, it can't connect neither, when i test connection, it says client can't connect to server. The machine in LAN has no fixed IP, so mightnot be TCP/IP protocal to setup ODBC, I suppose it might be a problem there is no MADC(?) installed on client machine?could anybody give me a light?Cheers |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-06-13 : 22:38:03
|
| What happens when you try odbc from the same machine.Also try a ping on that machine in your LAN.the way to setup instance seems alright.{servername}\{instance name} |
 |
|
|
fan
Starting Member
10 Posts |
Posted - 2004-06-13 : 23:11:04
|
| Thanks for ur reply. I've set up ODBC successfully via changing client configration. but I still can't understand the first problem |
|
|
|
fan
Starting Member
10 Posts |
Posted - 2004-06-14 : 00:36:29
|
| I've installed a MDAC, then the first problem has been solved |
|
|
|
|
|
|
|
|
Connection problem