CODEWITHSUNDEEP
sql-servermsde
Zuno
Zuno

Reputation: 471

Unable to connect to instance

I've installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A using the following switches/parameters in the setup.ini file:

[Options]
SAPWD="sa"
DISABLENETWORKPROTOCOLS=0
DATADIR="C:\Program Files (x86)\SQL Server 2000\"
TARGETDIR="C:\Program Files (x86)\SQL Server 2000\"

When I try to connect to the instance in Management Studio 17, I get the attached error.

I've been bouncing around Google and couldn't find a solution here, I cannot see why it's not working. I have an instance, it's started, so I should be able to connect to it!!

Note that I also have SQL Server 2008 R2 installed and can connect to that instance no problem.

I'm looking to replicate an issue I'm having at work but can't even get SQL Server 2000 to work!

Please do you know what might be the issue?

Unable to connect to SQL Server 2000 MSDE

Upvotes: 0

Views: 155

Answers (1)

marc_s
marc_s

Reputation: 755321

MSSQLSERVER is the instance id for the default, unnamed instance. To connect to it, you should use:

  • .
  • (local)
  • or your machine name, or IP address

but without any instance name - most definitely not with MSSQLSERVER

Upvotes: 0

Related Questions