How can we help you today? How can we help you today?

Server does not exist or access denied with command line

I've upgraded to SQL Server 2005 and I'm having problems using SQL Compare on the command line. I get the following message:

Registering databases
Error: Error Comparing localhost/Dezign vs localhost/EnterpriseMerchant : SQL
Server does not exist or access denied.
Press any key to continue . . .

I'm using version 5.1 of SQLCompare. Everything works fine in the GUI. I don't think it's a permissions problem, because my windows login is set up as a system admin in SQL Server. This worked fine with SQL Server 2000.

Thanks,
Ben
Ben Mills
0

Comments

2 comments

Sort by
  • Ben Mills
    OK, I found that localhost doesn't work now that I've upgraded to SQL Server 2005 for some reason. I can either use my actual machine (which I don't want to use, because I want this script to be portable across machines) or I can use (local). Can anyone explain this?

    Thanks,
    Ben
    Ben Mills
    0
  • Ben Mills
    I figured out the problem. I'm using the Developer edition of SQL Server 2005 and by default, the TCP/IP protocol is switched off. Turn it on and restart the service and localhost will work again.
    Ben Mills
    0

Add comment

Please sign in to leave a comment.