Networks

Ask something
Question Locked

SQL Server 2000

0 helpful
2 replies

by dilumd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by cmiller5400

making sure that the 'sa' account has the same password as your machine?

This discussion is closed to new replies.