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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2005-04-14 : 10:05:55
|
| OK, I can't figure out (nor can anyone here) why I used to be able to connect to an instance I built, when I used to be able to, and some people I distributed to an Access Data Project still can.I can connect using an alias, but I'm wondering how I can distribute the "app" with an Alias and ODBC.I'd prefer to figure out why I can't connect to the instance.I'm thinking it has something to do with DNS, but I havn't a clue.I just found out that the service center had the wrong ip in DNS for the box. By using nslookup, we saw it was wrong.But how do we do that for an instance? It keeps saying that it's a nonexistant domain.Any direction would be most appreciated.Brett8-) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-14 : 13:24:23
|
| OK, I was able to set up an ODBC Connection using the Alias...but that's no good unless I can set up the alias on client machines that don't have sql server tool installed...Brett8-) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-04-14 : 13:31:29
|
| Use PING?If you can't PING the name then you ain't got DNS resolving, and ODBC ain't going to find it either. Dunno if that's helpful though?Kristen |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-14 : 13:51:32
|
| You can't ping an instance can you? I thought you could only ping the server...I'll give it shot....Who managers your dns?Brett8-) |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-14 : 16:06:47
|
| Ping will at least tell you whether or not the server name is being resolved correctly.What is the ODBC error and description? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-14 : 16:10:53
|
quote:
Originally posted by X002548
OK, I was able to set up an ODBC Connection using the Alias...but that's no good unless I can set up the alias on client machines that don't have sql server tool installed...
You don't need the Client tools installed to be able to create an alias. You can do this via regedit.exe. You can export the key to a reg file using the export option. You then can distribute this reg file via a login script or as part of your application's installation.Search the forums for Client\ConnectTo with me as the poster. I've desribed what string value you need for an alias in a couple of threads.quote:
Originally posted by X002548
You can't ping an instance can you? I thought you could only ping the server...I'll give it shot....
You can ping an instance via odbcping, but it'll only report that it can't get to it as you are getting an error anyway. Figuring out why you need an alias would involve network admins and possibly sniffers. I almost always create an alias for each instance that I need to connect to. I don't rely on the tools figuring out which port my servers listen on as we almost never use 1433.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-14 : 16:52:14
|
| Well...whatever Bill did to the search, it doesn't seem to be working anymore....Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-14 : 17:01:34
|
| I just tried too and I couldn't find it. So here it goes:regedit.exeHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectToIf the above keys do not exist (which they will on a machine that has an alias already created), create them. Then create a string value on the right pane. Name the string value the name of the alias. The data for it would be DBMSSOCN,SQLServerName\InstanceName,PortNumber. Here's some examples:String value name: Server1Data: DBMSSOCN,Server1,1433String value name: Server1Data: DBMSSOCN,Server1\Instance1,10100You don't have to specify the instance name in the data as long as you've specified the correct port number for that alias. The below is the same as the second example above.String value name: Server1\Instance1Data: DBMSSOCN,Server1,10100BTW, DBMSSOCN says to use TCP/IP. If you aren't going to be using TCP/IP, then the data values will need to change to the appropriate string that supports that network library.Check out the string values on your machine to see more examples.You can export an entire key by highlighting the key, then selecting File/Export... Save it as a file, then you'll have a reg file. Once created, right click on the file and go to edit in order to edit it. If you double click, it'll add those values to the registry (it won't create duplicates though).Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-14 : 17:15:53
|
Thanks a bunch...You're still the SQL Warrior Princess to me Brett8-) |
|
|
|
|
|
|
|
|
Instance Alias and ODBC