Cannot Open Database Requested In Login 'Database1' / Login Fails / Login Failed For User 'sa'
Mar 1, 2011I got the above error when i deploy my web application into windows server 2003. How do i resolve it? [code]
View 3 RepliesI got the above error when i deploy my web application into windows server 2003. How do i resolve it? [code]
View 3 RepliesI created a SQL DB named MainDB.mdf and a small VB 2010 application with some forms and datasets.Everything was working OK until i got a new computer and re-installed Visual Studio 2010 and SQL server 2010 on it. I copied my DB from the old to the new computer and also copied by VB 2010 project to it. I used Windows Authentication to connect to the DB in the old computer and also in the new one, i am using different Windows user account names though.
I was able to connect to the DB in the new computer in the Server Explorer section, i created a new connection string to the DB and i can seed there is data in the tables. When i run my VB 2010 application created in the old computer get error:
"Cannot open database "MainDB" requested by the login. The login failed. Login failed for user 'D630Admin'."
I need to get rid of that error and be able to add/mod/del data from my DB using my VB application as i used to.
I followed below attached tutorial but I got this error: Cannot open database "mydb" requested by the login. The login failed. Login failed for user 'NAME OF COMPUTER FOR THE NETWORKUsername'. Second question: When I deploy my application which communicates with SQL server, should I put in the installation file SQL server? If I need to deploy and SQL server, I have to configure server, right? P.S.I use SQL 2005. I changed Authentication Mode of the SQL server to: SQL Server and Windows Authentication mode.
View 12 RepliesI'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 1 RepliesI'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP.I created a database on my local PC HDD. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service.The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 10 RepliesI have an ASP application with Sql Server 2000 database. The application has a login page. It was working fine. But from past few days, some times login fails and some time it works. I looked into the procedure and ASP page but could not find any issue.
View 2 RepliesI had a problem with WebBrowser component. Basically, it works improperly when try to log in on one web-site (Forex Trading Social Network | Online Forex Trading Forum and Social Networking Site). I am working with Visual Studio 2010 Professional. I created a simple WebBrowser trying to access the indicated web-site. The problem begins. Well, the website loads, but when you go to the login page (Forex Trading Social Network | Online Forex Trading Forum and Social Networking Site) and try to log in, it doesn't work. I mean, when I enter the login details the login page just refreshes itself and the login wasn't proceed. The same login page appear with every login attempt. The is the current problem!I check with Google, it works. But, it doesn't work with Forex Trading Social Network | Online Forex Trading Forum and Social Networking Site! Why?
View 14 RepliesI am using the following code to backup my database...
Dim con As SqlConnection
Dim cmd As SqlCommand
con = New SqlConnection("Data Source=.SQLEXPRESS;Initial Catalog=LIC;Trusted_Connection = yes")
[code]...
But I get this error
Cannot open database "LIC" requested by the login. The login failed.Login failed for user 'mono-PCmono'.
I have a login control in my asp.net webform i uses the roles manager...i have two roles admin and vendors i want when user enter username and password in login control then on login button click event it validates either the user is admin or vendors if vendor is admin then it will redirect to default.aspx other wise stay on login page with error. ...how to do this using vb.net ?
View 1 Replieshow can i login when user type password and they press enter that login code can be activiate. What event can be using for this, i m using button_click event. need textbox typed value and press enter it should be login to that next form.
View 1 RepliesAlright, So with this game I am Making with VB I am Confused on how to make the login system to make the registered user to login to his character automatically other then having to make a new character? Here is my login System code not much[code].....
View 3 RepliesI'am trying to make a login system with the dll. I want the .dll file to have the password inside of it and make another interface window that the user can login in.
View 10 RepliesConnection string is "server=192.168.0.191;database=pubs;integrated security=sspi
View 9 RepliesI am currently working with VB.net 2005. I am trying to create a login form and use a text file as a database to login. The part login form is fine but i can't connected to the text file. When i use my coding with a database such as access or mysql is work fine.
[Code]...
How do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
I am debugging my companies program that the previous programmer has created. It is buggy and an annoyance in my life and I want to get this done as quickly as possible. Ive already fixed some bugs and published the updated version onto our server. User installs app, login box pops up and prompts user to input username and password. Here is the sql code for logging in:[code]User tries to log in and I get this error; I will put the code for catching the sqlexception then the error I get when a user tries to log in.Now she is in the Employees table and she has access to the application through the EmpGroupPermissions table. when I install it on my computer and try her username and password it succeeds, but when she tries it on her computer it fails, along with any other computer I try it on.
View 4 RepliesI got a simple error for establishing a connection.The database is 'Nwind.mdb'.The code is very small, I know that it is a username issue. The default user is "Admin". The error is "Login failed for user '' after I clicking a button.
Imports System.Data.SqlClient
Imports System.Data.OleDb
Imports System.Data.Odbc
[code].....
My first time trying to log in to my local sqlserver with VS2010 was greeted by this vague, unhelpful error:
"Cannot open database "Database1.sdf" requested by the login. The login failed.[code]...
I am beginner in Vb.net. I try to connect SQl server from VB.net by ADO.net but has run time error in this line.
connection.open ()
Error say:
"Login failed for user 'SHLap\Shouman'. The user is not associated with a trusted SQL Server connection."
This is my code:
Imports System.Data.SqlClient
Public Class Form1
Dim ConnectionString As String
Dim Connection As SqlConnection
Dim Adapter As SqlDataAdapter
[Code] .....
I just setup my old pc to run SQL Server and VisualSVN. I have a laptop and another pc that i need to work on a website and that is why i setup subversion and sql server on a seperate pc. I have set up VisualSVN and ToirtoiseSVN but im getting SQL Server Problems below is how im connecting to the DB[code]...
View 1 RepliesI'm currently upgrading my sql server from 2005 to 2008 enterprise server. I used VB to connect to the database. It worked fine in the previous version of sql, but when upgrading it seems doesn't recognize my connection string.
Below is my connection string:
myConnection = New SqlConnection("server=RAVY-PCRAVY;uid=;pwd=;database=CIEDC");
myConnection.Open();
Where Ravy-PCRAVY is my server name at the sql server login dialogue box. And I used the windows authentication mode.
error"login failed for user using vb.net2003 program application connect to sql 2000. i have sql2000 server and i created dbname test then i created log in sql name xtops gran permission access on dbname test, but if i created login in windows it works, but i don't want to create log in in windows coz the prog can access dbase even if hte user is not created into dbase.
View 3 RepliesDim sqlConn As New SqlConnection("Server=.\SQLEXPRESS;uid=;pwd=;database=ContactManager")
sqlConn.Open()
Above is my connection string, The programs runs up until sqlConn.Open() and then i get the same error, using no UID and Pass, or using a uid and pass.
Login Failed For User ''. The user is not associated with a trusted sql server connection
I have the SQL Servers authentication se to Windows Authentication and SQL Authentication. I'm using Visual Studio 2005 and SQL Server 2005.
i am having a console application. I am trying to connect to a sql server.
my connection string: Data Source=<Some server>;Initial Catalog=<some database>;Trusted_Connection=True.
when i am executing on my local machine it runs successfully. But when i am trying to run it on a server it is giving me the following error:
Login failed for user ' '. The user is not associated with a trusted SQL Server connection.
do i have to change my connection string? if so what it should be?
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
I have the lines above to login by database. However, I really don't know why always give me the error: "Incorrect fields". I am 120% sure that all the fields of the table are right, including the text that I put into my textboxs. I have already add a user into the database. I can make login in PHP but in VB.NET I just can't.
Try
Dim MySQLConnection As New MySqlConnection("server=localhost; user id=root; password=; database=DB")
Dim MySQLQuery As String = "SELECT * FROM TableLogin WHERE Username = @username AND Password = @password"
[CODE]...
I already tried to show the data of the database into a Datagridview and it works fine, it displays to me all the rows that I had add in the database.
May i know how to change my below login code to support for multi access level login? So that i can differentiate between manager and normal employees login so that i can enable or disable certain features for different department? I have the below code that can serve as a basic login.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'login code can work
conn.Open()[code]......
It is simply a "Y" in the road. If they are Company A, then I want to send the username and password over to that website and log them in as if they typed it in there. If they are Company B, then the same thing but with a different website. I do not know the term for this, so the google results are not very pretty.I can not do this with a query string (not that I'd want to anyway) as I do not want the username/pw to be visible.Here is the other weird thing. This can be done via a simple HTML <FORM> and Submit button as I have tested it. But I want to do it all in VB.NET code. How is it that it is possible with some simple HTML but not possible in VB.NET? I guess it could be a security thing, right? What do the good guys like us do when we legitimately just want our employees to go to one login page, enter their username/pw, and then (based on their username) send them to either pageA.aspx or PageB.aspx which receives their username/pw that they only entered once before on the first page?
View 1 RepliesI've been trying to make a app that logs into a website. So far it didn't work for me.I have trouble because:
- The "pin" (username) box on the site doesn't have an ID. (Can't use getelementbyid)
- The picture doesn't have an ID either
Codes I've tried:
With WebBrowser1.Document
.All("pin").InnerText = "mypinhere"
End With
End Sub
This should have, in my opinion, filled in the textbox. Now I need to click the login button?Also I found this in the source of the site:
<img src="/media/img/text_AccountPin.gif" alt="Account Pin" width="93" height="10" border="0"> <input type="text" name="pin" class="form" size="15"> </p>
As we can see, it says
name="pin"
So I should be able to use "getelementbytagname" right?Also, the formId is logmein (log me in)
<form id="logmein"....
This is what I came up with:
Dim webbrowserDocForm As HtmlElementCollection = WebBrowser1.document.GetElementsByTagName("logmein")
For Each curElement As HtmlElement In webbrowserDocForm
Dim controlValue As String = curElement.GetAttribute("Value").ToString
[code]....
in the next code it's tagname is "input" or "text"? Because I found:
<input type="text" name="pin" class="form" size="15"> </p>
Code for filling in:
webbrowserDocForm = WebBrowser1.document.GetElementsByTagName("text")
For Each curElement As HtmlElement In webbrowserDocForm
Dim controlName As String = curElement.GetAttribute("name").ToString
[code]....
It doesn't give me any errors no more, but it doesn't work either.
For the past couple of days I have been using Visual basic 2008 and learning it.Anyway, I am trying to make a login form that will login to a website with WebBrowser control.and I am noticing that the webbrowser is extremly slow, it takes him about 20 seconds to load a page while mozilla opens it in a moment, why is that?
View 6 Replies