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 |
|
jlbantang
Starting Member
16 Posts |
 Posted - 2007-06-05 : 04:59:57
|
| hi sql team i've been reading much of the ms walkthroughs and some forum how they solve sql server 2005 (express) remote connection but non of them squared my problem.in my case since we dont have in-house web server i need the script (ASP) run from our domain host/hoster and the sql database will be somewhere in our office. i try making a local (LAN) run of script just to test if the connection (asp-to-sql dbase) was established and im getting all things work.OUT PUT[url]http://images.cjb.net/114e8.gif[/url][url]http://images.cjb.net/343e3.gif[/url]problem/nightmare comes when i access the test script through domain host with error:Microsoft OLE DB Provider for ODBC Drivers error '80004005'[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.i tried using the following connection string thinking it will work for me but nothing seems happen:test connection 1cn.Open "Driver={SQL Server};" & _ "Server=www.gpzgroup.com;" & _ "Address=10.0.0.254,1433;" & _ "Network=DBMSSOCN;" & _ "Database=testdb;" & _ "Uid=xx;" & _ "Pwd=xx;"test connection 2cn.Open "Driver={SQL Server};" & _ "Server=live-static-ip;" & _ "Address=10.0.0.254,1433;" & _ "Network=DBMSSOCN;" & _ "Database=testdb;" & _ "Uid=xx;" & _ "Pwd=xx;"test connection 3cn.Open "Provider=sqloledb;Network Library=DBMSSOCN;" & _"Data Source=10.0.0.254,1433;" & _"Initial Catalog=testdb;" & _"User ID=xx;Password=xx;" where i am getting wrong at this point?your response will be greatly appreciated thanks. |
|
|
jlbantang
Starting Member
16 Posts |
Posted - 2007-06-17 : 12:00:42
|
| modz please close prob resolve. thanks |
 |
|
|
|
|
|
sql server remote connection prob