Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Magnetar4
Starting Member
2 Posts |
 Posted - 2007-10-05 : 09:37:56
|
Afternoon everyone!I would really be grateful for some advice regarding the above matter (note: am novice to the 'client/server' implementation, so would ask for your patience, pls!):We have a front-end Access 2K app’n, which connects to some back-end data, (using a 'dsn-less' ODBC link (Access table)). The system was not in use for several months, during which time the server was re-built. The problem I’m having is that although I can connect to the back-end data, the other users are unable to do this.I have been looking into the problems/issues encountered so far, including:· - Updating the dsn-less connection table within the front-end Access application (note: we have other applications which use this method for connectivity, without any problems here), i.e.ODBC;Driver={SQL Server};APP=Microsoft Access;UID={updated username};PWD={updated password};Server={name of server};DATABASE={name of database on server}· Re-visiting the ‘ODBC Data Source Administrator’ and checking the configuration of the ‘Microsoft SQL Server DSN Configuration’ (i.e. ‘Window authentication, using the network login’, etc).The strange thing is that I’m able to access the back-end data, via the application without any problems at all (I’m using the full version of MS Access 2K, as need to eventually make changes to the front-en app’n. All of the users have MS Access 2K run-time only installed).However when the user tries to log, they acquire ‘ODBC—connection to {Access application name} failed’ messages.Up to three other users have tried to access the system, and acquire error message of the following nature:Within the front-end application: · ‘The {Access application name} is not available (Error No: 3151. Error: ODBC—connection to {Access application name}’ failed.)· (1) Initially the user obtains the message: ‘The expression you entered has a function that ‘{Access application name}’can’t find.’ Then (2) I receive an ‘Action Failed’ on the ‘AutoExec’ macro (this is set up to execute a function which acquires the user’s window’s login details). Linking to the back-end data:· Connection failed: SQLState: ‘28000’. SQL Server Error: 18456. [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘{domain_name}\{users_Windows_login_name}’.· Whilst user was logged in at my desktop, I tried to implement a ‘SQL Server ODBC Data Source Test’. However the ‘Test Results’ have been as follows “Microsoft SLQ Server QDBC Driver Version 03.85.1117. Running connectivity tests… Attempting connection [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘{domain_name}\{users_Windows_login_name}’.We currently have other client/server applications which link using the above methods (ODBC dns-less connections, etc), but have no problems with the user’s and their permissions to access these.Would appreciate any help/suggestions/advice, etc with this.Many thanks in advance.Magnetar4 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-10-05 : 19:24:05
|
| I'm sure the gurus have a better answer but have you checked that the sql server is set up in mixed authentication mode? Right-click server instance and you'll find it under authentication in properties somewhere...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 22:39:50
|
| Did you add those users as sql login in sql server yet? |
|
|
|
Magnetar4
Starting Member
2 Posts |
Posted - 2007-10-07 : 10:23:18
|
quote:
Originally posted by rmiao
Did you add those users as sql login in sql server yet?
Hi, Magnetar here.Many thanX for your responses, Guys.rmiao, in regards to your suggestion above (adding the users 'as sql login in sql server'), - is this something that the server administrators should have implemented after the re-build/maintenance work was completed?[Note: I can only access the data via the front-end app'n (i.e. via 'File' -> 'Get External data' -> 'Link tables...). I have no access to the SQL server db's (- as am not a SQL server DBA!), - apart from connecting to the data, via the 'ODBC Data Source Administrator’, within Control Panel. Normally I wouldn't even need to do this, as some 'dsn-less' connections have been set up previously (- I didn't implement these either!!), for all our front-end app'ns, as needed]. Would appreciate a confirmation on this, and/or any further suggestions. Many, many thx in advance.Kind regardsMagnetar |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-07 : 20:50:52
|
| You should work with your dba since they know your sql server better than us. |
|
|
|
|
|
|
|
|
Connectivity error(s) after re-build