Geeks With Blogs

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

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 OS/Networking/Misc Apps , SQL Server | Back to top


Comments on this post: SQL Server 2005 error: VIA Provider: The specified module could not be found.

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
thanks it just works...
Left by francesco on May 17, 2008 3:03 AM

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
thank you. it just worked for mw...
Left by francesco on May 17, 2008 3:03 AM

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
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
Left by Taher on Jun 07, 2008 6:38 PM

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
very good thanks its working :)
Left by Robert on Jan 31, 2009 10:30 PM

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
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
Left by Lucian on Apr 19, 2010 2:46 PM

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
This is great info thank you very much
Left by Marko on Apr 26, 2011 3:34 AM

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
Appreciate ur help. This just worked for me..
Left by Dhora on Mar 03, 2013 11:43 PM

# re: SQL Server 2005 error: VIA Provider: The specified module could not be found.
Requesting Gravatar...
this website help me a lot
Left by may loc nuoc on May 07, 2013 1:17 AM

Your comment:
 (will show your gravatar)


Copyright © Tim Huffam | Powered by: GeeksWithBlogs.net | Join free