Hi, I really can not connect to our remote MSDE database running under Ms 2003 server web edition. I am thinking that it might be the problem of firewall which block port 1433,but my ISP don't think so. How can I check that my server is listening on port 1433 or not?? -- Met vriendelijk...more >>

Hi, I am trying to connect to a MSDE Sp3 database remotely, however I always got "server does not exist or access denied". I was told that the problem is from sp3. Any idea how can I solved the problem?? -- Met vriendelijke groet, Guoqi Zheng Tel: +31 (0) 23 5343545 http://www.meetholl...more >>

I installed SQL Server 2000 on Win2k3, and it seemed to install correctly, but I could never connect to the database. I uninstalled it and attempted to reinstall it, but I always get this message "Setup failed to configure the server" then it aborts. I tried everything in MSKB #801499, ...more >>

I recently restored a database from tape. However when I go into SQL Enterprise Manager, I see the recently restored database showing "loading". I assumed that this was a good indication however it has been loading now for the last 12 hours. The database is about 17 gig. Is this normal or ...more >>

i have a few spids that aren't releasing after they are told by visual basic 6.0 code. Is there any way to investigate the spid (besides using the sysprocess, dbcc input buffer, etc - this spid is not blocking anything) to see what it was doing last? or why it is hanging on. if there is ...more >>

Hello, I'd like to create an ado connection to my linked server called Prob_Schd on a machine called pccn-nt. When I use the code below I recieve an error of the type ' Invalid connection string attribute'. Would someone show me how to create an ado connection to a linked server? Thanks, Chie...more >>

I try to connect to the pubs database but get the following error: Server Error in '/myWebApp' Application. -------------------------------------------------------------------------------- Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Im ...more >>

hello all, iam trying to connect to a sql server using thsi format Application("ConnectStr") = "provider=SQLOLEDB;SERVER=xxxxxx;UID=xx;PWD=xxxxxxxxxx; DATABASE=xxxxxxxx". earlier this used to work fine. but offlate i started getting a error : Microsoft OLE DB Provider for SQL Se...more >>

Hi All, My problem is this , that I'm not able to connect to one (a particular one) of my SQL server from my client machine. Though I'm able to connect to other SQl servers but only that particular sever does not connect. I have full permissions given on that server. I checked all proper...more >>

We recently moved our Access databases to SQL and are trying to get our pages to open the connections to the server. I've set the system DSNs on the server as needed. However, no connections are made. After reviewing several books, microsoft.com, etc...I'm severely frustrated. The only thi...more >>

I have an SQL 2000 server with two instances of SQL installed. I am trying to connect to a database in the second instance using Windows 2000 Pro workstations. I have successfully connected to this instance from many other workstations. I have rebuilt one totally from scratch and applied a...more >>

When attempting to configure an OleDbDataAdapter I get the following error message: [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied. Here is the detail I am evaluating Visual Studio.Net and I am new to the environment. In the process of evaluating VS...more >>

hi, the sqlserveragent service start successfully and failed after 40 seconds. it use local system account. after that I use sysadmin account to start it,its work well but the jobs didnt work? if u can help plz do!...more >>

Please help!! I need to use NET Compact Framework and Oracle Lite. Does somebody know if there is a provider ADOCE to connect an application in NET Compact Framework with Oracle Lite? Thanks in advance. sergei98 ----------------------------------------------------------------------...more >>

I have installed SQLEVAL and the service pach 3 on Windows XP Home edition.... now i can't use telnet/ftp connection because my port23 is closed and i can't uninstall SQL because there isn't an uninstallation file. I don't know what i have to do. thanks to much. lmc...more >>

I have a job that connects one SQL Server to another (both MSDE). Sometimes (most of the times) a got an error that says: "Login failed for user 'userID'. Reason: Not associated with a trusted SQL connection." I already have made all the things that i see in newsgroups to correct the problem ...more >>

I have a problem with installation of sqlserver 2000. I have a pc at home, my pc is not in a network. The operative system installed is windows xp professional. When I try to install sqlserver I receive the following message: " sqlserver 2000 enterprise edition component is not supported ...more >>

Hi All when i try to register an instance of SQL server sometimes it's registered successfully and sometimes not, giving me the error SQL server Error:17 SQL server does not exist or access denied. I installed service pack 3 and i still get error. Also when i try to add a Data source, i can do ...more >>

Hi All when i try to register an instance of SQL server sometimes it's registered successfully and sometimes not, giving me the error SQL server Error:17 SQL server does not exist or access denied. I installed service pack 3 and i still get error. Also when i try to add a Data source, i can do ...more >>

Hi, I'm running WinXP Pro, when I try to connect to MSSQL Server via ASP.NET, I get an error with the message "Login failed for user 'userID'. Reason: Not associated with a trusted SQL." I set up a log-in, which is set to SQL Server Authentication, I tried enabling named pipes, and still a...more >>

When I try to connect to the SQL Server I get this error message: "Unable to connect to Server [SRVNAME] Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied" My computer is outside the network. It actually works with ...more >>

I have to recover a database and redirect it to another server with the same database name. Every time I run the job, I get "Unable to attach to <servername>. A network connection to the device could not be established." What am I missing? How can I redirect a SQL restore to another serv...more >>

What is this error message meaning? Please help? SqlDumpExceptionHandler Process 196 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process....more >>

Hi, I installed SP3 over SQL2K on NT Server SP6. The Server hangs on startup. This is after I did an upgrade installation of SQL 7 to SQL Server 2000 and applied SP3 over it. Everything runs fine for afew hours and then we get the message below and some of our servers lose the ability to ...more >>

I can't create a linked server when the same two servers are set up for replicatation. I get 'Error 15028: The server 'SERVERNAME' already exists.' when I try to add a linked server. And it does exist as a Remote Server because as I mentioned, the two servers are replicating data. There has to ...more >>

I've been having trouble connecting to a 2nd instance of a SQL Server 2k with some VB.NET code from my WinXP Prof workstation. "System.Data.SqlClient.SqlException: Specified SQL server not found: my server" My application connects just fine from a Win2k machine with a like Client Network Ut...more >>

On a server the SQL Agent service did not startup after reboot. There is definitely a tick in Auto-Start. I get the following error in the SQL Agent log:- [298] SQLServer Error: 1265, Cannot generate SSPI context [SQLSTATE HY000] [000] Unable to connect to server '2003SERV2\DEVIN1'; SQLServe...more >>

Does anyone know of any current ADO/RDS issues that could cause a connection to the database to fail? Any conflicts or problems with newer patches/service packs/updates? I have an application that has connectivity problems intermittently. It clears itself up after 3-5 minutes. The issue can...more >>

I've been workink with a WebService locally using a connection string with 'data source=(local)' for a number of weeks and I wanted to move my database onto our production server, Zeus. So i change the connection string to 'data source=Zeus'. When I Preview Data in Visual Studio .NET ever...more >>

Hi All, I need to make a trusted connection for sql2000 but not sure how. I am using NT authentication. If possible I would like it to be Sql server login instead. Please give instructs. Thanks, Pete...more >>

Need help with Sql access. I have an Office 2000 access project front end to an sql database. I normally use win98 with the sql connectivity client and have no problems. I built a new pc with xp and get the error "no such interface supported". I have office 2000 installed with all the ...more >>

Hi All, I am really stuck with this thing and not able to thing of any good reason. Is there any body who can help me out!!! I am using sp_addlinkedserver to connect to a foxpro DB like this. And I am executing this stored proc on \\NU-CAPDE-01 (local machine) exec sp_addlinkedserver @s...more >>

What is the max database size in SQL Server 2000? What is the Max Table size in SQL Server 2000? I am expecting that my databae will get 20 milion row each day. What should be the server configuration in tarmes of hardware and software (OS)? ...more >>

I have SQL server 7 running on Win NT server (separate domain). I wish to have ODBC connectivity to the said server from Windows 2000 server in another domain. When I try I get the followin error SQL State : 4200 SQL Error : 18452 Reason : Not Associated with trusted SQL Server Connection...more >>

Hello, I have an Windows application which works on an SQL DataBase. I would like to run this application trough the Internet. My Web server and SQL server are connected together with a Hub. How could i run my windows application (Programs are on my own computer) and use the SQL DataBase wh...more >>

Hello all. We're trying to connect to SQL Server via VS.NET's Server Browser. We've done everything in this article about enabling debugging http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxlrfsettingupsqldebuggingenablingsqldebuggingonsql2000desktop.asp. It still o...more >>

Hi all, I need your help re the following situation: I have a network of 2 pc, WinXp and Win2KPro. A SQLServer2K instance is running on each. I want to connect onto the WinXp instance from Win2KPro. Its ok, using an AccessXp client, with an SQLServer connexion, using sa + pwd. From the ...more >>

When I try to register another server from another computer, I get an error. The computer sees the other server, but won't allow me register it, even all usernames and passowrds are the same...more >>

I am having trouble linking to a Sybase DB through SQL 2000. I continue to get an error 7399: OLE DB provider 'Sybase.ASEOLEDBProvider' reported an error. OLE DB trace error [OLE/DB 'Sybase.ASEOLEDBProvider' IDBinitialize::returned 0x80004005: ]. The Knowledge base really doesn't see...more >>

Hello - I'm trying to run Exec sp_change_Users_login 'report' From a few databases on our production server. When I try to execute, I'm receiving the following error message: Server: Msg 15289, Level 16, State 1, Procedure sp_change_users_login, Line 27 Terminating this procedure. C...more >>

Hello -- We have a SQL Server 2000 machine that has approximately 500 user databases. Don't ask why -- I did not create this mess. Anyway, we have about 200 users access the SQL Server as a DSS machine using SA. We've finally weaned all users off of SA and each have their on ID per custo...more >>

I'm using SQL Server 2000 SP3. I've a VB 6 application that connects to a database using ADO. When opening a recordset I sometimes get the error:- Run-time error '-2147467259 (80004005)': Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I am...more >>

HI ALL I got SQL Server 2000 SQL1 and in linked servers i make server SQL2 witch looking at itseft (SQL1)...looks like loopback I need this for debuging. In real system i got 2 servers When i start transaction in server SQL01 and do some work with linked server SQL2 i got message "The operation ...more >>

I have two nearly identical servers (Dell 2650's, exactly the same h/w, same directory structure, same software, same pacthes installed, etc.). Both servers run Windows 2000 Server (SP4) and SQL Server 2000 standard edition (SP3a) in mixed mode. Until a month ago, both of these servers ...more >>

When I failed to update records of a table, SQL server locks the table. And then I cannot run the SELECT . Why? How can I do ? When failed to update ,it maybe lock the row of record ,not table. I think. ...more >>

Really would appreciate some advice on this problem. I have a cluster, CORPUSGA and a stand alone server CORPUSAPP22. CORPUSAPP22 has a linked server set up to CORPUSGA using 'sa' as the security context. Within a stored procedure I am running a SELECT to CORPUSGA.msdb.dbo.sysjobs. When this is...more >>

Hi, We have a simple stored procedure that has a text parameter, among others. Inside the procedure the text parameter is assigned to a text column in a simple SET clause of a simple UPDATE statement. We pass a 15 character string as an argument for the parameter, and even though the string i...more >>

Hi I've two SQL server one running with windows 2000 server (A) and an other running into a windows 2000 cluster (B). I've tried to read some tables in (A) from (B) but I've this error Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. In ...more >>

this is the scenario: I've a windows2k with MSDE2k Sp3 intalled On windows2k TCP/IP is disabled and IPX/SPX is enabled I configured MSDE to use IPX/SPX network library with the network client configuration utility and then server with SVRNETCN.exe but clients cannot establish a connection. t...more >>

Good day! My program which was developed using Visual Basic 6 as the programming language, MS SQL 2000 as the database and Seagate Crystal Report as reporting tool. The program runs well in all the PC except for one. When the program suppose to display a report, it says "Cannot Open SQ...more >>