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 |
|
meetsavvy
Starting Member
6 Posts |
 Posted - 2007-06-30 : 17:24:02
|
| HiI have a DTS master package that runs on the live server (Cin01). I have created a test server(dev01) and replicated everything from the live server to this test server including the DTS package.The DTS package runs fine on Cin01 but i get an error " invalid login for sa" on the Test server(dev01).The DTS package on the test server(dev01) shows Cin01/mainsaver as the owner, which is my login for the live server.My login for these servers are as follows:Live server (Cin01): Cin01/mainsavertest server (dev01): dev01/mainsaverI am getting "invalid login for sa" . i have tried changing this login in the connection string to mainsaver. Then i get invalid login for mainsaver.Can someone help please???Can someone help please? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-30 : 21:39:11
|
| Did you enable sql authentication on dev server? |
 |
|
|
meetsavvy
Starting Member
6 Posts |
Posted - 2007-07-01 : 05:57:32
|
| Thank you very much for your reply. yes i have and i am still getting this error. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-01 : 20:35:07
|
| So you can logon dev server with sa account? Tried reset id/pwd in the package on dev server? |
|
|
|
meetsavvy
Starting Member
6 Posts |
Posted - 2007-07-02 : 17:20:45
|
| No i can't login to the dev server as sa. I login as mainsaver. It is still not working. I am not sure what's happening? where i am going wrong? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-02 : 17:39:20
|
| If you want to login as SA, you have to know the password.CODO ERGO SUM |
|
|
|
meetsavvy
Starting Member
6 Posts |
Posted - 2007-07-04 : 05:40:54
|
| I've changed the sa password, and tried it again. Still no luck. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 17:26:50
|
| Did you really enable sql authentication on sql server? |
|
|
|
|
|
|
invalid login for sa