[dba-SQLServer] Browsing tool?

Andy,

The .udl will allow you to test the connection and will let you know if the username and password you provide (or Windows Authentication) are valid ways of connecting.

-Chris Mackin

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Andy
Lacey
Sent: Thursday, October 07, 2004 12:39 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Browsing tool?


Thanks Francisco
That'll help ascertain if it's Sql Server, but presumably the database can
be secured and prevent me linking to it. So I was looking for a "browsing
tool" to check whether that is the case or if I can freely get at the data.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Francisco Tapia
> Sent: 06 October 2004 22:36
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Browsing tool?
> 
> 
> Additionally the Machine that is said to have the Sql Server 
> on it, look for a service running named: MSSQLSERVER, where 
> the executable file name is sqlservr.exe
> 
> 
> 
> On Wed, 6 Oct 2004 14:08:24 -0600, Mackin, Christopher 
> <cmackin at quiznos.com> wrote:
> > One simple way is to just create a text file and then rename it to 
> > .udl.  Once you open it you can set up a connection to it using the 
> > avaialble Providers.
> > 
> > -Chris Mackin
> > 
> > 
> > 
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com]On 
> Behalf Of Andy 
> > Lacey
> > Sent: Wednesday, October 06, 2004 1:53 PM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: [dba-SQLServer] Browsing tool?
> > 
> > Hi folks
> > 
> > Next week I'm going to see a potential client (hurrah!). He 
> has a 3rd 
> > party package specific to companies in the printing industry, and 
> > wants a simple contact management system which will link to 
> the client 
> > data in this package. I suspect (but am not sure) that the package 
> > uses a SQL Server database. If I'm correct (and I've 
> already asked how 
> > best to see if it's SQL Server d/b, thanks for help on 
> that) and it is 
> > SQL Server then I'd like to see if I can link to it 
> successfully. So, 
> > if I start from the worst case scenario that they won't have any 
> > software capable of linking to SQL Server does anyone have 
> or know of 
> > any free utility which will fit on a CD that I could use 
> just to look 
> > at a database, whatever the OS and whatever the SQL vintage?
> > 
> > -- Andy Lacey
> > http://www.minstersystems.co.uk
> > 
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 
> > 
> > 
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 
> > 
> 
> 
> -- 
> -Francisco
> <a href="http://pcthis.blogspot.com">Pc This! pc news with 
> out the jargon</a> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com