Hello all, I am using SQL Server 2k SP3 on Windows 2000 server. I setup db maintenance plans to backup my databases across the network to a Terrabyte NAS storage unit. The jobs execute, but then seem to lose connectivity to the NAS after about 10 - 15 minutes. I get the following errors in SQ...more >>

Hello, I have a Server with SBS 2003, Exchange 2003, SQL 2000 and Outlook 2003 all with current service packs. I am having a problem with SQL Mail. The problem is the mail profile is grayed out in SQLServerAgent and I do not know why. I created a mail profile on the server in exchange that ...more >>

Is it possible to create a linked server to an Excel spreadsheet using a UNC? I have no problems doing it with a file on the local server, but am having trouble when using a UNC, which is what I really need to do. If I use no security context, I get an upspecified error. If I specify a remo...more >>

I'm trying to connect to my sql database across the internet from a C# application. I am attempting to login using the administrator account that has been added to the SQL server database and given all the roles. The auth mode is mixed (it was windows, but I changed it to mixed after reading ...more >>

Hi, I'm seeking your help please. My database is SQL Server 2000 with the latest SP on W2K SP3. I have some users having problem connecting to the database via the application with Windows authentication but some dont. The error message for those who have problem is "SQLSTATE = 08001 Mi...more >>

I apologize in advance for posting this here and in the ProjectServer NG, but I'm not sure which side the problem is on. I am experiencing a problem with getting users logged into the SQL server when they launch Project. The environment is: OS = XP Pro Project 2003 ProjectServer 2003 ...more >>

Posted - 09/29/2004 : 11:46:27 -------------------------------------------------------------------------------- Hi folks, I have a linked server pointing to oracle server 8i on my sql server 2000 box. Initially i was able to run queries on sql server using the four part naming conventi...more >>

I've just installed Visual Studio 2005 and SQL Server 2005 Express beta 2 (all on my local PC). I try to connect to the SQL server from studio using "Tools/Connect to database" selecting my local pc in the "Select or enter a server name" combo box. I can select my pc's name but when I try to expa...more >>

Brand new W2K3 server in a workgroup, no domain. Server name and IP address are pingable. Installed SQL Server 2000 with SP3a, no errors. Chose Windows authentication. SQL Server service and Agent service are running, Enterprise Manager on the server appears fine. No database created yet, t...more >>

Hello, I have a problem with DAO, Transactions and SQLServer. I want to do a very simple thing (in VB)! BeginTrans Call db.Execute("UPDATE counter SET value = value + 1 WHERE name = 'mycounter'", dbSQLPassThrough) Set Rec = db.OpenRecordSet("SELECT value FROM counter WHERE name = 'mycount...more >>

I have a 2003 server (completely up to date according to the windows update utility) running SQL Server 2000 SP3a. I have an ISAPI DLL which uses ADO to connect to the database. When I run this through my web site (IIS is also on the same 2003 box), about 50% of the time it work just fine, the...more >>

Hi ! We are using Windows XP, ADO.NET in our application (programming language: C#), MS SQL Server 2000. The computer is a SONY notebook. SQL server is running on the same machine as the application. The application has worked in many, many cases under W2K and even XP. But on that compute...more >>

Can anyone give me an example of the arguments for using openrowset to connect to a text file data source? Thanks, Gerald *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

After removing (an error) the default (window autentication) user from (local) server i can access no more to it even with "sa" user.I have SQL SERVER 2000 with service Pack 3 (sa without password). I would like recover at least DTS i had on it......more >>

On Windows Server 2000 with SQL 2000 SP3 I opened a Query Analyzer window to insert a single record into a remote table. This remote table is on SQL 2000 SP3 on Windows Server 2003 Standard. I insert a record with insert into [production\caremanagement].icms.dbo.test_table (field1) v...more >>

I have SQL Server SPK3 and Visual Studio.NET running on the same machine. When I try to connect to my SQL Server from the VS.NET Server Explorer I can expand the server and look at the SQL Server instance on my computer but when I try to expand the instance, I get a login dialog entitled "SQL...more >>

I want to create a link between SQL Server and DB2(IBM AS400). I'v used those paramters: EXEC sp_addlinkedserver @server='DB2', @srvproduct='Microsoft OLE DB Provider for DB2', @catalog='DB2', @provider='DB2OLEDB', @provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=12...more >>

Since installing the new SP2 for XP I have no longer been able to connect using ODBC on a client machine to my SQLServer running on XP SP2. I have configured SQL Server to use TCP ports 1433 and allowed this port to be excluded in the firewall, but I still get SQL Server does not exist when ...more >>

I have a SQL 2000 database and I'm using Access 2003 to gain access to the tables. All cells contain #Deleted. What am I doing wrong? TIA Jon ...more >>

Hi all, I am currently porting some software to support SQL Server. The software will act as a client and I'm having no problem with that. My problem is that I currently build and test my application with the SQL Server 7 client. I don't ship the client on the assumption that the custome...more >>

Not sure if this is the right forum, if not, please direct me. When I create a link to a SQL 2000 server database via Dreamweaver MX, for some reason on one account retrieved, it pulls up duplicate data. The other acounts appear fine. When a customer pulls up their account history, th...more >>

I have had a problem with EM being extremely slow. The first time this ocurred it was related to one users Windows Logon Profile... i.e. whichever PC he logged onto, EM was very slow to connect and run. It turned out his Windows Network roaming profile was corrupt and fixing this solved the ...more >>

Receiving the following error: Message: SQL Server does not exist or access denied. Source: .Net SqlClient Data Provider at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon nection(SqlConnecti...more >>

Hello, We have the following problem: Separate application server and database server. Both Windows 2003. On both MSDTC 2.8 installed. Bith in same domain. Both in same network segment. When accessing the database via the application server, it seems that there is for each connecti...more >>

Hi, What is the best practice to allow remote users that are not part of our domain to connect to a specific database on our server? Do we use Windows Authentication by adding them to the domain or do we use sql authentication. These users are in a different company and they will be logged on...more >>

hi, i am having a difficult time trying to connect to my SQL server with the odbc drivers. i have it set to named pipes right now and when i try to switch back to tcp/ip, i come up with the above error, and says user 'null'. not associated with a trusted SQL server connection. here's what...more >>

Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise Manager (EM) located on another machine on the same network? When I try to do this the EM setup wizard locates the host running MSDE but it cannot connect either with Windows authentication or the strong password created dur...more >>

Hi, when using EM to open any table or diagram from a particular database I get the following message (no error number) ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure I’ve run DBCC CHECKDB and everything seems ok. I sometimes use ms access to view the data and...more >>

Hi everyone, I need your expert advice. I have a w2k AD service with mssql on it. and I setup another w2k server with IIS on it as webserver. my website works on NT servers, but when I moved the website to the w2k server, it doesn't work. It saids: Error Type: Microsoft OLE DB Provider for...more >>

I've been looking at this problem for hours and hours - any help most gratefully received! I'm trying to set-up a test scenario between my desktop running SQL Server 2000 and my laptop (also running SQL Server 2000). Both machines are connected to a Netgear DG834G router, although if I har...more >>

I got an extremely serious problem with SQL Server 2000 now. Without it, I couldn't start SQL and continue my programming work in SQL CE(I need both). Please kindly give me some help concerning the problem below: 1. When my pc starts, sometimes the SQL Server and the SQL Server Agent ...more >>

Hi While I am trying to open enterprise manger it's showing the error login failed to the user,Even I am trying to use domain adminacct I am unable to open it.My sql server agent also not starting Chris...more >>

Actually, it appears to install fine. I used the command line parameters setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described. I've tried with the double quotes and without. I've tried on a machine running Windows 2000 and XP (home addition). I tried updating the XP ...more >>

My Data Link (udl) files stopped working on just one of my pcs. The pc has been updated with mdac 2.8. I cant figure out what could have caused the 'corruption'? but i've tried creating a new one and get the same error. Any suggestions besides making sure MDAC is up to date? thanks jo...more >>

I was able to successfully create a linked server to AS400 box without any problem. But now, due to some reason the following query does not return any data (0 rows) Select * from openQuery(CWBIS800, 'select * from lib.tb where cmln = 10001001') whereas the following query does return the c...more >>

Hi, I have SQL Server 2000 SP3a installed on Windows 2003 server. Client is Windows XP machine. Up to today I have no problems connecting to SQL Server - my Windows ID is assigned as SQL administrator. This morning I installed Windows XP SP2. I logged in to windowx XP using my usual userID (l...more >>

Has anybody, anywhere figured out a way to use a trusted connection (Windows authentication) with OPENROWSET? The first two queries below used to work just fine because they use SQL authentication. The four queries after that are various sad, sad (and unworking) attempts I've made at using Wind...more >>

Hi all how about for SQL 2000 Enterprise? what are the concurrent connections? the reason I am asking is because I had an issue where we were getting asp errors/access denied during heavy traffic to our web servers/db servers. Our web server and db server are on 2 sep. machines. Pbvi...more >>

I've had some problems connecting remotely to my named instance of SQL Server, so I started some usual troubleshooting. My original problem was that I can run EM locally without problems, but not remotely. After the usual checks I could think of I am down to this peculiar problem. There's o...more >>

Hi friends when i try to connect our sql server thru QA or EM i am getting timeout expired. It happens intermittently. whats weird is if i am already connected (i mean thru QA or EM ) then i can execute queries successfully. but if i try to login with new instance of QA then i get "timeou...more >>

While trying to connect SQL server from one network to another I'm suddenly getting this error message: A connection could not be established to ServerName. Reason: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.. Please verify SQL Server is runni...more >>

Hi all, I'm having a problem with backing up SQL to a network share, often I would get the "network name is no longer available". Sometimes it works and sometimes it doesn't. During the backup, both servers - source and destination are at minimal cpu , memory and network utilization. Netw...more >>

If I create a link server on my SQL Server to another SQL Server and run a stored procedure using: EXEC otherserver.database.dbo.sp_myproc Does the procedure actually "run" on the remote server or on my SQL Server? Thanks! ...more >>

Dear Colleagues: This is such an SQL newbie question its not even funny. To begin with, please forgive my informality as well as my lack of any specific error messages, etc.. . I think the questions are academic (the specific error messages and notes are strewn about my desk at work). Ok...more >>

Hi Data Link Properties, open by test.udl file, when open don't show any istance of MSDE sp3 installed. By Visual Studio.NET 2003 Server Manager I can see the server and database. If I insert manually name istance and try test connect it return me this message: Test connection failed becau...more >>

the error string is as follow: "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator." ...more >>

Hi all, I am having a major problem with a simple application that queries a database. Firstly we have SQL2000 SP3a running on a Windows 2003 Server with all the latest patches and updates. Windows 2003 is running the shipped MDAC 2.8 and I've run the component checker to make sure there is...more >>

Hi all, I have table A and populate table B with table A but before I do that I need to compare records in between those two tables.... If there are new records on table A, I need to insert it into newTable and if there are records that has changed then I need to insert into upda...more >>

HI, i am a newbie of SQL server. What I got is an error shown as the title in which an ASP file made the SQL call. The script is just as follow: set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_cia_STRING 'Recordset1.Source = "SELECT * FROM fund WHER...more >>

We periodically receive an error message: Database 'db name' can not be found or is busy.... We seem to get it more often with users who attempt to connect to our DB using a wireless network card in their laptop. However, we periodically get it with users on our network. Is this a conn...more >>