Solved

Troubleshoot connection to SQL Server 2005 on simple Home Network

Posted on 2009-07-04
6
462 Views
Last Modified: 2012-05-07
Hi Experts,

I recently setup a simple home wired network so as not to waste the resource of my old Laptop.
Both Laptops (New and Old) are running XP Professional.

I can access the shared drive on my old laptop fine but here is my problem...... the c:\ drive of my old laptop has SQL server 2005 installed but I cannot access it through ODBC...

Do I have to do an install of SQL server in the shared directory.... Is there a way around this problem?

Please see the ODBC error message below.

Thanks.

Michael.

I know that SQL & ODBC are fine as I can connect via ODBC to SQL but only using my old laptop locally.
ODBC-User-DSN-Error-Message.JPG
0
Comment
Question by:MJOAP
6 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24777743
is the sql server actually running?
what sql server network protocols are enabled on the server?
what sql server network protocols are enabled on the client?


ps: I replaced your BIG 7.2MB bitmap screenshot be a reduced 46kb jpg file ...
0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 24777750
THis is quite probably not a SS2005 problem, per se, but a user permissions problem on the kaptop.  You are going to have to give your new laptop's log in access to the SQL Server, either by way of Windows Authentication or by way of SQL Server authentication.  
The first step would be to see if you can se the SS installation on the old laptop from the new one by way of SS Management Studio or Visual Studion on you new laptop.  If you can't, then you'll need to grant more priveleges to that login on your old laptop.  
If you can, then you'll need to check to see whether you are using Windows or Mixed Mode authentication.  If you are using Windows Authentication, then you need to make sure that you have the new laptop's login that it uses to access the old laptop set up as a User on the SS instance (i.e. in the main security section under the SS Inactance rather than in the individual databases . . . although, you'll need to set it up to have access there as well).
 
0
 
LVL 26

Accepted Solution

by:
tigin44 earned 500 total points
ID: 24779170
check your firewall settings. Did you enabled the the port and add the sql server in exeption list of your firewall settings.? You may try this by disabling firewall on the machine running the sql server.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:MJOAP
ID: 24780445
Hi Experts,

The SQL server is definately running.... I have upsized Access Northwind on the SQL server and created a file DSN ODBC connection locally on the server and all is fine.... the problem is the connection from the other machine.

I have shared my entire C:\ drive on the SQL machine with my other machine.

I am still getting the same ODBC error.

I am using Windows Authentication.

Can I get some help with this please
"If you are using Windows Authentication, then you need to make sure that you have the new laptop's login that it uses to access the old laptop set up as a User on the SS instance (i.e. in the main security section under the SS Inactance rather than in the individual databases . . . although, you'll need to set it up to have access there as well)."

Please see attached files re SQL server.

Many thanks.
0
 

Author Comment

by:MJOAP
ID: 24780454
sorry I forgot to attach screehshots... please see attached
SQL-Login.JPG
SQL-Security-Logins.JPG
0
 

Author Closing Comment

by:MJOAP
ID: 31599807
nobody bothered helping me further
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL HELP 2 87
sql query help 2 52
Can Unique column have more than one Null? 8 53
SQL Server Insert where not exists 24 41
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
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 video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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