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 |
|
bbjojo
Starting Member
1 Post |
 Posted - 2009-09-27 : 23:32:18
|
| Windows authentication failed connect SQL 2000 SP4 instance running in Windows server 2003R2I have an application run in SQL server 2000 in Windows server 2000 without any problems. The installation of the SQL and server 200 works well in mixed mode . There are no special security permission in the database file attached.Recently , my company bough the new server with Windows server 2003 R3 and the application installation successfully with SQL server 2000 SP4.However , when I tried to launch the application , the message prompts - " application failed, unable to find logon server". In order to connect the SQL instance and get rid the error, I must the add the domain users into local administrator of the new server , but this is incorrect as it will exploit the secuity issues. There is no such issue in Windows 2000 server after re-installation , but I really need the Windows server 2003 due to license bundled. Please advice. |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-09-29 : 16:20:51
|
| The sql server account needs specific permissions to run on the machine.This is for 2005, but the theory among service account / file permissions / database access is similar. |
 |
|
|
|
|
|
Failed to connect SQL instance in W2003 server