I am using Visual Studio 2005 and MSSql-2005 Server. But i also want to add MSSql-2000 Server Database.
Both the servers are running but when i provide the connection string of MSSql-2000 in SqlConnection to access data base, i get an error. It says like MSSql-2005 is not allowing to access.
So, How can i add MSSql-2000 to Visual Studio-2005?
I don't think there should be any problem. Pse post back the actual error you gets. And also , when you have two instances on same machine , you need to mention port number in the connection string. Which is the default instance in this box. and also check SQL Browser is running or not. If firewall is enabled on this machine you should excempt the port which sql server uses from firewall
Madhu
No comments:
Post a Comment