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 |
|
maine254
Starting Member
1 Post |
 Posted - 2006-06-12 : 17:05:12
|
| I got a Sql Server running on my pc machine. I can access it as a localhost just fine. Its on a network and now I can't access it on other computers. When the odbc asks for the ip of the sql server is that in the normal ip format or the 9.0.1399 number that is next to the name of the server. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-12 : 17:54:30
|
| It is best not to use the IP address in case it ever changes. It is recommended that you use the SQL Server name instead. If you installed a named instance, then you'd specify HostName\InstanceName. If you didn't, then you'd just specify HostName.Tara Kizeraka tduggan |
 |
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-13 : 00:57:20
|
| 9.0.1399 is the version number of your SQL server (in this case SQL Server 2005 initial release). All IP adresses is on the form 1.1.1.1 (four digits ranging form 0-255 seperated by '.').My guess is that you have installed the Express version, and it doesnt have TCP/IP access turned on by default. So unless you asked for it during installation (unchecking 'Hide advanced options') or have done it afterwards (using 'SQL Server Configuration Manager' or 'SQL Server Surface Area Configuration'), then you will need to do that as well.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
|
|
|
Localhost question