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 2003R2
I 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