Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TexMurphy01
Starting Member
1 Post |
 Posted - 2011-05-13 : 11:23:24
|
| Hi there... okay I'm not sure if this is the best place for this question, but I figure at least someone here might be able to point me in a good direction. I have very little SQL knowledge, so please be gentle.Okay, so I set up a remote SQL database (in order that I can connect to it from my Silverlight application) (actually, I followed this: http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/). Basically that involves making sure the SQL Server Browser service is running, enabling TCP/IP and making sure the server is set to 'SQL Server and Windows authentication mode'. Well that's what it covers in the linked article anyway.So I open up my Silverlight and create this ADO.net Entity Data Model (the thing that connects to the SQL) and you get a set of connection properties you need to fill in.Data Source (pre-set here to Microsoft SQL Server (SqlClient).Server name (I've put in the IP here).Windows or SQL Server Auth radio buttons (I selected the latter) and a user name and password for the latter (I set up the 'sa' account on the SQL server and used that). Database name (I put in just the name of the database from SQL - 'HVD01' in this case).So if I test connection as it stands (there's a button to do that), I get 'error 40' - could not open a connection to SQL server.So then I looked some things up and some people suggested I try a specific port, the default apparently being 1433. So I appended the IP address with a colon and 1433. I tested the connection again.This time I get 'error 25' - connection string is not valid. Let me say though that this seems pretty much all automated. I don't know what the connection string is or how to change it. I assume it's created automatically by the details I enter into the boxes. Some people asked me if I can ping the server. Yes I can. I can also log onto the server remote desktop style (which is how I was able to make the changes to the SQL server).Any help or suggestions would be great. Thanks a lot! |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-05-13 : 11:39:13
|
| The link you have in your post describes using SQLEXPRESS. If you are using the express edition, you should use Servername\SQLEXPRESS in the ServerName box in the connection properties dialog.One way to figure out whether you are using the default instance or something else (such as SQLEXPRESS) is to connect to the server box using RDT and look at the server name in the object explorer in SSMS. |
 |
|
|
|
|
|
Unable to connect to remote SQL 2008 R2 DB