I have the following query that uses a linked server that is on a different VLAN of our network:
[Code]....
It works fine in Query Analyzer but when I put it into Visual Web Developer 2008 Express as a SQL Data Source I get an error:
"OLE DB Provider 'MSDASQL' reported an error. Authentication failed."
I've narrowed the problem down to the following:
Receive "Login failed" for user ASPNET error message SQL Server 2005 is db and IIS is web server (both on same computer) Mixed authentication used on SQL Server I have created user ASPLogin with password that is correctly typed int the web.config:
add
name="masterConnectionString"
connectionString="Data
Source=computernameGMOSERVER;Initial Catalog=Portal;Persist Security Info=True;User ID=ASPLogin;Password=password" providerName="System.Data.SqlClient"
/>
I am able to access my webpages that query the database as long as they are not parameterized.However, the parameterized queries (e.g., SELECT * FROM SUPP_DASH_RESULTS WHERE organization_code = @orgcode) are the ones that do not work, and give me the "Login failed" error message
while i was using sql server authentication, it was running a quite good but suddenly it starts showing an error 'Login Failed for user sa'
Here is my error-Login failed for user 'sa'.
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: Login failed for user 'sa'.
Here is my code-
<add name="MyDB" connectionString="Data Source=ERPTEST;Initial Catalog=LoginDatabase;User ID=sa;Password=sa"
providerName="System.Data.SqlClient" />
I've got this query UPDATE linkeddb...table SET field1 = 'Y' WHERE column1 = '1234' This takes 23 seconds to select and update one row But if I use openquery (which I don't want to) then it only takes half a second.
The reason I don't want to use openquery is so I can add parameters to my query securely and be safe from SQL injections. Does anyone know of any reason for it to be running so slowly?
My website is running well when i used windows authentication In web.config file i used the connection string as follow
<add key="connect" value="Data Source=MMSEEE;Initial Catalog=CCC;Integrated Security=True"/>
When i use sql server authentication i am getting the error like Login failed for user 'sa'. In web.config file i used the connection string as
<add key="connect" value="Data Source=MMSEEE;Initial Catalog=CCC;User ID=sa;Password=***********"/>.
When installing Sql Server 2005 i configured both windows authentication and sqlserver authentication, and i am able to connect with both sqlserver authentication and windows authentication in msserver management studio.
I just installed sql server 2005 to my pc and when i try to log in to the server instance i get an error log in failed for user xxx (error 18456).I browse to the server instance and i keep getting the same error even though i chose windows authentication option during the installation.
I restarted the service for the sql server instance (which is running).The only problem i can think about is a problem with permissions but again there should not be any problem there because i logged in as administrator
How to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
I got an error while sending mail from server, i am using this code:
public static void SendMail(string subject, string body, string from, string to)
{
try
[code]...
This code is working fine in my local system but when i upload it on server then it gives this error. From the last 1 year it was working fine but from last few days it gives me above said error, please suggest me is there any authentication required to send mail from server (my hosting plan is with 1and1.com)
getting below error when trying to display list of providers, i really appreciate feedback on troubleshooting and fixing it.Server Error in '/testload' Application.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.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:ystem.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Source Error:
[Code]....
I am facing the problem to acess the Data Base. some time ago i am easily acess the data base by typing the server name(like 127.80.1.7) and type the user id and password from web.config file but now i am find the error.like Login failed for user 'NSAdmin' (Microsoft Sql Server, Error:18456).
View 3 RepliesI have a long running PageMethod defined in the cs that is being called from javascript and after 4 minutes I am getting the below error and 504 status code for my aspx page and onFail callback is raised.
<HTML><HEAD>
<TITLE>Gateway Timeout - In read </TITLE>
</HEAD><BODY> [code].....
I get the following error "Conversion failed when converting the varchar value ' (' to data type int." when executing this code
View 2 RepliesI'm having a problem in setting up my reportviewer's ReportServerUrl and ReportPath(Server Report's Properties).
View 6 RepliesI'm trying to figure out this error but I can't point out what's exactly causing this.Here is what's happening.User loggs in for a few hours and gets "Validation of viewstate MAC failed" Error after post back.I have set timeout in Web.config as follow.
<authentication mode="Forms">
<forms timeout="540" slidingExpiration="true" loginUrl="~/maintain/login.aspx" />
</authentication>
[code]...
Whenever I have my database open in Visual Studio 2010 Express, I get this error:
Cannot open user default database. Login failed.
Login failed for user 'IIS APPPOOLDefaultAppPool'.
Cannot open user default database. Login failed.
Login failed for user 'IIS APPPOOLDefaultAppPool'.
I have a query in SQL Server 2008:
[Code]....
Everything looks fine but I keep getting the error: 'Conversion failed when converting the nvarchar value 'xxxx' to data type int... where xxxx is the the value of @Query.
I wrote a web service to send emails and some win apps supossed to call the service for sending emails. When I test the service via Visual studio development server everything is ok and it sends emails. But with IIS the smtpclient.send throw an exception whit this message : No connection could be made because the target machine actively refused it [mailserver ip:port] The endpoint for VS development server is [URL] and for iis [URL] The smtp server is remote (gmail) and iis version is 6. I set the current local user as iis anonymous user. I am in LAN and my client firewall is off. There is an ISA server for the internet but I'm using a dialup connection for the internet. So why visual studio can send emails but iis can't?
View 5 RepliesI used Ajax script Manager in new version of my and when i ran on Visual Studio server it worked fine and never shows framework failed error but when i installed on IIS 7.0 Vista webserver and ran across it i got his error. Can Anyone helpme out in solving this issue?..Web.config file:
[Code]....
I am working on Login control and I am new in ASP.NET. So far what I did is :
1. In Website->ASP.NET Configuration I change the form authentication to internet.
2. I created a user profile
3. This gave me a ASPNETDB.mdf database.
4. I added this code :
[Code]....Stack Trace:
[Code]....
[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849015 [code]....
The remote server returned an error: (407) Proxy Authentication Required.I get it when I use the GetReponse() method in WebRequest Dim request As WebRequest = WebRequest.Create(getNextURL()) Dim httpResponse As HttpWebResponse = CType(request.GetResponse(), HttpWebResponse)
View 1 Replies I have created roles and users using ASP.NET configurations for login validations, it works fine if I run my application within project but when I publish my site and try to run from my Inetpub it giving this error. I tried all shorts of solutions posted in website but nothing worked for me.
"Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed"
we have a web application that one company prepared for us. this application read connection string from registery key in hkey_local_machine and connect to sql server 2005 database. It worked correctly in windows server 2003. we changed our Server'OS to windows server 2008. but we have a problem to login. after try to login we see this error: Server Error in '/dabir' Application. Login failed for user ''. The user is not associated with a trusted SQL Server connection. 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: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Source Error:
[Code]....
Stack Trace:
[Code]....
I am connecting to remote server for web service using ASP.NET 3.5 web site. something like, [URL]. Remote server is providing digest authentication to access the web service. I dont have access to modify authentication on the remote server but I have an windows account on that server. If I try to Access service WSDL through programming I get the following error:
The request failed with HTTP status 401: Unauthorized. Same web service if I try to access through browser, [URL], it asks for user name and password. Entered windows account user name and password, still getting error: You are not authorized to view this page, HTTP Error 401.1 - Unauthorized. How to pass the digest authentication credentials to the web service through visual studio or any other programmatic method?
In fact, I DO NOT want to ask a question but to share one solution to this. One cause of this problem is you did not register your sql express on iis.I installed .net 3.5 sp1, then ran aspnet_iis -i, then installed sql express 2005 advanced. Yes, here came the notorious alert. So, I ran aspnet_regiis again and everything is OK.Run aspnet_regiis before you have installed sql express.
View 1 Repliesi'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)