I have the full version of SQL Server 2005 on my machine under XP. Installed ok and can connect with management studio, but if I try and connect with Analysis Services or even SQLCMD, I get the error below :
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.
I have networking enabled, I've enabled all the protocols (apart from VIA because it doesn't start if you do that), and I have all the services running.
Any ideas what can be up ?
I have now fixed this issue and thought I'd just list what was wrong :
The VIA message was because in desperation to connect I had enabled some VIA connections - I think client side.
I disabled all connection types for both client and server except shared memory and TCP/IP.
Still didn't work - and gave a message that the server refused connection.
I then looked at the server side TCP options and found the port number, using SQLCMD tcp:servername,portnumber I could now connect !!
Finally changed the client side TCP to use this port number and now can connect with SQLCMD and no options.
My main gripe is why didn't it all work as installed and why did I have to go through all this to get it to connect !!!
No comments:
Post a Comment