MS SQL Server 2000, And ASP.NET 2.0 Membership Controls (login)
Dec 14, 2007
when my ASP.NET 2.0 web site working against MS SQL Server 2000,
I Usually have a connection string to the DB, I create a connection, and start working on the data.
While reading about the MemberShip provider of ASP.NET 2.0 (Login control, Forgot password, etc.),
I read that it's possible to save the MDF file of the membership controls, within the APP_DATA folder.
But how can it be ? the MDF file must be at the server folder,
How can I access this MDF file ? with which connection string ?
How does MS SQL Server 2000 syncronize against this MDF file within my APP_DATA folder ?
And by the way, if my hosting company allow me to use 1 db schema of the MS SQL Server 2000 server,
Does this method (saving the MDF file within thr APP_DATA folder) allow me to use multiple schemas ?
Thanks.
View 4 Replies
ADVERTISEMENT
Jul 4, 2007
hello, I have developed a website using asp.net 2.0 and sql server 2005 express edition. I have used the built-in membership, roles and login controls in my website. now i need to change the database server. i have to use sql server 2000 instead. as asp.net 2.0 uses the ASPNETDB.mdf for member,roles and login controls, so how can i do it? i can easily export the database from 2005 to 2000 but how my application controls will know where to look at for those data. I am clueless. please help me. thanks in advance.
View 2 Replies
View Related
Apr 27, 2008
i recently create c#.net we application in vs2005 environment using membership control provided by vs 05 ,first i uploded my site to ftp a/c then generated sql script from enterprise manager of my local database and run script on remote database using sql query analyzer database created , i try to run application it give me error on login page that dbo.asp_checkschema stored procedure have not permission to execute then i learned that dbo is admin an i have create stored procedures with my user name , then i followed same and change stored procedures ownership to my username than again i try to run my application it give error that dbo.asp_checkschema stored procedure have not found but same stored procedure is there only with owner name changed such as abc.asp_checkschema , iserched a lot but i not find a solution on that plese help me in solving it
View 2 Replies
View Related
Jun 3, 2007
sir
i have uploaded my website but there is a problem
It is working very well wneh on the local host
but when uploaded on the web server the login control is not validating the users of the database
also i have added a CAPTCHA control
and that is giving an error that the cobe u entered is not matching
u can even check this error
My Url is http://www.webgrowthengine.com
click on the login button
user name: "aaaa" (Excluding the quotes)
password: !@#$%^& (Press shift+ 1234567)
plzhelp me
Nitin
View 1 Replies
View Related
May 9, 2006
Hello,I'm programming asp.net 2.0 with a mySql database.Now I want to implement membership-features.I consider converting mySql to SQL server 2000 because then I don't have to build a custom membershipprovider.my question is: does membership work as good on sqlserver2000 as it does on sqlserver2005? (my host doesn't support sqlserver2005 (yet).another question: can I expect problems converting the database from mysql to sqlserver2000?
View 1 Replies
View Related
May 14, 2008
Hello All,
I am recieving this error using vs2005. I am using the login controls which creates a mdf file. i am not using sql server 2005 in this program. The program runs well in my local machine, but as soon as i publish the site, i recieve this error after i login into the site.
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) 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: 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)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): 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)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +685966 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +109 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +383 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
does anyone know why?
thank you,
kagome
View 9 Replies
View Related
Mar 14, 2007
I have a two problems. First is connecting to my sql server 2005 express with my sql account. Every time i try to configure data source to connect to my db on server using my windows auth. it works and when i try using my sql account i get error, User is not associated with a secure SQL Server connection. Second, how can i configure my application to store membership, roles, user data in a database on my server like /Servername/SQLEPRESS/mydbname and not to App_Data/ASPNETDB. Tnx in adv.
View 3 Replies
View Related
Sep 8, 2006
Could anyone please advise on a good hosting company that DOES support the above applications and any advice on the Login Controls for the uploaded database would be greatly appreciated.
View 1 Replies
View Related
Dec 18, 2006
(Sorry this was posted to VWD2005 Express by mistake)
I have created a simple project using ASP.NET 2.0 which enables a user to login. I created the login user using the Web Administration Tool in Visual Studio 2005.
I created everything locally and it worked.
Locally I have 2 databases. One containing normal data (which my site uses to populate a GridView control) and the other being ASPNETDB.MDF - which contains membership (login user) data. These 2 databases sit in the App_Data folder which is in the root of the project.
I have a remote database which is hosted in a shared environment.
This is just the one database and it appears to have all tables in the one database (membership tables and normal tables - such as the one I use to populate my GridView control).
I uploaded the website and using the Database Publishing Wizard I uploaded the database data to the shared host. I also changed the connection string to point to my remote database.
If I visit the website the GridView is populating correctly (pulling data from the remote database) but when I try to login it crashes. The error is "Access denied creating App_Data sub directory".
The membership login details for the user I created are in the remote database as I have compared the data in it to the data in my ASPNETDB.MDF local database.
If I launch from within Visual Studio 2005 then it allows me to login perfectly well.
Please does anybody know why it won't let me login when I access it via the website?
Many thanks for any help,
Graham
View 3 Replies
View Related
Apr 14, 2006
We have succesfully moved SQL server to a new machine and this same machine will also be running IIS 5.1 to host our intranet. We will be doing the actual developing on other machines and publishing the site to the new machine.
Now, when I went to test the site, it all comes up just fine, but logging in is a problem. What do I need to do to configure the new SQL server to accept new members, logins, etc.
Oh, and actually membership is still on the "old" SQL.
When I tried to login, I get this:
Server Error in '/' Application.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Thanks for the information.
View 2 Replies
View Related
May 9, 2007
Hi, I am porting a massive VB6 project to ASP.net 2005. Most of the code is fine, however because the original developers used lots of data controls and my own time restrictions I thought to replicate the functionality by using Sqldatasource controls instead.
These data controls are bound to DBtruegrids. The project has has lots of code like...
AdodcOrders.Recordset.RecordCount > 0 or If AdodcOrders.Recordset.EOF or AdodcOrders.Recordset.MoveNext() or
AdodcDetail.Recordset!FieldName
The problem is the sqldatasource control doesn't have a recordset/dataset property which I can access and manipulate, or does it? What should I do to get round these? The project has thousands of lines like this in so its not feasible to rewrite it (although if I could I would!).
Any suggestions please gratefully appreciated.
many thanks
mike
View 1 Replies
View Related
Oct 20, 2005
Hi.. I am able to create a new login thru sql server enterprise manager..but when i try to connect thru query analyser using the same login and password,i am getting the following error.. Unable to connect to server EI_DT Server:Msg 18452,Level 16,State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test'.Reason:Not associated with a trusted SQL Server Connection Can anyone plzz help me to rectify this error.. Thankz in advance..
View 1 Replies
View Related
Jan 27, 2006
Is there a way to audit the login on SQL Server 2000? I'm looking for away to get a report login/logout events with the name of the database.Thanks in advance.
View 3 Replies
View Related
Oct 29, 2007
Hi,
I have created a database ABC under an instance <compname est> and have assigned an user name and password for it. Also i have created another database DEF under the same instance with respective login credentials.
The problem is that i can login to ABC using DEF login credentials and vice versa.
Can anyone suggest a solution for this?
Is there any query to create a login for a particular database?
View 3 Replies
View Related
Jan 22, 2008
Hi,
I am using SQL Server 2000. But i am not able to see the BuiltinAdministrator account in the logins list in Enterprise Manager but by default the owner of the system gets access to all databases and objects in the system. I would like to restrict that by restricting the access of BuiltInAdministrator account but it is not visible. Is there any option to be enabled to make that visible?
Could you please help me in this issue..
Thanks.
View 4 Replies
View Related
Nov 6, 2007
I was using detach & attach method to move few 2000 databases to the instance 2005 on the same server...After moving a couple of databases which worked fine...Now i am not able to log into 2000 database...i guess the default database which i was connected had been moved at so its not letting me in to 2000 server..
TITLE: Connect to Server
------------------------------
Cannot connect to SQL-CENTRAL-DEV.
------------------------------
ADDITIONAL INFORMATION:
Cannot open user default database. Login failed.
Login failed for user 'test est'. (Microsoft SQL Server, Error: 4064)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
how do i fix the problem
thanks
View 5 Replies
View Related
Feb 28, 2007
As an 'SA' I thought that you have permission to do anything on the server. Running an update command from Query Analyzer is throwing this error:
SQL Server 2000 SP3
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'sa'.
The table is in the dbo schema.
Has anyone seen this error before?
View 12 Replies
View Related
Sep 12, 2006
Is Windows Login Name Case Sensitive in SQL Server 2000?
View 1 Replies
View Related
May 7, 2008
In my site, when a user registers, I need to create rows in additional tables besides aspnet_Users. So, I need to be able to pass the generated userId guid to subsequent SqlCommands. I'm having a terrible time with this. What's the correct way to set up a SqlParameter so that it will accept a guid? I keep getting this error: "Conversion failed when converting from a character string to uniqueidentifier."
I've tried creating the parameter both with and without a SqlDbType.
cmd.Parameters.AddWithValue(paramName, guid);
and
SqlParameter p = new SqlParameter(paramName);p.SqlDbType = SqlDbType.Guid;cmd.Parameters.Add(p);
and I get the same error either way.
Driving me nuts! Any help appreciated.
View 1 Replies
View Related
Sep 21, 2004
How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_nameASPNET'.
View 1 Replies
View Related
Nov 3, 2006
Hi, i wrote a simple program to access a SQL Server 2005 DB and i use the following connection string: <connectionStrings>
<add name="Alunos" connectionString="Data Source=.;Initial Catalog=ALUNOS;integrated security=true"/>
<add name="Escola" connectionString="Data
Source=.SQLEXPRESS;Initial Catalog=Escola;integrated
security=true"/>
</connectionStrings> It all works fine.Then
i try to create a SQLDataSource object graphically and configure it.
when i choosethe instance and DBi choose Test Connection and it gives
the 'Named Pipes Provider , error 40'. I think i solves this problem
because i googled thisand found a lot of info and i did all that.But
the problem remains.Could it be the a security issue? with the user i´m using to access the DB?Some help on this would be very appreciated.ThanksSP
View 2 Replies
View Related
Feb 19, 2006
Hello all,I need help with sql server which i was wondering if someone can shedsome light on my problemThe problem:Hello all,I need help with sql server which i was wondering if someone can shedsome light on my problemThe problem:i am using .net 2.0 membership provider interface to provide amembership in my website...now i also am using the sql server 2005 forthe backbone of the site..now when a new user is created theirinformation is saved into asp_ membership and their userid isautomactially saved into another table called asp_users...now these aredefaults by membership provider...what i would like to do is to createanother table which i have called "Rank" and i would a column in this"rank" table that would keep the user ids, now i have noticed that theasp_user.UserId has a releationship with asp_Membership.userId so when anew user is created asp_user.Userid automactially gets updated..i havecreated a colum called Rank.UserId which has a relationship withasp_users.userid and asp_membershi.Userid but it doesnot get updatedautomatically when a new user is created...what can i do so i can havethis table "Rank" also gets updated automactially as soon a a new useris created or a user has been deleted...just like asp_users gets updated...thanks in advance---Best RegardsAmir---Best RegardsAmir*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies
View Related
Sep 5, 2014
I have an area of a report that id like to use on other reports, its just a few images with some data on top.
how id save it as a control so I could use it as an add on?
View 2 Replies
View Related
Jan 17, 2007
Hi, I hope this is in the correct category. I have two .mdf files. aspnetdb.mdf and emotiveonline.mdf. My host provider can only give me one database in sql server express 2005. Now I am no genius when it comes to programming and that kind of stuff but those two mdf files would be seen as 2 databases right? What I would like to know is that if I can but everything into one mdf file and how would i go about doing that. My website is almost finished and just thought about this now. Would like to do the changes as soon as possible so that I won't sit with a humongous problem later on. Thank you in advance. Kind regards,Ruan Rossouw
View 2 Replies
View Related
Feb 9, 2006
I have a problem that I'm hoping someone can give me some advice with: I have created a website that uses .Net 2.0, SQL 2005, and ASP.NET Membership to manage users. Everything works fine until it comes to calling reports, in particular setting report parameters:
Exception Details: Microsoft.Reporting.WebForms.ReportServerException: The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)
Source Error:
Line 30: End If
Line 31:
Line 32: Me.rvInvoice.ServerReport.SetParameters(p)
Line 33: Me.rvInvoice.Visible = True
Line 34:
The report worked fine before the security model was changed to use the Membership classes which leads me to conclude that I have not configured the Report Server to deal with the network account that the ASP pages are now using.
I have looked at the example project for configuring extensions with no success. Any help would be greatly appreciated.
Thanks,
Mike
View 1 Replies
View Related
Mar 9, 2007
Hello, we have some tables and views that are not assigned to the standard schema of dbo.Whenever I try to use a design time control and/or SQLDataSource connection control, it does not like objects other than those using the dbo. schema.Any ideas on how to resolve this issue?For example, her are a couple of views:dbo.vwCustomersdbo.vwCustomerDetailsord.vwOrdersord.vwOrderDetailsthe views with dbo.* I have no problem with.the views with ord. it tells me the view(s) do not exist.Thanks in advance!
View 1 Replies
View Related
Jun 13, 2006
When I include a field from my SQL Server database, which has it's Allow Nulls value checked, in the data source of any type of control with it's Enable Editing property check, I then can not edit the record! If I remove the Allow Nulls field I can then edit it! What am I missing here?
View 1 Replies
View Related
Mar 30, 2007
Hello all,
I am having problems running a stored proc from an aspx.cs file. Basically I want to extract data from webForm controls and create a new record in a DB table. I have watched the "Getting Started" videos on thi site, and the only difference between my code and the code of the demonstrator is the connection string. My conn string:- dataSrc.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectTblConnString"].ConnectionString;Demonstrator conn string:- dataSrc.ConnectionString = ConfigurationManager.ConnectionStrings("ProjectTblConnString");When I debug with the string as shown by the demonstrator the error list reports that ConnectionStrings is a property and I am trying to use it as a mothod, which is fair enough, but I am just confused as how it worked for the demonstrator and not myself. When I debug with the code I used above I get no error, but nothing is inserted in the DB.Also, it looks as if the only class in my aspx.cs file that is actually being executed is PageLoad() - the remainder of the code seems to be ignored. Below is the entired aspx.cs file:- 1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11
12 public partial class CreateProject : System.Web.UI.Page
13 {
14 protected void Page_Load(object sender, EventArgs e)
15 {
16
17 if (User.Identity.IsAuthenticated == false)
18 {
19 Server.Transfer("Default.aspx");
20 }
21
22 if (chkbox_startDate.Checked == true)
23 {
24 txtbox_startDate.ReadOnly = true;
25 txtbox_startDate.Text = (System.DateTime.Now.ToString());
26 }
27
28 }
29
30 protected void btn_create_Click(object sender, EventArgs e)
31 {
32 //connection string for connecting to SQL Server DB
33 SqlDataSource dataSrc = new SqlDataSource();
34 dataSrc.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectTblConnString"].ConnectionString;
35
36
37 //insert data in table using the CreateNewProject stored proc in the DB
38 dataSrc.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
39 dataSrc.InsertCommand = "CreateNewProject";
40 dataSrc.InsertParameters.Add("Project_Title", txtbox_title.ToString() );
41 dataSrc.InsertParameters.Add("Description", txtbox_desc.ToString() );
42 dataSrc.InsertParameters.Add("Start_Date", txtbox_startDate.ToString() );
43 dataSrc.InsertParameters.Add("Primary_Dev_Lang", list_devLang.ToString() );
44 dataSrc.InsertParameters.Add("Dev_Environment", list_devEnv.ToString() );
45 dataSrc.InsertParameters.Add("No_Junior_Devs", txtbox_juniorDevs.ToString() );
46 dataSrc.InsertParameters.Add("No_Senior_Devs", txtbox_seniorDevs.ToString() );
47
48 int rowsAffected = 0;
49 try
50 {
51 rowsAffected = dataSrc.Insert();
52 }
53 catch (Exception ex)
54 {
55 Server.Transfer(Error.aspx);
56 }
57 finally
58 {
59 dataSrc = null;
60 }
61
62 if (rowsAffected != 1)
63 {
64 label_confirm.Text = "Error, Contact system admin";
65 }
66 else
67 {
68 label_confirm.Text = "Success";
69 }
70
71 }//end btn_create
72
73 //if cancel is clicked set all values back to default
74 protected void btn_cancel_Click(object sender, EventArgs e)
75 {
76 txtbox_title.Text = "";
77 txtbox_desc.Text = "";
78 txtbox_startDate.Text = "";
79 txtbox_seniorDevs.Text = "";
80 txtbox_juniorDevs.Text = "";
81 list_devEnv.SelectedIndex = 0;
82 list_devLang.SelectedIndex = 0;
83 chkbox_startDate.Checked = true;
84 label_confirm.Text = "";
85 }
86
87 //if checked the current dateTime is inserted into txtbox
88 protected void chkbox_startDate_CheckedChanged(object sender, EventArgs e)
89 {
90 if (chkbox_startDate.Checked == true)
91 {
92 txtbox_startDate.ReadOnly = true;
93 txtbox_startDate.Text = (System.DateTime.Now.ToString());
94 }
95 else
96 {
97 txtbox_startDate.ReadOnly = false;
98 txtbox_startDate.Text = "";
99 }
100 }//end chkox
101
102
103 }//end class
Any help anyome can give is greatly appreciated. This is part of my Final Year College Dissertation which is due in 3wks !!!!
Sláinte á chaire,
Seán
View 2 Replies
View Related
Jun 30, 2007
All,
My ISP does not allow me to remotely connect to my hosted SQL Server DB--how can I use SQLDataSource and other data bound controls in development?
Here are my specs:
IDE: Visual Web Developer Express 2005
Database: MS SQL Server
ASP Version: ASP.NET 2.0
The SQL Server is hosted centrally at the ISP; basically I have been given the connection string parameters.
My question is this:
Do I use two web.config files (one for when I develop locally and one for when I deploy remotely)? If so, how? Will the SQLDataSource control find the connection string defined in web.config on the remote server? I don't want to have to write all of the database code and it would be a big loss of one of the major benefits of using ASP.NET 2.0 if I do.
Any help will be greatly appreciated,
Leslie
View 4 Replies
View Related
Feb 22, 2006
How can I implementing Membership and Role Management on SQL Server 2005 (not Express)? Anyone have any documentation? Are there any scripts to run that will basically set up the same Database schema on SQL Server 2005 that Express uses?
Thanks.
View 3 Replies
View Related
Oct 24, 2006
Hi,
I downloaeded "Microsoft SQL Server 2005 Datamining Viewer Controls" feature pack, and tried to run the dataminingviewerclient.exe.
When i view my local time series data mining model, It works well for single series model, but when i load a Microsoft time series model containing multiple data series, an unhandled exception occurs.
I post the error message below:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer.PreprocessChartArrays(ArrayList rgPredicted, ArrayList rgActual, ArrayList rgDeviations)
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer.LoadChartSpace(MiningModel model)
at Microsoft.AnalysisServices.Viewers.TSCheckedListViewCombo.HandleChangesCommitted(Object sender, EventArgs ea)
at Microsoft.DataWarehouse.Controls.BaseControlComboBox.OnCommittedChanges(EventArgs e)
at Microsoft.DataWarehouse.Controls.BaseControlComboBox.SetSelection(String str, Object obj)
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer.InitializeCurrentlySelectedPage(Object context)
at Microsoft.AnalysisServices.Viewers.TreeViewer.viewerTabControl_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.TabControl.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.TabControl.WmSelChange()
at System.Windows.Forms.TabControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
DataMiningViewerClient
Assembly Version: 1.0.2023.16746
Win32 Version: 1.0.2023.16746
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/DataMiningViewerClient.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 9.0.242.0
Win32 Version: 9.00.2047.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Microsoft.AnalysisServices.Viewers
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.Viewers.DLL
----------------------------------------
Microsoft.DataWarehouse
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.DataWarehouse.DLL
----------------------------------------
Microsoft.DataWarehouse.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.2047.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.DataWarehouse.Interfaces/9.0.242.0__89845dcd8080cc91/Microsoft.DataWarehouse.Interfaces.dll
----------------------------------------
Microsoft.AnalysisServices.Controls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.Controls.DLL
----------------------------------------
Microsoft.Office.Interop.Owc11
Assembly Version: 11.0.0.0
Win32 Version: 11.0.5530
CodeBase: file:///E:/WINDOWS/assembly/GAC/Microsoft.Office.Interop.Owc11/11.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Owc11.dll
----------------------------------------
Microsoft.AnalysisServices.Graphing
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.Graphing.DLL
----------------------------------------
MSDATASRC
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///E:/WINDOWS/assembly/GAC/MSDATASRC/7.0.3300.0__b03f5f7f11d50a3a/MSDATASRC.dll
----------------------------------------
mscomctl
Assembly Version: 10.0.4504.0
Win32 Version: 10.0.4504
CodeBase: file:///E:/WINDOWS/assembly/GAC/mscomctl/10.0.4504.0__31bf3856ad364e35/mscomctl.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.AnalysisServices.OleDbDM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.OleDbDM.DLL
----------------------------------------
Microsoft.SqlServer.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.2047.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
***** end of error message***
Can someone help to figure out what went wrong? thx.
View 7 Replies
View Related
Apr 16, 2008
Hi all,
Have just tried my sql server 2005 connected asp classic website on II7 for the first time and have gotten some errors.
First off I have unchecked show friendly errors in IE and have enabled ASP to send error messages to the browser.
My error I get is when I execute a basic .asp page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabasename" requested by the login. The login failed.
/index.asp, line 10 which is dbConnect.Open cstring
from this peice of code:
sub dbOpen()
set dbConnect = Server.CreateObject("ADODB.Connection")
cstring = "DSN=mysqldsn; Trusted Connection=yes"
dbConnect.Open cstring
end sub
I have gone into ODBC and have setup both a user dsn and file dsn that equals mysqldsn and points to my database (I know you only need to set up one DSN but I'm not sure which)
I also notice under mywebsite home panel there is a connection string option. Do I do anything with that?
Definatley a lot more to it than XP's II6!
Any help or advice would be greatly appreciated.
View 3 Replies
View Related
Apr 26, 2015
Oracle and Teradata are able to capture the windows/client login that connects to their database with a functionnal ID.I've searched around and I don't think MS SQL can do this...I administer SQL 2014 server and also SAS Enterprise guide product. I've created sql server logins for several teams so everyone shares the same sql server login which is used to bind the SAS library to my SQL server database.
However, when looking at activity monitor, I can't drill down to which user is executing a particular query. I only see the SQL login which is share amongs 200 other folks.On the other hand, when they connect from SAS to Oracle or Teradata, I can see the shared login + additionally their windows NT login used to connect to SAS which is awesome....they can't fool me by using a shared/funcionnal ID....i still see who's using that ID...
View 2 Replies
View Related
