Hi I have an SQL server, which (for some unknown reason) will not start as a service. Whenever it is tried to start (either using SCM, NET START, or Enterprise Manager), it reports the following error: "System error 1058 has occurred. The service cannot be started, either because it is ...more >>

PROBLEM: I connect to multiple remote SQL Servers. QUESTION: Is there a script I can use in Query Analyser to connect to these Servers instead of using Connect from the File menu?...more >>

Is there any way to restrict user from using a certain protocl / access method to connect to SQL Server 2000 on server side? Like, I want USER A to connect with ODBC only while I want USER B to connect with DB-LIB only. Is it possible?...more >>

hi all, I have a sql server 2000 on win 2k server, and some application's are using database residing on the server. now i need to change the ip address of my server, will this change affect the production... application's are connecting to server through server name not through ip, pl...more >>

How to create one stirng of connection in SqlServer using integrated autencicação AD expecificando using and password of the AD? tanks joao ...more >>

I'm getting this error when I try to connect to a SQL Server. Run-time error '-2147467259 (80004005)': Login failed for user '(null)'. Reason: No associated with a trusted SQL Server connection. Can someone please enlighten me. I have one other system that is able to to conne...more >>

How to create one stirng of connection in SqlServer using integrated autencicação AD? tanks joao ...more >>

We have a customer setup where all users were connecting via Named Pipes to a SQL 7 server (running on NT4). This was causing a periodic "freezing" in our application whereby all connections to SQL were made to wait around 30 seconds - even with just one user connected. (Our application accesses ...more >>

Hi all, Is there any way to stop a ROLLBACK process? Thanks Td ...more >>

I am changing the service account password. I am aware of four places where to change it:two services(sql server and agent) under services(win2000) and startup account password within sql server. Is there any other place that I am not aware of? Thanks...more >>

Hi Everyone, Links, tips, whatever you can think of, I will take. Here is my setup: 1. Client 2. Internet 3. Windows XP (2 NICS) 4. HUB 5. MS Server Enterprise 2003 (running SQL Server) I can connect fine to the SQL server from my XP box. However, when I added the Alias in the Server...more >>

Microsoft Consumer this is the latest version of security update, the "December 1996, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to pr...more >>

Hello, I have designed an activeX DLL for database transaction. I am using this DLL from ASP page. I am using DSN for database connection. My Problem is I am able to connect to database, when I try to connect to database it gives message "Login Failed for User sa". The same DSN works if I con...more >>

Hi - When using linked SQL Server definitions, and using sp_addlinkedsrvlogin, is there any way to designate the remote user as a Windows Domain login? Given that OHIO is the Domain and OHIO\Joe is in the System Administrator role on the remote server; sp_addlinkedsrvlogin @rmtsrvname ...more >>

I'm using SQL Server 7 and SQL-DMO within a Visual Basic program to do BCP. When I'm importing data I get an error message :- ODBC SQL SERVER DRIVER - SHARED MEMORY - SQL SERVER DOES NOT EXIST OR ACCESS DENIED - CONNECTIONOPEN(CONNECT()) With an error code of -2147221504. Can anyone ...more >>

We're getting our feet wet with Microsoft Access projects using a SQL Server 2000 back-end. We have three machines: DOM\JOHNSMITH : The developer's machine. DOM\FRONTEND: The remote front end machine. DOM\BACKEND: The remote SQL Server. We have user SMITHJ, who created an Access project on ...more >>

Any help would be APPRECIATED!!! Problem: Trying to connect from a web server to a named instance of SQL Server 2000 on a database server fails. Connection to the default instance of SQL Server works. Connection to the named instance does not. Database server: SQL Server 2000 + Win2K S...more >>

If I do the following, it works... EXEC sp_addlinkedserver @server = test , @srvproduct = 'Jet 4.0', @provider = 'Microsoft.Jet.OLEDB.4.0', -- @datasrc= '\\computer\test Database\Data\test.mdb', @datasrc= 'd:apps\test Database\Data\test.mdb', @location = NULL, @p...more >>

We have SQL server 7. Workstation XP. For our accounting application I have several ODBC setup that access different databases. When I go to ODBC setup- all the ODBC still appear to be there- but when you try to configure any of them it gives an error that it is not an existing data source...more >>

I am getting: Error Description: [Microsoft][ODBC SQL Server Driver] Timeout expired when a procedure in MSSQL server goes to oracle through db link. ...more >>

One of apps has moved to another server and once a day we get this error "Error '8002801d' Library not registered." A while later, that app working again by itself. When I checked ERROR Log in SQL, I found this saying a user account which is SQL authentication user account for ASP progra...more >>

when i deny access to the BUILTIN\Administrator group, I am unable to connect to SQL Server using OS authentication, even though I have defined a login with sa privileges for myself on that server to use OS authentication. what's the trick to denying access to BUILTIN\Administrators?...more >>

Does anyone know how to stop/start SQL services (listed in service manager) using Windows scheduling service? Or something like this?Is this even possible. We want to be able to start and stop these unattended. ...more >>

We have a SQL Server 2000 database. I naively purchased VB .net standard thinking that I can write a couple Windows Forms applications, connecting to the database through ODBC. When I try to set up a data connection object to our SQL Server database in the visual environment I get a mess...more >>

Hello All I have an ASP Website running on W2K SP4 with SQL Server 2K SP3 using MDAC 2.71.9040.2. The website has been running with no problems for about three months. Over the weekend and today we have been experiencing the error below: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).] ...more >>

I am trying, without success, to obtain information from the Active Directory using a linked server. I've trawled the internet and found abundant information (including others with a similar problem) but as yet no solution. SQL server 2000 SP3 is running on a member server (not a domain ...more >>

I have SP3a for SQL installed on my server. When connect over a VPN and then try to find the computer that is connected, I get Sql server does not exist or access is denied error. Thanks Gary...more >>

I recently split SQL from the machine running IIS and Sharepoint Services. In attempting to connect the web portal to the new instance of SQL, I get the following error: Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection. (Error code: 184...more >>

When connected through Vpn and trying to open an application whose back end is sql server it gives an error as [DBNETLIB][ConnectionOpen (Connect())SQL Server does not exist or access denied. any clues??...more >>

Here's the setup Win XP SP1 With SQL Server 2000 Enterprise Edition with SP3a installed. It worked on the desktop prior to the application of SP3. SP3a was in an attempt to fix it. On my laptop I CAN register a server just fine using sql authentication, on the desktop, I get A connect...more >>

I am using the 4 part syntax to connect to a linked server. The problem I'm having is that the linked server name has an \ . When the linked server is entered in the query. I get Incorrect syntax near '\'. Do I have to change the SQL server name?...more >>

Hello. I have installed MSDE sp3a on a customer's Windows NT server, a new instance with the following settings in setup.ini: [Options] SAPWD=admin SECURITYMODE=SQL INSTANCENAME=MYDB DISABLENETWORKPROTOCOLS=0 I am able to access the database without issue from this machine. From anot...more >>

I have been connecting without errors to a database located on my machine. I'm now receiving the following error: "A connection could not be established to (LOCAL). Reason: General OLE Error 16386. Please verify SQL Server is running and check your SQL Server registration properties..." ...more >>

I created an application from Delphi5. I made this application, which connects Paradox Tables through BDE. Then, I made this Tables shared through the Network for wider expansion of my system. The client machine could access the shared tables through BDE. Now my boss told to use MS SQL Server inste...more >>

how SQL6.5 to read data from other server and database example server1 to get server2 information. SQL2000 can select statement as server.dbname.dbo.tablename, so how to work in SQL6.5 Thank you....more >>

If I do the following, it works... EXEC sp_addlinkedserver @server = test , @srvproduct = 'Jet 4.0', @provider = 'Microsoft.Jet.OLEDB.4.0', -- @datasrc = 'i:\test Database\Data\test.mdb', @datasrc = 'd:apps\test Database\...more >>

Good day, I have an application that uses connection optimizers (or SET options as they are called) that I dont want to have to set EVERY single call to the DB (we create new connections for each query to use connection pooling). I was wondering if there is a way to set a list of these co...more >>

Hi All, How do I monitor a databasetable located in Oracle 9i for updates/inserts from my SQL Server 2000 instance? Can I accomplish this by using linked servers ? Regards, Marcel ...more >>

I have started having problems with Linked Servers and Inserting data into tables. When I use the following statement (Insert x_table (a_col, b_col, c_col) Select a_col, b_col, c_col From LinkServer.database.dbo.x_table) the insert never completes (runs for days, it also does cancel). T...more >>

I setup a batch file to stop the SQL services before a backup, but it doesn't work. When I check the backup log, it says the service was not stopped. I went to stop it manually and it prompted me to enter either Yes or No. Is there a way to force the service to stop unattended? Thank...more >>

Hi, last week I changed my eMail address, because I get more then 500 virusmail on a day. After this change I get no virusmail until I give you my new eMail address. Therfore I think someone will scan your sender's eMail addresses and send virusmail on this adresses. Have anybody the same pr...more >>

Hi, when I connect to the SQL-Server 2000 with the tcp/ip- protocoll I receive the error message "SQL-Server does not exist". With an udp port scanner I tested the port 1433, but the port wasn't open. Why does not the server listen on this port, even if the tcp/protocoll is activated with...more >>

Hi Help!!! I am using sql server 2000 with microsoft windowsXP. I am using Microsoft Visual Studio 2003. My version of Sql server is tha latest server 2000 Eval. Which should run with windowsXp Pro. But but gess what ?!?!?!?! It doesnt. I have tryed to find something about this. There a...more >>

We recently have this problem. When the linked server provider is set to recognize windows authentication only, and the client creates a linked server without userid mapping, when trying to connect to the linked server, I got "Error 18456: Login failed for user'NT AUTHORITY\ANONYMOUS ...more >>

SQL Server does not exist or access denied ------------------------------------------ Hello, We came accross a major problem in one of our latest projects... This is the situation: We have SQL server 2000 (standard edition + SP3) running on a windows server 2003 machine (standard e...more >>

Hi, I've set up "Force protocol encryption" on MSDE site and remote clients can connect to this DB correctly. But I'm curious if it is really working so I'd like to verify it so is there any other way to check it except capturing every packet and examining its content? Regards Silmar ...more >>

I have a SQL server that is hosting 5 databases, when I try and use Enterprise Manager running it from the server its self and connect to one specific database I get A runtime Error has occurred Do you wish to debug? Line 306 Error: Unspecified error it only does it for one specific da...more >>

I use sp_addlinkedserver create a link to Foxpro files by using the lastest VFPOLEDB driver. If I use QA to query the table, it works fine. But if I put that query into scheduled job in SQL Server Agent, I get this error message: Executed as user: domainName\domainAccount. Could not init...more >>

I have two SQL servers set up on a computer. One of the SQL servers is the 'local' or default SQL servers installed. The default server is setup by the installation application. Then I installed another SQL Server called 'TEST'. I didn't change any security settings on any of the SQL S...more >>

Ok.......... I'm new to this so please bare with me. I'm trying to connect to a SQL database via a SqlDataAdapter. I have a Load button that should be loading the info onto a DataGrid. I can preview the information view the Data Adapter Preview but I can't load it onto my Datagrid when I run ...more >>