Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'Gullanian'.
I've created the database 'Scirra'. I've also attempted to add a login, but nothing seems to work. Logging into SQL management via Windows Authentication is the only way I can gain access to my DB's.
Ideally I just want to create a user, and that user having full control of DB. So I can run scripts etc.
Here's a few details:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4952
Operating System 6.1.7600
Idk why it says v2 for asp.net, all my application pools are set to 4.0.
I'm using an Oracle database(10g) which contains a stored procedure called Foo. Foo takes 2 datetime as IN parameters and 1 cursor as OUT parameter. I've been trying to make the connection and the query to the database with the OleDbCommand, but since Foo needs a cursor I have no choice but to use a OracleCommand(right?).When I try to connection to the database I get the following error : "OCIenvCreate has failed return code -1". I've gived the correct permissions to ASPNET user for the oci.dll file so that it can read and execute it. Unfortunately, I still get the same error and I'm lost.Here is what cause the error
I recently upgraded a WinXP machine that had been running VWD 2005 to a Win7 machine using VS 2010. The application targets .Net 2.0, but since the upgrade, I cannot get VS to connect to my database and this is the first time I've tried working on the site since upgrading, so no changes have been made to any code (with the exception of trying to change my connection string so I can connect). The specific error is:Cannot open database requested in login 'dbName'. Login fails. Login failed for user 'SqlLogin'The sql database is on another machine and I was assigned the login/password; I know the login works because I can connect to it with SQL Server Management Studio. Having read several posts and still having trouble, I tried to do a couple things. First I modified my web.config connection string, which looks like this:
[Code]....
When that did not work, I deleted the connection string from the web config and dragged a sqldatasource control onto a page and tried to use the connection string builder while in design mode. Then the error I got was:The database db1 does not exist or you do not have permission to see it. Would you like to attempt to create it?I'm not sure I understand that there is a problem at all, except that I upgraded the OS/IDE. I'm using IIS 7.5 on my local machine to serve the development site while connecting to the development sql server on the other machine. Since I can't use the IIS aspnet account on the remote sql server and my assigned login is verfied working through sql management studio, what else can I do to get my developement site working again?
I have asp.net application, using LINQ to connecto to SQL Server 2008 R2 databse. My connection string: Data Source=[SqlServerIp];Initial Catalog=[databaseName]User Id=newLogin;Password=newPassword; When I deploy application on my local IIS (which is not the same machine as database server)
it works fine, but when I deploy application on other IIS (the same machine as sqlServer) it throws an exception: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. how to fix it? Maybe it is due to some bad configuration of IIS?
Server Error in '/' Application. The transport failed to connect to the server. 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.Runtime.InteropServices.COMException: The transport failed to connect to the server.
In the VS2008, everything works just fine. But after deploy app to the IIS7, tried to access SQL Server 2008 on the same PC, I got the following errors:
[SqlException (0x80131904): Login failed for user 'NT AUTHORITYNETWORK SERVICE'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
i'm using asp.net 3.5 and my site is hosted on godaddy i have a contact us form on the site. and i have to send the contact queries on [URL] which is hosted on godaddy. whenever i try sending mails i get this error
The transport failed to connect to the server.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: The transport failed to connect to the server.
Source Error:
[Code]....
Line 250: SmtpMail.SmtpServer = "smtpout.asia.secureserver.net"; Line 251: mailmsg.Priority = System.Web.Mail.MailPriority.Normal; Line 252: SmtpMail.Send(mailmsg); Line 253: } Line 254: }
i tried changing smtp to relay-hosting.secureserver.net aswell. but it didn't work. i'm using this method of my classfile's sendmail class public void SendMessage(string From, string ToEmail, string subject,string body)
I have created a web application and an SQL database using Web Developer 2010 Express. I have SQL Server 2008 and SQL Server Management Studio Express. In order to deploy the database to my hosting space I need to create a .BAK file from my new database. I think I can do this from with the Management Studio, but can't figure out how to get it to connect to the database. I have used Management Studio before to retore another SQL database and the only connection I see when I open the Management Studio is the old connection to the old database. How do I connect to my new database?
I'm using VSTS 2K8 and I've set up a Unit Test Project. In it, I have a test class with a method that does a simple assertion. I'm using an Excel 2007 spreadsheet as my data source.
My test method looks like this:
[Code]....
As indicated in the method decoration attributes, my Excel spreadsheet is on my local C:/ Drive. In it, the sheet where all of my data is located is named "Sheet1".I've copied the Excel spreadsheet into my project and I've set its Build Action = "Content" and I've set its Copy to Output Directory = "Copy if Newer".
When trying to run this simple unit test, I receive the following error:
The unit test adapter failed to connect to the data source or to read the data. For more information on troubleshooting this error, see "Troubleshooting Data-Driven Unit Tests" (http://go.microsoft.com/fwlink/?LinkId=62412) in the MSDN Library. Error details: ERROR [42S02] [Microsoft][ODBC Excel Driver] The Microsoft Office Access database engine could not find the object 'Sheet1'. Make sure the object exists and that you spell its name and the path name correctly.
I've verified that the sheet name is spelled correctly (i.e. Sheet1) and I've verified that my data sources are set correctly.Web searches haven't turned up much at all. [Code]....
and I'm trying to use that to submit to my database, but when I click on the submit button, no data is being inserted into my database, but I'm also not receiving any errors.
I moved to ASP.NET from PHP where the queries are run directly. So I always create Connection in the Page_Load Event, dispose it after I do all stuff needed, and access data with NpgsqlCommand. (Yes, I use Postgresql in my ASP.NET applications.)
After starting to learn ASP.NET MVC I was amazed how easy it is to access SQL with the LINQ to SQL thing. But... It works only with MS SQL. So my question is how to implement the same functionality in my applications? How to connect to databases easily?
I wrote my own wrapper classes for connecting to Postgresql. 1 class per a table.
This is a part of the Student class:
[Code]....
So as you see the problem here is that with every INSERT, DELETE, UPDATE request I'm using Connect() method which connects to the database. I didn't realize how stupid it was before I had to wait for 10 minutes to have 500 rows inserted, as there were 500 connections to the database.Using pooling while connecting does help, but still making the connection and making the server check the pool during every single query is stupid.So I decided to move Connection property to a static DB class, and it didn't work either, because it's a really bad idea to store such objects as connections in a static class.I really don't know what to do know. Yes, there's an option of manullay creating the connections in every Page_Load event and close them in the end like I'm doing it right now.
I am building an MVC application with C# as my language which is hosted on Widows 7 IIS. A call to Add a new member to the database works, but when attempting to save the change I get the following error:
Cannot open user default database. Login failed. Login failed for user 'IIS APPPOOLmyApplication'
The SQL table was added just by adding it within VS.
i would like to use asax to check my database for every 5 min. if let say the database detect high in threshold.. it will send a notification to administrator. Anyone have done this before mind to share some code?
I have already created the database for my website, however when i create the webforms such as a student sign up form i dont know how to connect the text boxes to the database to its relevant table, so data can be updated and deleted. I am aware of the grid view and form view tools but when using those tools I can't seem to move the labels and text boxes around the webpage for design purposes.
so this is my first Solution using the Entity Framework (EF). Here are my steps so far:
1) Created Database named: BSA with an owner of username/password (AspNetServicesUser/password) 2) Created Entity Data Model (EDM) in a separate project (contained within the same solution) 3) Created an ASP.NET Web Application with basic functionality (new project within the same solution) 4) Added Reference to the EDM in Web App and added Connection String to the EF 5) Decided I wanted ASP.NET Membership added to the Web App 6) Configured SQL Server for Application Services using aspnet_regsql.exe on BSA database
Now, I need to know:
a) How do I create the connectionString for the Web.config file in the WebApp?
Errors I receive:
I get this error using the ASP.NET Configuration Tool under the "Security" Tab:
Login failed for user 'AspNetServicesUser'.
I get this error using the ASP.NET Configuration Tool under the "Provider" Tab --> Select a single provider for all site management data --> Test
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
I've got a situation where it seems I am required to have an identity impersonate statement in my compiled web app, i.e. <identity impersonate="true" username = "mydomainmyusername" password ="xxx" /> The thing is, it is not required when running from Visual Studio and virtual web server, as everything works fine, but when I do not have the <identity> tag in the web.config file in my compiled web app, I get a connection error. Simply won't connnect to the database if the <identity> tag is not there. I'd rather just do away with this requirement, and have been looking through IIS for a solution, but can't seem to find any.
i red some stuff, and what i got is that mvs normally works not directly with MSSQL on pc but witht he one it creates within project.. hm.. like that, and you can not see the database created from the project in normal SQL server databases.
