Hi I had installed SQL Server 2005 Express Avanced and busines intellegence development studio express. in my windows XP profesional
I have ready my first report, and When I want deploy , the system say: Reporting Services Loign: User name & Password.
I don't know that user and password must write!!!
Please can someone help me!!!
thanks folks
david
spain
Moving to the Reporting Services forum.
Mike
sqlHi
Are there any specific Help files to download for SQL Server Management Studio Express. I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express? I can't find reference to Studio in there...
Thanks
Gauguin
Hi,
Here are some links for MS Sql Management Studio Express Help.
-SQL Server 2005 Express Edition Documentation and Samples (December 2005)
-SQL Server 2005 Books Online (December 2005)
HTH,
Michael Castillones
|||Thanks, the first link was the one I had been looking for.
W
sqlHi
Are there any specific Help files to download for SQL Server Management Studio Express. I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express? I can't find reference to Studio in there...
Thanks
Gauguin
Hi,
Here are some links for MS Sql Management Studio Express Help.
-SQL Server 2005 Express Edition Documentation and Samples (December 2005)
-SQL Server 2005 Books Online (December 2005)
HTH,
Michael Castillones
|||Thanks, the first link was the one I had been looking for.
W
Hi
Are there any specific Help files to download for SQL Server Management Studio Express. I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express? I can't find reference to Studio in there...
Thanks
Gauguin
Hi,
Here are some links for MS Sql Management Studio Express Help.
-SQL Server 2005 Express Edition Documentation and Samples (December 2005)
-SQL Server 2005 Books Online (December 2005)
HTH,
Michael Castillones
|||Thanks, the first link was the one I had been looking for.
W
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:
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/
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:
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/
hi
Im using the free version of ms sql 2005 studio express. I can upload databases, edit them and check them etc.
how do I back them up on to my pc, I do not have the server with me, my ms database is hosted on namesco.co.uk hosting.
I know how to right click the database, click task and back up. But I dont know where to back it up?
Whenever I try to back up to somewhere on my c: drive it won't. I think it also only backs up on a .bak files. Which I don't have.
I've looked on the net and it says you need a seperate hard drive or tape drive for back. Do I need to add another hard drive to my pc, if yes what do I format it as. And also how do I get a .bak file?
Here is a screenshot of where I can get to:(you might have to copy and paste them in your browser, there bmp so are big images)
http://www.uktattoostudios.co.uk/images/ms1.bmp
http://www.uktattoostudios.co.uk/images/ms3.bmp
As you can see I dont have a .bak to choose so it comes up this. If I click ok and try and back it up, it says back up complete. However when I go in the folder there is no .bak file
I also read on the net that if there shared databases the hosts are the only ones who can back stuff up, I asked them and they said that I should be able to do it on ms sql studio express.
thanks
dave
Backup folder are relative to the server. So every drive / file dialogue you see during the backup is from the server not from the client.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||hi, ok thanks.
So is there no way users can back up there databases? Sounds a bit stupid really?
Also namesco said I should be able to back it up
|||YOu can, but you will have to transfer the backup somehome on the client computer if you want to have if there.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||In Management Studio, right click on the database name, select Tasks|Backup.|||
hi,
rongolini wrote:
In Management Studio, right click on the database name, select Tasks|Backup.
this sounds difficult, if the server resides in a remote hosting company... as Jens anlready pointed out, the backup still resides on the remote machine and you have the hoster to provide a way (say a remote folder you can access over FTP) to bring it home...
regards
hi
Im using the free version of ms sql 2005 studio express. I can upload databases, edit them and check them etc.
how do I back them up on to my pc, I do not have the server with me, my ms database is hosted on namesco.co.uk hosting.
I know how to right click the database, click task and back up. But I dont know where to back it up?
Whenever I try to back up to somewhere on my c: drive it won't. I think it also only backs up on a .bak files. Which I don't have.
I've looked on the net and it says you need a seperate hard drive or tape drive for back. Do I need to add another hard drive to my pc, if yes what do I format it as. And also how do I get a .bak file?
Here is a screenshot of where I can get to:(you might have to copy and paste them in your browser, there bmp so are big images)
http://www.uktattoostudios.co.uk/images/ms1.bmp
http://www.uktattoostudios.co.uk/images/ms3.bmp
As you can see I dont have a .bak to choose so it comes up this. If I click ok and try and back it up, it says back up complete. However when I go in the folder there is no .bak file
I also read on the net that if there shared databases the hosts are the only ones who can back stuff up, I asked them and they said that I should be able to do it on ms sql studio express.
thanks
dave
Backup folder are relative to the server. So every drive / file dialogue you see during the backup is from the server not from the client.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||hi, ok thanks.
So is there no way users can back up there databases? Sounds a bit stupid really?
Also namesco said I should be able to back it up
|||YOu can, but you will have to transfer the backup somehome on the client computer if you want to have if there.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||In Management Studio, right click on the database name, select Tasks|Backup.|||
hi,
In Management Studio, right click on the database name, select Tasks|Backup.
this sounds difficult, if the server resides in a remote hosting company... as Jens anlready pointed out, the backup still resides on the remote machine and you have the hoster to provide a way (say a remote folder you can access over FTP) to bring it home...
regards
I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.
TITLE: Connect to Server
Cannot connect to DEVCOMP\SQLEXPRESS.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:
Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"
TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-
Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Let me know if this doesn't fix your problem.
Thanks,
Rob|||
The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.
If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.
The hosts file is located in your windows directory under
C:\windows\system32\drivers\etc\hosts.
Regards
Axel
I have checked out the blog and performed all the steps. I have restarted the services and still no luck.
I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.
Where do I goto from here?
Paul
I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.
TITLE: Connect to Server
Cannot connect to DEVCOMP\SQLEXPRESS.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:
Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"
TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-
Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Let me know if this doesn't fix your problem.
Thanks,
Rob|||
The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.
If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.
The hosts file is located in your windows directory under
C:\windows\system32\drivers\etc\hosts.
Regards
Axel
I have checked out the blog and performed all the steps. I have restarted the services and still no luck.
I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.
Where do I goto from here?
Paul
I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.
TITLE: Connect to Server
Cannot connect to DEVCOMP\SQLEXPRESS.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:
Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"
TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-
Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Let me know if this doesn't fix your problem.
Thanks,
Rob|||
The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.
If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.
The hosts file is located in your windows directory under
C:\windows\system32\drivers\etc\hosts.
Regards
Axel
I have checked out the blog and performed all the steps. I have restarted the services and still no luck.
I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.
Where do I goto from here?
Paul
I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.
TITLE: Connect to Server
Cannot connect to DEVCOMP\SQLEXPRESS.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:
Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"
TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-
Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Let me know if this doesn't fix your problem.
Thanks,
Rob|||
The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.
If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.
The hosts file is located in your windows directory under
C:\windows\system32\drivers\etc\hosts.
Regards
Axel
I have checked out the blog and performed all the steps. I have restarted the services and still no luck.
I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.
Where do I goto from here?
Paul
