connect from ASP app: connections

Showing posts with label connections. Show all posts

Wednesday, March 7, 2012

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005
|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
YES, Version 4.1
2) Is your device running the supported Windows CE Version?
Yes
3) Are you able to browse files & folders on the device using Windows Explorer?
Yes
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.
Yes, it's listed
Any ideas?
Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

1) Did Active Sync detect the connection and turned green?. And, which

Active Sync version are you using, Is it the latest or the old?

YES, Version 4.1

2) Is your device running the supported Windows CE Version?

Yes

3) Are you able to browse files & folders on the device using Windows Explorer?

Yes

4) Did you do any uninstallations and installations in the mean time?

Check whether the SQL Mobile data provider is listed in .NET Framework

config file machine.config.

Yes, it's listed

Any ideas?

Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

1) Did Active Sync detect the connection and turned green?. And, which

Active Sync version are you using, Is it the latest or the old?

YES, Version 4.1

2) Is your device running the supported Windows CE Version?

Yes

3) Are you able to browse files & folders on the device using Windows Explorer?

Yes

4) Did you do any uninstallations and installations in the mean time?

Check whether the SQL Mobile data provider is listed in .NET Framework

config file machine.config.

Yes, it's listed

Any ideas?

Cant create database. VS 2008. Need help.

Hello,

I just installed VS 2008.

I opened the Server Explorer window and right clicked on Data Connections and selected "Create New SQL Server Database".

Then I selected the Server Name and wrote the database name. I have Windows Authentication selected.

When I click OK I get the error:

"An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provides, error: 40 - Could not open a connection to SQL Server)

Could someone, please, tell me what I am doing wrong?

Thanks,

Miguel

error: 40 - Could not open a connection to SQL Server

It's a connection problem. Are you sure you have typed the correct server name? Also note there could be firewall issues which block your connection. I would suggest you connecting the database server

through mangement studio frist and see if the server is reachable from your machine.

Hope my suggestion helps

Sunday, February 19, 2012

Can't connect to SQL server after hibernating

Hi,
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server
,
such as from Query Analyzer, work fine, but I can not make new connections t
o
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:

>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the serve
r,
>such as from Query Analyzer, work fine, but I can not make new connections
to
>the server. I've tried restarting the server through the SQL Server Servic
e
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the lapto
p
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about
a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:

> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Even
t
>Viewer in Administrative Tools. There's nothing SQL related in there about
a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
>|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:

> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open fo
r
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out o
f
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
>|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adapto
r
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:

> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adapt
or
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:
>

Can't connect to SQL server after hibernating

Hi,
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server,
such as from Query Analyzer, work fine, but I can not make new connections to
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:

>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the server,
>such as from Query Analyzer, work fine, but I can not make new connections to
>the server. I've tried restarting the server through the SQL Server Service
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the laptop
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)
|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:

> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>
|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Event
>Viewer in Administrative Tools. There's nothing SQL related in there about a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:

> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open for
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out of
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adaptor
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:

> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adaptor
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:

Cant connect to SQL Server 2005 Express from VStudio 2005 pro.?

Hello
I can't do subject. It says the SQL Server does not allow remote connections, but in SQL Server surface area conf. it is turned on.
What to do?
CheersGot it to work now. I wrote localhost as with SQL Server 2000, and changed it to .\SQLExpress
Cheers

Wednesday, March 7, 2012

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

Cant create database. VS 2008. Need help.

Sunday, February 19, 2012

Can't connect to SQL server after hibernating

Can't connect to SQL server after hibernating

Cant connect to SQL Server 2005 Express from VStudio 2005 pro.?

connect from ASP app

Blog Archive

About Me