I have a weird problem. I have a web application that is in ASP.NET 2.0. It was connected to a SQL 2000 single server no problem. I changed the connection to our SQL 2000 cluster and it won't connect. It gives me this error: Named Pipes Provider, error: 40 - Could not open a connection ...more >>

I want to fetch data from Oracle 8i, so how do I connect with SQL Server 2005? I want to use the connection in SQL IS, RS & AS and also perhaps using a Linked Server. And what do I need to install on my server? Any good/bad experience out there?? Please help!...more >>

Hi, how to check how many connections current be used? Thanks, ...more >>

Hi, I'm building up a membership website by using MS SQL Express and ASP.NET2.0 with IIS on Windows XP Professional. I've developed a login page for the user to type the username and password to login. Everything is ok when I use VS.net 2005 to do testing. However,I can't login the websit...more >>

I have about 30 machines that I currently manage. I should also say, I just took over this position as Senior DBA. One machine is a Windows 2003 Quad Processor 4GB ram box with SQL 2000 Standard Edition installed. I am in the SQL Admin group and SQL is set for both SQL and WIndows authenica...more >>

I completed a default install that uses the server name: Server1 and completed an instance install on Server1 called Server1test with the same users, etc. I can connect remotely to Server1 using SQL Server 2005 Management Studio, but when I try to connect to Server1\Server1test I get: An e...more >>

I've got a windows 2003 server running sql server 2005. When I run a web site on a desktop machine, there is no problem connecting to the database. But, when I run the same web site with the same connection string on the 2003 server, I get the following error: An error has occurred while e...more >>

We have one sql server 2005 machine which have two instance named: DEVSQL(default server named when first installed) and DEVSQL\TESTING (second installed). On the client, I can connect default instance, but the second instance cannot connect. What settings I should to do? ...more >>

Hi, 1. I have a SQL2000, SP3 Linked Server to an Access mdb that breaks every couple of weeks. If I do a SELECT statement to the Linked server in Query Analyzer,, even on a small table of 3 records, QA seems to be working, and no error messages come up. However, the SELECT command never ...more >>

Ok here is the problem. I am trying to set up logging on SQL 2005. Now I am trying to setup the OBDC on the ISA server and it is failing each time. It cannot reach the server. Every other computer in the domain can access the SQL server via OBDC. So what am I missing to do that on the ISA s...more >>

If you can't get connected to SQL Server, you need to help us help you = by providing the answers to as many of these questions as possible: a.. The version of SQL Server you're accessing. For example, SQL = Server 2000, SP3. b.. Are you accessing SQL Express via User Instance? c.. Are yo...more >>

hello, i want to install sql server 2000 in my machine which has win xp. now the problem is that it does not get connected to the server. error message comes that there is a connection failure. pls help me thank u bitu...more >>

I have an active/active SQL2005 cluster. Node1 has a default instance of SQL 2005 installed (i.e. no named instance). Node2 has a named instance of SQL 2005 (i.e. node2\sqlb). I can connect remotely to node1 SQL 2005 without problem. When I attempt to connect to node2 remotely I get an err...more >>

I need to create my own SQL Client and am looking for resources on the protocol used to communicate to the Server via port 1433. Any info would be helpful... Thank you, Scott<- ...more >>

I installed the latest version of VB Express & SQL Express with no trouble. VB fails to connect to any database -- even the sample applications fail with an SQL Exception: System.Data.SqlClient.SqlException was unhandled Class=20 ErrorCode=-2146232060 LineNumber=0 Message="An...more >>

HI, I have just installed vista and reinstalled the SQL tools, but can not longer connect to the SQL Server 2005 server. I recall there where some diag nostic tools (sqlping ??) that could help resolve connection issues (vista firewall is off) but can not find them. Where do I get them, a...more >>

Here is the situation: I have SQL server express 2005 installed on my pc as instance SQLEXPRESS. I have created a Visual Basic applicaion with the following as connection to the SQL server express 2005 running on the same PC: *****************************************************************...more >>

I am using SQLServer 2000, Visual Studio 2003, C#. I am writing a web part which requires me to connect to a local sql database. I wrote a class which handles the connection and reading of the table. When I try to call .Open on the connection, it fails, the exception is something to do wi...more >>

Win2003 Server R2 Sql2005 My problem is unless I Login as a user with administrator permissions I cannot connect the SQL DB on the main server. I want setup users as USERS on the local domain with minimal access and have use of the Application which uses the Sql Server TIA Sam ...more >>

Hi All, I am getting a BSoD when opening tables using Microsoft SQL Server Management Studio Express 9.00.2047.00. A few seconds after opening a table, it appears that the entire form refreshes and the table's gridlines will double for a split second. While my computer does not crash every ti...more >>

Hello, I'm using the AttachDBFilename option in the SQL connection string to attach a database to a SQLExpress instance on another machine. The is an error though, it seems to want to refer to a log file on the machine the .mdf was originally created on. The error is as follows: Could ...more >>

what does teh MSSQL$SQLEXPRESS event ID 17110 really men? can I just ignore that Event Type: Information Event Source: MISSAL$SQLEXPRESS Event Category: (2) Event ID: 17110 Date: 2007-01-04 Time: 08:38:26 User: N/A Computer: IEI-A64 Description: Registry startup parameters: For ...more >>

Hi, I have a W2k3 with SQL Server 2000 SP4. I have configured the server to use named pipes and TCP on 1433 (at least that is what the registry and server configuration tool say) However the server does not accept tcp connections (i tried with telnet, query analyzer, etc). Log says the follow...more >>

Hi, i installed sql server 2005 express on a windows xp prof. sp2 system. i also installed the 2005 studio management tool. I can connect to the sql server (sqlcmd -S), i can create a new database in the 2005 studio management tool, but i can't attach a mdf file. I'm administrator so have...more >>

I have an issue that is totally baffling me. When I use a program I've written to connect to SQLExpress (and a given database), all works well on my development system and on a laptop that I tested with. However, I have two users that I sent the SAME database files and program files to and at ...more >>

Hi, I am able to connect to the degault instance of a remote server But not able to connect to a Named Instance called DEVELOPMENT on a same remote server. I am using SQL Server 2005 Developer edition on my server, Windows server 2003 SP1 & on client side I am using XP Proff. SP2. I ...more >>