Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

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
0
merv11
Asked:
merv11
  • 2
  • 2
1 Solution
 
Roopesh ReddyIT AnalystCommented:
Hi,

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...
0
 
merv11Author Commented:
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.
0
 
Roopesh ReddyIT AnalystCommented:
0
 
merv11Author Commented:
Got it. Turns out it was my attempt at using active directory server referencing, e.g., "\\database_server\instance_name" when in reality it required the FDQN, e.g., "databaseserver.domain.com" without the instance name.

Thanks for the help all the same!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now