problem with installation of RDA...

Hello,

We have a server with 64bit Windows 2003 Server. I installed sqlce30setupen.msi and started to configure it. I get an error during virtual directory creating process which says "server tools must be installed first"....but I installed sqlce30setupen.msi already...Doesn't it the server tools that the error message says about?

The server tools are not supported on 64 bit Windows (for now) - sadly!|||

Hello,

Is it possible to install the server components to a pc(1) and install sql server to another pc(2) and connect to (2) via (1) using RDA method. I need this because the sql server is in 64bit windows 2003 server,so server tools can not be installed to it. I want to install server tools to another pc and access sql server via it.

How can I do that?

|||

Yes, this scenario is absolutely supported, so you must run 32 bit Windows on the web server, and can run 64 bit Windows on the DB server. See the SQL CE Books Onlie topic: Multiple Server Environment at http://msdn2.microsoft.com/en-us/library/ms172937.aspx

Problem with db connection

My application works properly with development area (VS 2005) , When I created virtual directory and call using browser (IE 7.0) , error occurs exacly the same below

ERROR:

Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.

Source Error:

Line 4932: this.Adapter.SelectCommand.Parameters[2].Value = ((int)(PROFIL));Line 4933: neuron.KULLANICI_TANIMLARIDataTable dataTable = new neuron.KULLANICI_TANIMLARIDataTable();Line 4934: this.Adapter.Fill(dataTable);Line 4935: return dataTable;Line 4936: }

Connection String is below

"Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\neuron2007_AJAX\\App_Data\\neuron_Data.MDF;Integrated Security=True;User Instance=True";

How can I solve this problem?

Thanks

Did you grant the ASPNET user account permission for the database?

Jeff

|||

Are you publishing to a remote server and are you publishing a copy of the local database that you are connecting to in that connection string?

Did you grant the correct permissions for Integrated Security?

|||

Yes BRCK231\ASPNET has rights below

- db_datareader

- db_datawriter

But connection is done with user BORINTERNAL\CBOZLAGAN for BRCK231\SQLEXPRESS sqlexpress 2005 server

|||

Is the website set up (via IIS) to accept anonymous connections? If not, please give that a try.

Mark

|||

Did you figure it out yet?