is it possible to process the cube using vb.net/c# which exists in the remote server?

Hi

can we process the cube exists in the remote system, using vb.net/c#

i am able to process in the same system, where analysis service available.

i couln't process this from the client system.

is there any soluctions?

You can use either the AMO or ADOMD libraries to send processing commands to a remote server.

The AMO library is easier to work with for admin tasks, but you would have to redeploy the dll's. Where as any client that has to query the cubes will already need have ADOMD installed.

The following send an XMLA processing command using ADOMD, all you need to do is to create a console application, add a reference to Microsoft.AnalysisServices.AdomdClient and paste in the following:

Code Snippet

Sub Main()

Dim serverName As String = "Server1"

Dim databaseName As String = "Adventure Works DW"

Dim databaseID As String = databaseName

Dim cubeID As String = "Adventure Works"

Dim cn As New AdomdConnection("Provider=MSOLAP;Data Source=" & serverName & ";Initial Catalog=" & databaseName)

Console.WriteLine("Opening Connection...")

cn.Open()

Dim cmd As AdomdCommand

cmd = cn.CreateCommand()

cmd.CommandType = CommandType.Text

cmd.CommandText = "<Batch xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine""><Parallel><Process> <Object>" & _

"<DatabaseID>" & DatabaseID & "</DatabaseID>" & _

"<CubeID>" & cubeID & "</CubeID> " & _

"</Object><Type>ProcessFull</Type><WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch>"

Try

Console.WriteLine("Executing Command...")

cmd.ExecuteNonQuery()

Console.WriteLine("Command Complete")

Catch ex As Exception

Console.WriteLine(" --== ERROR ==--")

Console.WriteLine(ex.Message)

Console.WriteLine()

Finally

cn.Close()

Console.WriteLine("Finished")

End Try

End Sub

|||

Hi Darren

I tried your solution using AdoMd 8.0 on AS 2005,

but it seems that no data are refreshed,

neverthless the command text is executed without any error

Do I miss any other instruction (i.e: 'comitt transaction', .)?

Thanks

|||

I don't think ADOMD 8.0 has the execute method you need 9.0 to work with AS2005.

I just double checked and if your account has permission to process the server, database and cube properties are set correctly it should work. Try running a profiler session on the server and see if there are any errors being thrown at that end.

Is it possible to prevent databases from being copied?

Hi,

We have a point of sale application (C# .NET 2.0) and a Sql Server 2005 database back end.

Our customers are concerned that employees could create a backup of the SQL Server database (or even of the MDF file) and use it to steel customer data.

Very often, the application is running on a single PC in a shop using Sql Server Express Edition 2005 under Windows XP. The users usually log on as local administrator. It's hard for us to force our customers to change their local security policies.

Ideally, I would like some form of security mechanism that prevents a backup from being restored on to another PC without either a password or some other form of authentication.

Is this possible?

Regards,

Sigol.

I'm assuming you meant 'steal' (to take), rather than 'steel' (to harden).

There are several issues.

1. As you noted, a backup 'could' be restored on another server. Various third party backup programs allow passwords and encryption for backups. Any SQL Admin can create a backup that can be restored elsewhere.
2. A SQL administrator could take the database 'offline' for a few minutes and copy the data file (*.mdf)
3. A local administrator could shut down the SQL Service for a few minutes and copy the data file (*.mdf).
4. Even with an Encrypted database, or tables, or even specific columns, a local SQL Administrator can usually get around the protections.

Don't allow any local administrators to be in the SQL Admins role.

So if you are concerned about protecting a database, the 'best' solutions, in a situation where you can't control the local administrators, is to look into database encryption using encryption keys, or better yet, certificates.

|||

Thank you for your comments, Arnie. This was very helpful to me.

Regards,

Sigol.

|||

Arnie Rowland wrote:

I'm assuming you meant 'steal' (to take), rather than 'steel' (to harden).

Having a grammatically bad day, Arnie!

sql

is it possible to know whether report still executing

Hi friends
i've .net app where display reports from report server using SOAP api.
all works fine. my question is,
i have a export button on my screen to export to different formats.
whats happening is , as you know, when load report it says "report being generated" ,right ?
so our users clicking export button before report is loaded into report viewer control.
is it possible to know whether the report is still being loaded ?
Thanks for your help

Are you using winforms or webforms?

With the winforms ReportViewer control, you can use the RenderingComplete event.

If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.

|||

Thanks for that Brian.

Yes , am using a winform with a report viewer control.

i'll give a try using "RenderingComplete" event.

Thanks for your help

|||

Hi prk,

i wanted a help from u, how are u uploading files to the reporting server.

i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.

I am new to .NET technology. if u have any samples with SOAP API please send it to me

sureshk@.dcons.com / sureshbabu_krish@.yahoo.com

|||

Thanks Brian

That worked nicely :)

|||Suresh
i've not done that part.at the moment all reports created by report builder by our end users. and i just use soap api to load reports .
anyway to help you on this ,you need to give web reference to 2 services. one is for report management and the other one is report execution end points. these references create a proxy class for you in ur project. thats using SOAP api.
see following books online link on how to add web reference
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsprg9/html/b1217843-8d3d-49f3-a0d2-d35b0db5b2df.htm

once you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm

following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx

let me know how you are going with this.
Best of luck

is it possible to know whether report still executing

Hi friends
i've .net app where display reports from report server using SOAP api.
all works fine. my question is,
i have a export button on my screen to export to different formats.
whats happening is , as you know, when load report it says "report being generated" ,right ?
so our users clicking export button before report is loaded into report viewer control.
is it possible to know whether the report is still being loaded ?
Thanks for your help

Are you using winforms or webforms?

With the winforms ReportViewer control, you can use the RenderingComplete event.

If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.

|||

Thanks for that Brian.

Yes , am using a winform with a report viewer control.

i'll give a try using "RenderingComplete" event.

Thanks for your help

|||

Hi prk,

i wanted a help from u, how are u uploading files to the reporting server.

i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.

I am new to .NET technology. if u have any samples with SOAP API please send it to me

sureshk@.dcons.com / sureshbabu_krish@.yahoo.com

|||

Thanks Brian

That worked nicely :)

|||Suresh
i've not done that part.at the moment all reports created by report builder by our end users. and i just use soap api to load reports .
anyway to help you on this ,you need to give web reference to 2 services. one is for report management and the other one is report execution end points. these references create a proxy class for you in ur project. thats using SOAP api.
see following books online link on how to add web reference
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsprg9/html/b1217843-8d3d-49f3-a0d2-d35b0db5b2df.htm

once you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm

following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx

let me know how you are going with this.
Best of luck|||

Hi;

I am working on report view of a web form. I am looking for some event can fire after a report rendering. I only find a RendingComplete event of report viewer in a window form. But I could not find a similarly enent in the web form. Could some one help me?

Jennifer Xu

is it possible to grab data from 2 different databases

Hello-

I have a chart I am producing in .net and I need to values. The problem is the values (sums) i need are on 2 different servers. Is there any where to combine the query using two databases? Does anyone have any suggestions?

thanksYou may try to use something like:

"SELECT a.*, b.* FROM DB1..TableA a INNER JOIN DB2..TableB b ON a.WhatID = b.WhatID"

Regards,|||but they are on two different servers.. How would I set up the connection string for that?|||With that scanerio, what I have done is issued a sp_addlinkedserver from SERVER1 to link to SERVER2. Then you can access SERVER2 through SERVER1 by using a fully qualified table name: SELECT * FROM Server2.Database2.dbo.Table1.

Terri|||what is a sp_addlinkedserver and how do i set this up?

thanks|||Looks like we straightened this out in another thread:view post 458481

Terrisql

Is it possible to create reports in SSRS 2005 by mining data in SQL Server 2000

All,

I have found a lot of comments on the net but nowhere was I able to have a direct answer to this question:
My client has a complex database deployed on SQL Server 2000. He wishes to create reports based on this data using SSRS. Another division of the same company just implemented SQL Server 2005 and SSRS 2005.
I wish to know if SSRS 2005 is able to create reports based on data from SQL Server 2000?

Thank you.
S
Sure. You'll have no problems reporting against 2005 and 2000 together...

Is it possible to create a UDF from a .NET 2.0 assembly that uses dllimport to call unmanaged co

I have been reading up on everything I can find on this subject and I am not clear if this is allowed within the SQL Server 2005 CLR. My function calls work within a Windows form project, but don't run when invoked from a SQL function. I don't get any errors or warnings when creating the assembly and functions within SQL Server, but when running via a select statement, the spid just hangs and I have to stop & restart the service to kill the process. I have been investigating the security settings for this assembly, but I think I have that covered via the RunTime Security Policy settings in the .NET Framework 2.0 Configuration tool.

Any insights, knowledge, or thoughts would be greatly appreciated.

Barry

Hi Barry,

Calling into a CLR function which in turn p-invokes into unmanaged code should work without issues, although we would usually recommend against this if you can avoid it, as it would require the assembly being registered as UNSAFE.

What is the unmanaged code doing? Is it possible to have a look at your SQL function?

Thanks!

-Mat

sql

Is it possible to connect to a SQL Server 2005 database usine asp.net v1.1

Hi,

I am having difficulties connecting to a SQL Server 2005 database from an ASP.NET windows application.

Is there any difference in the way the connection string is written when connecting to SQL Server 2005

I have the following connections in my App.config file :

<addkey="Sql2000ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2000DB; User ID=UID;Password=Pwd;"/>

<addkey="Sql2005ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2005DB;User ID=UID; Password=Pwd;"/>

Every time I run my application it crashes when I try to connect to SQLServer2005 - The connection to the Sql2000 database works without any errors.

Do I need to write the connection differently??

Thanks

Hi kellem,

You would have to post your error message.

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

|||Make sure the remote connections are enabled on the SQL2005 instance, which can be checked in Sql Server Surface Area Configuration.

Is it possible to change the operator of an expression at run time?

I have a report I have created in local mode, in a Winform ReportViewer using VB.net.

Is it possible to change the operator of an expression at run time? That is, I have a filter on a list that looks like this:

Expression: =Fields!InvNum.Value

Operator: =

Value: =Parameters!InvNum.Value

It is possible in code to change the operator from = to >= at the time I run the report? If so, what is the syntax? What I would like to do (don't know it is possible) is to have the operator set to >= at the time the the report is run and then set it back to = when a user selects a specific value for a Parameter for the report. Is this possible?

I suppose I can set it in the load event of the form that contains the ReportViewer, but if this is possible I have not been able to discover the syntax.

Anyone?

You can't change the filter operator at run-time. But you can change the filter expression to =IIF(<your condition>, Fields!InvNum.Value=Parameters!InvNum.Value, Fields!InvNum.Value>=Parameters!InvNum.Value), and the filter value to =true.|||

Thank you for responding.

It's not clear to me what you're saying. I mean I understand that you can change the filter expression as a whole (and not the filter operator) and I understand that you can do that with an Immediate IF statement, but where?

Are you saying that you can change the expression in code, at run time? If so, how and Where, specifically?

Or, are you saying that in the Filter tab of the List component that you can enter an IIF there? If so, what kind of value would I put in <your condition>?

It may be that I am asking a question that seems illogical to you, like "How is time?". But to me, what I am trying to do is pretty common. I am trying to figure out a way to bring lots of information into a report and then give the user the ability to whittle it down if he wants to.

|||

OK. I think I understand some of this. I created an additional string parameter for the report called IWantToSeeAllRows. I set the default value to Y. Then in the filter tab of the list, in the expression column I typed the following:

=IIF(Parameters!IWantAllRows.Value = "Y", Fields!InvNum.Value>=Parameters!InvNum.Value, Fields!InvNum.Value=Parameters!InvNum.Value)

After typing the above RS put an = character in the Operator column and <Blank> in the Value column of the grid in the filter tab.

When running the report I get an error of "Cannot compare data of types system boolean and system string. Please check the data type returned by the filter expression.

I am really guessing here as to where just exactly to place the code etc., but the documentation that I've found on the matter is not explicit for this particular issue. What am I missing?

|||

Most likely you changed the filter value expression to a constant value like TRUE (which is interpreted as string - hence the type mismatch).

Change the filter value expression to =True (which evalutes to a boolean)

-- Robert

Is it possible to capture an OUT type parameter from a PL/SQL stored procedure?

When a stored PL/SQL procedure in my Oracle database is called from ASP.NET, is it possible to retrieve the OUT parameter from the PL/SQL procedure? For example, if I have a simple procedure as below to insert a row into the database. Ideally I would like it to return back the parameter namedNewId to my ASP.NET server. I'd like to capture this in the VB.NET code.

1createorreplace procedure WriteName(FirstNamein varchar2, LastNamein varchar2,NewIdout pls_integer)is
2
3NameId pls_integer;
4
5begin
6
7 select name_seq.nextvalinto NameIdfrom dual;
8
9insert into all_names(id, first_name, last_name)
10values(NameId, FirstName, LastName);
11
12NewId := NameId;
13
14end WriteName;

1<asp:SqlDataSource
2 ID="SqlDataSaveName"
3 runat="server"
4 ConnectionString="<%$ ConnectionStrings:ConnectionString%>"
5 ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName%>"
6 SelectCommand="WRITENAME"
7 SelectCommandType="StoredProcedure">
8 <SelectParameters>
9 <asp:ControlParameter ControlID="TextBoxFirstName" Name="FIRSTNAME" PropertyName="Text" Type="String" />
10 <asp:ControlParameter ControlID="TextBoxLastName" Name="LASTNAME" PropertyName="text" Type="String" />
11 </SelectParameters>
12</asp:SqlDataSource>

This is then called in the VB.NET code as below. It is in this section that I would like to capture the PL/SQL OUT parameterNewId returned from Oracle. 

1 SqlDataSaveName.Select(DataSourceSelectArguments.Empty)

If anybody can help me with the code I need to add to the VB.NET section to capture and then use the returned OUT parameter then I'd be very grateful.

This Select looks an awfully lot like an Insert, doesn't it? :)

My most honest suggestion is that you skip the SqlDataSource altogether for this kind of task. The SqlDataSource has some merit when it comes to binding databound controls to a datasource, but in this case it's a just simple insert from two textboxes.

In other words, use a simple OracleCommand, with a defined output parameter.

If you really want to use the SqlDataSource, then you should first use its Insert method, and corresponding InsertCommand etc. Next, define

<asp:Parameter Name="NewId" Direction="ReturnValue" />

and subscribe to the Inserted event of the SqlDataSource, where you'll be able to retrieve the value from the SqlDataSourceStatusEventArgs.

|||

Hi, thanks for replying. Yes, the example is overly simplified and an INSERT would have been better - I just used it to highlight what I was trying to achieve and that was to accept a returned value from the PL/SQL proc back in ASP.NET. However I think that you have answered my questions to thank you for showing me the Direction="ReturnValue" which is the bit I was missing.

Is it possible run C# .net Standard against SQL Server 2000?

Hi all!

I keep getting an error when I try and create a new data connection. This is the error I'm getting:

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

I can connect to Access without any problems. Is there anyway around this?
I'm using C# .net Standard with SQL Server 2000.

Thanks for any help.>>It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

What version?? "C#.net standard" ??

What version of the .NET framework are you using? What IDE are you using?|||Thanks ehorn for reply

I'd like to runVisual C#.net 2003 Standard IDE against SQL Server 2000

I'm using Framework 1.1|||Given that you say this is the error:

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

I imagine that the problem is exactly what it says. That is, the version you are using will NOT allow you to access SQL Server. However, if you install the MSDE on your machine (which is binary compatible with SQL Server) you will be able to access that.|||Thanks Douglas for reply!

It was exactly what I did but now trying to install MSDE I'm getting the error:
'The instance name specified is invalid.'

Will I have to remove SQL Server first then try again?|||I expect so, or alternately, specify an instance name while installing MSDE.

Is it possible

I have a .NET Web application that points to quite a few SQL reports.

Here is what I am looking to do:

I have a list of values that will change quite frequently. Say this is the list for example

A

B

C

D

E

In my report I need to say "where MyField = 'A' OR MyField = 'B' OR MyField = 'C'" .... etc.

The problem here is the list above is going to vary in value and *in number of parameters*. It won't always be 5 parameters...sometimes 6, etc. I won't know at compile time how many parameters.

***Is there a way to build the query for the Report in Visual Studio and have the report use that query for its dataset?***

Basically in Visual Studio I would say:

myQuery = "select whatever from wherever where MyField = FirstListValue "

While not at end of list

myQuery += "OR" + nextValue

End While

Has anyone done this before?

Are you using SQL Server 2005 and are you saying that it is a different number of values that can be in the same field? If so, just us a multi value parameter and in your SQL in the report add the clause: and MyField in (@.MyParm)

Then pass the values to the report in the MyParm parameter.

|||I'm fairly sure that is what I need. I'll give it a try and let you know how it turns out. Thanks!

IS IT Possbile to Invoke DATASTAGE (oracle Package) Job in Dot Net .

Hi ,

Anyone help me. Now we can do Invoke SSIS Package into ASp.NET.

Vice versa

Is there Possbile to invoke Datastage (oracle Job) into ASp.net? . Is already created in Oracle DataStage Server. it call or access through Dot net. Is it possble? Please any one help me.

Thanks & Regards,

Jeyakumar.M

chennai

What are the interfaces to run a DATASTAGE package. Web service, COM, OLEDB. Any of these would enable you to start the package from SSIS. The script component can do anything you can do in .Net

Is it mandatory to install "SQL server client" to connect to server that has "SQL

Hello,

My database is on the server. I have a vb.net application installed on a client's machine. The problem is I am not able to connect to server from my application.

I have figured out that "SQL server client" is not installed on client's machine.

So is there any settings/utility available using which without installing SQL client I can connect to Server.

Any views/help would be apprecciated.

You do not need to install anything on the client to connect to RS. What error are you recieving?|||

The server machine contains the database and the vb.net application is installed on the client's machine. So my question is in order to connect to the database that resiedes on the server, should client's machine also need "sql server client" or is there any way in which the application can connect to database without "sql client" on client machine.

This has nothing to do with reporting services.

Thanks

|||

I would suggest posting your question here http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

This is a report server forum, so I assumed the question was about RS. Assuming you are using .Net, the answer would still be no, client tools are not required on the client for an application.

Is it mandatory to install "SQL server client" to connect to server that has "

Hello,

My database is on the server. I have a vb.net application installed on a client's machine. The problem is I am not able to connect to server from my application.

I have figured out that "SQL server client" is not installed on client's machine.

So is there any settings/utility available using which without installing SQL client I can connect to Server.

Any views/help would be apprecciated.

You do not need to install anything on the client to connect to RS. What error are you recieving?|||

The server machine contains the database and the vb.net application is installed on the client's machine. So my question is in order to connect to the database that resiedes on the server, should client's machine also need "sql server client" or is there any way in which the application can connect to database without "sql client" on client machine.

This has nothing to do with reporting services.

Thanks

|||

I would suggest posting your question here http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

This is a report server forum, so I assumed the question was about RS. Assuming you are using .Net, the answer would still be no, client tools are not required on the client for an application.

Is it a bug in SQL CE?

Hi!

I use SQL CE with VS.NET. I find the following bug 2th.

The table has an "ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity.

I add rows to the table, then I realized that the ID order not in the general order (from 0 to ........)

For example: 6,7,8,0,1,2,3,4,5.

Of course row 6,7 and 8 was added the very last.

The content of each row is not mixed, only the ID order.

Is it a very confused, because we develop mobile invoice programs for PDAs.

What I did wrong?

Thank you!

Does that happen in the Query Analyzer on the PDA?

Maybe it does not order the rows by the primary key column by default (?). I don't know if that would be a bug, although it sounds more convenient if it did order on any key columns.

|||I moved this thread to the SQL Mobile's team forusm|||

Neither SQL Server nor SQL Mobile guarrenty you about the physical order of the rows and you are not expected to concluded something from running multiple queries. It can always change. If you want the rows to be ordered on a column, you should ideally use ORDER BY. Your query result (with out ordering) always depends on the cursor position.

Thanks,

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

Is having a trigger that inserts a row in Table A, when a row in same table is inserted by

I want to insert a row for a Global user in Table 'A' whenever ADO.Net code inserts a Local user row into same table. I recommended using a trigger to implement this functionality, but the DBA was against it, saying that stored proecedures should be used, since triggers are unreliable and slow down the system by placing unecessary locks on the table. Is this true OR the DBA is saying something wrong? My thinking is that Microsoft will never include triggers if they are unreliable and the DBA is just wanting to offload the extra DBA task of triggers to the programmer so that a stored procedure is getting called, so he has less headache on his hands.

Thanks

Hey,

I would prefer stored procedure; the reason is I have no control over triggers, so it makes it easier from a maintenance perspective on me, which is what I think you may also be under that restraint? I don't know how much slowing down it would do; I would think a lot of that depends on volume of data as well.

If you are inserting the main data using a stored procedure, then that stored procedure can do two inserts. You can also group them in a transaction so if one fails, both statements are rolled back for safety purposes.

Microsoft includes a lot of things: they include xp_cmdshell which most DBA's disable because of the power of it. So they will include things even though they may not be the best to implement...

|||

Actually, your DBA is correct. I always recommend, if possible, opting for stored procedures as opposed to triggers. The trigger will save you time if you are inserting rows into the table from many different sources in many different ways. But, if the only point of entry is a stored procedure, there's no reason not to place it in the sp. The farther back in SQL Server version you go, the less reliable triggers seem to get - and, yes, they can place locks on tables. Microsoft included them because they have their place - but it is a mistake to use them as substitutes for logical flow.

This shouldn't be a lot of extra work on you. If you aren't using a stored procedure already, they are much faster and far more secure than "on page" SQL. If you have insert statements in various parts of your application inserting to the same table, then you should be encapsulating them into a stored procedure anyway! Your DBA's job is to protect the efficiency and cleanliness of your database. Adding triggers unnecessarily affects both.

is folder App_data uses to store database by .net 2.0 hosting companies?

I am workin on a website for me and my friend. I want to host it at a hosting company. In asp.net 2.0 projects are build with the App_data folder, which can stores data source such as a SQL Server 2005 database. But when i want to host the site at a hosting company, will the database goed into this folder?

I also have a hosting company and dealing with the same problem.

The company has a SQL server that is different than the web server so; you have to create the database in the SQL server and then have your asp codes connect to that server by a connection string. You have to have the IP address of the server, your username and password to make that work.

Hope this helps.

Is Enterprize manager secure for remote admin?

Hello all,

An ASP.NET website hosting service allows the use of Enterprize Manager to manage the backend database of a hosted asp.net website. This is not done across a VPN and I don't think it could be done on SSL so the question is : How Secure is that? would this be ok for learning but not Ecommerce? Or is it an encrypted session and I paranoid?

-Thanks
HeywadeI wouldn't be overly enthusiastic about storing sensitive e-commerce info in there, no. I think you can rig it to communicate with IPSec, but it depends what the host supports - ask them.

IS ASP.Net 1.x Working together with SQL 2005?

Hi

Should ASP.Net 1.x work togheter with sql 2005 without problems? I have try to open a web project but I got the following error:

Cannot open database "crm" requested by the login. The login failed. Login failed for user 'crmuser'.

This crmuser is "promoted" to owner of the crm base, but still I got the problem.

I upgrade this web project to ASP.Net 2.0 and I don't have the login problems, that's why I'm wondring.

Hope someone can answear me on this question. Thanks!

Jan

SQL Server 2005 does not care what version is your application all you need is correct permissions and the correct connection string for 1.1, there are two permissions in SQL Server both are covered in the thread below and look up connections string for 1.1 in the product docs. Hope this helps.

http://forums.asp.net/thread/1492092.aspx

|||You solve my problems, thanks!!|||

lsoljf:

You solve my problems, thanks!!

I am glad I could help.