November 11, 2011 at 2:49 pm
Hi Everyone!
I'm in the process of designing a database using Access 2010 as a front end and Microsoft SQL express 2008 as a back end via ODBC.
I've been trying to use the upsizing wizard and continuously run into this error to no avail
Connection failed:
SQLState: '01000'
SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect())
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does not exist or access denied.
I'm trying to access SQL Express 2008 on a Server 2003 machine over a local network. The client computer is running windows 7 with Office 2010.
I used Management Studio 2008 to create a test user with SQL Server authentication. Not sure which rolls were necessary but I eventually checked off all Server Roles and all Database role memberships in desperation.
I've Enabled TCP/IP using port 1433 with SQL Server Configuration Manager and configured the firewall appropriately, even disabling it completely to no avail.
Active directory is not installed on the server. Is active directory required for this connection?
This is my very first experience with Microsoft SQL. I had the same access database connect successfully to a MySQL server running on a windows xp pro machine via ODBC with no issues.
Any help would be greatly appreciated!
Daniel
November 12, 2011 at 12:26 pm
Did you restart SQL Server after configuring TCP/IP?
November 12, 2011 at 12:38 pm
Can you connect to the database using Management Studio and logon as the test user you're trying to use with ACCESS? (First step: figure out if it's a SQL permission issue)
November 12, 2011 at 1:57 pm
Are you connecting from the same server where SQL Express is installed? If not, remote connections are disabled by default on SQL Express. You'll need to enable that.
Also, Try connecting using the IP address.
November 12, 2011 at 9:33 pm
Thanks for the replies!
I did restart the service and even the server several times.
I'm going to apply your other suggestions as soon as I'm back at work on Monday and get back to you.
Daniel
November 14, 2011 at 12:23 pm
I am using SQL Express and it is configured to accept remote connections (according to server properties in management studio). I can connect with my test user using management studio from the server itself but not over the local network from my windows 7 machine. The firewall on the server is off.
Here's the error I get when trying to connect from management studio with my windows 7 machine.
TITLE: Connect to Server
------------------------------
Cannot connect to mftserver\sqlexpress.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
Any other suggestions?
Thanks for your help!
November 14, 2011 at 2:36 pm
I solved it! 😀
I didn't have the SQL server browser running!
Moving forward....
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply