November 27, 2008 at 7:43 am
Hi,
This problem is driving me crazy:
- I have a virtual, 64bit 2005EE SQL server SP2, CU9 (v9.00.3282.00) for test purposes.
- Server is accepting remote connections and SQLbrowser is enabled
- I have a domain account which is local admin (say: 'XXXXXXame', password='yyyyy')
- SQL services are using this account to run (which works fine)
If I login to this server (OS login) with this account and do a SQLCmd with a trusted connection, it works fine
These options are not working:
1) If I login to this server (OS login) and do a SQLCMd with the parameters -UXXXXXXame -P yyyyy afterI login to this server (OS login)
2) an admin account on a different server which starts sqlcmd with the parameters -UXXXXXXame -P-yyyyy to connect to the problem server
Which results in:
Login failed for user 'XXXXXXame'
Any ideas?
Wilfred
The best things in life are the simple things
November 27, 2008 at 7:47 am
Wilfred, did you try -UComputername\xxxxx ?
[font="Verdana"]Markus Bohse[/font]
November 27, 2008 at 7:55 am
Thanks for your reply.
Unfortunately, this results in the same error (login failed)
Wilfred
The best things in life are the simple things
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply