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 |
|
YogiBear
Starting Member
2 Posts |
 Posted - 2012-07-31 : 14:50:31
|
| HelloI am using SQL Server 2008 Express and I have a ready Sql DataBase on my computer. I want to connect to this DataBase from another computer in my LAN network.I have no idea how to do this, How can I know the DataBase IP?Thank you very much :) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-31 : 15:01:51
|
| are the machines in same domain?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
YogiBear
Starting Member
2 Posts |
Posted - 2012-07-31 : 15:06:00
|
| Yes I think so,we are both connected to the same router. |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-08-02 : 08:59:44
|
| 2 more ideas:- you may need to go to SQL Server Configuration Manager and enable some Protocols under the Network Configuration- If your Firewall is on you may need to allow SQL Server through, i.e. add it to the exception list |
|
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-08-04 : 00:31:23
|
quote:
Originally posted by YogiBear
HelloI am using SQL Server 2008 Express and I have a ready Sql DataBase on my computer. I want to connect to this DataBase from another computer in my LAN network.I have no idea how to do this, How can I know the DataBase IP?Thank you very much :)
Connecting how? from a .Net or PHP code? ...It depends of what you mean with connecting.What you usually require is the connection string which is the server name, if you are using a default instance, plus the default SQL port. That connection string is what you write in your piece of code in order to connect to your database.If you just want to connect via Management Studio, just open it and do the same: put the server's name and your login. If you have SQL login there already you will be able to connect as well. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-04 : 11:57:44
|
| To confirm you can see the serever - try a ping test from the command line, although sometimes administrators block this test. You can also try a telnet test - from the command line . This enables you to check the port access.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Connecting to SQL Server from another computer