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 |
|
great_mamun
Starting Member
14 Posts |
 Posted - 2009-10-17 : 23:31:31
|
| Dear All,I am using SQL Server 2000 (server version), and recently I upgraded my windows from Windows 2000 server to Windows 2003 server. I have two webservers i) IIS, and ii) Apachee. When I tried to connect from my web page to database server it produced unable to connect Sql server, not associate any trusted connection or user/pass. It was working on Windows 2000 server, but not working Windows 2003 server. I tried to update SQL Server 2000 Desktop Engine for Windows 2003 Server but failed.Can anyone helps me regarding above matter.Best Regards,Abdullah Al Mamun |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-10-18 : 11:31:01
|
| Did you reinstall SQL Server correctly after upgrade? Did you configure MSDTC correctly which talks with webservers? Also enable remote connections. |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-10-30 : 15:58:59
|
| Did you recreate the user accounts your webserver uses to connect to the sql database.You will likely want to used mixed authentication mode as well. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
problem sql server 2000 in windows 2003 server