Hello!
I am working at a ASP.NET Project with has a sign-in area. All users (the aspnet_Membership and so on) are on an external SQL Server stored.
The ConnectionString in the web.config looks like this:
<add name="hspWerbung" connectionString="Persist Security Info=False;User ID=XXXXX;Password=XXXXX;Initial Catalog=HSPWERBUNG01;Data Source=SERVER_SQL_02STOCKHOLM"
providerName="System.Data.SqlClient" />
Is there any way to create a ConnectionString without the User ID and without the password?
When i want to reach my site on the web (not with http://localhost/...) , i can't do it with "Integrated Security=True", because there will be no user, or?
What different are there between connectionString (Part 1) and connectionString (Part 2) in web.config The CCWW is my PC's name, normally I can connect to the database ASPNETDB.MDF correctly either Part 1 or Part 2 in a web page,After I open Database Explorer panel and browse ASPNETDB.MDF, I can't connect to database using Part 2 when I open a webpage in Microsoft Visual Web Developer 2005 Express Edition,but I can correctly open a webpage using Part 1 after I open Database Explorer panel. What different are there between connectionString (Part 1) and connectionString (Part 2) in web.config? I guess while I use Part 1 to connect, maybe it will be cancel exclusive method of the database ASPNETDB.MDF first, but when I connect to database using Part 2, maybe two programms both Part 2 and Database Explorer visit ASPNETDB.MDF at the same time!
I have connected to Database using my credentials by checking remember password option. After few days I forgot my password. How can I recover the password as SQL remember it. Is there any way to recover my password instead of resetting it.
I have a package protected by a password - I am already unhappy that to get it to use the configuration file to change connection strings for the production servers I have had to hardcode the password into the config file - very insecure! However, the package now deploys correctly to the production server and will run from there OK, but NOT if scheduled as a SQL Server Agent Job. Thus is because however often I edit the command line to include the password after the DECRYPT switch (which it has prompted me for when I click on the command line tab), the Job Step will not retain it. If I open it up after I have edited it and closed it, the password has disappeared.
I know that if I run dtexec plus the code in the Command Line tab (with the password), the package runs OK.
This is driving me insane! I have read all the other posts and so I tried replacing the SSIS package step with a CmdExec step and pasting that code into there - then I get an OLEDB error..
The code I use is: DTEXEC /SQL "ImportRateMonitoringTables" /SERVER servername /DECRYPT password /CONFIGFILE "D:Microsoft SQL ServerSSISDeploymentsRateMonitoringImportTasksDeploymentImportRateMonitoringTables_Production.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
and I get
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF
although the same code executes perfectly from a command prompt.
Please does anyone have any experience with a similar problem and if so, how did you get round it?
I am receiving the following error message when attempting to create a new SQL Authenticated login id.
Password validation failed. The password does not meet the requirements of the password filter DLL. (Microsoft SQL Server, Error: 15119)
I have four servers all running SQL Server 2005 SP2 on Windows 2003 Ent. SP1. Of the four servers, only one received the above error message using the same TSQL below.
CREATE LOGIN TEST_LOGIN WITH PASSWORD = 'pvif9dal' MUST_CHANGE, CHECK_EXPIRATION = ON
All four servers are in the same domain, which if I understand correctly, the password policies are therefore inherited at the OS level by the domain. The password being used is within the password policies of the domain.
I tried to install an ALLDATA database which run with SQL Server 2005 express edition. The data base fails to install becase of the following code that come up which is related to AS password requirement. The error that come up is:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28001&EvtType=sqlca%5csqlcax.cpp%40SAPasswordPolicyCheck%40SAPasswordPolicyCheck%40x6d61
------------------------------ BUTTONS:
&Retry Cancel ------------------------------
I am trying to install this database in a network server operating under Windows Server 2003 R2 with SP2. If anyone knows how to solve this problem, please let me.
Just installed Express edition on my laptop and don't know how to set up the connection string in my aspx.vb page. I've added my connection in the webconfig page and want to set up the vb page. This is not working please tell me what's missing in the Dim conn section.Protected Sub SubmitInfo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubmitInfo.Click Dim conn As ConnectionStringsSection = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|BEEN.mdf;Integrated Security=True;User Instance=True"Dim cmd As New Data.SqlClient.SqlCommandWith cmd .Connection = conn .CommandType = "AddUserInfo".Parameters.AddWithValue("@FName", Fname.Text) .Parameters.AddWithValue("@LName", LName.Text).Parameters.AddWithValue("@Email", Email.Text) .Parameters.AddWithValue("@Comments", Comments.Text) End With conn.Open() cmd.ExecuteNonQuery() conn.Dispose() End Sub
Hi I'm using Sql Server (SQLOLEDB.1) and I want to connect it by Sqlconnection.those are the details:user Id: saPassword: *****database: ServiceManagementserver name: KLXPE002KULMOSWhat should be the Connection String? Thats what i did: "Persist Security Info=True;Integrated Security=SSPI;server=SQLOLEDB.1;database=ServiceManagement;Data Source=KLXPE002KULMOS;User ID=sa;password=****"It doesn't work.thnxItai
Hello, I have just tried to deploy my app from my local pc to our server and I have been getting this error. Server Error in '/' Application.
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.Source Error:
Line 164: <providers> Line 165: <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" Line 166: type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> Line 167: <add name="AspNetWindowsTokenRoleProvider" applicationName="/" Line 168: type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />Source File: C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Configmachine.config Line: 166
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 I am new to SQLExpress 2005 and asp.net 2.0. I created some database files on my local pc then copied the whole app to the server. Not sure what to do. Any help would be greatly appreciated or direction to info. Thanks Matt
The server is on the localhost, the database name is ok, but what do I put in for the username and password?, At the moment because it is hosted locally I am not using any logins.
Hay, I have a problem with this connectionstring.Dim myConnection As New Data.OleDb.OleDbConnection("Provider=SQLNCLI;Data Source=whatever-ja4lbqsqlexpress;Initial Catalog=Account;Integrated Security=SSPI;")I use this code to receive a value on a specific query Public Sub readdata(ByVal myconnectionstring As String) Dim mySelectQuery As String = "SELECT UserName, Password FROM TAccount WHERE UseName = '" & TextBox1.Text & "'; and Password = '" & TextBox2.Text & "';"
Dim mycommand As New Data.OleDb.OleDbCommand(mySelectQuery, myConnection) myConnection.Open() Dim myreader As Data.OleDb.OleDbDataReader myreader = mycommand.ExecuteReader While myreader.Read Label1.Text = myreader.GetString(1)
End While myreader.Close() myConnection.Close()
End Sub But when it execute i receive this exeption Login timeout expiredAn 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.SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Is this mean that i can not make a connection to my sql server 2005.
Hi, After many nights without sleep I'm not seeing this? Can anyone help why I'm getting a ConnectionString Property not set error? thanks! Dim Sconn As StringDim DBCon As New Data.SqlClient.SqlConnectionSconn = ConfigurationManager.AppSettings("LocalSqlServer")DBCon = New SqlClient.SqlConnection(Sconn)Dim cmdCommand As New Data.SqlClient.SqlCommand 'Dont forget to instantiate a connection object cmdCommand.Connection = DBConDBCon.Open()
Hello, Well actually I am beginner to ASP.Net, I am working on Microsoft Virtual PC with VS 2005 and SQL Server 2005 installed. Now when Create web application in Studio all works fine with databases but when i try to write some code for accessing SQL Databases I keep getting this error PLZ heLP.Following is my code<% @ Import Namespace="System.Data" %><% @ Import Namespace="System.Data.SqlClient" %><html><script language="C#" runat="server" Debug="false" >SqlConnection sqlcon;protected void Page_Load(Object Src, EventArgs e){ sqlcon=new SqlConnection("Data Source=VS02005;Initial Catalog=Gaurav;Integrated Security=True"); SqlDataAdapter sqlcom = new SqlDataAdapter("select * from Employee", sqlcon); DataSet ds = new DataSet(); sqlcom.Fill(ds,"Employee"); DataGrid1.DataSource = ds.Tables["Employee"].DefaultView; DataGrid1.DataBind();}</script><form runtat="server"> <asp:datagrid id="DataGrid1" runat="server" /></form></html>This is the error i am gettingServer Error in '/' Application.--------------------------------------------------------------------------------SELECT permission denied on object 'Employee', database 'Gaurav', schema 'dbo'. 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: SELECT permission denied on object 'Employee', database 'Gaurav', schema 'dbo'. I am stuck dont know what to do, I hve checked all permissions for user gaurav, I also gave administrator rights to gaurav but nothing is working PLEASE help me.
This works: SqlDataSource1.ConnectionString = "Data Source=mydb.myserver.com;Initial Catalog=mydbname;User ID=mydblogin; pwd=mydbpassword"; This doesn't: SqlDataSource1.ConnectionString = "<%$ ConnectionStrings:myConnectionString_from_WebConfig %>" Ok, how do I tell it to use my connection string from my web.config?
HiI've my ConnectionString in web.config... I want to display the DB UserID on my webPage and UserID is specified in ConnectionString... Can any one help me in this caseThanksNasir Ibrahim
hi, i have problem in connectionstring in sql server. my connection string is, ------ conn.ConnectionString = "workstation id=BARODA;packet size=4096;integrated security=SSPI;data source=BARODAMYINSTANCE;user id=sa;password=;persist security info=True;initial catalog=SMS" it will give error like..... login fail for user "MERIDIANIUSER_GROUP"
------- conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODAMYINSTANCE;user id=sa;password=;persist security info=True;initial catalog=SMS" it will give error like..... login fail for user "sa"
------- conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODAMYINSTANCE;user id=;password=;persist security info=True;initial catalog=SMS" it will give error like..... login fail for user "(null)"
i can do everything, but error occur everytimes.
when i use this, without instance conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODA;user id=;password=;persist security info=True;initial catalog=SMS" it will run successfully,
I've defined my connection string in the web.config file: <add name="RealtorXConnectionString" connectionString="Data Source=localhostSQLExpress;Initial Catalog=RealtorX;User ID=sa;password=welcome" providerName="System.Data.SqlClient" /> Now I want to get that string and use it in some code where I'm going to run a query against the database. This query happens in PageLoad, and won't be bound to any UI component. How can I replace XXXXX below with the value stored in web.config? Dim strConnection As String = XXXXX Dim cn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(strConnection) cn.Open()
I have completed a windows db app. I have saved the db files in the application/bin/ folder. The connectionstring that i am using is
Code:
sql Server =(local);Data Source=.SQLEXPRESS;DataBase=;Integrated Security=SSPI
say i wanted to install this app on my home computer, does not have sql express or anything installed. Now i want to use the application and it must read/write data from the sql db that was saved in the application/bin/ folder. what is the connectionstring then ?
can anyone please help ? what im trying to say is that the application must work independent from any SQL manager/express etc.
I have changed connection string property of connectionmanger at runtime and saved package.But my new connectionstring is not persisting, i am getting my old connection string after reload package .
ConnectionManager cm = package.Connections[test.ConnectionManagerID];
cm.ConnectionString = @"C:Test.csv";
app.SaveToDtsServer(package, null,
@"File SystemDupaco Load Next Best.dtsx", "CIRCLE");
Hi, does anyone knows where can i find all the values that support the connectionstring??? since the connectionstring uses the "server=local;database=nortwind;UID=me...."
etc. are there more parameteres to specify ?? which one of them is not REALLY important?, where can i find a list or something about it??
When I create typed datasets (for SQL Everywhere db) using the VS designer, I get a connectionString like Data Source =".App_DataDb1.sdf" added to the settings file by the designer. This works fine in the designer but not at runtime. If I replace the settings value to Data Source ="|DataDirectory|App_DataDb1.sdf" then it works fine at runtime but breaks the designer. I looked at the typed dataset designer generated code & it creates a SqlCeConnection object which supports |DataDirectory| macro. So, how can I get the designer & runtime to agree on a connectionString. I guess I can create a partial class for the table adapters & force a connectionString at runtime via a constructor overload, but, is that my only option?
Btw, the error I get at runtime when using the designer generated connectionString is: "The path is not valid. Check the directory for the database."
On the login prompt for Report Server, there is a checkbox option to "Remember my Password." I check this, login successfully... but when returning to the Report Server, I am again prompted for the password, although the user name is saved. No matter how many times I do this, the password will not save in IE7. I have tried this on 3 different computers with IE7. In IE 6, I do not even get the checkbox as an option, just the user name/password prompt. In Firefox, the password saves fine. Any ideas what would be causing this?
hi, I'm having this application using the express way to create the dategridview by having the query string builder. However, my computer recently crashed and I have no idea to change the connection string. so when I load the whole windows application, I am unable to view the information that are supposed to be in the datagridview. however, it returned an exception. after finding out the main culprit, I realised that the database is using the old sql server's login. since it is using the old database's login, therefore it is unable to log the information into the datagrid view. Please help! Thanks.
Hi all, I want to connect to an SqlServer database and I have given the connectionstring on an WinXP computer as Dim ConnectionString As String = "server='localhost'; trusted_connection=true; Database='domains'" Now, when I copied the files to another computer which is Win 2003 Server, I had to give the connectionstring as Dim ConnectionString As String = "workstation id=INFO0;packet size=4096;integrated security=SSPI;data source=INFO0;persist security info=False;initial catalog=domains" Now, I want to upload the files to a website called "BrowseNow.com". What should be the connectionstring when the files are being uploaded to the server. I want the public to read from and write to this database tables. Is there anything I should do witht the SQL Server Enterprise Manager? Thanking you in advance, Tomy
In short, I have a couple grid views on a page that are used for editing as well as sorting, etc. The grids are setup to use the SqlDataSources. I'm trying to deploy this to a server environment for different instances (test,cert,prod) and am trying to set the ConnectionString for the SqlDataSource in the code behind (Page_Load()). Everything works well, except, I get an error message that says the "ConnectionString Property Has Not Been Initialized." Its a javascript alert coming up on top of the grid view. Here is how I'm trying to set the ConnString in the Page_Load():this.EmployeeTimeCardDataSource.ConnectionString = ConfigurationManager.ConnectionStrings[connStr].ConnectionString; Here is an example of the DataSource.<asp:SqlDataSource ID="EmployeeTimeCardDataSource" runat="server" SelectCommand="sp_Select_Managers_Employees_List" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CurrentUser" SessionField="User" Type="String" /> </SelectParameters></asp:SqlDataSource>
I am getting an error message that says that my connection string has not been intialized I have initialized it. Dim AirliquidiConn As New SqlClient.SqlConnection(ConfigurationManager.AppSettings("AirliquidiDatabase")) Any suggestions??
Hi all This is the code in my web.config file. <appSettings> <add key="ConnectionString" value="server=127.0.0.1;database=testdb;uid=sa;pwd=sa"/> </appSettings> When I'm connecting to the sqlserver database,the page shows that The ConnectionString property has not been initialized. The code that I used to get the "ConnectionString" as belows using System.Configuration; protected static string connectionString =ConfigurationSettings.AppSettings["ConnectionString"]; public static object GetSingle(string SQLString,params SqlParameter[] cmdParms) { using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand()) { try { PrepareCommand(cmd, connection, null,SQLString, cmdParms); object obj = cmd.ExecuteScalar(); cmd.Parameters.Clear(); if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))) { return null; } else { return obj; } } catch(System.Data.SqlClient.SqlException e) { throw new Exception(e.Message); } } } }
These code works well on my machine.When running on my colleague's machine ,the page show that exception. Any ideal?
I have a datasource on my ASP.NET 2.0 control I want to make dynamic. I have 6 different connection strings in my web.config file and want to change the connection with the selection in dropdownbox. Here is my VB code:Protected Sub GetDatabase(ByVal intDb As Integer) Select Case intDb
Case 1 ' Americas srcCustomers.ConnectionString = "RWSqlServer" Exit Sub Case 2 ' Asia srcCustomers.ConnectionString = "SGSqlServer" Exit Sub Case 3 ' Australia srcCustomers.ConnectionString = "SYSqlServer" Exit Sub Case 4 ' Canada srcCustomers.ConnectionString = "MSSqlServer" Exit Sub Case 5 ' EMEA srcCustomers.ConnectionString = "NCSqlServer" Exit Sub Case 6 ' NE srcCustomers.ConnectionString = "RUSqlServer" Exit Sub End Select End SubProtected Sub ddlBusinessUnit_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
If (ddlBusinessUnit.SelectedIndex = 0) Then panUser.Visible = False panDistributor.Visible = False panEndUser.Visible = False GetDatabase(ddlBusinessUnit.SelectedIndex) lblDb.Text = ddlBusinessUnit.SelectedIndex.ToString Else
panUser.Visible = True End If End Sub Here is my ASP.NET code:<asp:SqlDataSource ID="srcCustomers" runat="server" SelectCommand="SELECT cm_addr + ' - ' + cm_sort AS [name], cm_addr, cm_sort FROM cm_mstr WHERE cm_type <> 'I'"> </asp:SqlDataSource><asp:DropDownList ID="ddlBusinessUnit" runat="server"AutoPostBack="True" OnSelectedIndexChanged="ddlBusinessUnit_SelectedIndexChanged"> <asp:ListItem Value="" Text="Select One"></asp:ListItem> <asp:ListItem Value="1" Text="Americas"></asp:ListItem> <asp:ListItem Value="2" Text="Asia"></asp:ListItem> <asp:ListItem Value="3" Text="Australia"></asp:ListItem> <asp:ListItem Value="4" Text="Canada"></asp:ListItem> <asp:ListItem Value="5" Text="EMEA"></asp:ListItem><asp:ListItem Value="6" Text="NE"></asp:ListItem> </asp:DropDownList> What am I missing? Do I need to reference the whole connection string or is there a way I can reference the "NAME" id in the web.config file for the connection string?
I tried to insert my inputs into the database but it says "The ConnectionString property has not been initialized."
These are my codes: SubmitAssigment.aspx.vb Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim conn As SqlConnection Dim mycmd As SqlCommand Dim dr As SqlDataReader Dim str As String conn = New SqlConnection(Configuration.ConfigurationManager.AppSettings("ConnectionString")) conn.Open() str = "INSERT INTO [UploadInfo] ([StudentID], [Subject], [Assigment], [File], [Upload], [Time]) VALUES (@StudentID, @Subject, @Assigment, @File, @Upload , @Time )" mycmd = New SqlCommand(str, conn) mycmd.Parameters.Add("@StudentID", Data.SqlDbType.VarChar, 500).Value = User.Identity.Name mycmd.Parameters.Add("@Subject", Data.SqlDbType.VarChar, 500).Value = DropDownList1.SelectedValue mycmd.Parameters.Add("@Assigment", Data.SqlDbType.VarChar, 500).Value = DropDownList2.SelectedValue mycmd.Parameters.Add("@File", Data.SqlDbType.VarChar, 500).Value = File1.PostedFile.FileName mycmd.Parameters.Add("@Upload", Data.SqlDbType.VarChar, 500).Value = "Yes" mycmd.Parameters.Add("@Time", Data.SqlDbType.VarChar, 500).Value = System.DateTime.Now dr = mycmd.ExecuteReader() mycmd.Dispose() dr.Close() End Sub
My IT dept set up an SQL db on a server for me and I am connected to it through a port. They told me I had to create my tables through an MS Access adp, which I have done. I am using VWD Express and am trying to create a login page using usernames and pw's from a db table. I am connected (at least the db Explorer tab shows I am) to the MS Access adp and can drop a GridView from my Employees table from it onto a page and get results. I keep getting the "ConnectionString property not initialized" error message pointing to my sqlConn.Open() statement and cannot figure out why. I have looked at hundreds of posts but can't seem to find anything that works. If someone could point me to some post or website that could explain connecting to a SQL db through a port or whatever you think I need to learn to get this fixed I would appreciate it. Web config: <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings/> <connectionStrings> <add name="ASPNETDB" connectionString="Description=Training;DRIVER=SQL Server;SERVER=USAWVAS27;UID=usx14611;APP=Microsoft® Visual Studio® 2005;WSID=983QD21;Network=DBMSSOCN;Address=USAWVAS27,3180;Trusted_Connection=Yes" providerName="System.Data.Odbc" /> </connectionStrings>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server">
Protected Sub LoginUser(ByVal s As Object, ByVal e As EventArgs) Dim blnAuthenticate As Boolean = Authenticate(username.Text, password.Text) If blnAuthenticate Then FormsAuthentication.RedirectFromLoginPage(username.Text, False) End If End Sub Function Authenticate(ByVal strUsername As String, ByVal strPassword As String) As Boolean
Dim strConnection As String = ConfigurationManager.AppSettings("ASPNETDB") Tried this code as wellDim sqlConn As New SqlConnection(ConfigurationManager.AppSettings("ASPNETDB")) Dim sqlConn As New SqlConnection(strConnection)
Dim sqlCmd As SqlCommand Dim sqlDR As SqlDataReader Dim userFound As Boolean sqlCmd = New SqlCommand("SELECT * FROM Employees " & _ "WHERE username='" & strUsername & " ' AND password='" & strPassword & "'", sqlConn)
