prlit
asked on
Connecting to SQL database - odd issue.
We've just implemented a SQL express database with an Access front end. Really nothing big at all. We have 5 computers connecting to it just fine. My PC however is giving me issues. A little background: I was on a domain at one point. I took myself off the domain assuming that would allow me to connect to the database - it did not. I am using the administrator account on my PC. We're using SQL authentication for this database.
I use access and navigate to "Connect". I use the drop box and it sees the SQL server. I enter my credentials and type in the name of the database.
Once I hit connect I get: [DBNETLIB][ConnectionOpen (ParseConnectParams()).]In valid Connection.
If I click "Test Connection" I get: Test Connection failed because of an error in initalizing provider. I also sometimes get an error referencing a catalogue.
On the server's event log, I get:
Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18452
Date: 1/29/2007
Time: 2:02:49 PM
User: N/A
Computer: XCALIBUR
Description:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.26]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 14 48 00 00 0e 00 00 00 .H......
0008: 14 00 00 00 58 00 43 00 ....X.C.
0010: 41 00 4c 00 49 00 42 00 A.L.I.B.
0018: 55 00 52 00 5c 00 53 00 U.R.\.S.
0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
0028: 50 00 52 00 45 00 53 00 P.R.E.S.
0030: 53 00 00 00 07 00 00 00 S.......
0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
0040: 65 00 72 00 00 00 e.r...
I use access and navigate to "Connect". I use the drop box and it sees the SQL server. I enter my credentials and type in the name of the database.
Once I hit connect I get: [DBNETLIB][ConnectionOpen (ParseConnectParams()).]In
If I click "Test Connection" I get: Test Connection failed because of an error in initalizing provider. I also sometimes get an error referencing a catalogue.
On the server's event log, I get:
Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18452
Date: 1/29/2007
Time: 2:02:49 PM
User: N/A
Computer: XCALIBUR
Description:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.26]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 14 48 00 00 0e 00 00 00 .H......
0008: 14 00 00 00 58 00 43 00 ....X.C.
0010: 41 00 4c 00 49 00 42 00 A.L.I.B.
0018: 55 00 52 00 5c 00 53 00 U.R.\.S.
0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
0028: 50 00 52 00 45 00 53 00 P.R.E.S.
0030: 53 00 00 00 07 00 00 00 S.......
0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
0040: 65 00 72 00 00 00 e.r...
ASKER
I'm using a username and password. I'm not uing Windows authentication.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are a genius! The ODBC worked once I switched my connection method from TCP/IP to "Named Pipe". Not sure what any of that means but...Thank YOU!
No worries - you might want to read the following for some background info.
http://msdn2.microsoft.com/en-us/library/ms187892.aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1a_7fcj.asp
http://msdn2.microsoft.com/en-us/library/ms187892.aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1a_7fcj.asp
It looks like the server is not receiving a username - see that user is N/A and '' in the error message. Are you trying to logon with Windows authentication, or a username and password? If windows authentiacation - I'd say that you will most likely need to be on the correct domain.
Cheers,
Hillwaaa