I have a Windows Service middleware application that depends on SQL Server. We are migrating from an existing Windows 2000 server/ SQLServer 2000 to Windows 2003 Web Edition and SQLServer Express. At boot time and more often than not, the middleware application fails to start and SQLServer repor...more >>

Hi, I have created .net windows service for running an exe. Exe is running fine. It is used for inserting xml data in sql server database. My service mode is automatic. Whenevr i start my computer it is throwing me an error below :- "An unhandled exception of type 'system.data.sqlclient.s...more >>

Hi, I have requirment to Import and export the data using MS-access file. I am able to read the data from MS-access file, now i have to copy the tables to SQL server , after processing(jumble) the data again, i have to export the data to same MS-access file. ...more >>

We just get a connection.txt file from another organization that should be useful for my company. I am new to SQL connection and would like to seek your advice on what does it mean. packet size=4096;user id=HRprocess;pwd=process;data source=DA16\B1;persist security info=False;initial cat...more >>

If you edit File and Print Sharing in Windows Firewall, you'll see that it lists 2 UDP ports and 2 TCP ports. This is something that cannot be done normally but is offered through the XPSP2 resource DLL. You can see this by looking at the registry entry for GloballyOpenPorts under HKLM. ...more >>

I am having a problem connecting to my SQL 2005 named instance on a clustered server in another domaim. If I am within the domain everything works fine. If I am in a different domain, I cannot register it through SQL Management Studio or create an ODBC connection. I can ping it and all of the ...more >>

im experiencing connection timeout in SQLSERVER2000 when using my web application. It seems the database connection pool has been reached. Im using microsoft application block sqlhelper to connect to the database. A temporary solution is to increase the connection timeout and/or increase the d...more >>

Okay, this is probably a stupid question, but so be it. I've had a cert on a SQL server containing only one database. I'm now considering putting a cert on our main db server. But I can't find any info as to whether I should be concerned about how all the individual database applications w...more >>

I was wondering if it was possible to remove internet access from a PC but, still run tracsactions over the internet using our software program which is connected the an internet accessable sql server via odbc? Our SQL sales program processes credit and gift cards, because of this all of the ...more >>

I have a SharePoint server that I want to be able to connect to its database and pull info off. When I installed the Sharepoint server it installed an instance of msde. For the life of me I cannot remotely connect to this MSDE instance. I am able to remotely connect to the backup exec insta...more >>

Hello! I have been messing with this all day and it is beginning to aggrivate me. I am installing an instance of SQL Server 2005 on one of our machines to support WSUS and SCOM 07. I installed it a bit differently because I wanted the data files in a specific location and I dont know if t...more >>

Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tables off of the cluster onto other clusters or will that just create processing bottleneck on the cluster running SQL server? ...more >>

I have almost the same problem than Clive (cf 18/07). I have 2 servers S1, S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2). The two servers are indentical, but if the two clients can connect S1, they cant' connect to S2 ""Access denied or SQL Server does not exist" (but ...more >>

hi all, I have a vfp8 application that works with sql2000. now we have to use it with sql2005. the actual connestion string is lik Driver={SQL Server}; Server=myserver; Database=mydb; Uid=myuser; PWD=mypwd; I have read in the books that for sql2005 I have to use Driver={SQL Native Clie...more >>

I'm trying to install a bespoke application for a new client, and am embarassed by not being able to connect to their DB Server. The server and clients are XP all running on a workgroup called OFFICE File access is not problem and the DB Server name appears in a dropdown box of SQL servers...more >>

I am having difficulty connecting to SQL Server 2000 on one of our servers via a VB6 program on Vista. I can connect fine to a different server, but it gives me the following error with the server in question: "Unable to connect to database. Please check your internet connection Error# -21...more >>

Hi everyone, I have something weird with an SQL Client connection and the default protocols. I set the TCP has the only one default client protocol with the CLICONFG tool. On most of the computers, when a client wants to connect to a server with its IP (somewhere over Internet), it uses ...more >>

[Discouraged by the lack of any response on microsoft.public.access.odbcclientsvr, I'm now cross-posting to microsoft.public.sqlserverconnect and microsoft.public.access. If the message does not explain the problem adequately or is sent to the wrong group, please let me know what else is nee...more >>

Everything was working fine until suddenly this problem appeared from nowhere: Boot up the pc and go into SQL Server Management Studio. The database is present and the data can be accessed. Go into VB2005 Express and run the project. Everything works fine. Open Database Explorer and c...more >>

Hi. I have an IIS web site built using Visual Studio 2005. I'm trying to add a database connection via a GridView, but I keep getting the following error when I test the connection: "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, th...more >>

Hello, I've noticed that if you have model and tempdb to different compatability levels and restart the sql instance, the value in sysdatabases (cmptlevel) does not get changed correctly. Here's how to reproduce: 1. set model compatability to one level, say 9.0 2. set tempdb compatab...more >>

Last time i started my PC the SQL Server had stopped, this seems to have created other issues - 1. Business Contact Manager not available 2. Outlook and Explorer take 10 minutes to load Are these issues connected? How can I resolve the problem? Help - I'm not a techie...more >>

Hello. I have a sql server install / database on the web server. Work great, all my asp.net 2.0 code on that server can access the database with no problem. I can access the database on the web server from my development machine through sql authentication from the sql server client with ...more >>

This is very odd. I have a VB6 application. I have fixed it up to play nice with Vista, and embedded a manifest (contents at the end of this post) into the exe. When I try to connect to the SQl Server 2005 server from a Vista client, I get a timeout on the first try. My app asks to verify t...more >>

Hi All, We have a .NET 2.0 web application. Occasionally, we get the following error below when we are doing performance testing. It is not consistent and only happens every once in awhile. We are using TCP/IP and only have one instance of SQL running. We do specify connection pooling i...more >>

I installed msde fine I installed webadmin fine I try to fire up webadmin from the server's local interface...I get Access denied to the path "I:\Windows\Microsoft.net\framework\v1.1.4322\Temporary ASP.NET Files\webadmin\38132526\7607cfaa" Apparently, ASP.net is trying to create temp files,...more >>

Hi, after inserting a record in a table (sql server), i need the last value of the primary key of that table, which increments automatically, before inserting that value in another table. I did like this: comd.CommandText = "insert into [mytable] (field1, field2) values(@datbeg ,@date...more >>

Hi, i try to insert values into a sql server table like this (code-behind): comm1 = Textbox1.Text comm2=Textbox2.Text ....... comd.CommandText = "insert into [dbo].[mytable] (field1, field2,...) values(comm1, comm2, ....)" i get the error: The name "field1l" is not permitted in thi...more >>

I have a webservice I am creating. I am needing to connect to a SQL server on a different machine using SQL authetication. I have the connection string located in the machine.config. Could somebody give me a sample of how to use that connection string to connect to the database from inside a w...more >>

We have a situation where multiple-random client connections to SQL server get disconnected. The workstations are not consistent, the time is not consistent, and the functions being run are not consistent. One thing that we can reproduce is that sometime, but not always, if a workstation r...more >>

Hi all, I am trying to add an Access database as a linked server in SQL Server 2005. For a "regular" database, everything works fine. BUT (there's a but...) the database I'm trying to access is a "read-only" database (i.e.: folder in which db is located is read-only). When I open it from A...more >>

Hi guys, I have an application that uses ADO.Net (2.0) to connect to SQL Server. We've never had any problems connecting to SQL Server 2005 using this application, but one client has had problems and the error he gets is of the type "General Connection Error...[Microsoft][ODBC SQL S...more >>

This week we are migrating our servers from one domain to another. We have SQL Server 2000 installed on two cluster servers running MS Server 2000 . After migration I updated the registry with the new IP addrerss per MS instructions on migrating a cluster to a new IP address. We began...more >>

Hi, I am using the following connection string from Access vba to call stored procedure. However, there is error in the connection. When I am checking the same connection from the control Panel using dsn, the connection shows success. I would appreciate if someone can tell me what's wrong wit...more >>