cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
scott_farrell
Engaged Sweeper

I'm having trouble getting lsconsole.exe to connect to my msde2000 database. I'm a newbie when it comes to sql but I can see the database and tables from another SQL 2000 server on my lan. When I run lsconsole I find "03/02/2005 1:21:04 PM SQL Server does not exist or access denied." I know the service is running and I can see the database. Here is my lsconsole.exe.config


<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="ConnectionString" value="data source=localhost;
persist security info=True;initial catalog=lansweeper;user id=sa;password=password" />
<add key="ConcurrentThreads" value="10" />
</appSettings>
</configuration>

Here is a screenshot of a query on my localserver


Any help is greatly appreciated. BTW this is a great program

5 REPLIES 5
scott_farrell
Engaged Sweeper
Thanks GreenTwiq. That did the trick :w)
GreenTwig
Engaged Sweeper
Hi all!

I had the same issue... you got me thinking with you showing us how to log into the database through Dos.
Instead of "data source=localhost" I put in (in my case) "data source=QLDCMX891S\ECORA" So u should try "localhost\testsql"

That worked for me...

:w)
Hemoco
Lansweeper Alumni
maybe try to replace localhost by 127.0.0.1 (just a thought, don't know if it works)
scott_farrell
Engaged Sweeper

sorry

here it is.

Hemoco
Lansweeper Alumni

Could you please repost your screenshot,