Hello I 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?
Hello I 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.
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.
Connecting to SQL Server from another computer
Posted - 07/31/2012 : 14:50:31
