System.Data.SqlClient.SqlException: Login failed for user : The Official Microsoft ASP.NET Forums

Reply

ruzhyn

Member

1 Points

5 Posts

System.Data.SqlClient.SqlException: Login failed for user

Aug 26, 2007 03:56 PM|LINK

Help me:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'name'.

Source Error:

Line 205:   using (SqlCommand command = new SqlCommand("GetNonEmptyAlbums", connection)) {
Line 206:    command.CommandType = CommandType.StoredProcedure;
Line 207:    connection.Open();
Line 208:    List<Album> list = new List<Album>();
Line 209:    using (SqlDataReader reader = command.ExecuteReader()) {

Source File: x:\Inetpub\name.domain\personal\mysite.name.domain\www\App_Code\PhotoManager.cs Line: 207

Stack Trace:

[SqlException (0x80131904): Login failed for user 'name'.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
   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) +359
   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
   PhotoManager.GetRandomAlbumID() in x:\Inetpub\name.domain\personal\mysite.name.domain\www\App_Code\PhotoManager.cs:207
   PhotoManager.GetPhotos() in x:\Inetpub\name.domain\personal\mysite.name.domain\www\App_Code\PhotoManager.cs:100

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2040
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
   System.Web.UI.WebControls.FormView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.FormView.EnsureDataBound() +163
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +41
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

*******************************

"Login failed for user 'user'.
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 'user'.

Source Error:

Line 5: void Application_Start(object sender, EventArgs e) {
Line 6:   SiteMap.SiteMapResolve += new SiteMapResolveEventHandler(AppendQueryString);
Line 7:   if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");
Line 8:   if (!Roles.RoleExists("Friends")) Roles.CreateRole("Friends");
Line 9: }

Source File: x:\Inetpub\name.domain\personal\mysite.name.domain\www\Global.asax Line: 7

Stack Trace:

[SqlException (0x80131904): Login failed for user 'user'.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
   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) +359
   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.SqlRoleProvider.RoleExists(String roleName) +482
   System.Web.Security.Roles.RoleExists(String roleName) +242
   ASP.global_asax.Application_Start(Object sender, EventArgs e) in x:\Inetpub\name.domain\personal\mysite.name.domain\www\Global.asax:7

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 "

Edited by ruzhyn on Aug 26, 2007 04:12 PM

Reply

ian.coetzer

Member

363 Points

153 Posts

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 26, 2007 04:27 PM|LINK

Hi, this has something to do with your connection string.

What is the connection string that you are using? (in other words what is in your connection object's connectionstring property?)

Bye

I.W Coetzer

Reply

ruzhyn

Member

1 Points

5 Posts

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 26, 2007 04:34 PM|LINK

Reply

TATWORTH

All-Star

72415 Points

14017 Posts

MVP

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 26, 2007 04:39 PM|LINK

You can investigate what the connection string should be like:

1) Create an empty text file in windows explorer and rename it to X.UDL
2) Double click on it and the datalink provider dialog will appear.
3) Select the provider tab. Find the provider for your data access method and click next.
4) Select your source
5) Test the connection and save it.
6) Compare the contents of X.UDL with your connections string.

Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239

Reply

ruzhyn

Member

1 Points

5 Posts

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 26, 2007 05:59 PM|LINK

Cannot open database "PERSONAL" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

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: Cannot open database "PERSONAL" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Source Error:

Line 205:			using (SqlCommand command = new SqlCommand("GetNonEmptyAlbums", connection)) {

Line 206: command.CommandType = CommandType.StoredProcedure;
Line 207: connection.Open();
Line 208: List<Album> list = new List<Album>();
Line 209: using (SqlDataReader reader = command.ExecuteReader()) {

Source File: x:\Inetpub\name.domaine\personal\mysitedomaine.name\www\App_Code\PhotoManager.cs Line: 207

Stack Trace:

[SqlException (0x80131904): Cannot open database "PERSONAL" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]

Reply

TATWORTH

All-Star

72415 Points

14017 Posts

MVP

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 27, 2007 06:41 AM|LINK

You need to grant access to 'NT AUTHORITY\NETWORK SERVICE' to your PERSONAL database.

Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239

Marked as answer by ruzhyn on Aug 27, 2007 03:01 PM

Reply

ruzhyn

Member

1 Points

5 Posts

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 27, 2007 08:16 AM|LINK

TATWORTH

You need to grant access to 'NT AUTHORITY\NETWORK SERVICE' to your PERSONAL database.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

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: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

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): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
   System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +367
   System.Web.Security.SqlMembershipProvider.CheckSchemaVersion(SqlConnection connection) +85
   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.ImageButton.OnCommand(CommandEventArgs e) +115
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +171
   System.Web.UI.WebControls.ImageButton.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

Reply

SalmonTraini...

Participant

1279 Points

234 Posts

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 27, 2007 11:41 AM|LINK

You've changed the connection string (web.config) entry that points at the membership schema. "Out of the box", the Personal Starter Kit comes with two SQL express databases under \APP_DATA: Personal.mdf and ASPNETDB.mdf. The ASPNETDB.mdf has the membership schema, including the stored procedure your error is failing to find.

A fresh install of the kit sets LocalSQLServer to point at ASPNETDB with integrated security. You've changed the database and also the security setting. I guess that you've switched to SQL Server (instead of SQL Express)? That's fine - but you need to install the membership schema into the SQL Server database.

If you've created a SQL Server database named PERSONAL, then you need to run the aspnet_regsql.exe wizard to install the membership schema into it. Scott Guthrie walks through this process: http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Articles & Training for SQL Server and ASP.Net

Check out our tutorials for going live on GoDaddy

Edited by SalmonTraining on Aug 27, 2007 11:42 AM

Reply

ruzhyn

Member

1 Points

5 Posts

Re: System.Data.SqlClient.SqlException: Login failed for user

Aug 27, 2007 03:00 PM|LINK

Thanks. But......

very simply:

Data Source=localhost;Initial Catalog=ASPNETDB; Integrated Security=SSPI

Data Source=localhost; Initial Catalog=PERSONAL;User ID=personal; Integrated Security=SSPI;Persist Security Info=False;

site ok!

Marked as answer by ruzhyn on Aug 27, 2007 03:01 PM

Reply

flashman

Member

19 Points

23 Posts

Re: System.Data.SqlClient.SqlException: Login failed for user

Jan 10, 2008 01:55 AM|LINK

System.Data.SqlClient.SqlException was unhandled
Class=14
ErrorCode=-2146232060
LineNumber=65536
Message="Login failed for user 'TOMMAGARO-PC\sa'."
Number=18456
Procedure=""
Server="localhost"
Source=".Net SqlClient Data Provider"
State=1
StackTrace:
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at DatasetExample.Form1.Form1_Load(Object sender, EventArgs e) in C:\Users\Tom Magaro\Documents\Visual Studio 2005\Projects\DatasetExample\DatasetExample\Form1.vb:line 25
       at System.EventHandler.Invoke(Object sender, EventArgs e)
       at System.Windows.Forms.Form.OnLoad(EventArgs e)
       at System.Windows.Forms.Form.OnCreateControl()
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ContainerControl.WndProc(Message& m)
       at System.Windows.Forms.Form.WmShowWindow(Message& m)
       at System.Windows.Forms.Form.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.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
       at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
       at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
       at System.Windows.Forms.Control.set_Visible(Boolean value)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.Run(ApplicationContext context)
       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
       at DatasetExample.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
       at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
Connection string is :

("server=localhost;database=pubs;user id=TOMMAGARO-PC\sa;password=")

Thomas Magaro

System.Data.SqlClient.SqlException: Login failed for user RSS

18 replies

ruzhyn

System.Data.SqlClient.SqlException: Login failed for user

ian.coetzer

Re: System.Data.SqlClient.SqlException: Login failed for user

ruzhyn

Re: System.Data.SqlClient.SqlException: Login failed for user

TATWORTH

Re: System.Data.SqlClient.SqlException: Login failed for user

ruzhyn

Re: System.Data.SqlClient.SqlException: Login failed for user

Cannot open database "PERSONAL" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

TATWORTH

Re: System.Data.SqlClient.SqlException: Login failed for user

ruzhyn

Re: System.Data.SqlClient.SqlException: Login failed for user

TATWORTH

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

SalmonTraini...

Re: System.Data.SqlClient.SqlException: Login failed for user

ruzhyn

Re: System.Data.SqlClient.SqlException: Login failed for user

flashman

Re: System.Data.SqlClient.SqlException: Login failed for user

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft

System.Data.SqlClient.SqlException: Login failed for user RSS

18 replies

System.Data.SqlClient.SqlException: Login failed for user

Re: System.Data.SqlClient.SqlException: Login failed for user

Re: System.Data.SqlClient.SqlException: Login failed for user

Re: System.Data.SqlClient.SqlException: Login failed for user

Re: System.Data.SqlClient.SqlException: Login failed for user

Cannot open database "PERSONAL" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Re: System.Data.SqlClient.SqlException: Login failed for user

Re: System.Data.SqlClient.SqlException: Login failed for user

TATWORTH

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Re: System.Data.SqlClient.SqlException: Login failed for user

Re: System.Data.SqlClient.SqlException: Login failed for user

Re: System.Data.SqlClient.SqlException: Login failed for user

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Cannot open database "PERSONAL" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.