Cannot see SQL Server 2008 on other node!
in [Programming SQL]
|
Prev: Query for merge column
Next: Update order
From: Siegfried Heintze on 14 May 2010 00:41 I have visual studio 2008 installed on my home workstation and visual studio 2010 on my notebook computer issued to me by my employer. For some reason, my employer did not install sql server on the notebook. I have the developers version of SQL Server 2005 installed on my workstation and it seems to work fine when I specify "(local)" when developing data base applications on visual studio 2008. Now should I not be able to use the SQL server on my workstation to write database applications on my notebook computer? What do I specify in the visual studio 2010 on the note book when I right click on "data connections"? I tried specifying the node name and that did not work. I tried specifying "Use SQL Server Authentication" and that did not work. I know I had the write username and password because it worked on the workstation. For the server name, I also tried specifying 192.168.1.111. I know the network connection is good because I'm using remote desktop to connect from the workstation to the notebook. Thanks, Siegfried
From: Erland Sommarskog on 14 May 2010 04:28 Siegfried Heintze (siegfried(a)heintze.com) writes: > I have visual studio 2008 installed on my home workstation and visual > studio 2010 on my notebook computer issued to me by my employer. For > some reason, my employer did not install sql server on the notebook. Some (all?) editions of VS comes with SQL Server Express. They did not include that one? > I have the developers version of SQL Server 2005 installed on my > workstation and it seems to work fine when I specify "(local)" when > developing data base applications on visual studio 2008. > > Now should I not be able to use the SQL server on my workstation to write > database applications on my notebook computer? What do I specify in the > visual studio 2010 on the note book when I right click on "data > connections"? Have you ensured that you SQL 2005 instance accepts remote connections? You configure this in SQL Surface Area Configuration. You can also configure it in SQL Server Configuration Manager under Server Protocols. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: Geoff Schaller on 14 May 2010 22:37 ...in addition to Erland's advice, make sure the target machine's firewall allows SQL Server ports. Geoff Schaller Software Objectives "Siegfried Heintze" <siegfried(a)heintze.com> wrote in message news:uKw7x#x8KHA.4648(a)TK2MSFTNGP04.phx.gbl: > I have visual studio 2008 installed on my home workstation and visual studio > 2010 on my notebook computer issued to me by my employer. For some reason, > my employer did not install sql server on the notebook. > > I have the developers version of SQL Server 2005 installed on my workstation > and it seems to work fine when I specify "(local)" when developing data base > applications on visual studio 2008. > > Now should I not be able to use the SQL server on my workstation to write > database applications on my notebook computer? What do I specify in the > visual studio 2010 on the note book when I right click on "data > connections"? > > I tried specifying the node name and that did not work. I tried specifying > "Use SQL Server Authentication" and that did not work. I know I had the > write username and password because it worked on the workstation. > > For the server name, I also tried specifying 192.168.1.111. > > I know the network connection is good because I'm using remote desktop to > connect from the workstation to the notebook. > > Thanks, > Siegfried
From: Siegfried Heintze on 15 May 2010 20:12 Can you be more explicit in your instructions? I cannot find the SQL Surface Area Configuration. I ran the SQL Server Network utility and saw that TCP/IP and pipes were already enabled. I'm wondering if I am really running SQL Server 2005 or some older version. I also ran the client network utility and saw that TCP/IP was already enabled. Under properties it said the default port is 1433. How do I tell what version I am running? Thanks, Siegfried
From: Siegfried Heintze on 15 May 2010 20:13
Hmmm... Sorry if this appears twice. It is not showing up when I post: Can you be more explicit in your instructions? I cannot find the SQL Surface Area Configuration. I ran the SQL Server Network utility and saw that TCP/IP and pipes were already enabled. I'm wondering if I am really running SQL Server 2005 or some older version. I also ran the client network utility and saw that TCP/IP was already enabled. Under properties it said the default port is 1433. How do I tell what version I am running? Thanks, Siegfried |