Solved

Troubleshoot connection to SQL Server 2005 on simple Home Network

Posted on 2009-07-04
6
466 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 143

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

729 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