We are using SQL Server 2000 Standard Edition. The MSQLserver service starts and the stops. We need to restore 2 databases, but cannot since the service will not start: This is a copy of the error log: 2007-09-27 18:17:21.00 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) ...more >>

I installed SQL 2005 with some settings which is below. INSTANCE NAME: CAVCAV Protocols For CAVCAV : Shared Memory : Enabled Named Pipes : Enabled , Pipe Name :\\.\pipe\MSSQL$CAVCAVsql\query TCP/IP : Enabled Yes Ip address : Ip1 active:yes enabled :yes Ip Adress : 212.154.38.146 T...more >>

Every morning, i have been experiencing this problem with my test server. i unable to connect to SQL using Management Studio, oSQL, ODBC, Query Analyzer from other computer at all. I migrated SQl server from sql 2000 into SQL 2005 two weeks ago i have iinstalled service pack 2, change the rem...more >>

I am getting this error message: SQL Network Interfaces, error: 26 - Error Locating Server/Instance. I have talked with my hosting company and they don't allow remote connections. Is there a work around code I can put in my web.config file for this? Thanks *** Sent via Developersdex http:/...more >>

Is it possible to make a connection from the CF 2.0 using the SQLClient to a SQL Server 2005 where encryption is enabled and a SSL certificate is installed ? If so, which versions of SQL Server 2005 supports this ? Do I need a special SSL certificate to do this ? Kay ...more >>

Hi I want to check if a server is available - at present the system just gives a message then bombs out - I want to be able to redirect to another server if the software cannot find the initial connection string Can you please help!! -- Regards Bob...more >>

Background : moved a database from one sql server to another by detaching it from old and attcahing on new server, SQL2000. Old server was w2k new one is w2003. In EM all works fine, can see the tables and work with them. Have a windows form app on a nother machine that uses a connection st...more >>

We're working to get our remote clients connected via ODBC to a new SQL 2005 server. Our programmers have a Powerbuilder executable that connects to the database. Clients that are on the local, high-speed lan can connect in a few seconds, however remote, T1 clients can take over 120 seconds to...more >>

Hello, I'm using SQL2005 Express User Instance Feature. The OS is Windows XPSP2 up to date with updates. I have a problem connecting to the SQL 2005 Express instance when it is installed while the computer is a domain member. The user instance is accessed by a local user (as opposed to a domai...more >>

Hello, I am quite new to sql 2005. We have an application that was using msde. We recently moved it to sql 2005 and now we get idle sessions disconnected after about 20 minutes. I have searched the doc for answers and can't find any. Where are the session auto disconnection times set in...more >>

Hi, We publish our pages in a 3rd party web server, so they host our website. but behind scence data is stored in our internal SQL server, all outside traffic needs go through our router before reach the SQL server, so in the Web Configuration file, in connection string entry, "Data Source", ...more >>

We installed our SQL Server / Access Client application at a clients site several months ago. This customer was using the Windows XP Security Firewall. Because we could not get our software to connect to SQL Server with the Firewall on we turned it off. But, our customer would like to have the...more >>

I have a new computer with Windows VISTA on it. I have installed SQLExpress and everything appears correct - i did not have issues during set-up, that I can remember, I did this some while ago. I have just started to consider using SQLExpress, my issue is I cannot create a new database. I...more >>

Hi I have a MFC application which uses CFileDialog. When I use the following managed code to connect to SQL, as soon as I have the Open, the "My computer" and other virtual folders do not display any folders. But when I have Open commented out everything works fine. SqlConnection *myConnect...more >>

hi, I had a query on sql database, we know we usually store files of different type in sql database and its helpful for searching and retrieving the documents from the database, but one query i had was related to the amount of space required to store the files in the database. For Eg....more >>

Hi, If I have a Intel x86 64 bit server, installed Win2003 64bit OS + MSSQL2005 64 bit version, and the client running Intel "Core2 Duo" (32 bit), installed WinXP Prof, is the client able to connect to MSSQL2005 64 bit Database thro ODBC drivers? Thanks ...more >>

Hi All, I am running SQL Server 2005 SP2 (Without SP1) on Windows 2003 Machine. I am facing a very strange problem. Sometimes the database stops responding, In this situation no user from my web application can connect to database. But If I go to server and open connection by management stu...more >>