Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greensmile
Starting Member
3 Posts |
 Posted - 2013-07-18 : 02:08:03
|
| Hi,Error: connection failed SQLState: 01000 SQLServer Error: 1326 (Microsoft)(ODBC SQL Server Driver)(Named Pipes)Connection open(Connect()). Connection failed: SQLState: 08001 SQL Server Error: 17(Microsoft)(ODBC SQL Server Driver)(Named Pipes) SQL SErver does not exist or access denied.is the error i get everytime i connect 1 system to the SQL Server 2012 SP1, which runs on Windows 2008 R2 OS.Everyother system on the Network connect alright, but i just a problem with 1 particular client.Please what can i do? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-18 : 02:12:24
|
| Is Mixed mode authentication enabled for the server? If you want to use sql server login, you need to set authentication mode to Mixed------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
greensmile
Starting Member
3 Posts |
Posted - 2013-07-18 : 02:17:59
|
| Yes, Missed mode authentication is enabled.but the error persist |
|
|
|
greensmile
Starting Member
3 Posts |
Posted - 2013-07-18 : 02:19:12
|
| Mixed mode* |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-18 : 02:34:58
|
quote:
Originally posted by greensmile
Yes, Missed mode authentication is enabled.but the error persist
Is this server in same domain as others which you can connect to? Is this inside a firewall? Try adding the port SQL server uses to exceptions list and then reconnecting.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SQL Server login