April 20, 2009 at 5:53 am
First of all hello to all, my first post - yay!
I am currently a final year student and working on my dissertation where i need to provide a prototype database for the company i am working with. Long story short, it has been determined that i will be using Access 2007 as the front-end and SQL Server as the back-end.
I have already created the database in SQL Server Express 2005 and i now have the task of linking it to Access. To achieve this i have decided to obviously link to the existing database created in SQL Server Express 2005, but in doing so this is where my problem lies.
I need to create a new data source so i select to do so, specify SQL Server as the driver for which the data source is being set up, specify a name (test), and then finish. The create a new data source to SQL Server wizard then opens and this is where i seem to have the problem.
In the which SQL Server drop down box i have the options [local] or KKR (the name of my SQL server) but they appear multiple times, i.e.
[local]
[local]
KKR
KKR
KKR
Now i have tried all of these and proceeded to the next step which asks "How should SQL Server verify the authenticity of the logon ID? to which i have selected both options (i.e. Windows and SQL authentication) only to always receive the following error message each and every time:
Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
If anyone could shed any light on why this might be occurring it would be greatly appreciated! After searching google all morning i cant seem to see what exactly the issues is. I am running both SQL Server and Access on my home desktop, with Windows XP SP3 and im using Norton Antivirus also.
I am so close to finishing the prototype for my dissertation and this is the only issue holding me back, so if anyone has any inpute please please feel free to offer any ideas or suggestions.
April 20, 2009 at 6:44 am
I have also faced this problem with MSSQL Server 2005 Express Edition then i check connectivity from ODBC i give the solution pls go step by step
Start => Control Pane => Open Administrative Tools => Data Sources (ODBC)
u get window with tabs
Go Tab - User DSN => Click on ADD => opemed window => Create New Data Source => SQL Native Client or SQL Server => Finish
You find New Window Create New Data Source To SQL Server
Name = SQLEXPRESS
Description = SQLEXPRESS
select Server or type the name of Server with correct path
Server = COMP1\SQLEXPRESS (your computer name \ SQLEXPRESS)
Click on Next => On next window you have choose Window or Server Authentication and click on Next
Now you have find new window with Change Default Database and Attach Database FileName, if you want to chand default db then click and change. go to Next
On next window you just click on Finish and see the Magic you have find your connectivity.
Test the Data Source
Microsoft SQL Native Client Version 09.00.1399
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
if you shown this msg then you have done. and click on ok Button
Ok so i think i have solved my own problem! 😀 After stumbling across this here.[/url]
Basically i think it was an issue with what i was entering for the server name/path - :blush:
By specifying KKR\SQLEXPRESS instead of the [local] or KKR options it was working fine! At least it did for the test i set up so now i have to do it for the real thing!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply