Board index » delphi » Remote Connection Error
Maggie Clark
 Delphi Developer |
Remote Connection Error2008-02-08 01:57:09 PM delphi143 Hi, I am running some tests regarding SQL Server to see if it is suitable for our clients. I ran some tests on my desk top, connecting and using a database on the local machine and all went well. I tried to run the application from my lap top over to the database on the desk top and I was unsuccessful. The error message I am getting is "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." Desk Top Environment (MAGGIE):- XP Pro Delphi 7 SQL Server Developer Edition 2005 Lap Top Environment (LAPTOP):- XP Home Delphi 7 SQL Server Express 2005 Both machines are in the same workgroup and recognise each other and can view/exchange files. I am using the same connection string that was built on the desk top version of delphi which is :- Provider=SQLOLEDB.1;Password=*******;Persist Security Info=True;User ID=sa;Initial Catalog=MaggieTest;Data Source=MAGGIE\SQLSERV2005DEVED;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MAGGIE;Use Encryption for Data=False;Tag with column collation when possible=False When I try to rebuild the connection string on the lap top (via delphi) I get the same error message when I try to use the drop down that selects a database on the server (Build Tab "connection", item 3). I am not so sure if it is delphi or sql server causing the problem, but from my limited knowledge of sql server the desk top environment is set up so:- Microsoft SQL Server Management Studio Server Properties Security SQL Server & Windows authentication mode Connections Allow remote connections to this server is ticked Permissions using "sa", the system administrator, so hoping this is my highest chance of success any ways! I am persuming that this problem cannot be a problem accessing the database as when I try to rebuild the connection string on the lap top it will not let me even see a list of available databases. SQL Server Configuration Manager SQL Server 2005 Services SQL Server Integration Services *** Running Automatic NT AUTHORITY\NetworkService 1608 SSIS Server SQL Server FullText Search (SQLSERV2005DEVED) *** Running Automatic LocalSystem 3384 Full Text SQL Server Analysis Services (SQLSERV2005DEVED) *** Running Automatic LocalSystem 1276 Analysis Server SQL Server (SQLSERV2005DEVED) *** Running Automatic LocalSystem 3776 SQL Server SQL Server Reporting Services (SQLSERV2005DEVED) *** Stopped Automatic LocalSystem 0 ReportServer SQL Server Agent (SQLSERV2005DEVED) *** Running Automatic LocalSystem 2980 SQL Agent SQL Server Browser *** Running Automatic LocalSystem 2060 SQL Browser ie all services running with the exception of the Reporting Services. SQL Server 2005 Network Configuration Protocols for SQLSERV2005DEVED Shared Memory Enabled Named Pipes Disabled TCP/IP Enabled Keep Alive = 30000 Listern All = Yes No Delay = No IP1 Active = Yes IP1 Enabled = Yes (this is the only thing I changed) IP1 IP Address = 192.168.0.1 (which is the ip address of the desk top) IP1 TCP Dynamic ports = 0 IP1 TCP Port is blank VIA Disabled SQL Server 2005 Surface are Configuration SQLSERV2005DEVED Database Engine Service = running, as already specified Remote Connections Local and Remote Connections Using TCP/IP only Hope this email makes sence, Looking forward to your reply as I am stumped and really need to know how to do this before I can start using SQL Server to any degree Thanks, Maggie |