Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
royalhishighness
Starting Member
1 Post |
 Posted - 2014-05-21 : 01:20:58
|
| HI,I am new to vb.net environment and recently I developed a application for my client. I am using sqlexpress 2005 for my back-end and vb.net front-end (VS 2008). I don't want to install SQLEXPRESS on local machine of my client due to data security for that I copied my sql data file (xxxx.mdf) to local folder of application. My application running successfully on my machine but when I am running the same application on client's machine it gives me an error. The error message is A network related or instance-specific error occurred while establishing connection to SQL Server. The Server was not found or was not accessible. Verify that the instance name is correct and SQL Server is configured to allow remote connections. (Provider: SQL Network Interfaces, error 26 - Error Locating Server/Instance Specified).Please help me to resolve this problem.Thanks in advance.With Warm RegardsRajesh Paul |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-05-21 : 08:44:15
|
quote:
Originally posted by royalhishighness
HI,I am new to vb.net environment and recently I developed a application for my client. I am using sqlexpress 2005 for my back-end and vb.net front-end (VS 2008). I don't want to install SQLEXPRESS on local machine of my client due to data security for that I copied my sql data file (xxxx.mdf) to local folder of application. My application running successfully on my machine but when I am running the same application on client's machine it gives me an error. The error message is A network related or instance-specific error occurred while establishing connection to SQL Server. The Server was not found or was not accessible. Verify that the instance name is correct and SQL Server is configured to allow remote connections. (Provider: SQL Network Interfaces, error 26 - Error Locating Server/Instance Specified).Please help me to resolve this problem.Thanks in advance.With Warm RegardsRajesh Paul
You need an instance of SQL Server on the client's local machine, or on a server somewhere where the client machine can access it. The MDF file is only the container of data and to communicate with it and retrieve and deposit data into it, you need something sitting between your vb application and the MDF file. That something is SQL Server. |
 |
|
|
|
|
|
RUNNING VB.NET APPLICATION WITHOUT INSTALLING SQLE