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 |
|
oddjones
Starting Member
11 Posts |
 Posted - 2003-02-11 : 04:49:04
|
| HI. I have a SQL2000 SP2 install (MDAC 6.2.1 - which is required by the Content Management System which uses the database). I can register the server in Enterprise Manager (using the sa user/pwd) running on any machine other than the local host, where whenever I try to register the server (either as [local] or by the machine netbios name)I get "A connection could not be established to DB*****" - "Reason: SQL Server does not exist or access denied." I'm sure that this is a permissions issue, as I can register the server successfully if I choose "prompt for password" during the registration process (although I can't subsequently actually GET IN to the server by entering the password of course)____________________________________________"Simplicity is the ultimate sophistication." Leonardo da Vinci |
|
|
Argyle
Yak Posting Veteran
53 Posts |
Posted - 2003-02-11 : 12:16:05
|
| Seems to be a problem with Named Pipes on the server. Run cliconfg.exe and change the default network library to TCP/IP and see if it helps./Argyle |
 |
|
|
oddjones
Starting Member
11 Posts |
Posted - 2003-02-11 : 12:47:30
|
| Thanks Argyle - tried that and I get a new error message : "DB***** - Encryption not supported on SQL Server | Connection Open(preloginHandshake)"(Which is the same error message I got when I attempted to connect using the IP address rather than the netbios name)____________________________________________"Simplicity is the ultimate sophistication." Leonardo da Vinci |
|
|
|
oddjones
Starting Member
11 Posts |
Posted - 2003-02-12 : 07:00:53
|
| You may be interested in the fix we found for this: (so simple when you know how) - The SQL Client was set to "Force Encryption" - uncheck the box and you're in.____________________________________________"Simplicity is the ultimate sophistication." Leonardo da Vinci |
|
|
|
|
|
|
EM Can't Register [local] database,