SQL Server does not exist or access denied running an application wich uses DataViews on SQLServer2000.
Running the application on the emulator, It throws the exception: "SQL Server does not exist or access denied."
Running on the device connected on the cradle: "General network error. Check your network documentation."
Running on the device and off the cradle: "Specified SQL server not found:"
This error arises because there is no connection between SQL Server and your device.
Do a
netstat -an and see if the default instance is listenning on port 1433 (TCP).
Potential causes of the error:
- You have sp2 on sqlserver: How does Windows XP SP2 affect SQL Server? R: SQL Server will have access to the local subnet by means of file and print sharing, which will enable access to named pipes, also known as multi-protocol, that use Port 445. TCP/IP and UDP will be turned off by default. Applications that connect to a SQL Server database by means of a network will not be able to accept or make connections. This setting change helps protect the customer system by making it resilient to malicious worms that send port requests to a computer in an attempt to create a denial of service attack.
- Your "server name" property of the Data Store is localhost. In that case change it to the Server Name.
- Check the following article: Potential causes of the "SQL Server does not exist or access denied" error message
Error creating data base: Error loading data store 'C:\Documents and Settings\All Users\Application Data\Microsoft\VisualStudio\devices\7.1\conman_ds'
Compiling Reorganization...
gxexec
"C:\Modelos\ModelYi\Prueba\DATA002\bldReorganization.cs" -r:GxBaseBuilder.dll
-arg:csc="C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\csc.exe" /noconfig
@cf_csc.rsp -arg:mdlpath="C:\Modelos\ModelYi\Prueba\DATA002\"
Building bin\Reorganization.dll
Versión del compilador de Microsoft (R) Visual C# .NET7.10.6001.4 para
Microsoft (R) .NET Framework versión 1.1.4322
(C) Microsoft Microsoft Corporation 2001-2002. Reservados todos los
derechos.
Compilation Successful
Executing Reorganization...
C:\Modelos\ModelYi\Prueba\DATA002\bin\Gxcff5.exe
"C:\Modelos\ModelYi\Prueba\DATA002\bin\reor.inf"
"C:\Modelos\ModelYi\Prueba\DATA002\bin" "reor"
Error loading data store 'C:\Documents and Settings\All Users\Application
Data\Microsoft\VisualStudio\devices\7.1\conman_ds'
Reorganization not completed.
Execution Failed
It is a common error related to the Visual Studio and Emulator languages (the language is hard coded at ConManDataStore.dll as English and your Visual Studio language is other than English) .
Work-Around:
Supposing you have Visual Studio in Spanish (Traditional Sort) which has code id 1034 and emulator in English, it could be resolved copying the folders named with Spanish code id (1034) to English code id (1033).
So, copy all your 1034 folders below (search 1034 folders recursively) C:\Documents and Settings\All Users\Application Data\Microsoft\visualstudio as 1033 and try again. Do the same on folders below C:\Program Files\Microsoft Visual Studio .NET 2003 (again, search folders recursively).
If your Visual Studio installation language is not Spanish (code 1034) you will not find the 1034 folder , instead you will find a "####" folder which represents the number code for your Visual Studio installation languaje. Apply the work-around to that folder.