Odbc Sql Server Error 231
Contents |
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand
Connection Failed Sqlstate 08001 Sql Server Error 17
Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services microsoft sql server login connection failed sqlstate 08001 Groups Website Testing Store Headlines Experts Exchange > Questions > ODBC error Connecting to SQL 2008 DB Want to Advertise Here? Solved odbc connection to sql server failed ODBC error Connecting to SQL 2008 DB Posted on 2012-03-13 Windows Server 2008 MS SQL Server 2008 1 Verified Solution 6 Comments 1,394 Views Last Modified: 2012-06-27 after creating a sql db and using the sa account
Sql State 01000
to login via a pc or thin client i get this error: Connection failed: SQLState:'01000' SQL Server Error: 231 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Copnnection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. If i log in to the server and run the application it works fine and i can connect to the DB via ODBC just fine using the same information? 0
Connection Failed Sqlstate 01000 Sql Server Error 2
Question by:mogurek Facebook Twitter LinkedIn Google LVL 29 Active 1 day ago Best Solution byPaul Jackson Have a look here : http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/ (http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/) Go to Solution 6 Comments LVL 29 Overall: Level 29 MS SQL Server 2008 11 Windows Server 2008 4 Message Active 1 day ago Expert Comment by:Paul Jackson2012-03-13 Make sure if you have a firewall that port 1433 is open. In SQL Server MAnagement studio on the server, right click the server name and select properties, on the connections page ensure remote connections is enabled. In SQL Server Surface Area Configuration, select Surface area configuration for Services and Connections, UNder database engine > remote connection ensure setting is set to Local and Remote connections. 0 Message Author Comment by:mogurek2012-03-13 Where do i go for the SQL Server Surface Area Configuration? Remote connections is enabled. Thank you for helping. 0 LVL 29 Overall: Level 29 MS SQL Server 2008 11 Windows Server 2008 4 Message Active 1 day ago Expert Comment by:Paul Jackson2012-03-13 Start > All Programs > Microsoft SQL Server 2008 > Configuration 0 Message Author Comment by:mogurek2012-03-13 I have a configuration Tools> >Reporting Services Configuration Manager >SQL Server Configuration Manager >SQL Server Service
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss sqlstate 01000 sql server error 53 the workings and policies of this site About Us Learn more
Connection Failed Sqlstate 01000 Sql Server Error 10060
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault sql server error 14 Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign https://www.experts-exchange.com/questions/27630256/ODBC-error-Connecting-to-SQL-2008-DB.html up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top How do I get this SQL Server ODBC Connection working? up vote 25 down vote favorite 7 Note: I've obviously changed the server names and IPs to fictitious ones. Here's what's going on. I've got http://serverfault.com/questions/82007/how-do-i-get-this-sql-server-odbc-connection-working a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Right on this server itself, I've got an ODBC connection set up pointing at itself, and that already works perfectly. I log in using SQL Server Authentication (not Windows authentication), and it's set up like this: Like I said, that one works. But next, I've got another computer which is on a totally different domain/not on the intranet, that needs to access this same SQL Server hosted on MYSERVER. Because it's on a different domain, it doesn't recognize the name "MYSERVER"; I have to point it at the IP address of MYSERVER, which we'll say is 123.456.789.012. But the ODBC connection doesn't seem to work there. I tried setting it up like this: This doesn't work. When I put in the username and password and press Next, it stalls for a good 10 to 20 seconds, and then finally comes back with the following error: Connection failed: SQLState: '01000' SQL Server Error: 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08
help? Post your question and get tips & solutions from a community of 418,605 IT Pros & Developers. https://bytes.com/topic/sql-server/answers/144188-odbc-connection-sql-server-failing It's quick & easy. ODBC connection to SQL server failing P: n/a Dan Hi, I have an access 2003 database which connect to sql server via a DSN that goes through a VPN. The database works fine and everyone can coonect from their normal computers but for anyone working on their Laptops (IBM Think Pad T42's) they cannnot sql server connect to the datasource. The DSN fails upon connection attempt with : Connection Failed: SQLState: '01000' SQL Server Error: 1326 [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 is denied. This has been driving me insane as i cannot understand why it works sql server error for our desktop computers and not for our laptops. The version of MDAC is the same on a computer that connects as it is on a laptop that doesn't. TCP/IP is enabled on the server and is using the default 1433 port. severs, desktops and laptops all patches and up to date with the latest SP's. DSN has been dropped and re-created. Domain user has been put in localAdmin group for laptop. I hope i'm mising something really obvious....can someone please please put me out of my misery and tell me they have come accross this before and have a solution. Ive tried everything i can think of. Cheers Dan Jul 23 '05 #1 Post Reply Share this Question 3 Replies P: n/a Erland Sommarskog Dan (da************@hotmail.com) writes: Hi, I have an access 2003 database which connect to sql server via a DSN that goes through a VPN. The database works fine and everyone can coonect from their normal computers but for anyone working on their Laptops (IBM Think Pad T42's) they c