Hi, Newbie here. I'm trying to connect in Visual C# to the Northwind database using ADO: SqlConnection conn = new SqlConnection(@"DataSource=localhost; Initial Catalog=Northwind"); The password and user id were left blank in setup so I assume I shouldn't have to enter anything there. I've als...more >>

I want the following query to result in "2004/10". SELECT DATEPART(yyyy, datein) & '/' & DATEPART(mm, datein) AS theDate From myTable However, I get the error: Syntax error converting the varchar value '/' to a column of data type int. Is there a better way to do this? Also, I realize ...more >>

1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Release A are the same. 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this stage I dont remember which file I downloaded...more >>

I have a client machine running VS.Net 2003, using TCP/IP to connect to a server running SQL Server 2000 Developer. The first time I connect to the server it always takes 15 seconds. Subsequent work on the server is very quick but that first 15 seconds is extremely painful. It doesn’t mater ...more >>

I have a client machine running VS.Net 2003, using TCP/IP to connect to a server running SQL Server 2000 Developer. The first time I connect to the server it always takes 15 seconds. Subsequent work on the server is very quick but that first 15 seconds is extremely painful. It doesn’t mater ...more >>

I have a client machine running VS.Net 2003, using TCP/IP to connect to a server running SQL Server 2000 Developer. The first time I connect to the server it always takes 15 seconds. Subsequent work on the server is very quick but that first 15 seconds is extremely painful. It doesn’t mater ...more >>

Hi Friends, I have two LAN networks, having different IP Address classes(say one network is 101.12.12.x and other is 102.12.11.x). These LAn Networs are connected by the Internet connection. At both the networks routers are configured and at the Gateway Firewall Port 1433 is opened. Ho...more >>

Hi, I'm trying to connect to SQL 2005 using standard sql user login on an ASP.NET 2.0 site. I get a Shared Memory provider error. Shared memory provider is enabled. I have tried disabling, but to no avail. Connection string looks like this: Password=***???**;Persist Security Info=True;User...more >>

Hi - I am trying to run a test environment with Windows Server 2003 (computer A) as my domain controller and a XP Pro machine (computer B). What I want to do is to log in to sql server on A through B using windows authentication. Everything works fine when I use sql server authentication, ...more >>

I have Node1 (Win2K Sp4) with SQL2000 Database And Node2 (XP SP2) with COM+ components connecting to SQL Server Database on Node1. After installing SP2 for XP on Node2 my apps don't run they produce this error: <description>New transaction cannot enlist in the specified transaction coordina...more >>

SQL - 2000 running on Win2k Server I am unable to view my databases in enterprise manager but can see them in Query Analyzer/ODBC. I had deleted a bunch of unused databases last night and after reboot this morning Enterprise manager will not display any of my databases. What have I done? rwj...more >>

We are trying to connect to an Oracle Server via MSSQL Enterprise Manager so that we are able to query both the Oracle & SQL Database, can anybody tell me if this is possible and how to do it?? I have followed the instructions in Q280106 and this does not appear to show the database in Ente...more >>

Hi: I have noticed that if there is no network connection, the TCP Server on port 1433 doesn't start. Is this a normal behaviour?, Is there any way to change this behaviour, so I can work offline with SQL Server?. I'm running SQL Server 2000 Enterprise Edition (8.00.878) SP3 over Window...more >>

Hi all, I want to add an SQL Server 2000 to the list of linked servers of an sql server 7 in order to run distributed queries. I used sp_addlinkedserver and also sp_addlinkedsrvlogin, both with no error but trying to execute a distributed query returns the following error: [OLE/DB provider ...more >>

Recently had to reload laptop (XP) and can no longer connect to SQL Server. Nothing has changed on network side of things - only my laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping the server's IP without problem. The username and password is correct....more >>

I receive numerous deadlocks while processing transactions with more than 2 users in SQLServer 2000 SP3. While these does not happen often, it does happen often enough where it has become an annoyance. The error that the users are getting are very similar or identical to the one below: Micro...more >>

Hi, we have an customer trying to run our app. after installation. They get the error messeage: Login failed for user skdomain/skuser. Our app uses ADO.NET and the database is MS SQL Server. The program and sql server is installed on a separate server. To run the app. they have 8 applicatio...more >>

Hello, I'm running a webapplication which uses msde 2000 as database server. All webpages query the database. If I refresh a lot of time a webpage then I get a time-out error . With the netstat command I found a lot of ms-sql-s connections. Is there a way to disconenct these connections? ...more >>

Hi, If I create a table from scratch in EM I can then connect to this with an Access front end, and add / update and delete data as will. If I import an existing Access table and then connect to it in Access I find that whereas I can update and delete existing (ie imported) rows I can't upd...more >>

I have an instance of MSDE running that have 3 computers connected to it and using it no problems. 1 computer cannot connect or even see msde when enumerating sql servers using sqldmo. This computer can ping the server msde is on no problem. My thought was to next look at the netlibrary on ...more >>

Well i've been given a big job of copying all the databases from an old server to a new server. In order to provide better security, availabilty, performance. My servers are in a DMZ, so i have to use remote desktop/terminal services to connect to it. 1. I have two logical partitions in the...more >>

Hi, a user of my lan has windows xp installed (sp1 first now sp2). He works with access 2002 and wants to link to some sqlserver tables. when he creates a new odbc connection to that sqlserver he gets the following error message: Connection failed SQLState: '01000' SQL Server Error: 53...more >>

Hi all! At work, I've no problems connecting to our testserver. From home I have problems. I use VPN to get inside our firewall, and everything else works as expected. Whether I try to connect to my testdata from my application, or I try to connect using SQL Query Analyzer, I get the same errorm...more >>

I have a problem in connecting to an SQL database on a server from laptop computers. The users can access it from a desktop with same windows login as they use on their laptop but all I get when they try on the laptop is an error message saying connection failure. All machines are running XP and ...more >>

I installed the MSDE version from the Office 2003 disk without any trouble. It worked perfectly for about two weeks on an XPprof machine with servicepack 2. I upsized Access databases and worked with VB and ADO(X). All great, but somehow the server got autistic and although it runs fine, I c...more >>

I am using sgl2000 server ent. edition. I could not view the table on a database.I am able to view the structure of the same. When I try to run a query with the same table it says an error "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(WrapperRead())" I don't know what is to b...more >>

Hello, > I get the following error: > > Server: Msg 11, Level 16, State 1, Line 1 > General network error. Check your network documentation. > > > Need help. > > I have 2 sql server instances on two different machines. > > Created a linked serve between SERVE1 and SERVER2. > > Tried to...more >>

I'm administering serveral sqlserversin our company. Most off the servers are in different domains. For the Enterprise Manager that's no problem, you can register any server with it's ipnumber or name. But on all the servers which are not in the same domain, it's security log is getting full w...more >>

I have found several pages demonstrating this but I still cannot make it work. I need to connect to an external data source. I have a user DSN named "OMD" which does not require a username or password. My connection will be read-only. My intent is to use SQLConnect, although I am open to a...more >>

I receive this error while running a db maintenance plan that backs up a 7GB db to a NAS device. All other dbs are backed up fine (they are considerably smaller) to the same device. I have tried using both a UNC for my path in addition to a mapped drive letter to my NAS device. Thanks in ad...more >>

I'm using SQL Server 2000 I'm trying to store a database to a test database as I have done in the past, now I'm getting an error message saying "Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally." No is using this test database....more >>

... connection. Hello all! I have a little problem and cannot solve it. On a remote location (connected through frame relay), i have two Windows XP computers, ComputerA (with MS SQL 2K installed) and ComputerB. They are both part of our domain. On some occasions (random), ComputerB can...more >>

Hi all, I have an application running on a MSSQL Server on local machine, but the service has failed to start all in a sudden. It has been working fine for months. All i got is this error message. I tried to use the administrator account for the "Log on service" rather than the "System ...more >>

Hello, I get the following error: Server: Msg 11, Level 16, State 1, Line 1 General network error. Check your network documentation. Need help. I have 2 sql server instances on two different machines. Created a linked serve between SERVE1 and SERVER2. Tried to run a select query u...more >>

Hi, I downloaded and installed SQL Express 2005 (Beta 2). I want to create tables and see whether I can get the data from the trivial windows based application or web application I will be building in C# using Visual Studio 2003. Question : Where can I get the details regarding how to crea...more >>

If I log on to the master database in an SQL server, is there a way for me to tell if a non-master database has any connections to it? VB6 ADO MSDE (SP3) William Hildebrand wahilde@cableone.net ...more >>

Hi All, An interest question about "Network Library=dbmssocn" in connection string. I have a Excel VBA application which I used to connect to SQL Server 2000 server. my connection string is: "Provider=SQLOLEDB; Data Source=servername; Initial Catalog=dbname; User ID=username; Password=pwd;...more >>

I have created a user (calladmin2) of a database in SQL Server Enterprise Manager. When I load SQL Query Analyzer and attempt to File->Connect using this user name I get: Msg. 18452, Level 16, State 1 Login failed for user 'calladmin2'. reason: Not associated with a trusted SQL Server conne...more >>

We have several loptops that run Windows XP and have SQL Server databases, which we access through a Java application. After WinXP Service Pack 2 was installed, none of the laptops can connect to the database. We have tried opening port 1433 for TCP/IP and port 445 for Named Pipes; still n...more >>

Hi Can someone tell me where the connection string is set up in MSDE TIA cds ...more >>

Hi, I recently upgrade a WinNT 4 SP6a Proxy server to Win2K SP4 with ISA SP2. I have to allow remote users to connect to a SQL server 7 SP4 on Winnt 4 SP6a behind ISA. The IP is static. It was working fine with Proxy but now I have the following with clients on the Web: [Microsoft][ODBC SQ...more >>

Job 'bla' : Step 1, 'execute spbla' : Began Executing 2004-10-13 10:33:13 Msg 7410, Sev 16: Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] I get the above error when I try to execute a sp sitting on a remote server with a SQL Server Agent job. The sp e...more >>

Hi everyone, I need to find a way to connect from AS/400 DB2 to SQL Server database. Is there any way to do this? I know how to go the other way. I see that there is DB2 Information Integrator but it seems to be very pricey. Thank you for any links! ...more >>

Hi, Can you use #temp tables in stored procedures that access data for a website? Will this not cause a slowdown if say 5 users of the website access the same Stored Procedure at the same time? As far as I can tell if I use a statement like this "select * into #temp from tblOrders" a prob...more >>

Hi! We have a problem with a database asignation. When we try to make an attach (sp_attach_db) the system display an error: Server: Msg 3624, Level 20, State 1, Line 1 Location: recovery.c: 2657 Expression: seenCkptEnd SPID: 10 Process ID: 560 Connection Broken We work with SQL Serve...more >>

I created the below script to track my linked servers. I set it up that it would record a record for each server along with all its corresponding databases. Unfortunately, I have not been able to successfully track a server which is offline. Currently, I am using cmdshell to ping linked serv...more >>

Hello, May be my question its simple, but I don't know the answer, I need to connect to a named instance into a Remote Server using an IP Address, how I can do that ??? Thanks ...more >>

Hi Can someone advise where I locate the connection string in SQL server 2000. I keep getting a "Server does not exist" message when trying to connect to another SQLserver computer (although the server is running). TIA cds ...more >>

I need to copy my SQL Server 2000 database from my development machine to the server of one of the client. By using Enterprise Manager I was going to detach db from my server, create a database with the same name on a new server, detach it, replace files on the new server with my copies and attac...more >>

I am connecting through ole db from Powerbuilder to Ms Sql Server 2000. Powerbuilder is not recognizing the column defaults which leads to problems, especially for inserts. Has anyone run into this and can you help me out?...more >>