I'm developing a Window Form project in VS2005 (C#, WinForm) and SQL Server 2005 Standard Edition as database. When I try adding "SQL Database" by right clicking project in Solution Explorer => Add => New Item => SQL Database it shows following error message. ------------------------------...more >>

Hi all, If this is not the correct groups to post this, please redirect me. I have a .NET application and SQL Server 2005 Express running on a Windows Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database running on Windows 2000. SQL Server Express 2005 has the 2000 s...more >>

We recently upgraded our SQL 2000 SP3 instance (running on Windows 2000) to SQL 2000 SP4 running on Windows Server 2003 SP1. The migration went fine but we are now experiencing a problem where connections are not dropping once the application is finished with it. The application is a COM+ ap...more >>

Hello Is there any relation between SQL2005 connection and /share file and printer/ option in Windows firewall? When I check the option I can connect from remote client via script, while not that when I unchecked the option. I can't easily believe the two entities are related. I checked...more >>

i have a table that has no index on a date column and a regular index on a customer_id column. the customer_id will be somewhat volatile, lots of updates and and deletes on this table. this is the design i inherited and i need a little advice. table (pertinent columns shown here for bre...more >>

It's always great to run into problems on a Friday afternoon before a holiday weekend, but here I am. I'm not sure when this started happening, but if I try to get properties on any of the databases on my SQL Server Express 2005 server (using the Management Studio GUI), it fails with the follo...more >>

I have both SQL Server 2000 Developer Edition SP3 and SQL Server 2005 Developer Edition (9.00.2047.00) installed on my WinXP SP2 notebook. I'm connecting from a Windows PocketPC 2003 Second Edition device which is running a custom app which uses SQL Server CE 3.0. The database I need to co...more >>

Hi, When I try to update a column value using MS SQL Server 2005 Management Studio (SMS), I am getting "timeout period elapsed prior to the completion of the operation". Our server setup is: 2 identical MS SQL 2005 installed in Windows 2003 OS and the first server connected to second ...more >>

Hi there, We have two physical sites - A and B - and each has its own Domain. Within site A's domain, we created a link server and everything works just fine. We can call store procedures from one database to another database. We can also insert store procedure results into a temp table ...more >>

Created a new alias with the SQL Server client network utility. With the connection parameters, changed the server name to the IP address - still no success. Edited the Sql Server Network utility to use port 1433 to use port 0 (per another google discussion), still no success. Any other ...more >>

I had just install MS SQL 2005 at my server computer ( OS windows 2000 server sp4). I have LAN in office with workgroup, and I have a problem that I can't connect to MS SQL 2005 from client mechine. Previously, I used MS SQL 2000 server. Please anybody can help me to resolve this problem? ...more >>

I am making a local connection to an instance of SQL Express on XP SP2. I get the following error message: "Microsoft SQL Native Client: 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 unde...more >>

I have a couple large databases (20 databases, many GB of data in each). the vendor has told me that their application will work fine with 2005, but, I've not done the migration yet. Is it as simple as a backup from 2000 /restore to 2005? Can I detach the files for each DB and then just r...more >>

Hello, I have a Win2K3 Server running .Net Framework 2.0 applications. When I run an application for the first time on a particular day, the first connection takes an extremely long time to connect (60 seconds or more). Other connections afterwards are fine. I am running the application on ...more >>

I installed MS SQL Server 2000 and sp4. The operation system is Windows 2003 server. On server machine, I open server network utility, and checked. found that the default TCP port at server end is not 1433. Why? But then I open Client Network Utility, the default port is 1433. On my machine....more >>

Hi, all, I have SQL Server 2005 Express and Visual Studio 2005 installed on the same machine. I created a database using Management Studio Express, and a C# application to access the database. Here's the problem: I can connect to the database via either the C# application or the Manageme...more >>

how to use SQL server 2005 ? i want to know much information with it.. thanks . ...more >>

Hello all- Connecting to a SQL Server 2005 Express w/Advanced Services database using ADODB in vbscript. The database is on the local server and am using shared memory. The server has dual processors and 3GB Ram, but SQL Server Express is limited to 1 processor and 1 GB of ram. Every on...more >>

Good evening, I've been struggling with this for a few days. I was able to connect to both Analysis Services and the Database Engine of SQL Server 2005 when I first installed it. Just the other day, I started getting the error below. Now, I can't connect to my database engine. I've uninstal...more >>

I've got SQL Server Express 2005 running as a backend and a front-end made with microsoft access. I can connect when I run the front-end on the same machine as the SQL Server but as soon as I try to set up a network ODBC connection I get these errors. (The access front-end can see the SQL Server...more >>

I asked my question in VB groups and was suggested to ask here. My question: I have VB6 project working with SQL2000 database. I use ADO. Is it going to work without any change with the same database attached to SQL2005? If NO, then what kind of changes are required to make it work? Thank ...more >>

I migrated from SQL Server 2000 Standard to SQL Server 2005 Standard x64. Now i try to get the linked Servers working, but it looks like there is no way to use ODBC Data sources as linked servers. Yes of course, i ve got 64-Bit ODBC Drviers installed and tested. The MSDASQL (ole db provi...more >>