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 |
|
makko
Starting Member
4 Posts |
 Posted - 2008-06-20 : 16:09:18
|
| Hi Guys,I'm brand new to SQL server and all that and am having a little bit of hassles getting up and running.I have a server 2003 computer running on my lan that I installed SQL server 205 express onto. I have attatched a database that I got with a C# book..When I go into visual studio 2005 on the client to try and connect to te server vs cannot see the server at all.. the only server that displays is the client computer(which isn't a server??) I know there is a valid connection between the two computers because I login to the server using remote access..Also, I have enabled TCP in the SQL server configuration program..I wonder is there any beginnger guides on how to get the whole show up and running??Thanks.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-20 : 16:25:08
|
SQL Server Express is most often installed as an INSTANCE.Use [Machine name]\SQLEXPRESS as database server name.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
makko
Starting Member
4 Posts |
Posted - 2008-06-20 : 16:42:15
|
| thanks for that but i tried it before and it wouldnt work..Even when i go to add new connection and select a .mdf file on my computer it gives an error about a connection. How can i check to see if the computers can connect for SQL purposes?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-21 : 17:43:40
|
| How did you connect to sql? Did you get any error? Tried connect with sql client tools? |
|
|
|
makko
Starting Member
4 Posts |
Posted - 2008-06-21 : 17:55:35
|
| OK well I am now able to add the SQL server to the server explorer in Visual Studio.When I go to:Tools -> Connect to database -> connect to SQL server..I select the server enter my password.In the select or enter Db name nothing appears..And when I go to attach a database I get the following error about:Named Pipes Provider:40 - could not open a connection to SQL server..Thanks for your help so far..I know I should probably just run it locally on my system but that would feel like im giving in to it(can't have that!)..I must do it across a lan.I used Management studio on the client to attach db then Visual studio to try and connect to it(without success!) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-21 : 18:08:38
|
| Works in ssms? May need stick with it. |
|
|
|
makko
Starting Member
4 Posts |
Posted - 2008-06-21 : 18:56:22
|
| ssms? I'm sorry but i'm completely new to servers ad stuff.. I only installed server 2003 the other day along with SQL Server 2005 express. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-21 : 20:51:38
|
| In this case, you can download sql server management studio express from Microsoft. |
|
|
|
|
|
|
Cannot connect(or see) SQL Server in client