Hello again, Can someone explain to me how to determine what the fully qualified name of a linked server is? I am attempting to do a query like: SELECT * FROM LinkedServer.dbo..TableName and get this: Server: Msg 7314, Level 16, State 1, Line 1 OLE DB provider 'ODBC_VFP' does not cont...more >>

Hiya, I am attempting to make a Linked Server connection within SQL to a .dbf file (not a .dbc file, using open file connection) located on a network server and am receiving the following error: Select * From OpenQuery(OL_ODBC, 'Select * From phone') Server: Msg 7399, Level 16, State 1, ...more >>

Hello, What different methods exist when trying to set up a sql server box to be accessible to an app that needs to connect to it through DSN. The app is running in a different city than the sql server box. Would I need to do this through a VPN, IIS? Any suggestions much appreciated....more >>

Hi There, I have a problem connecting a Windows 2000 Advanced server to a 2003 server running a SQL server (not sure of the version at this point). Here's the error below, this is using TCP/IP connect on port 1433. Any help would be greatly appreciated. Thanks. Microsoft SQL Server Login C...more >>

Please forgive me if this is the wrong forum and suggest a better place to ask, but here goes: 1. How can you discover in vb.net code what servers are connected to the network your PC is talking to? (I.E. How to the various MS tools that have a pull down list of sql servers populate that list...more >>

Hi, I'm having trouble connecting to the SQL server in a LAN. I can't even telnet to the port 1433 of the server. Does anyone have any idea how to fix this problem? Shafiee. ...more >>

i install a windows 2000 family and a sql server enterprise. I don't set any db params,but it is only let one client to link. what? can you help me! ...more >>

I am having trouble connecting to SQL 2005 June CTP on Windows 2003 Enterprise from remote SQL 2000 SP4. I get the folloewing message: SQL Server does not exist or access denied. I have tried all of the obvious things such as Firewall settings. permissions, IP and Port bloackage, etc. I...more >>

I have a client with a machine that refuses to connect with any SQL Server over 1433. It is as if the port is being filtered. Windows firewall is OFF (and I've tried various attempts to change the firewall with no effect, add the ports explicitly etc.) Other machines on the same network have n...more >>

Hello everybody, I am trying to register a new SQL server with enterprise manager and I get the following error message: SQL Server does not exist or access denied The SQL Server (its name is SATURN) is running Windows 2003 SP1. SQL Server SP4 is installed and I'm using Windows authentic...more >>

Hello all, When I used DTS, I found out that network library pointed Named pipes at Process Info in Current activity panel. As my understanding, the network library should points TCP instead. What does the network library point to when DTS is used? Should that library point to TCP/IP? Wh...more >>

Hi all, newbie of SQL2000. Running in LAN SBS2003 with SQL2000 SP3. From a client (InfoPath) I want to make a dataconnection to SQL2000, but access is denied. How can I check from the client-PC whether a connection is possible with SQL2000? SQL2000 is running on the server and when I fill out...more >>

I hope someone can help us..... We have a database that is using SQL7 and My local pc = WinXP Pro Ver5.1_sp2 Suspect it is a local setting when I connect for remote access (Have been using VNC and www.gotoassist.com) I do not get this error on the other workstation or at the se...more >>

Hi All We are using SQL 2k(sp3) with Win2k3. I started getting this error lately, every time someone connects to the server, we end up in this error. if i reboot the machine , it works fine for a while and then again the error. I am physically on the box using TS and connect thru Query Anal...more >>

SQL server 2000 SP4 has been running for several years. We added a new Client PC, our first with the XP operating system. Microsoft Access 2000 is the front end, and all tables and views on the server are connected thru an ODBC connection. Everyone else in the office works fine, but the new...more >>

Hello, We are experiencing an intermittent problem where we loose our connection to SQL server from RSSQL. The system logs are reporting this in the following order: 1 8/23/2005 1:58:59 AM 5 256 RSSql N/A TSSFOOTAGECTR (52152) SQL state (error) is 37000 1 8/23/2005 1:58:59 AM 5 256 RSSql...more >>

I have been using SQL for a while using TCP/IP server side network utility only, but suddenly it seems that I am unable to connect to SQL. Checking most of the related posiblities (TCP/IP Protocol ...Etc...) I was unable to resolve the connection problem. Finaly, I added Named Pipes Server sid...more >>

Hi All, I need help urgently. I got problem. Whenever I issue DBCC SHRINKDATABASE the below message appear. Server: Msg 1205, Level 13, State 57, Line 1 Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the ...more >>

Hi All, I have a NetGear combined wireless router / ADSL modem, and am attempting to connect to SQL Server from my (wifi enabled) laptop, but am getting a 'failed to create SSPI context' message (note that I'm using Windows Authentication). I'm connected to my work LAN through a SonicWall VP...more >>

I get the following error trying to attach an .mdf file, the first line is contained in the windows title bar. I do NOT have the .LDF file. Will I be able to salvage this database? Microsoft SQL-DMO (ODBC SQLState:42000) Error 1813: Could not open new database 'name'. CREATE DATABASE is ab...more >>

I am trying to connect to a default instance of SQL Server 2000 Enterprise on a remote network server using ADO.NET objects through ASP.NET Web Application. The SQL SERVER is on a Windows XP machine (no firewall enabled) with TCP/IP and Named Pipes enabled For the test purposes, I created ...more >>

Hi, My application (in VB.net) is extensivelly querying a remote SQL server. Somebody sniffing the traffic could eventually find out all important information such as passwords (from users stored in datatables as well as the password and user name used in connectiong string to that server)....more >>

Hi, We are having difficulties with the security settings for distributed transactions between linked servers , getting error 18456. I have read a number of postings on internet but not got any closer to resolving this. We have been rushed into managing distributed transactions across two ...more >>

I have one windows 2003 server running Exchange 2003. It is also running MSDE. What I want to know is can I install the full version of MS SQL 2000 while MSDE is on the same server. Can they coexist with each other? TIA, Clayton ...more >>

About a month ago I setup a Server and named it SQL1 I setup a maintenance plan and all was well. I needed to rename server to SQL. I went onto the server today to take a look around and noticed that the DB is 133GB instead of 35GB. When I when to make some changed on the maintenance plan I go...more >>

Hello, I tried a lot of hint from some newsgroups, but without success. I try to connect to a Microsoft SQL-Server 2000 (Servicepack 4) via JDBC (original driver from Microsoft). But I get the following error [SQLServer 2000 Driver for JDBC]Error establishing socket. My Applikation and...more >>

I am trying to use SQL Server but I get this error when I connect to the server "A connect could not be established to (Local). Reason: SSL security error Connectopen(SecdoClientHandshake()).. Please verify sql server is running and check your sql server registration properties (by right...more >>

I’m a little new to this so forgive me if this seems to be a trivial issue. The problem I’m having is that when I use the connection string: “Server=localhost;Database=test;Trusted_Connection=True;” It works, then when I use: “Server=localhost;Database=test;User ID=sa;Passw...more >>

Can I write the connection string that uses a specific Windows user account and not SQL user account?...more >>

> Error opening [DATASOURCES]; Transaction (Process ID 71) was deadlocked on > lock resources with another process and has been chosen as the deadlock > victim. Rerun the transaction. This error is being returned to our application from SQL 2000 SP4. Should I be looking at a disk I/O issue or...more >>

Earlier today, we were getting time out errors when trying to run a query. We could access some files, but when we tried to access a particular file, we got a time out error. We rebooted the server, and now we're running into the following error when we simply try to open a connection to the ...more >>

1) For performance of BLOB only data that will have at least 100 KB per BLOB, what is the best network packet size setting? The resource kit indicates that it is 8080. Is that correct, or is it a typo that should say 8192? 2) Does the client connection have to match the network packet size se...more >>

Hello, I've got a problem connecting to SQL server 2000 using windows 2000. Where testing a database using msde2000 (access project as front end) on a network with +/-20 people. And use of the "great" tool DbaMgr2k We have added al the users groups giving them access to the server. An...more >>

I'm trying to setup a linked server from SQL server to another. Here's the catch. One server is in a domain the other is in a workgroup. I can't get the linking to work. Has anyone gotten this to work? ...more >>

I'm looking for some docs to instruct me how to setup log shipping in a SQL 2000 Standard environment. Thanks ...more >>

Hai, I used sqlservr -m to start the server in single user mode , how to get to multi user mode. Thanks, V.Boomessh...more >>

Hello, I have a problem and I do not know if it is a SQL problem or a ISA firewall problem. I have two seperate SBS servers 'Server A' is a SBS 2000 and 'Server B' is a SBS 2003 and both have SQL 2000 installed on them. On a workstation on 'Server B' I am running an application that is acc...more >>

I have SQL (MSDE2000A) installed on a W2003 server. I can connect to the database OK using either SQL or Windows authorization from a W2000 (SP3) machine or from an XP Home (SP2) machine. But connection from an XP Pro machine (SP1) fails every time - unless I specifically define the DNS serve...more >>

Greetings, I have a CGI web application that is connecting to SQL2k sp3 server using a system ODBC DSN to display data from tables on a web page. These tables are being populated by another application that is using .net SqlConnection object to insert data. The problem I am seeing is th...more >>

Hi, I am not sure if this is the right place to post my problem. If not so, pls do advise me of the right group. Here is my problem: I have this problem with SQL server. All of a sudden the insert, updates does not work on SQL server based application written in ASP. The select commands ...more >>

I need to change the server name of a live SQL server. Aside for re-creating ODBC connections; are there any issues doing this? ...more >>

I have two xp sp2 machines(one desktop with sql server running, the other is a virtual pc, on the same domain), I'm trying to connect between the two using the dtcping.exe tool from ms the virtual pc has vs2005 etc installed and I can't get it to run a distributed transaction on the sql ser...more >>

Hi I have some code that I am testing to read data from a FoxPro file. I have copied the FoxPro file locally to test. I have created a linked server that points to this file. Enterprise manager correctly shows the tables available. Works fine.! However, when I create another linked serv...more >>

I am trying to run SQL Server Enterprise on AMD Opteron 64-bit server (Windows 2003 standard). It is starting OK with no errors in event log, and I can work with it on the same machine, but it's not opening any sockets, so clients on any other machines can't connect. Anybody knows how to fi...more >>

Hello, I'm trying to connect a mobile computer runing under windows CE to a database located on a windows XP desktop. The mobile computer application is written in C# under Visual Studio .NET 2003. My problem occurs when I execute mConnection.Open(); A SqlException is caught with this ...more >>

Hi, In My SQL 2000 (w/ Sp4) it wont start sql service ( Win 2000 with SP4 ) - Priya ...more >>