Community FAQ
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, 

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now