Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi, I have installed 2 SQL Server versions on my PC, 2000 and 2012, and is now trying to connect my application on the 2000 one. It is necessary in order to support legacy systems still beiung used that uses MSSQL2000 as backend. I used named instance as well as IP/Port address on the connection string but still I cannot connect as the server was not found. Any one of you who can point me to the right direction would be highly appreciated. Thanks in advance :)

for my MSSQL 2012 Server:
Dim cn As SqlConnection = New SqlConnection("Data Source = CMSIMON\MSSCT; Initial Catalog = Northwind; User = sa; Password = August151984")

for my MSSQL 2000 Server:
Dim cn As SqlConnection = New SqlConnection("Data Source = CMSIMON\MSSCT2000; Initial Catalog = Northwind; User = sa; Password = August151984")

2012 works fine, MSSQL 2000 is not.

What I have tried:

I used named instance as well as IP/Port address on the connection string but still I cannot connect as the server was not found.
Posted
Updated 25-Aug-16 20:03pm

 
Share this answer
 
If MS SQL Server couldn't be found, you have to check if the SQL Server is properly installed and configured...

Run MS SSMS (Microsoft SQL Server Management Studio) and check if the instance of MS SQL Server (you're trying to connect) exists. If doesn't exist, you have to properly configure it.
Instance Configuration[^]
Create a New Registered Server (SQL Server Management Studio)[^]
Create or Delete a Server Alias for Use by a Client (SQL Server Configuration Manager)[^]
Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager)[^]
Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)[^]
Create or Delete a Server Alias for Use by a Client (SQL Server Configuration Manager)[^]
Configure a Windows Firewall for Database Engine Access[^]

For further details about connection string, check this: SQL Server connection strings - ConnectionStrings.com[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900