Sometimes, when I try to access a SQL SERVER, the exception is fired.

"SQL SERVER DOES NOT EXIST OR ACCESS DENIED."

Anybody knows was happen?

Rogério

"Rogerio Jun" <(E-Mail Removed)> wrote in message
news:96ABAAFE-D946-4482-90E2-(E-Mail Removed)...
> Sometimes, when I try to access a SQL SERVER, the exception is fired.
>
> "SQL SERVER DOES NOT EXIST OR ACCESS DENIED."
>
> Anybody knows was happen?
>

Not without more information.

1. Is this message received when accessing Sql Server from your app on the
device?
2. Is your connection string correct? If you're not sure, check
http://www.connectionstrings.com for help.
3. Does the account you are using have appropriate permissions on the Sql
Server?
4. Have you tried using the Sql Server's IP address instead of its host
name?


--
David McNamee
Mobility Architect
developerLabs, Inc
http://www.developerLabs.NET/

1. Is this message received when accessing Sql Server from your app on the
device?
I receive the message when my app try to connect a SQL SERVER

2. Is your connection string correct?
"Server=10.0.0.1;Initial Catalog=PDV; User ID=sa; Password=senha";

3. Does the account you are using have appropriate permissions on the Sql
Server?
Yes. Sometimes, the connect is ok.

4. Have you tried using the Sql Server's IP address instead of its host
name? Yes. IP and hostname.




"David McNamee" wrote:

> "Rogerio Jun" <(E-Mail Removed)> wrote in message
> news:96ABAAFE-D946-4482-90E2-(E-Mail Removed)...
> > Sometimes, when I try to access a SQL SERVER, the exception is fired.
> >
> > "SQL SERVER DOES NOT EXIST OR ACCESS DENIED."
> >
> > Anybody knows was happen?
> >
>
> Not without more information.
>
> 1. Is this message received when accessing Sql Server from your app on the
> device?
> 2. Is your connection string correct? If you're not sure, check
> http://www.connectionstrings.com for help.
> 3. Does the account you are using have appropriate permissions on the Sql
> Server?
> 4. Have you tried using the Sql Server's IP address instead of its host
> name?
>
>
> --
> David McNamee
> Mobility Architect
> developerLabs, Inc
> http://www.developerLabs.NET/
>
>
>

Can you try to ping the server? Or if 10.0.0.1 has the IIS try to browse
into it from device to make sure that you have no problems with
accessing to server. Also make sure that firewall does not restrict
access for this device.

--
Sergey Bogdanov
http://www.sergeybogdanov.com


Rogerio Jun wrote:
> 1. Is this message received when accessing Sql Server from your app on the
> device?
> I receive the message when my app try to connect a SQL SERVER
>
> 2. Is your connection string correct?
> "Server=10.0.0.1;Initial Catalog=PDV; User ID=sa; Password=senha";
>
> 3. Does the account you are using have appropriate permissions on the Sql
> Server?
> Yes. Sometimes, the connect is ok.
>
> 4. Have you tried using the Sql Server's IP address instead of its host
> name? Yes. IP and hostname.
>
>
>
>
> "David McNamee" wrote:
>
>
>>"Rogerio Jun" <(E-Mail Removed)> wrote in message
>>news:96ABAAFE-D946-4482-90E2-(E-Mail Removed)...
>>
>>>Sometimes, when I try to access a SQL SERVER, the exception is fired.
>>>
>>>"SQL SERVER DOES NOT EXIST OR ACCESS DENIED."
>>>
>>>Anybody knows was happen?
>>>
>>
>>Not without more information.
>>
>>1. Is this message received when accessing Sql Server from your app on the
>>device?
>>2. Is your connection string correct? If you're not sure, check
>>http://www.connectionstrings.com for help.
>>3. Does the account you are using have appropriate permissions on the Sql
>>Server?
>>4. Have you tried using the Sql Server's IP address instead of its host
>>name?
>>
>>
>>--
>>David McNamee
>>Mobility Architect
>>developerLabs, Inc
>>http://www.developerLabs.NET/
>>
>>
>>

"Rogerio Jun" <(E-Mail Removed)> wrote in message
news:F402070B-3771-4247-8CB0-(E-Mail Removed)...
>
> 4. Have you tried using the Sql Server's IP address instead of its host
> name? Yes. IP and hostname.
>

Are you able to ping the Sql Server host from the device? You can grab a
ping utility from http://www.cam.com/

-david