MSDE And remote connections


We have done a programme that connects to a SQL 2000 SERVER with ADO librarys, and it works ok both using ip address and machine names.

But the same programme fails if it trys to connect to a MSDE, if the MSDE and the client programme are in differents machines.
On the other hand it works propperly if MSDE and the client programme are in the same machine (DATA SOURCE=(local) in
the connection string).

Is that normal Should MSDE answer to remote connections

Thank you very much for your help.



Posted On: Tuesday 20th of November 2012 12:33:10 AM Total Views:  203
View Complete with Replies

RELATED TOPICS OF Microsoft SQL Server PROGRAMMING LANGUAGE




Urgent!! - copy column data to remote server

hi, really need some help with this I asked my webhost to drop a full-text index on a column so I could make a change to the column size, but they dropped the column!!! So now I've lost the data on that server. Luckily, I got them to give me a backup so I could make sure I didn't lose the data when I dropped/recreated the column. What I don't know is - how do I run an update statement across 2 servers I've never done this before. The database names are the same on my local and the remote. The remote machine doesn't have a name, just an IP address. I've been trying select statements across the 2 but I can't get it to work.
VIEWS ON THIS POST

312

Posted on:

Tuesday 20th November 2012
View Replies!

Cannot establish a connection to SQL Server 2K sp3a remotely

Cannot establish a connection to SQL Server 2K sp3a remotely Ok, here's the scenario. 1. Windows Server 2003 Standard running SQL Server 2000 sp3a 2. Windows Server 2003 Standard (where the website sits) 3. This is not a network, the connections are over the Net 4. I have set up SQL Server 2k to allow for TCP/Named Pipes listening. checking the SQL Logs I see the following: (note: I replaced private information with "x's") ------------------------ 2004-03-09 10:39:51.39 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: ) 2004-03-09 10:39:51.39 server Copyright (C) 1988-2002 Microsoft Corporation. 2004-03-09 10:39:51.39 server rights reserved. 2004-03-09 10:39:51.39 server Server Process ID is 3252. 2004-03-09 10:39:51.39 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. 2004-03-09 10:39:51.39 server SQL Server is starting at priority class 'normal'(1 CPU detected). 2004-03-09 10:39:51.62 server SQL Server configured for thread mode processing. 2004-03-09 10:39:51.62 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2004-03-09 10:39:51.64 server Attempting to initialize Distributed Transaction Coordinator. 2004-03-09 10:39:53.65 spid3 Starting up database 'master'. 2004-03-09 10:39:53.95 server Using 'SSNETLIB.DLL' version '8.0.766'. 2004-03-09 10:39:54.21 server SQL server listening on x.x.x.x: 1433. 2004-03-09 10:39:54.21 server SQL server listening on 127.0.0.1: 1433. 2004-03-09 10:39:54.23 spid5 Starting up database 'model'. 2004-03-09 10:39:54.26 spid3 Server name is 'xxxxxxx'. 2004-03-09 10:39:54.26 spid8 Starting up database 'msdb'. 2004-03-09 10:39:54.26 spid9 Starting up database 'pubs'. 2004-03-09 10:39:54.26 spid10 Starting up database 'Northwind'. 2004-03-09 10:39:54.26 spid11 Starting up database 'xxxxxxxx'. 2004-03-09 10:39:55.12 spid5 Clearing tempdb database. 2004-03-09 10:39:55.23 spid9 Starting up database 'xxxxxxxx'. 2004-03-09 10:39:55.60 spid10 Starting up database 'xxxxxxxx'. 2004-03-09 10:39:56.48 server SQL server listening on TCP, Shared Memory, Named Pipes. 2004-03-09 10:39:56.48 server SQL Server is ready for client connections 2004-03-09 10:39:56.53 spid5 Starting up database 'tempdb'. 2004-03-09 10:39:56.64 spid3 Recovery complete. 2004-03-09 10:39:56.64 spid3 SQL global counter collection task is created. ------------------------ Ok, so I try to connect via ASP, ASP.NET, ODBC, Enterprise Manager all from the Web server. In every attempt, I get access denied messages. On the SQL Server box, I went into a command prompt and ran the following command: ISQL -Stcp:SQLServerNameHere -E -Q"select @@version" This ran fine. Here is the result: ------------- Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copy right (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: ) (1 row affected) ------------- I also ran the following command: netstat -an This ran fine with the following results: (note: I replaced private information with "x's") ----------------- Active Connections Proto Local Address Foreign Address State TCP 0.0.0.0:21 0.0.0.0:0 LISTENING TCP 0.0.0.0:25 0.0.0.0:0 LISTENING TCP 0.0.0.0:80 0.0.0.0:0 LISTENING TCP 0.0.0.0:99 0.0.0.0:0 LISTENING TCP 0.0.0.0:110 0.0.0.0:0 LISTENING TCP 0.0.0.0:135 0.0.0.0:0 LISTENING TCP 0.0.0.0:143 0.0.0.0:0 LISTENING TCP 0.0.0.0:366 0.0.0.0:0 LISTENING TCP 0.0.0.0:445 0.0.0.0:0 LISTENING TCP 0.0.0.0:465 0.0.0.0:0 LISTENING TCP 0.0.0.0:993 0.0.0.0:0 LISTENING TCP 0.0.0.0:995 0.0.0.0:0 LISTENING TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING TCP 0.0.0.0:1101 0.0.0.0:0 LISTENING TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING TCP 0.0.0.0:5222 0.0.0.0:0 LISTENING TCP 0.0.0.0:5223 0.0.0.0:0 LISTENING TCP 0.0.0.0:5269 0.0.0.0:0 LISTENING TCP 0.0.0.0:32000 0.0.0.0:0 LISTENING TCP 0.0.0.0:32001 0.0.0.0:0 LISTENING TCP x.x.x.x:110 66.25.183.245:33080 TIME_WAIT TCP x.x.x.x:110 66.25.183.245:33401 TIME_WAIT TCP x.x.x.x:110 66.25.183.245:33448 TIME_WAIT TCP x.x.x.x:110 66.25.183.245:33555 TIME_WAIT TCP x.x.x.x:110 66.25.183.245:33564 TIME_WAIT TCP x.x.x.x:139 0.0.0.0:0 LISTENING TCP x.x.x.x:1330 x.x.x.x:1433 TIME_WAIT TCP x.x.x.x:3389 66.25.183.245:33260 ESTABLISHED UDP 0.0.0.0:445 *:* UDP 0.0.0.0:500 *:* UDP 0.0.0.0:1106 *:* UDP 0.0.0.0:1107 *:* UDP 0.0.0.0:1258 *:* UDP 0.0.0.0:1259 *:* UDP 0.0.0.0:1434 *:* UDP 0.0.0.0:4500 *:* UDP x.x.x.x:123 *:* UDP x.x.x.x:137 *:* UDP x.x.x.x:138 *:* UDP 127.0.0.1:123 *:* ---------------- The Windows 2003 Firewall is DISABLED for both machines. When I attempt to set up an ODBC connection from the Web Server, I get the following error: ---------------------------- Connection Failed: SQLState: '01000' SQL Server Error: 10051 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. ---------------------------- Now, I attempted to set up the SAME ODBC connection on the SQL Server box, with the same login credentials (both using SQL Server Authentication), and it worked fine. So, as far as I can tell, the SQL Server box is listening on port 1433. I have all the usernames/passwords set up for each DB. I can set all this up on the local box. The SQL Server used to house the web server as well so there doesn't seem to be any firewall or connection issues going INTO the box (again, Internet Firewall is turned OFF on both machines). I have also run the following command from the command prompt on both machines: ISQL -Stcp:ServerNameHere -Uxxxxxx -Pxxxxxx -Q"select @@version" On the SQL Server Box, I get a good return message, on the Web Server I get the following message: -------------------------- C:\>ISQL -Stcp:66.135.32.79 -Usa -Pxxxxxx -Q"select @@version" DB-Library: Unable to connect: SQL Server is unavailable or does not exist. Una ble to connect: SQL Server does not exist or network access denied. Net-Library error 10051: ConnectionOpen (Connect()). -------------------------- Can anyone help I appreciate your help!
VIEWS ON THIS POST

264

Posted on:

Tuesday 20th November 2012
View Replies!

unable to connect to remote MS Analysis Server

I am unable to coonect to a remote analysis server using analysis manger. When i try to register server it says 'Server not found') But i m able to telnet it. Can somebody help
VIEWS ON THIS POST

167

Posted on:

Tuesday 20th November 2012
View Replies!

two servers 1 being remote

There is a remote server being set up that is a database (sql2K) This server will store paths to its folders containing scanned images (images around 250k each) I have a website that has a calendar of events, the user of the calendar can have the ability to select supporting documents for the event they create on the calendar (so the calendar event needs a link to the documents on the other server. The website is fully under a ssl key and the remote db server is not. I don't was to inconvience users / give up security by having them click a link to load files from an unsecure location. How would it be best to keep the security of the ssl and create a link from the secure web calendar of events to unsecure supporting documents on another server. When the user uses the calendar of events, since it is dynamic, the users login information is passed along so the user views their information. This is what i was thinking, would it be possible to pass the users Login information to a store procedure in remote server (which would only be listening for the web servers ip address) THis procedure would then pass back to the website (at a different ip) the urls to the images. My main issue is avoiding the security prompts created from importing unsecure info and clicking a link to unsecure info FROM a secured. Any suggestions on how i can do this
VIEWS ON THIS POST

296

Posted on:

Tuesday 20th November 2012
View Replies!

LIST the systems DSN existing of the PC (OBDC connections) with ASP

. I need LIST with ASP CODE the systems DSN existing of the PC (OBDC connections), the conections and properties like goto into in win2k to: Star->Configuration->Control Panel->ODBC Connections For example show the text and properties like this image http://dirlist.sourceforge.net/docs/odbc/sysdsn.gif y really not need show graphics, i only need the names of DSN and The name of the ODBC type. If any one knows how show this please write me to my email juan_msdn@hotmail.com
VIEWS ON THIS POST

280

Posted on:

Tuesday 20th November 2012
View Replies!

Free remote management tool for SQL Server 2k?

Are there any good free remote management tools for SQL Server... preferably web driven either via asp or asp.net Im currently using table editor which is fine for adding records but it's a bit cumbersome. Ideally the tool would look similar SQL Server.
VIEWS ON THIS POST

239

Posted on:

Tuesday 20th November 2012
View Replies!

SQL server remote connection error

I am getting this error when I execute a query on a remote server. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. Connection Broken This only happens when my query is run between these dates '5/1/2003' '5/30/2003' The query returs an extended cost- I have checked the totals for that quarter is over 1900000.00 If I run for the first quarter of this year the total is just under 1800000.00 and it executes fine. here is my query SELECT TOP 15 t.description, Amount = CASE WHEN t.Extcost_priceUSD IS NULL THEN 0 ELSE t.Extcost_priceUSD END FROM ( SELECT DISTINCT a.description, (SELECT sum(d.Extcost_priceUSD) FROM POS_DataTable d WHERE d.description = a.description AND d.ship_date >= '5/1/2003' AND d.ship_date = '5/1/2003' AND ship_date
VIEWS ON THIS POST

309

Posted on:

Tuesday 20th November 2012
View Replies!

Need help Installing msde 2000

, I have downloaded MSDE 2000 as recommended from my previous post, thing is, there is no better way of saying this, I really do need a Dummys guide to installing it! I have tried to run setup.exe at which point it says I need to set a SAPWD, then I have read the readme where I have then ran a number of Command prompt strings like : setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL... but then it says I need to go to my Control Panel to install and configure system components... at which point I am completely lost as to what to do, or whether I am doing it right in the first place!! I am very new to MS Sql, as my database is MS Access at the moment, but I need to convert it to MS Sql, so need a program to edit it in, which is what I am not having much success with now (, any help would be so so so much appreciated!
VIEWS ON THIS POST

259

Posted on:

Monday 26th November 2012
View Replies!