I just installed SQL Server 2005 Express edition, and created an app in Visual Studio using C#. I get the following error when trying to connect: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact ...more >>

I have spent the best part of 4 days trying to connect to SQL 2005 express from an winforms app! Yes , I have checked surface config and TCP/IP blah blah ... I have trawled the net and spent countless hours on MSDN and many have tried to help. I have changed the passwords to strongly typed... ...more >>

I have a client with two Perl CGI intranet database applications that have been working successfully for over a year. Each one runs on the same IIS6 server and connects to a different database within the same SQL Server on a different machine using the same SQL user. Recently (within the l...more >>

When I try to connect one one of our SQL Server databases using SQL Server 2005 client tools I get the following error. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that inder the default set...more >>

Hi I'm not sure if this is the right Newsgroup for this question, apologies if it's off topic. I've got a stored procedure that calls a second stored procedure on a linked server. My local stored procedure encloses the call to the remote stored procedure in a try - catch block. I have ...more >>

I have an Access 2003 database that I have split, then upsized to SQL Server 2005. The database works find on the machine that has the SQL Server 2005, but when I try to run the program from another machine on the network, I get the following error: An error has occurred while establishing a...more >>

Hi all, can you help me with following message: Error: 10054, ErrorMessage: "TCP Provider: An existing connection was forcibly closed by the remote host". Env: W2k sp4,SQL 2005 Express, Management Studio Express I have found only some registry change for Win 2003 only. I'm not sure it ...more >>

I have recently installed SQL Server 2005 onto my development machine and another developers machine. I am trying to connect to his server via my SQL Server Management Studio but I am getting the following error. ================================================== "A connection was successfull...more >>

I would like to know how can I count SQL CAL on the servers I mean i.e. if I assign 50 CALs to a SQL server 2005, how can I know how many users connect to the server in order to compliance licensing I know the SQL license model. I do not care Processor license because I can know how many serve...more >>

Hi I'm having trouble connecting to an instance of SQL Server 2005 (Express) from 2 individual Windows Server 2003 machines running IIS (asp.net 2.0) I have an IIS on each 2k3 machine, both with identical sites. The idea is simply that we have a third sql server which is accessed by these ...more >>

Just installed the eval edition of 2005, and when I went to make a connection, was told that the engine wasn't started. How do I start the db engine???...more >>

Hello, I have some application that fails to connect to my SQL Server 2005 Express Edition (PC\SQLEXPRESS). The application configuartion required providing connection string. I have written: Server=localhost,1037;Database=MIMProjekty;User ID=;Password= But I receive error: Test .NET ...more >>

i have two inserts and one delete i want in one transaction, is there any issue with this tsql strategy: http://rafb.net/paste/results/uY2KYP16.html ...more >>

Hi! How can I determine the size of my server in sql server? Please help! Thanks! ...more >>

Some application I need cannot connect to my SQL Server 2005 Express Edition because of the following problem: java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property. I am beginner. Could you help me please? I don't know wh...more >>

Folks, I have an MDF and LDF file which I am attempting to attach as a SQL db. I keep getting the error 602 that begins with "could not find row in sysindexes for database ID 13, object id 1, index id 1". I think MDF and LDF files are SQL 2000, but I'm having my doubts. If I tried to lo...more >>

However it works perfectly if I specify the full server name like this 192-55-55-55\SQLEXPRESS. Is there any way to configure it so I would be able to connect to it using localhost? Thank you, Vlad ...more >>

I am getting the following error when trying to access a database with a trusted connection: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." My connection string is: "Server=MyServer; Database=MyCatalog; Trusted_Connection=True;" N...more >>

I don't understand why. My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert (administrator) account on Windows XP Professional. I use Windows Authentication. Remote connections are switched on ("Using both TCP/IP and names pipes.") Please help. Thank you. /RAM/ ...more >>

Does there exist an ODBC or OLEDB/ADODB driver for talking to SQL server over HTTP/port 80? In other words, I want to be able to issue SQL commands (INSERTs, UPDATEs, SELECTs) from a client application to a database that happens to be sitting on a server somewhere that I can only reach via HTTP ...more >>

I provide for complete creation of a database in SQL Express from a script. When the moon is in the seventh house and Jupiter lies in Mars, it works wonderfully. HOWEVER, if I have used any external tool to look at the db such as the IDE or the SQL Manager Express, then I suspect but do not...more >>

I have SQL 2000 installed on the server, and running VB6.0 program on the clients. Everything was working ok until user began to complain they cannot logon because of a invalid username or password. the exact error is: Connection failed: SQLState: '0100' [Microsoft][ODBC SQL Server Dri...more >>

I need to change the IP address of the server where SQL 2000 is running. What implications can that have on the SQL DB?...more >>

HELP. I have installed SQL 2005 express onto a WIN XP Pro SP2 machine and have it working with a piece of software called IRIS. I have another machine connected to the IRIS software via a network drive, which I have installed over the mapped drive. My issue is that when I try to run IRIS softw...more >>

when i try to attach file there is an error occur " An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Net...more >>

I have a user application that runs on MS Access 2000. On one client PC, the user's PC log in and got the following error: 17[Microsoft][ODBC SQL Server Driver][DBNETLIB]AQL Server does not exist or access denied.:53[Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen(Connect())....more >>

I couldn’t connect to the sql server instance (10.192.130.80\development2 and 10.192.130.80\development3) remotely on enterprise manager and query analyzer. The error is sql server does not exist or access denied. I setup well in the client network utility and put sever name and port number ...more >>

I've searched trying to find help for "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send())", but couldn't find any solutions (and precious few leads). I think I've figured out the problem, and wanted to post it in case anyone else was looking also. My enabled protocols in...more >>

Hi all tthe full mssg is ::: A database-related exception occurred! System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon...more >>

how to use a sqlserver connection??...more >>

I have a bunch of SQL 2K servers that can see each other fine and can connect to each other. I have 2 SQL 2K servers on Win2K3R2 and everyone can see each other except these 2 can't see each other. I can force a connection, but the green light doesn't appear by default. One of the servers...more >>

I am trying to connect to an SQL Server using a vb.net program. It works if I put it on the SQL Server computer, but will not connect over my local network that is set up as a workgroup. I get the following message: Login failed for user 'DELL4100\Guest' DELL4100 is the computer name where t...more >>

What is the performance cost of not using connection pool when connecting to a sqlserver 2005 using windows identity. We are planning an application where the users windows identity is forwarded through all layers all the way into the sqlserver. This gives security and auditing advantages....more >>

Hi, Can someone help me with a connection problem! I am trying to connect from an XP SP2 machine remotely to a SQL Express database on a 2003 server. Everytime I try to connect via Visual Web Developer, i get the following error: "An error has occurred while establishing connection to ...more >>

I am experiencing this "known issue in MDAC", in which querys in MS = SQL against a selected tables in a Oracle server linked using "Microsoft = ODBC Driver for Oracle" can generate the error: OLE DB provider 'MSDASQL' returned an invalid schema definition. OLE DB error trace [Non-interface ...more >>

Hi! I have a strange problem. I have a few procedures which run fast in query analyzer, but extremely slow from Access (via ODBC) and for example Crystal Reports. The difference is enormous, the procedure takes about 1 second to run from QA; it takes about 200 seconds from Access. With t...more >>