HELP CANT CONNECT TO SQL SERVER ON WIN XP PRO

I am having connection issues with SQL 2k on my win XP pro box. I had no problems last week but now I cant do anything.
I read many kb articles about problems with SP 2 and SQL 2k and nothing seems to help. Has anyone had any similiar problems? I need to access my remote sql server for a client and I have been dealing with this problem for the last week with no solution? I believe I have opened up every possible port the SQL will use. I followed all of the kb articles and still nothing.
Thanks

Can you give us more detail on the "connection issues"? Are youreceiving any error messages? If so, these will go a long waytowards helping you to resolve the problem.
|||

Sure, in enterprise manager when I click on one of my server nodes it try to connect to the site.

The error I get is
A connection could not be established to xyz server
Reason: SQL Server does not exist or access denied
ConnectionOpen (Connect()...)
I was able to connect to this server last week with no issues. I have tired 5 different servers and I cant connect to any of them. I am running windows xp pro service pack 2 and sql 2k.

|||One thing you could do is to check the logs under Data folder.

Help about running SQL CE on Win CE 4.2

Hi everybody,

I developed mobile programs for WM5.0 with C#.NET using SQL Mobile. (Visual Studio 2005, SQL Server 2005 Mobile, Mobile SDK)

But I couldn't run SQL CE on WinCE 4.2 ? (Visual Studio 2003, SQL Server 2000 CE). For example on emulator, an Insert command is running successfully. But on device (Intermec CK 31) we are getting error.

Here is my code :

using System;

using System.Data;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data.SqlServerCe;

namespace UmurBS.Forms.BasimSayimForms

{

publicclass bsEkleForm : System.Windows.Forms.Form

{

private System.Windows.Forms.DataGrid dg;

private System.Windows.Forms.Button button1;

private System.Data.SqlServerCe.SqlCeConnection sqlceconn;

privatestring connstr = "DATA SOURCE = UmurDB.sdf";

public bsEkleForm()

{

InitializeComponent();

}

protectedoverridevoid Dispose( bool disposing )

{

base.Dispose( disposing );

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

privatevoid InitializeComponent()

{

this.button1 = new System.Windows.Forms.Button();

this.dg = new System.Windows.Forms.DataGrid();

//

// button1

//

this.button1.Location = new System.Drawing.Point(160, 264);

this.button1.Text = "button1";

this.button1.Click += new System.EventHandler(this.button1_Click);

//

// dg

//

this.dg.Location = new System.Drawing.Point(8, 8);

this.dg.Size = new System.Drawing.Size(224, 200);

this.dg.Text = "dg";

//

// bsEkleForm

//

this.ClientSize = new System.Drawing.Size(237, 291);

this.Controls.Add(this.dg);

this.Controls.Add(this.button1);

this.Text = "bsEkleForm";

}

#endregion

privatevoid button1_Click(object sender, System.EventArgs e)

{

sqlceconn = new System.Data.SqlServerCe.SqlCeConnection(connstr);

this.ekle();

}

privatevoid ekle()

{

try

{

SqlCeCommand cmd = new SqlCeCommand("insert into test (testValue) values ('hi world')", sqlceconn);

sqlceconn.Open();

int rowsaffected = cmd.ExecuteNonQuery();

}

catch(Exception exc)

{

MessageBox.Show(exc.Message);

}

finally

{

if (sqlceconn != null)

if (sqlceconn.State == ConnectionState.Open)

sqlceconn.Close();

}

}

}

}

Any idea ?

Regards

Serkan

In order to run SQL Mobile on WinCE 4.2 devices, you will have to request the following hotfix from Microsoft: http://support.microsoft.com/default.aspx/kb/924811

Hope this assists.

|||

Hi Erik

Actually I don't understand what must I do? Which files I must download? I have an Intermec CK 31 mobile device.

When I install CF 2.0 SP1 on it, I getting "not compatible" error. But completing install. But application does not run. :(

Thanks for any help , suggesstions.

Regards

Serkan

|||Which processsor architecture is your Intermec device based on - you must load the corresponding cabs for both .NET CF and SQL CE.|||

Hi Erik,

Processor is Intel XScale PXA255, 400 MHz . I think Architecture is ARM4.

|||

You need to call Microsoft support for the hotfix, for your Intermec device, you need to request the following files:

For ARMV4i-based devices

File name File version File size Date TimeSqlce30.dev.enu.wce4.armv4i.cabNot Applicable302,36802-Apr-200615:14Sqlce30.repl.wce4.armv4i.cabNot Applicable727,81902-Apr-200615:14Sqlce30.wce4.armv4i.cabNot Applicable1,586,50102-Apr-200615:14

as the only cab files made available for Windows CE 4.2 are for PocketPC devices, not general Windows CE 4.2 Devices.

ie: sqlce30.ppc.wce4.armv4.CAB, sqlce30.repl.ppc.wce4.armv4.CAB, sqlce30.dev.ENU.ppc.wce4.armv4.CAB

You may need to have a look at this as well: http://support.microsoft.com/kb/914829/

Help about running SQL CE on Win CE 4.2

Hi everybody,

I developed mobile programs for WM5.0 with C#.NET using SQL Mobile. (Visual Studio 2005, SQL Server 2005 Mobile, Mobile SDK)

But I couldn't run SQL CE on WinCE 4.2 ? (Visual Studio 2003, SQL Server 2000 CE). For example on emulator, an Insert command is running successfully. But on device (Intermec CK 31) we are getting error.

Here is my code :

using System;

using System.Data;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data.SqlServerCe;

namespace UmurBS.Forms.BasimSayimForms

{

public class bsEkleForm : System.Windows.Forms.Form

{

private System.Windows.Forms.DataGrid dg;

private System.Windows.Forms.Button button1;

private System.Data.SqlServerCe.SqlCeConnection sqlceconn;

private string connstr = "DATA SOURCE = UmurDB.sdf";

public bsEkleForm()

{

InitializeComponent();

}

protected override void Dispose( bool disposing )

{

base.Dispose( disposing );

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.button1 = new System.Windows.Forms.Button();

this.dg = new System.Windows.Forms.DataGrid();

//

// button1

//

this.button1.Location = new System.Drawing.Point(160, 264);

this.button1.Text = "button1";

this.button1.Click += new System.EventHandler(this.button1_Click);

//

// dg

//

this.dg.Location = new System.Drawing.Point(8, 8);

this.dg.Size = new System.Drawing.Size(224, 200);

this.dg.Text = "dg";

//

// bsEkleForm

//

this.ClientSize = new System.Drawing.Size(237, 291);

this.Controls.Add(this.dg);

this.Controls.Add(this.button1);

this.Text = "bsEkleForm";

}

#endregion

private void button1_Click(object sender, System.EventArgs e)

{

sqlceconn = new System.Data.SqlServerCe.SqlCeConnection(connstr);

this.ekle();

}

private void ekle()

{

try

{

SqlCeCommand cmd = new SqlCeCommand("insert into test (testValue) values ('hi world')", sqlceconn);

sqlceconn.Open();

int rowsaffected = cmd.ExecuteNonQuery();

}

catch(Exception exc)

{

MessageBox.Show(exc.Message);

}

finally

{

if (sqlceconn != null)

if (sqlceconn.State == ConnectionState.Open)

sqlceconn.Close();

}

}

}

}

Any idea ?

Regards

Serkan

In order to run SQL Mobile on WinCE 4.2 devices, you will have to request the following hotfix from Microsoft: http://support.microsoft.com/default.aspx/kb/924811

Hope this assists.

|||

Hi Erik

Actually I don't understand what must I do? Which files I must download? I have an Intermec CK 31 mobile device.

When I install CF 2.0 SP1 on it, I getting "not compatible" error. But completing install. But application does not run. :(

Thanks for any help , suggesstions.

Regards

Serkan

|||Which processsor architecture is your Intermec device based on - you must load the corresponding cabs for both .NET CF and SQL CE.|||

Hi Erik,

Processor is Intel XScale PXA255, 400 MHz . I think Architecture is ARM4.

|||

You need to call Microsoft support for the hotfix, for your Intermec device, you need to request the following files:

For ARMV4i-based devices

File name

File version

File size

Date

Time

Sqlce30.dev.enu.wce4.armv4i.cab

Not Applicable

302,368

02-Apr-2006

15:14

Sqlce30.repl.wce4.armv4i.cab

Not Applicable

727,819

02-Apr-2006

15:14

Sqlce30.wce4.armv4i.cab

Not Applicable

1,586,501

02-Apr-2006

15:14

as the only cab files made available for Windows CE 4.2 are for PocketPC devices, not general Windows CE 4.2 Devices.

ie: sqlce30.ppc.wce4.armv4.CAB, sqlce30.repl.ppc.wce4.armv4.CAB, sqlce30.dev.ENU.ppc.wce4.armv4.CAB

You may need to have a look at this as well: http://support.microsoft.com/kb/914829/

Help - Sql Server 2005 at a crawl on Win 2000 Server

Hello -
I know nothing about running servers, however, I am in a position where I
not only programmed the app, programmed Sql Server 2005 for the app and but
now had to install Sql Server 2005 on a box that was given to me - Pentium I
V
with 40 gigs of storage and 512 MB RAM. I thought the machine would be
sufficient, however, it has been running (with no users using the app yet)
for three days and it's at a crawl. The OS is Windows 2000 Server.
Any suggestions as to what may a likely problem? (Looks like some kind of
memory leak to me.) I know more specifics are probably needed, but I don't
know what specifics to provide.
Any help will be greatly appreciated! These people expect this app to be up
and running by Thursday morning!!!!
--
SandySandy
http://www.microsoft.com/sql/prodin...qs/default.mspx
"Sandy" <Sandy@.discussions.microsoft.com> wrote in message
news:AA02BFDD-1790-4A30-BA64-DE8937B5172A@.microsoft.com...
> Hello -
> I know nothing about running servers, however, I am in a position where I
> not only programmed the app, programmed Sql Server 2005 for the app and
> but
> now had to install Sql Server 2005 on a box that was given to me - Pentium
> IV
> with 40 gigs of storage and 512 MB RAM. I thought the machine would be
> sufficient, however, it has been running (with no users using the app yet)
> for three days and it's at a crawl. The OS is Windows 2000 Server.
> Any suggestions as to what may a likely problem? (Looks like some kind of
> memory leak to me.) I know more specifics are probably needed, but I
> don't
> know what specifics to provide.
> Any help will be greatly appreciated! These people expect this app to be
> up
> and running by Thursday morning!!!!
> --
> Sandy|||Apart from what Uri has recommended - particuarly the bit about 1GB memory
recommended, there are a number of measurements you could take focusing
around CPU,RAM,Hard Disk . I haven't included Network as it sounds like
there are no users, which is the main cause for network bottlenecks.
Quick tests are: Pages/Sec memory, percentage disk time, average disk queue
length , buffer cache hit ratio .
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Sandy" <Sandy@.discussions.microsoft.com> wrote in message
news:AA02BFDD-1790-4A30-BA64-DE8937B5172A@.microsoft.com...
> Hello -
> I know nothing about running servers, however, I am in a position where I
> not only programmed the app, programmed Sql Server 2005 for the app and
but
> now had to install Sql Server 2005 on a box that was given to me - Pentium
IV
> with 40 gigs of storage and 512 MB RAM. I thought the machine would be
> sufficient, however, it has been running (with no users using the app yet)
> for three days and it's at a crawl. The OS is Windows 2000 Server.
> Any suggestions as to what may a likely problem? (Looks like some kind of
> memory leak to me.) I know more specifics are probably needed, but I
don't
> know what specifics to provide.
> Any help will be greatly appreciated! These people expect this app to be
up
> and running by Thursday morning!!!!
> --
> Sandy|||Hi Jack and Uri -
Thank you very much for your responses.
One further question: I looked through the System properties and noticed
that under Performance Options (System Properties -> Advanced -> Performance
Options - Optimize Performance), "Background" is checked. Should
"Applications" be checked there instead?
Again, any help will be greatly appreciated!
--
Sandy
"Sandy" wrote:

> Hello -
> I know nothing about running servers, however, I am in a position where I
> not only programmed the app, programmed Sql Server 2005 for the app and bu
t
> now had to install Sql Server 2005 on a box that was given to me - Pentium
IV
> with 40 gigs of storage and 512 MB RAM. I thought the machine would be
> sufficient, however, it has been running (with no users using the app yet)
> for three days and it's at a crawl. The OS is Windows 2000 Server.
> Any suggestions as to what may a likely problem? (Looks like some kind of
> memory leak to me.) I know more specifics are probably needed, but I don'
t
> know what specifics to provide.
> Any help will be greatly appreciated! These people expect this app to be
up
> and running by Thursday morning!!!!
> --
> Sandy

Help

I've tried to install MDAC only at Win 98 (MDAC_TYP.EXE). But my program is
still not able to work. My Program use ADO to connect SQL Server 2000. So
what do i need to install again to my program can work/run?Why is it not working, do you get an error message for it ?
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Bpk. Adi Wira Kusuma" wrote:

> I've tried to install MDAC only at Win 98 (MDAC_TYP.EXE). But my program
is
> still not able to work. My Program use ADO to connect SQL Server 2000. So
> what do i need to install again to my program can work/run?
>
>|||wehhh, I'm forget its error message. But I sure that I don't install
complettely. Nah... I just ask to you, What Any kind of which need to be
installed So My app. can work / running?|||You just need to install the MDAC:
http://www.microsoft.com/downloads/...&displaylang=en
What kind of application do you want to deploy ?
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Bpk. Adi Wira Kusuma" wrote:

> wehhh, I'm forget its error message. But I sure that I don't install
> complettely. Nah... I just ask to you, What Any kind of which need to be
> installed So My app. can work / running?
>
>