Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'SERVERNAME\USERNAME'.
SQL Server Information:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.2.3790
Other Information: Single-machine setup. SQL Server is same as IIS box.
This is my first time in SQL Server 2005, and I have very little experience with prior versions. I think I have enabled TCP/IP / Named Pipes through Surface Area Configuration. I have reset the password to ensure that it is correct. In Management Studio, if I expand 'Security', then expand 'Logins' and double-click on my user, I see the following information:
- General Tab: Default database: the database I want to connect to
- Server Roles: I have all of them checked
- User Mapping: databaae is checked, and 'default schema' is db_owner
What are my options to fix this? Please bear in mind that I am a complete novice in SQL Server, so you may have to talk to me as if I were 5 years old (not kidding).