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 |
|
bazz
Starting Member
26 Posts |
 Posted - 2003-10-17 : 08:46:03
|
| HiI've setup MSDE on my test server at work. I've done everything the same as i did on my laptop (which i can connect to remotely), but i can't connectI have change the LoginMode from 0 to 2 in the registry.Can anyone think of what i'm doing wrong??? |
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-10-17 : 09:02:13
|
I can connect to the MSDE on the local machine in SQL Server Authentication, but not on my development computer with enterprise manager or any other program?? Help me  |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-18 : 03:56:15
|
| Is it running ?What is it telling you ? What error message ?You have to give us something more than emoticons to work with.Damian |
|
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-10-20 : 04:43:54
|
| A connection could not be established to TESTSERVERReason: SQL Server does not exist or access denied.ConnectioOpen(Connect())..Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the TESTSERVER node) and try again.That's it, it takes ages for it to come up with an error.i can get a connection on the server itself but not just remotely.very frustrating. |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-10-20 : 05:10:40
|
Can you ping that machine (just to make sure you can access it over the network)? Are you using SQL Server authentication when you try to connect?Owais
Make it idiot proof and someone will make a better idiot |
|
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-10-20 : 05:45:40
|
| Yeah i can ping the machine and there are no security issue in the networkI have tried windows and sql authentication, from different machines. I just reinstalled it and still doesn't work. |
|
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-10-20 : 06:47:27
|
| found out what was wrongtried to connect to the instancewithosql -S TESTSERVER -U sa -P [pwd] and got the same error.So the MSDE wasn't listening for a connection. even though it was listed on EM on my development computer.So ran SVRNETCN.exe and enabled TCP/IPAnd bob is my UNCLE!!!thanks for your time anyway |
|
|
|
|
|
|
Remote Connection