Tim Huffam

Dotting the I and crossing the T of I.T.

  Home  |   Contact  |   Syndication    |   Login
  153 Posts | 0 Stories | 2747 Comments | 653 Trackbacks

News

Archives

Post Categories

Interesting Blogs/Links

When trying to use sqlcmd.exe - and not specifying the server and instance name I got the following error:

C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqlcmd -E -d master
HResult 0x7E, Level 16, State 1
VIA Provider: The specified module could not be found.
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

 The solution is to simply specify the server (and instance) name eg:

C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqlcmd -S localhost\SQLEXPRESS -E -d master

posted on Wednesday, March 12, 2008 6:00 PM

Feedback

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 5/17/2008 3:03 AM francesco
thanks it just works...

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 5/17/2008 3:03 AM francesco
thank you. it just worked for mw...

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 6/7/2008 6:38 PM Taher
But what is the use of
sqlcmd -S localhost\SQLEXPRESS -E -d master

When I execute this command I get the following output

C:\Documents and Settings\user>sqlcmd -S localhost\SQLEXPRESS -E -d master
1>
2>
3>
4>
5>
6>
Sqlcmd: Warning: The last operation was terminated because the user pressed CTRL
+C.

what should i do please help me out

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 1/31/2009 10:30 PM Robert
very good thanks its working :)

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 4/19/2010 2:46 PM Lucian
Thank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank youThank you

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 4/26/2011 3:34 AM Marko
This is great info thank you very much

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 3/3/2013 11:43 PM Dhora
Appreciate ur help. This just worked for me..

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found. 5/7/2013 1:17 AM may loc nuoc
this website help me a lot


Post A Comment
Title:
Name:
Email:
Comment:
Verification: