Reg:Access DB using SQL Server 2005 Express Edition
-
Hi, I am using SQL Server 2005 Express Edition. It has been installed my system like name as "A". And also i have created a database like name as "MyDB". How can i access database("MyDB") from another system like name as "B". It is in same network. I tried to access through ODBC connection. It returned TCPIP error. I have checked through give IP address for ("B") in my system ("A"). It has connected and opened successful. Thanks in Advance Rameshkumar Thirumalaisamy
-
Hi, I am using SQL Server 2005 Express Edition. It has been installed my system like name as "A". And also i have created a database like name as "MyDB". How can i access database("MyDB") from another system like name as "B". It is in same network. I tried to access through ODBC connection. It returned TCPIP error. I have checked through give IP address for ("B") in my system ("A"). It has connected and opened successful. Thanks in Advance Rameshkumar Thirumalaisamy
SQL Server, as installed, has all remote connections disabled. You must use the configuration tools to enable TCP IP.
-
SQL Server, as installed, has all remote connections disabled. You must use the configuration tools to enable TCP IP.
Hi, Thank you your suggestion. I tried to change configuration manager for enabled TCP/IP. Again the following error returned "[Microsoft][ODBC SQL server Driver][TCP/IP Sockets]SQL server does not exist or access denied" Thanks in Advance Rameshkumar Thirumalaisamy