SQL Server 2005 express issue
-
Hallo, we have a pc that has Visual Studio and Sql Server 2005 Express installed on it, lets name it SERVER. We did a small project/application on SERVER with Visual Studio that has to be installed on another pc(client pc, lets name it CLIENTPC) and make some sql queries. The Database is placed on SERVER and the small project/application is placed on CLIENTPC. The application makes some queries from CLIENTPC to SERVER. Our problem is that we get error even from the beginning of the application, when we run it from CLIENTPC on myConnection.Open() method. We have to notice that the CLIENT machine does not have sql server express installed on it, and it seems that we are missing something here. In sql server 2000, installation of MDAC was enough but in server express 2005 there are no MDAC. Any idea what we have to do so client could 'see' and 'work' with SERVER database files? Thanks in advance
-
Hallo, we have a pc that has Visual Studio and Sql Server 2005 Express installed on it, lets name it SERVER. We did a small project/application on SERVER with Visual Studio that has to be installed on another pc(client pc, lets name it CLIENTPC) and make some sql queries. The Database is placed on SERVER and the small project/application is placed on CLIENTPC. The application makes some queries from CLIENTPC to SERVER. Our problem is that we get error even from the beginning of the application, when we run it from CLIENTPC on myConnection.Open() method. We have to notice that the CLIENT machine does not have sql server express installed on it, and it seems that we are missing something here. In sql server 2000, installation of MDAC was enough but in server express 2005 there are no MDAC. Any idea what we have to do so client could 'see' and 'work' with SERVER database files? Thanks in advance
ninkk wrote:
Our problem is that we get error even from the beginning of the application, when we run it from CLIENTPC on myConnection.Open() method.
Can you post this error?
-
ninkk wrote:
Our problem is that we get error even from the beginning of the application, when we run it from CLIENTPC on myConnection.Open() method.
Can you post this error?
Maybe i was not completely clear. The error we get is the regular windows error, the asks if we want to send this error to microsoft. There is no problem with the code we use, because when we run the application on the SERVER machine that has installed SQL SERVER 2005 express and the database files, everything works perfect. Problem occurs when we try to run the application from a CLIENT machine and it connects to the database based on SERVER machine, but in cliet machine(win XP SP2) we do not have installed sql server express or mdac. Do we have to install something or to do something else?
-
Maybe i was not completely clear. The error we get is the regular windows error, the asks if we want to send this error to microsoft. There is no problem with the code we use, because when we run the application on the SERVER machine that has installed SQL SERVER 2005 express and the database files, everything works perfect. Problem occurs when we try to run the application from a CLIENT machine and it connects to the database based on SERVER machine, but in cliet machine(win XP SP2) we do not have installed sql server express or mdac. Do we have to install something or to do something else?
-
1. I connect using myConnection.Open(). Before attempting to connect, myConnection.ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;UID=user;PWD=111;Initial Catalog=MyCatalog;Data Source=SERVERPC\SQLEXPRESS" After this we make myConnection.Open() This works fine only if it runs on SERVER pc that has the sql server express and database files, and when it runs on pc CLIENT that has nothing does not work, we get windows error. 2. After trying this tool, it works fine only while executing from the SERVER pc. When i try it from CLIENT pc, we get this error: "Unable to connect:An error occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure maybe caused by the fact that under the default settings SQL Server does not allow romote connections. )provider: SQL Network Interfaces, erroe: 26 - Error Locationg Server/Instance Specified" To try is we put on SQL Server tab, on Server, "clientpc\sqlexpress" and login name and password. Thanks for helping....
-
1. I connect using myConnection.Open(). Before attempting to connect, myConnection.ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;UID=user;PWD=111;Initial Catalog=MyCatalog;Data Source=SERVERPC\SQLEXPRESS" After this we make myConnection.Open() This works fine only if it runs on SERVER pc that has the sql server express and database files, and when it runs on pc CLIENT that has nothing does not work, we get windows error. 2. After trying this tool, it works fine only while executing from the SERVER pc. When i try it from CLIENT pc, we get this error: "Unable to connect:An error occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure maybe caused by the fact that under the default settings SQL Server does not allow romote connections. )provider: SQL Network Interfaces, erroe: 26 - Error Locationg Server/Instance Specified" To try is we put on SQL Server tab, on Server, "clientpc\sqlexpress" and login name and password. Thanks for helping....
-
1. I connect using myConnection.Open(). Before attempting to connect, myConnection.ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;UID=user;PWD=111;Initial Catalog=MyCatalog;Data Source=SERVERPC\SQLEXPRESS" After this we make myConnection.Open() This works fine only if it runs on SERVER pc that has the sql server express and database files, and when it runs on pc CLIENT that has nothing does not work, we get windows error. 2. After trying this tool, it works fine only while executing from the SERVER pc. When i try it from CLIENT pc, we get this error: "Unable to connect:An error occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure maybe caused by the fact that under the default settings SQL Server does not allow romote connections. )provider: SQL Network Interfaces, erroe: 26 - Error Locationg Server/Instance Specified" To try is we put on SQL Server tab, on Server, "clientpc\sqlexpress" and login name and password. Thanks for helping....
Can you see anything like SQL Server Surface Area Configuration in the Start Menu? I'm not sure if SQL Server Express Edition has this tool. If yes, check if remote connections to your database are allowed (BTW, this is what the error you posted above suggests to check).
-
Can you see anything like SQL Server Surface Area Configuration in the Start Menu? I'm not sure if SQL Server Express Edition has this tool. If yes, check if remote connections to your database are allowed (BTW, this is what the error you posted above suggests to check).
Yes, i found SQL Server Surface Area Configuration. I clicked on Surface Area Configuration for Services and Connection. From there i set the reomote connections to TCP\Ip for both MSSMLBIZ and SQLEXPRESS. But is still the same, cannot connect. I even set the windows firewall to off, but still not connecting.
-
Yes, i found SQL Server Surface Area Configuration. I clicked on Surface Area Configuration for Services and Connection. From there i set the reomote connections to TCP\Ip for both MSSMLBIZ and SQLEXPRESS. But is still the same, cannot connect. I even set the windows firewall to off, but still not connecting.