Solved

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

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

792 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