Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL - sum months, quarter, YTD 9 91
Help with SQL joins 9 43
Updating statistics with error notification email in SQL server 4 72
How to use TOP 1 in a T-SQL sub-query? 14 41
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

912 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

23 Experts available now in Live!

Get 1:1 Help Now