Solved

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

Posted on 2007-12-02
4
313 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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now