March 27, 2008 at 9:53 pm
When I connect using SQL SERVER MANAGEMENT STUDIO, i get following error:
The type initializer for 'AsyncWmiBinding' threw an exception. (Object Explorer)
Additional Information: unable to load 'sqltoolsvsnativehelpers.dll': Access is denied. (Exception from HRESULT: 0x80070005(E_ACCESSDENIED))(Object Explorer).
Then I try to start sqlcmd in DOS, i got following error:
F:\Documents and Settings\Administrator>sqlcmd
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
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.
Please guide me to resolve my problem.
Regards
March 27, 2008 at 11:50 pm
can you ping server?
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 12:59 am
yes
March 28, 2008 at 1:05 am
check this http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 3:00 am
Hi
Are the network protocols enabled. Are you connecting from a network?
"Keep Trying"
March 28, 2008 at 3:21 am
.
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.
Is this a remote server? Where is the server name in sqlcmd?
March 30, 2008 at 9:17 pm
actually, I am working on the server, where sql server is installed.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply