Recently I have completed Inventory control system to my company, back end is sql server 2000.
Initially i installed sql 2000 in my pc, because of it easier to develop this system. It worked without any problem (even from another computer) here is my connection string
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=123456;Initial Catalog=ddd;Data Source=DILUM
Today I installed sql server 2000 to our server which is MS Windows 2000 server sp4. I tried undermention connection string
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=123456; Initial Catalog=StockSS;Data Source=SSSERVER
When I use this connection string, there is a error “login fail for user ‘sa’ error number is -2147467259
Can you help me to overcome this