connect to sql server 2000 on another computer
-
I want to connect to a sqlserver instance on another computer in the workgroup network. ---------------------------------- my application: VS.NET 2008-C# my DB: SQL Server 2000 Personal Edition my OS: Win XP Profesional sp3 ---------------------------------- I have done these steps: 1. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Connections tab -> tick: -allow other sql servers to connect remotely to this sql server using RPC -enforce distributed transactions 2. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> General tab -> Network Configuration... button -> enabling TCP/IP 3. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Security tab -> Authentication -> SQL Server and Windows 4. I created a New Login in target sql server instance: Name=admin , Password=1001 , SQL Server Authentication , Database=Exam 5. my SqlConnection in application: "Server=192.168.0.205\\MYSQLSRV; Initial Catalog=Exam; Integrated Security=False; Persist Security Info=False; User ID=admin;Password=1001"; 6. I removed anti virus softwares and turned off Windows Firewall. 7. I tested both of my computers to ping to another But I have an error yet: an error was occured while establishing a connection to the server. when connecting to sql server 2005, this failure may be caused by the fact under the default settings sql server dose not allow remote connections. (provider:sql network interfaces, error:26-error locating server/instance specified) ---------------------------------- can any one help me ?
H.R
-
I want to connect to a sqlserver instance on another computer in the workgroup network. ---------------------------------- my application: VS.NET 2008-C# my DB: SQL Server 2000 Personal Edition my OS: Win XP Profesional sp3 ---------------------------------- I have done these steps: 1. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Connections tab -> tick: -allow other sql servers to connect remotely to this sql server using RPC -enforce distributed transactions 2. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> General tab -> Network Configuration... button -> enabling TCP/IP 3. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Security tab -> Authentication -> SQL Server and Windows 4. I created a New Login in target sql server instance: Name=admin , Password=1001 , SQL Server Authentication , Database=Exam 5. my SqlConnection in application: "Server=192.168.0.205\\MYSQLSRV; Initial Catalog=Exam; Integrated Security=False; Persist Security Info=False; User ID=admin;Password=1001"; 6. I removed anti virus softwares and turned off Windows Firewall. 7. I tested both of my computers to ping to another But I have an error yet: an error was occured while establishing a connection to the server. when connecting to sql server 2005, this failure may be caused by the fact under the default settings sql server dose not allow remote connections. (provider:sql network interfaces, error:26-error locating server/instance specified) ---------------------------------- can any one help me ?
H.R
H.R wrote:
may be caused by the fact under the default settings sql server dose not allow remote connections
Hopefully, this will help with your problem: How to configure SQL Server 2005 to allow remote connections[^]