View Single Post
  #1 (permalink)  
Old January 9th, 2008, 12:00 AM
stupid stupid is offline
Registered User
Join Date: Jan 2008
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Login failed for user 'username'.

Ok, I have done this a million times before, but this time I am running into a SQL authentication problem that I can not diagnose.

I am running SQL 2005, Server 2003 and ASP.NET 2.0 (3.5 is installed as well)

I have both SQL Server and Windows authentication enabled in SQL server mgmt studio. And I have created a login 'username' under the security->logins tab as well - that user has sysadmin server roles. Yet, when I use my application (that works on another server by the way) I get this error:

Login failed for user 'stan'.

 This is my connection string:

<add name="conString" connectionString="Data Source=localhost;Initial Catalog=tablename;User Id=username;Password=password;" providerName="System.Data.SqlClient"/>

Any ideas? Thank you

Reply With Quote