Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to connect to SQL Server 2005 without being part of the Windows domain

Posted on 2007-12-02
4
Medium Priority
?
320 Views
Last Modified: 2008-02-01
Hello there Experts,

I have an application on my laptop which should connect to a database on SQL Server 2005.

My laptop is running Win XP Pro and the SQL Server 2005 is running on a desktop, also with Win Xp Pro. This desktop machine is available on our office network domain, and I can easily connect to the database when I log in the network from any workstation.

However, I still need to access the database from my laptop without logging in the network.

Is there anyway I can do that, knowing that when I connect to the network (Just connect network cable, without logging in), I get to see the Server among the list of servers available.

Also, I'm the admin for the desktop server, so I have full right to create users and logins.

Appreciate your help

Is there any way I can connect to the server

0
Comment
Question by:Mehawitchi
  • 2
  • 2
4 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 20392106
Hi,

The key here is using the SQL authentication instead of the Windows Authentication.

Yes there are issues with SQL Authentication in that it isn't as secure as Windows logins, but its needed in some situations.

HTH
  David
0
 

Author Comment

by:Mehawitchi
ID: 20392315
Many thanks dtodd for your reply.

Does this mean I need only to change the connection string on my laptop, or is there any steps that I need to perform on the server?
Thanks again
0
 
LVL 35

Accepted Solution

by:
David Todd earned 2000 total points
ID: 20392327
Hi,

You _will_ need to change the connection string - instead of using a trusted connection, you will need to specify username and password.

You most likely _may_ need to change the setting on your server, to allow SQL authentication.

Cheers
  David
0
 

Author Comment

by:Mehawitchi
ID: 20392472
Thanks David.

That was so helpful
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question