merv11
asked on
problem connecting to a remote sql server database via webmatrix
I'm attempting to connect to a remote database over an internal network sql server database, on the same network as the workstation I'm connecting from, and I keep getting a "the parameter is incorrect" error. What does that mean? To preface that, I'm new to using web matrix and this is the first time I've attempted to connect to a network server.
Also, worth noting, I can connect to my local installation fine, via both windows authentication and sql database authentication. Any ideas?
Also, it's server 2008
Thanks in advance
Also, worth noting, I can connect to my local installation fine, via both windows authentication and sql database authentication. Any ideas?
Also, it's server 2008
Thanks in advance
ASKER
Thanks for the link Connecting via SQL Management Studio works fine. I do regular work on all our remote DB's daily via SMSS; this is the first web app I've tried hooking to any of them though.
Remote connections are enabled and the rest checks out. My workstation and the db servers are also on the same AD domain. Do you need to implicitly specify the port if it's still set to the default 1433? or will webmatrix already negotiate over the default?
Thanks again for the help.
Remote connections are enabled and the rest checks out. My workstation and the db servers are also on the same AD domain. Do you need to implicitly specify the port if it's still set to the default 1433? or will webmatrix already negotiate over the default?
Thanks again for the help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it. Turns out it was my attempt at using active directory server referencing, e.g., "\\database_server\instanc e_name" when in reality it required the FDQN, e.g., "databaseserver.domain.com " without the instance name.
Thanks for the help all the same!
Thanks for the help all the same!
Try connecting from SQL Management Studio!
Moreover, quick check list - http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx
Hope it helps u...