141 reputation
117
bio website jcpwebs.com
location Fairfield, PA
age 29
visits member for 1 year, 10 months
seen Apr 5 at 1:11

I am a Web Developer and enjoy problem solving and finding new and more efficient ways to do things in my code.


Feb
26
awarded  Famous Question
Sep
27
awarded  Revival
Aug
22
awarded  Teacher
Aug
9
awarded  Notable Question
Apr
10
awarded  Scholar
Apr
10
accepted ODBC Data Source SQL Server Connection - Login Failed For User
Apr
10
answered ODBC Data Source SQL Server Connection - Login Failed For User
Apr
10
awarded  Popular Question
Mar
19
awarded  Autobiographer
Dec
7
comment ODBC Data Source SQL Server Connection - Login Failed For User
The issue was that the server was set to "Windows Authentication Mode" only. To fix this I 1. Right click the server - > Properties 2. Click "Security" in the left side of the "Server Properties" dialog 3. Changed server Authentication to "SQL Server and Windows Authentication mode" 4. Clicked "OK" 5. Restarted Associated services. At first I forgot to restart the services, so I was still getting the error, but now I am able to connect without an issue. This was very helpful: support.microsoft.com/kb/555332
Dec
7
comment ODBC Data Source SQL Server Connection - Login Failed For User
Here is the answer since I am not allowed to answer my own question yet:
Dec
7
awarded  Editor
Dec
7
revised ODBC Data Source SQL Server Connection - Login Failed For User
added 306 characters in body
Dec
7
revised ODBC Data Source SQL Server Connection - Login Failed For User
edited tags
Dec
7
awarded  Student
Dec
7
asked ODBC Data Source SQL Server Connection - Login Failed For User