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 aliasThanks 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\ConnectToIt should look like this:String name: AliasName (can be ServerName\PDBMSDE2000 or however else you want to refer to it)Value: DBMSSOCN,ServerName,PortNumberTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Cannot Connect to SQL instance.