Connection Issue...

tomharrish
Member Posts: 5
I work in a Fitness Center with a piece of equipment called the Power Plate.
The machine itself is great, but the usage tracking software it came with is horrible.
It saves all user information on an SQL server.
I have virtually NO knowledge of SQL servers, databases, etc.
I would like to use excel to run queries on customer information, but
I am not having any luck connecting to the SQL server.
I run through the instructions exactly as the "flash tutorial" says.
I get to the "Data Link Properties" window.
My local computer name comes up under "Select or enter a server name."
I choose to "Use Windows NT" security.
But when I go to select a database on the server it takes a minute and an error pops up.
[DBNETLIB][Connection Open (Connect))]. SQL Server does not exist or access denied.
I've asked the all of you for help with accessing the data, and they are of no help whatsoever.
Am I connecting the wrong way?
The machine itself is great, but the usage tracking software it came with is horrible.
It saves all user information on an SQL server.
I have virtually NO knowledge of SQL servers, databases, etc.
I would like to use excel to run queries on customer information, but
I am not having any luck connecting to the SQL server.
I run through the instructions exactly as the "flash tutorial" says.
I get to the "Data Link Properties" window.
My local computer name comes up under "Select or enter a server name."
I choose to "Use Windows NT" security.
But when I go to select a database on the server it takes a minute and an error pops up.
[DBNETLIB][Connection Open (Connect))]. SQL Server does not exist or access denied.
I've asked the all of you for help with accessing the data, and they are of no help whatsoever.
Am I connecting the wrong way?
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions