| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-01-03 : 05:05:27
|
| i have an sql express db on my webserver.now from another computer I am trying to creat an odbc connection to the sql server but when I enter in just the ip and the login and password it fails.Please advise me what I can do?what i really am trying to do is set up an access db on my home computer to be linked to an sql server express backend.I thought to do this with odbc - is this the correct way? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-03 : 16:15:15
|
| seehttp://support.microsoft.com/kb/555585==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-01-04 : 01:26:05
|
| i will try all these options but where in teh dsn do i put in the server ip and where the server name or is it ip/server name? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-04 : 06:16:13
|
| Yes you can use an ip address as the server name==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-01-04 : 06:43:21
|
| so then where do i pass the sever name.i checked the above settings and it is still not working. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-04 : 07:43:15
|
| You can use either the ip address or the server name for a default instance.Try creating a odbc connection on the server first then do the same from the remote machine.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-01-04 : 07:56:16
|
| it works from teh server.when i try from my machine with the only difference being by servre name i enter the ip/nameofserver and i get connection failed |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-04 : 08:37:25
|
| Can you ping the server?Are you on the same domain?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-01-04 : 09:48:31
|
| how? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-04 : 10:16:03
|
| in command window:ping 10.10.1.100 (change to real IP Address)is this a hosted environment, or are u on the network? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-01-04 : 10:48:40
|
| when i ping i get a replyit's not hosted(meaning i can get on the computer through remote desktop) but i'm not on the network. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-04 : 12:02:47
|
| once u establish vpn connection, can u connect in SSMS?did u make sure remote connection enabled? sql browser service is running on sql box? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-01-04 : 12:10:05
|
| yes i enabled named pipes and tcp/ip -- what do you meaan by remote connection?sql browser is running |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-04 : 12:17:50
|
| did u look a t KB that nr posted above? if u enabled tcp/ip & named pipes, then u enabled remote connections.checked firewall settings?is sql running on default port?what does your conn string look like? |
|
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-01-04 : 12:43:09
|
| I think this is a better KB article to ensure you have enabled remote connections correctly in SQL Express, http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277. It explains more about how to open exceptions in the firewall.If you follow the KB and still have problems, it is likely an error in how you're referencing the SQL instance. By default, SQL Express installs as a named instance of SQLEXPRESS, so you must refer to it using the syntax <computername>\<instance name> or <ip address>\<instance name>. You should verify the name of your server using a tool such as SQL Configuration manager to ensure you are putting to correct name in the Server text box when you setup your DSN.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
|
connect via odbc