Hi! I have recently started using sql server management studio - I logon to my desktop (Vista ultimate 32 bit) at home (using an account like 'compname\myname') - I now VPN into my workplace (using my workplace account 'domainname\MyAcct'). Now, when I try to connect to a server at my wo...more >>

I have two machines called MA and MB. MA is hosting IIS and MB is hosting SQL Server. I'd like to use integrated security to access SQL Server in my application hosted in IIS. How should I configure the SQL Server so that it can recognize the Network Service account in another machine? Tha...more >>

Hi , I am using IIS 6.0 and have an ASP.NET where get the following error when trying to connect from a .NET assembly. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. So I read some info from other forums and understand that I must add the 'NT AUTHORITY\NETWORK SERVICE' as a user o...more >>

I've just installed SQL Server 2005 on my workstation, and attached an existing database using Management Studio. I can then browse the database in the Object Explorer and open the tables. But whenever I try to create a new query it fails to connect, and I can't run any queries against the ...more >>

I have a Sql Server 2k that needs a linked server set up to connect to a remote SQL Server 2k. The remote server is behind a firewall, and I don't want to open up port 1433 to the whole world. What other options are there to set up a linked server that is secure? What is the recommended sol...more >>

I have a question that is prob. something really quick to solve..... I am writing a program using C# and VS2005 I have two diff. ms sql servers set up on one ip using different ports for each. I can connect to one of the servers using the standard port but I have not been able to connect to the ...more >>

We are now testing out program using Vista. When we direct connect SQL 2000 using ADO, and SQL authentication, the login fail. When we use XP or Windows 2000, using ADO as connection, the program run fine. Is there anything we need to set? Ivan ...more >>

I am not able to connect on my SQLServer 2k enginge from VB.NET application. As part of trouble shooting process, First I tried to ping to SQL Server (Win2k and SQL2k) from the PC where I have the SQL connection problem. Pinging is working fine. Then I tried to telnetfrom that PC using ...more >>

When I try to use telnet to monitor sql2005 connectivity I'm getting an error says 17836 severity 20, state 1, Length specified in network packet payload did not match number of bytes read; the connection has been closed. Plase contact the vendor of the client library. In sql 2000, the same te...more >>

Hi, i have several mdf files for several asp.net applications. How can i reach such a database with sqlcmd? Thanks Bob ...more >>

I don't have Security Account Delegation for two SQL server so I cannot create a linked server. Any other ways to select tables from server A and insert into server B? (Besides SSIS, DTS, BCP)...more >>

I am having administrative previlages in the SQL Server Machine, but I am not able to connect to the SQL Server instance. Can you please help. I am using windows authendication. Thanks...Safeer ...more >>

Hi, this code inserts twice the same record. I thin it is due to the "Selet Scope_Identity" in the sqlcommand. If i remove the Select part, the inserts occurs only once. If i remove the line "comd.ExecuteNonQuery()", then the inserts also occurs once. Is there something wrong in my code?...more >>

Hi, i have installed sqlserver express 2005. I can manage sqlserver with MS sql server Sudio express. I also can use .mdf files with asp.net application. But when i type 'sqlcmd' in a dos-windows, i get the error: "Named pipes provider: could not open a connection to sql server" I also t...more >>

Hi, I want to find out number of SQL Server database engine running in my network ? I want to write code in VB but can you just give me idea? Regards, Sachin ...more >>

Hi, hope someone can help!!! I am programming with VS2005 with SQL Mobile Database. I've created a SQL mobile database and I can see it in my project. (MyTest1.sdf). I have the following code that should create a connection to the database: Imports System.Data.SqlServerCe Imports System.C...more >>

Hello, Having some trouble here with a CRM installation, and I think there is something wrong with our SQL Server, since we got the exact same issue with another application. Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for Microsoft Navision 4.0 and a .NET we...more >>

We have provisioned a new server to replace and existing SQL 2005 machine. We have a few win2k clients most of which are getting a "connection broken" error when trying to use the application that uses the SQL database. All the XP machines are ok so seems to be something that is particular t...more >>

I have the saem issue with my Precision 690 however I am using SQL Server 2005 Dev edition on Win XP SP2. I am not conviced that this has anything to do with the ACPI drivers. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

Hi All, I'm having a bit of a nightmare and could really do with some help. Our office server is running SQL 2005 Express. We have installed SQL 2005 Express in our remote web server. I want the web server to 'collect' data from the office server over night. We cannot get the two to...more >>

Hi All, I'd like to connect to a SQL Server 2000 instance which listens to not the default 1433 port. Can anyone help me with how to register the server in EM and how to connect to the server with QA? Thanks. Kolos...more >>

I want to know when someone will change Listen All to No for TCP/IP Protocol and set up individual IP addresses....more >>

Hi There, Who know how to detect active connection to a particular SQL Server? Eg: I have a SQL Server named MyServer and there are 3 computers link to MyServer when my application start, but how do I know which of the 3 computers is linked to MyServer when application is running? T...more >>

On some level I know how to use a trusted connection, but I am not actually certain what a trusted connection really is. I can't seem to find a clear explanation of what it is. What I mean is, was long as windows authentication is configured with sql server 2005, is any valid windows network '...more >>

here is the string: Data Source=.\MSSQLSERVER;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True i am trying to connect visuyal c# express with sql server 2005 develop edition ...more >>

Hello I have a database in warm standby The database was detached with sp_detach_db There seems to be no way to sp_attach_db and keep the database in standby mode? sp_attach_db seems to automatically recover the database into online mode i assumed it would leave the database uncha...more >>

Hello, We have 3 SQL servers. Server01 Win 2003 w/SQL 2000 192.168.1.1 Server02 Win 2003 w/SQL 2000 192.168.1.2 Server03 Win 2003 w/SQL 2005 192.168.1.3 Server02 can see Server01 and Server03. Server01 and Server03 can find each other but can not see Server02. I add 192.168.1.2 in Server0...more >>

Hi, We are running SQL Server 2005 with a local low-privileged service account. I would like to register the SPN (manually) to enable kerberos authentication. The domain admin gets the error message "Unable to locate account <Service Account Name>" when running the setspn command. I can...more >>

I have a remote server with SQL Server 2005 Express installed on it. I try to connect to it from my local machine using TCP/IP. I have the remote SQL Express set to mixed mode and enabled TCP/IP. If I connect using a self-created login it works fine and I can run queries against the database. ...more >>

I am remoting into a sql server 2005 express via vpn, and while my user acct does not have admin rights, it is a member of all of the sqlexpress groups. Needless to say I didn't install this sql server, but I think it was laid down with all of the defaults intact. Vague, sorry. One question...more >>

Is there an easy way to accomplish the following? Over the past 6 months I have made modification to an Excel Workbook that resides on the File Server. I have added Field Names in the Final Version (which coincide with Field Names on SQL Server) that don't exist in earlier version of the E...more >>

I have Microsoft Access ADP 2003 connected to a database running on SQL Server 2000. I just created a trigger on Table A to run on UPDATE. I also have a stored procedure that periodically updates Table A. The problem is that the stored procedure fials and returns the following error: OLE/D...more >>

Hello all, I see several older posts on this topic but I can't find a resolution outside of enable journaling on the as400 which is out of my control. I have a linked server setup in sql server 2k to an as400 using Microsoft OLE DB Provider for ODBC and the DSN uses the the iSeries Access for...more >>

Hello, I have been struggling with a problem when connecting to a SQL Server 2005 (Developer Edition) Database from a VB6 application that runs fine with SQL 2000. The problem seems to be that the time to opan a connection to the SQL 2005 Server takes longer than in SQL 2000. We use all ...more >>

We have a VB6 application that I recently converted over from SQL Server 2000 to SQL Server 2005. At numerous customer locations I am now experiencing occasional "lost connection" problems. This never happened with SQL 2000. Our client app does not use pooled connections and I have not been a...more >>

I notice that the following registries: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\SuperSocketNeLib HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\SuperSocketNeLib They seem to be for the same instance. But the first one has very detail info...more >>

I get the following error when I try to connect from an XP SP2 client to SQL MSDE: 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 remot...more >>

I want to understand the IP Addresses tab of the TCP/IP Properties in SQL Server Configuration Manager. The following settings are from the default named instance of SQL Server 2005 Express (computername\SQLEXPRESS) on a Windows XP SP2 machine with IP Address 192.168.1.151. IP1 has the fol...more >>

Two instances of SQL Server 2005 cannot "see" each other. One is Developer edition and one is Standard edition. Standard editon is running under Virtual PC. I would appreciate any suggestions on how make these two instances visible to each other. Thanks, Keith ...more >>

I am trying to write a TSQL Script for maintenance that willl read the databases from sysdatabases and change to each database inturn to perform some maintenance tasks. Problem is I can't get SQL to change to the next database. Tried Exec('Use' +@dbname) and it doesnt error out, but it also do...more >>

We have a situation for which I have been trying to find an explanation for over a week. A windows 2005 SP1 server which previously ran in Windows authentication only suddenly caused "cannot generate sspi context" errors after we switched it to mixed authentication mode. -SQL service is run...more >>

Hi, I have a webservice created in VB.NET 2003 hosted on a Windows 2003 server. This service inserts data into a SQL Server 2000 database also hosted on a Windows 2003 server. The webserver is in a closed DMZ and the Database Sever is on the internal network. The firewall is configured to a...more >>

I have installed SQL Server at my home computer. I can access from another computer over internet. But from my company, I can't. I talk to IT administrator, but he doesn't understand a lot abou this issue. Any help? What th IT should do to I have access? Thanks, Jose ...more >>

What the minimal speed is required to connect to SQL Server over internet to give a good connection? I mean where i can open forms, select item from the list boxes, generate reports, inputing data... Thanks José ...more >>

We are using the NTWDBLIB.DLL to connect to SQL2005 via the BDE(Delphi). As I understand it this DLL has been deprecated by Microsoft and therefore may not work with future releases of SQL Server. What is the likely future of the DLL, so we can understand the risks associated with continui...more >>

hi, i have 2 sql2005 servers. i am traying to drop , insert from one server to another, and when i am trying to run simple query , i getting an error: "Msg 18452, Level 14, State 1, Line 1 Login failed for user ''. The user is not associated with a trusted SQL Server connection." the...more >>

I have a feeling this might be a security problem so I posting the question in the security group as well. Sorry for the double post, I'll paste any answers over there as well. Here's the problem; I'm trying to do some prototyping with SQL 2005 Standard - Full Text Search in preparation f...more >>