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 |
RoryBecker
Starting Member
3 Posts |
Posted - 2009-02-10 : 09:44:31
|
I am having difficulty connecting to a named instance of MSDE2000sp3a inside a VPC VM.
The Client is XP. The Server is XP.
I CAN connect to the Instance on from within the VM. The VM Firewall is switched off. I can copy files in either direction between the 2 machines. The VM also has a Default instance of SQLExpress on it which is initially locked down. I enable TCP and Named Pipes and restart SQL.
Neither MSDE or SQL2k5 is accessible.
I use ServerName\SQLExpress or ServerName\PDBMSDE2000 to try to access either of these using SQL authentication. Local connections work ... Network connections do not...
Again.... no Firewall..
Any ideas?
-- Rory Becker |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
RoryBecker
Starting Member
3 Posts |
Posted - 2009-02-11 : 10:09:32
|
Fantastic... Having gone through the linked information I have discovered that my turning off the firewall apparently did not take the first time.... It is definitly off now and I can connect to either server using the "Servername, portnumber" syntax.
However I still cannot... ...connect to the MSDE server via it's name "ServerName\PDBMSDE2000". ...create an alias to access this server via tcp which actually works.
For the first, I assume I have screwed up something to do with named pipes. The listed named pipe default for this server is "\\.\pipe\MSSQL$PDBMSDE2000\sql\query".
For the tcp/Alias issue, I am clueless as manually entering in the "Servername, port" works fine... Just not through an alias
Thanks very much for you help... I have already learned a great deal from your links. I wonder if you have any ideas to combat these last couple of issues.
Thanks very much.
-- Rory Becker |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-02-11 : 14:25:47
|
I don't ever use named pipes to connect. Let's get TCP/IP working.
Show me what you have for the reg string and value associated with the alias, located here: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
It should look like this:
String name: AliasName (can be ServerName\PDBMSDE2000 or however else you want to refer to it) Value: DBMSSOCN,ServerName,PortNumber
Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/
Subscribe to my blog |
 |
|
|
|
|